Homebrew’s package index. Also known as: mysql-client@8.0 Formerly known as: mysql-connector-c Open source relational database management system. Note: This post assumes you followed installing Apache, PHP, and MySQL on Mac OS X Mojave and have since upgraded to macOS Catalina. If you did not follow the original post, you should follow installing Apache, PHP, and MySQL on macOS Catalina. When Mac OS X upgrades it overwrites previous configuration files.

The professional data recovery software for Mac can recover deleted files even if they have been permanently removed or emptied from Trash or Bin. Avoid overwriting of deleted files on Mac, launch Stellar software to allow scanning of your start-up disk and recover the deleted Mac files to a location of your choice. The professional data recovery software for Mac can recover deleted files even if they have been permanently removed or emptied from Trash or Bin. Avoid overwriting of deleted files on Mac, launch Stellar software to allow scanning of your start-up disk and recover the deleted Mac files to a location of your choice.

NetBeans (@ http://netbeans.org) is an open-source Integrated Development Environment (IDE). NetBeans began in 1996 as a Java IDE student project at Charles University in Prague. Sun Microsystems acquired NetBeans in 1999. In 2010, Oracle acquired Sun (and thus NetBeans).

Compared with its rival Eclipse (http://www.elicpse.org) (both are open-source, so I don't know what are they competing for?), NetBeans provides seamless support for Java AWT/Swing, Java ME mobility pack, Java EE, and bundled with an excellent profiler for performance tuning.

NOTE (2018 Feb 01): NetBeans 8.2 might not work with JDK 9 at this moment. Stick to JDK 8 now, if you want to use NetBeans.

How to Install NetBeans 8.2

How to Install NetBeans on Windows

Step 0: Install JDK

To use NetBeans for Java programming, you need to first install Java Development Kit (JDK). See 'JDK - How to Install'.

Step 1: Download

Download 'NetBeans IDE' installer from http://netbeans.org/downloads/index.html. There are many 'bundles' available. For beginners, choose the 1st entry 'Java SE' (e.g., 'netbeans-8.2-javase-windows.exe' 95MB).

Step 2: Run the Installer

Run the downloaded installer.

How to Install NetBeans on Mac OS X

To use NetBeans for Java programming, you need to first install JDK. Read 'How to install JDK on Mac'.

To install NetBeans:

1. Download NetBeans from http://netbeans.org/downloads/. Set 'Platform' to 'Mac OS X'. There are many 'bundles' available. For beginners, choose 'Java SE' (e.g., 'netbeans-8.2-javase-macosx.dmg' 116MB).
2. Double-click the download Disk Image (DMG) file.
3. Double-click the 'NetBeans 8.x.mpkg', and follow the instructions to install NetBeans. NetBeans will be installed under '/Applications/NetBeans'.
4. Eject the Disk Image ('.dmg').

You can launch NetBeans from the 'Applications'.

Notes: To uninstall NetBeans, drag the '/Applications/NetBeans' folder to trash.

How to Install NetBeans on Ubuntu Linux

To use NetBeans for Java programming, you need to first install JDK. Read 'How to install JDK on Ubuntu'.

To install NetBeans:

1. Download NetBeans from http://netbeans.org/downloads/. Choose platform 'Linux (x86/x64)' ⇒ 'Java SE'. You shall receive a sh file (e.g., 'netbeans-7.x-ml-javase-linux.sh') in '~/Downloads'.
2. Set the downloaded sh file to executable and run the sh file. Open a Terminal: Follow the instructions to install NetBeans.

To start NetBeans, run the script 'netbeans' in the NetBeans' bin directory:

Writing a Hello-world Java Program in NetBeans

Step 0: Launch NetBeans

Launch NetBeans. If the 'Start Page' appears, close it by clicking the 'cross' button next to the 'Start Page' title.

Step 1: Create a New Project

For each Java application, you need to create a 'project' to keep all the source files, classes and relevant resources.

1. From 'File' menu ⇒ Choose 'New Project...'.
2. The 'Choose Project' diglog pops up ⇒ Under 'Categories', choose 'Java' ⇒ Under 'Projects', choose 'Java Application' ⇒ 'Next'.
3. The 'Name and Location' dialog pops up ⇒ Under 'Project Name', enter 'FirstProject' ⇒ In 'Project Location', select a suitable directory to save your works ⇒ Uncheck 'Use Dedicated Folder for Storing Libraries' ⇒ Uncheck 'Create Main class' ⇒ Finish.

Step 2: Write a Hello-world Java Program

1. Right-click on 'FirstProject' ⇒ New ⇒ Java Class (OR choose the 'File' menu ⇒ 'New File...' ⇒ Categories: 'Java', File Types: 'Java Class' ⇒ 'Next').
2. The 'Name and Location' dialog pops up ⇒ In 'Class Name', enter 'Hello' ⇒ Delete the content in 'Package' if it is not empty ⇒ 'Finish'.
3. The source file 'Hello.java' appears in the editor panel. Enter the following codes:

Step 3: Compile & Execute

There is no need to 'compile' the source code in NetBeans explicitly, as NetBeans performs the so-called incremental compilation (i.e., the source statement is compiled as and when it is entered).

To run the program, right-click anywhere in the source (or from the 'Run' menu) ⇒ Run File. Observe the output on the output console.

Notes:

• You should create a NEW Java project for EACH of your Java application.
• Nonetheless, NetBeans allows you to keep more than one programs in a project, which is handy for writing toy programs (such as your tutorial exercises). To run a particular program, open and right-click on the source file ⇒ Run File.

Correcting Syntax Error

NetBeans performs incremented compilation, as and when a source line is entered. It marked a source line with syntax error with a RED CROSS. Point your cursor at the RED CROSS to view the error message.

Mac Os Catalina Mysql

You CANNOT RUN the program if there is any syntax error (marked by a RED CROSS before the filename). Correct all the syntax errors; and RUN the program.

[TODO] Diagram

HINTS: In some cases, NetBeans shows a ORANGE LIGHT-BULB (for HINTS) next to the ERROR RED-CROSS (Line 5 in the above diagram). You can click on the LIGHT-BULB to get a list of HINTS to resolve this particular error, which may or may not work!

SYNTAX WARNING: marked by a orange triangular exclaimation sign. Unlike errors, warnings may or may not cause problems. Try to fix these warnings as well. But you can RUN your program with warnings.

Read the NetBeans Documentation

At a minimum, you SHOULD READ the 'IDE Basics, Getting Started, Java Application', which is accessible via NetBeans's 'HELP' menu ⇒ Help Contents. This will save you many agonizing hours trying to figure out how to do somethings later.

The 'Help' ⇒ 'Online Doc and Support' (@ http://netbeans.org/kb/index.html) contains many articles and tutorial on using NetBeans.

The NetBeans 'Start Page' also provides many useful links to get you started.

Debugging Program in NetBeans

Step 0: Write a Java Program

The following program computes and prints the factorial of n (=1*2*3*...*n). The program, however, has a logical error and produce a wrong answer for n=20 ('The Factorial of 20 is -2102132736' - a negative number?!).

Let us use the graphic debugger to debug the program.

Step 1: Set an initial Breakpoint

A breakpoint suspends program execution for you to examine the internal states of the program. Before starting the debugger, you need to set at least one breakpoint to suspend the execution inside the program. Set a breakpoint at main() method by clicking on the left-margin of the line containing main(). A red circle or an inverted Triangle appears in the left-margin indicating a breakpoint is set at that line.

Step 2: Start Debugging

Right click anywhere on the source code ⇒ 'Debug File'. The program begins execution but suspends its operation at the breakpoint, i.e., the main() method.

As illustrated in the following diagram, the highlighted line (also pointed to by a green arrow) indicates the statement to be executed in the next step.

Step 3: Step-Over and Watch the Variables and Outputs

Click the 'Step Over' button (or select 'Step Over' in 'Debug' menu) to single-step thru your program. At each of the step, examine the value of the variables (in the 'Variable' panel) and the outputs produced by your program (in the 'Output' Panel), if any. You can also place your cursor at any variable to inspect the content of the variable.

Single-stepping thru the program and watching the values of internal variables and the outputs produced is the ultimate mean in debugging programs - because it is exactly how the computer runs your program!

Step 4: Breakpoint, Run-To-Cursor, Continue and Finish

As mentioned, a breakpoint suspends program execution and let you examine the internal states of the program. To set a breakpoint on a particular statement, click on the left-margin of that line (or select 'Toggle Breakpoint' from 'Run' menu).

'Continue' resumes the program execution, up to the next breakpoint, or till the end of the program.

'Single-step' thru a loop with a large count is time-consuming. You could set a breakpoint at the statement immediately outside the loop (e.g., Line 11 of the above program), and issue 'Continue' to complete the loop.

Alternatively, you can place the cursor on a particular statement, and issue 'Run-To-Cursor' to resume execution up to the line.

'Finish' ends the debugging session. Always terminate your current debugging session using 'Finish' or 'Continue' till the end of the program.

Other Debugger's Features:

Modify the Value of a Variable

You can modify the value of a variable by entering a new value in the 'Variable' panel. This is handy for temporarily modifying the behaviour of a program, without changing the source code.

Step-Into and Step-Out

To debug a method, you need to use 'Step-Into' to step into the first statement of the method. You could use 'Step-Out' to return back to the caller, anywhere within the method. Alternatively, you could set a breakpoint inside a method.

NetBeans - Tips & Tricks

General Usage

These are the features that I find to be most useful in NetBeans:

1. Maximizing Window (double-click): You can double-click on the 'header' of any panel to maximize that particular panel, and double-click again to restore it back. This is particularly useful for editing source code in full panel.
2. Code Auto-Complete (or Intelli-Sense) (ctrl-space): Enter a partial statement (e.g., Sys) and press control-space to activate the auto-complete, which displays all the available choices.
3. Javadoc (ctrl-space, alt-F1): Place the cursor on a method or class, and press ctrl-space to view the javadoc; or right-click ⇒ Show Javadoc (alt-F1) to open it on a browser.
4. Code Shorthand (tab): For example, you can enter 'sout' and press TAB for 'System.out.println'; 'psvm' for 'public static void main(String[] args) { }' or 'fori' + tab for a for-loop. To view and configure code template, choose 'Tools' menu ⇒ 'Options' ⇒ 'Editor' ⇒ 'Code Templates'.
5. Formatting Source Code (alt-shift-f): Right-click on the source (or from the 'Source' menu) ⇒ Choose 'Format'. NetBeans will layout your source codes with the proper indents and format. To configure the formatting, choose 'Tools' menu ⇒ 'Options' ⇒ 'Editor' ⇒ 'Formatting'.
   You can also select the section of codes to be formatted, instead of the entire file.
6. Hints for Correcting Syntax Error: If there is a syntax error on a statement, a red mark will show up on the left-margin on that statement. You could click on the 'light bulb' to display the error message, and also select from the available hints for correcting that syntax error.
7. Rename (Refactor) (ctrl-r): To rename a variable, place the cursor on that variable, right-click ⇒ 'Refactor' ⇒ 'Rename' ⇒ Enter the new name. All the appearances of that variables in the project will be renamed.
8. Small Programs: You can keep many small toy programs (with main()) in one Java project instead of create a new project for each small program. To run the desired program, on the 'editor' panel ⇒ right-click ⇒ 'Run File'.
9. Source Toggle Comment: To temporarily comment-off a block of codes, choose 'Source' ⇒ 'Toggle Comment'.
10. Error Message Hyperlink: Click on an error message will hyperlink to the corresponding source statement.
11. Command-Line Arguments: To provide command-line arguments to your Java program in NetBeans, right-click on the 'project' ⇒ 'Set as Main Project' ⇒ 'Set Configurations' ⇒ 'Customize...' ⇒ 'Run' ⇒ select the 'Main' class ⇒ type your command-line arguments inside the 'Arguments' field ⇒ choose 'Run' menu ⇒ 'Run Main Project'.
12. Line Numbers: To show the line numbers, right-click on the left-margin ⇒ 'Show Line Numbers'.
13. Changing Font Face and Size: Tools ⇒ Options ⇒ Fonts & Colors ⇒ In 'Category', select 'Default' ⇒ In 'Font', choose the font face and size.
14. Resetting Window View: If you mess up the window view (e.g., you accidentally close a window and cannot find it anymore), you can reset the view via 'Window' menu ⇒ 'Reset Windows'.
15. Code Templates: For example, when you create a new Java class, NetBeans retrieves the initial contents from the 'Java Class' code template. To configure code templates, select 'Tools' menu ⇒ 'Templates' ⇒ Choose the desired template ⇒ 'Open in Editor'. To set a value of a variable used in the all the code templates (e.g., $User), select 'Tools' menu ⇒ 'Templates' ⇒ 'Settings'.
16. Displaying Chinese Character: Need to choose a font that support chinese character display, such as 'Monospace', in Tools ⇒ Options ⇒ Fonts & Colors ⇒ Syntax ⇒ default.
17. Changing the JDK Location: The Netbeans configuration file is located at 'etcnetbeans.conf'. Edit the directive 'netbeans_jdkhome'.
18. Let me know if you have more tips to be included here.

Java Application Development

1. Choosing the JDK version for your program: Right-click on your project ⇒ 'Properties' ⇒ 'Source' node ⇒ You can select the JDK level of your project in pull-donw menu 'Source/Binary Format'.
2. Enabling JDK 7 support: If JDK 7 is already installed in your system, right-click on your Project ⇒ 'Properties' ⇒ 'Source' node ⇒ 'Source/Binary Format' ⇒ Select 'JDK 7'. Also check 'Libraries' ⇒ Java Platform ⇒ JDK 7.
   If JDK 7 is not installed/configured, install JDK 7. Add JDK 7 support to NetBeans via 'Tool' menu ⇒ 'Java Platforms' ⇒ 'Add Platform...'.
3. Choosing Default Charset: Right-click on your project ⇒ 'Properties' ⇒ 'Source' node ⇒ 'Encoding' ⇒ choose your desired charset for the text-file I/O from the pull-down menu.
4. Enabling Unicode Support for File Encoding: Right-click on your project ⇒ 'Properties' ⇒ 'Source' node ⇒ 'Encoding' ⇒ choose your Unicode encoding (e.g., UTF-8, UTF-16, UTF-16LE, UTF-16GE) for the text-file I/O.
5. To include Javadoc/Source: Use 'Library Manager' (select the 'Tools' menu ⇒ 'Libraries'); or 'Java Platform Manager' (select 'Tools' menu ⇒ 'Java Platforms')
6. Adding External JAR files & Native Libraries ('.dll', '.lib', '.a', '.so'): Many external Java packages (such as JOGL, Java3D, JAMA, etc) are available to extend the functions of JDK. These packages typically provide a 'lib' directory containing JAR files ('.jar') (Java Archive - a single-file package of Java classes) and native libraries ('.dll', '.lib' for windows, '.a', '.so' for Linux and Mac).
   To include an external JAR file ('.jar') into a project: Expand the project node ⇒ Right-click on 'Libraries' ⇒ 'Add JAR/Folder...' ⇒ Select the desired JAR file or the folder containing the classes.
   If the external package contains many JAR files, you could create a user library to contain all the JAR files, and add the library to all the projects that required these JAR files. From 'Tools' menu ⇒ 'Libraries' ⇒ 'New Library...' ⇒ Enter a library name ⇒ Use 'Add JAR/Folder...' to add JAR files into this library.
   Many JAR files come with native libraries in the form of '.dll', '.lib' (for Windows) and '.a', '.so' for Linux/Mac. The directory path of these libraries must be included in JRE's property 'java.library.path'. This can be done via right-click the project ⇒ Set Configuration ⇒ Customize... ⇒ Run ⇒ In 'VM options', enter '-Djava.library.path=xxx', where xxx is path of the native libraries.
   Notes: The JAR files must be included in the CLASSPATH. The native library directories must be included in JRE's property 'java.library.path', which normally but not necessarily includes all the paths from the PATH environment variable. Read 'External JAR files and Native Libraries'.

Writing Java GUI (AWT/Swing) Application in NetBeans

Step 0: Read

1. Java GUI Application Learning Trail @ http://www.netbeans.org/kb/trails/matisse.html.
2. Swing Tutorial's 'Learning Swing with the NetBeans IDE' @ http://docs.oracle.com/javase/tutorial/uiswing/learn/index.html.

Step 1: Create a New 'Java Application' Project

1. Launch NetBeans ⇒ File ⇒ New Project...
2. Under 'Categories', choose 'Java' ⇒ Under 'Projects', choose 'Java Application' ⇒ Next.
3. In 'Project Name', enter 'FirstNetBeansGUI' ⇒ Choose a suitable directory for your 'Project Location' ⇒ Uncheck the 'Create Main class' box ⇒ Finish.

Step 2: Write a Java File 'JFrame Form'

1. Right-click on the project 'FirstNetBeansGUI' ⇒ 'New' ⇒ 'JFrame Form...' (or 'Others' ⇒ 'Swing GUI Forms' ⇒ 'JFrame Form').
2. In 'Class Name', enter 'NetBeansSwingCounter' ⇒ Finish.
3. Create the GUI Components visually:
   1. From the 'Platte' panel ⇒ 'Swing Controls' ⇒ Drag and drop a 'Label', 'TextField', and 'Button' into the design panel.
   2. Click on the 'jLabel1' ⇒ In the 'Properties' panel, enter 'Count' in 'text' (You can also single-click on the jLabel1 to change the text). Right-click on the jLable1 ⇒ Change Variable Name ⇒ In 'New Name', enter 'lblCount'.
   3. Similarly, for 'jTextField1' ⇒ Change the 'text' to 0, and change the 'Variable Name' to 'tfCount' ⇒ Resize the text field if necessary.
   4. For 'jButton1' ⇒ Change the 'text' to 'Count', and change the 'Variable Name' to 'btnCount'.
4. Write the event handler for the button by double-clicking the button and enter the following codes:
5. Create an instance variable count (just below the class declaration) as follows:

Step 3: Compile & Execute

Right-click the source and select 'Run File'.

Step 4: Study the Generated Source Code

Expand the 'Generated Code' and study how the GUI builder declare, allocate and initialize the GUI Components in the initComponents(). Note how the JButton registers an ActionEvent listener and how an inner class is used as the listener and provide the event handler actionPerformed(). Also notice that the main() method uses a Swing's worker to run the GUI on the Event-Dispatcher thread, instead of the main thread, for thread-safe operations.

NetBeans and MySQL

Reference: 'Connecting to a MySQL Database' @ http://netbeans.org/kb/docs/ide/mysql.html.

NetBeans (JavaEE) provides direct support to MySQL server. You can use NetBeans as a GUI client to access a MySQL server, as well as an administrative tool (e.g., starting and stopping the server).

Configuring NetBeans to Support MySQL

From NetBeans 'Window' menu ⇒ Select 'Services'. The 'Services' tab shall appear on the left pane

Mac Os Catalina Mysql Tutorial

1. Right-click on the 'Databases' node ⇒ 'Register MySQL Server'. (If you have already registered a MySQL server, you can right-click on Server node 'MySQL Server at hostname:port' ⇒ Properties, to modify its properties.)
2. Select the 'Basic Properties' tab, enter the hostname, port number, root user and password.
3. Select the 'Admin Properties' tab:
   1. Leave the 'Path/URL to admin tool' empty.
   2. In 'Path to start command', enter '<MYSQL_HOME>binmysqld.exe'; in the 'Arguments', enter '--console'
   3. In 'Path to stop command', enter '<MYSQL_HOME>binmysqladmin.exe', in the 'Arguments', enter '-u root -ppassword shutdown'.
4. A server node 'MySQL Server at hostname:port' appears.

Database Administration - Start/Stop the Server and Create Databases

1. You can start the MySQL server by right-clicking on the server node ⇒ select 'start'. [There seems to be a problem here. If a 'connection refused: connect' error occurs, enter the password again.]
2. Once the MySQL server is started and connected, you can see the list of databases by expanding the MySQL server node. You can create a new database by right-clicking on it and choose 'Create Database...'.

Create a new Connection

You need a connection to manipulate data. You can create multiple connections with different users and default databases.

1. Right-click on the 'Databases' ⇒ 'New Connection...' ⇒ Select the driver 'MySQL Connector/J' ⇒ Next ⇒ Enter hostname, port number, default database, a general username and password ⇒ 'Test Connection' (make sure that MySQL is started) ⇒ Finish.
2. A connection node 'jdbc:mysql://hostname:port/defaultDatabase' appears.

Manipulating Data via a Connection

1. Right-click on a connection node (e.g., 'jdbc:mysql://hostname:port/defaultDatabase') ⇒ Choose 'Connect' (if not connected, provided that the MySQL server has been started).
2. You can expand the connection node to view all the databases.
3. Expand an existing database. There are three sub-nodes 'Tables', 'View' and 'Procedures'. Right-click on the 'Tables' to create table or execute command. Similarly, right-click on the 'View' and 'Procedures'.
4. To view/manipulate the records in a table, right-click on the selected table ⇒ You can choose to 'View Data...', 'Execute Command...', etc.
5. You can right-click on the connection to 'connect' or 'disconnect' from the server.

Create a SQL Script and Run the Script

You can create a SQL script by right-clicking on a project ⇒ New ⇒ 'SQL File'. You can run the script by right-clicking on the SQL script ⇒ 'Run File' ⇒ Select an existing connection (or create a new connection) to run the script. You could also run a single statement (right-click on the statement ⇒ Run Statement) or a selected group of statements (highlight the statements ⇒ Right-click ⇒ Run Selection).

Developing and Deploying Web Application in NetBeans

Read:

• 'Introduction to Developing Web Applications' @ http://netbeans.org/kb/docs/web/quickstart-webapps.html.
• More articles in 'Java EE & Java Web Learning Trail' @ http://netbeans.org/kb/trails/java-ee.html.

Web (HTTP) Servers

Configuring Web Server

You could configure the web server via 'Tools' menu ⇒ 'Servers'.

Tomcat Server

To configure Tomcat Server, select 'Tools' menu ⇒ 'Servers' ⇒ click 'Add Servers':

1. Choose Server: Select the desired Tomcat version ⇒ Next.
2. Installation and Login Details: In 'Server Location', fill in the Tomcat installation directory ($CATALINA_HOME) ⇒ Enter the username/password of a tomcat user with 'manager' role. You could either check the 'create user if it does not exist' or define the tomcat user in '$CATALINA_HOMEconftomcat-users.xml' as follows:

Running the Web Server

Choose 'Services' ⇒ Expand 'Servers' node ⇒ Right-click on the desired server ⇒ Start/Stop/Restart.

MySQL Database Server

You can also manage the MySQL database server directly from Tomcat. Read 'NetBeans and MySQL' Section.

Writing a Hello-World Servlet/JSP Web Application

Create a New Servlet/JSP Project

1. From 'File' menu ⇒ choose 'New Project...'.
2. 'Choose Project' ⇒ Under 'Categories', choose 'Java Web' ⇒ Under 'Projects', choose 'Web Application' ⇒ 'Next'.
3. 'Name and Location' ⇒ In 'Project Name', enter 'HelloServletJSP' ⇒ In 'Project Location', select a suitable directory to save your works ⇒ Check 'Set as Main Project' ⇒ Next.
4. 'Server and settings' ⇒ Choose your server, or 'add' a new server ⇒ Next.
5. 'Frameworks' ⇒ Select none for pure servlet/JSP application ⇒ Finish.

Writing a Hello-World JSP

A JSP page called 'index.jsp' is automatically created, which says 'Hello world!'. To execute this JSP, right-click on the project ⇒ 'Run'. The URL is http://localhost:8080/HelloServletJSP/index.jsp.

Writing a Hello-World Servlet

1. Right-click on the project 'HelloServletJSP' ⇒ New ⇒ Servlet.
2. 'Name and Location' ⇒ In 'Class Name', enter 'HelloServlet' ⇒ In 'Package', enter 'hello' ⇒ Next.
3. 'Configure Servlet Deployment' ⇒ In 'Servlet Name', enter 'HelloServletExample' ⇒ In 'URL Pattern', enter 'sayhello' ⇒ Finish.
4. Enter the following codes for 'HelloServlet.java':
5. To execute the servlet: Right-click on the project ⇒ run ⇒ Change the URL to http://localhost:8080/HelloServletJSP/sayhello.

Install Mysql Mac Catalina Operating System

Generating a WAR-file for a Web Application

A WAR (Web Archive) file is basically a zip file for distributing web application in single file. You can use WinZip or WinRAR to inspect or unzip the war file.

To distribute the project as a war-file, right-click project ⇒ 'Clean and Build'. The war file is created in the 'dist' directory. You can deploy the web application by dropping the war-file into Tomcat's 'webapps' directory. Tomcat will automatically unzip the war-file and deploy the application upon startup.

Mac Os Catalina Mysql Command Not Found

Debugging Web Application

The most important reason for using IDE is to use the graphic debugger for debugging the program. You can set a breakpoint in your server-side Java codes, and 'Debug' a web application, similar to a standalone application.

Mac Os Catalina Mysql Server

Writing a Hello-world JSF 2.0 Web Application

Create a New JSF 2.0 Project

1. From 'File' menu ⇒ choose 'New Project...'.
2. 'Choose Project' ⇒ Under 'Categories', choose 'Java Web' ⇒ Under 'Projects', choose 'Web Application' ⇒ 'Next'.
3. 'Name and Location' ⇒ In 'Project Name', enter 'HelloJSF20' ⇒ In 'Project Location', select a suitable directory to save your works ⇒ Check 'Set as Main Project' ⇒ Next.
4. 'Server and settings' ⇒ Choose your server, or 'add' a new server ⇒ Next.
5. 'Frameworks' ⇒ Check 'JavaServer Faces' ⇒ In 'Libraries', 'Registered Libraries', select 'JSF 2.0' ⇒ Finish.
6. An 'index.xhtml' JSF page is generated, as follows: To run this facelet, right-click on the project ⇒ Run.

Create a new JSF 2.0 Facelet

Mac Os Catalina Download

1. Right-click on the project ⇒ New ⇒ 'Other...'
2. 'Choose File Type' ⇒ Under 'Category', select 'JavaServer Faces' ⇒ Under 'File Type', select 'JSF Page' ⇒ Next.
3. 'Name and Location' ⇒ In 'File Name', enter 'HelloJSF20' ⇒ In 'Options', check 'Facelets' ⇒ Finish.
4. In 'HelloJSF20.xhtml', enter the following codes:
5. To execute the JSF page, right-click on the project ⇒ Run ⇒ Change the URL to http://localhost:8080/HelloJSF20/HelloJSF20.xhtml.

Writing a Hello-world JSF 1.2 Web Application

Mac Os Catalina Mysql Tutorial

Create a New JSF 1.2 Project

1. From 'File' menu ⇒ choose 'New Project...'.
2. 'Choose Project' ⇒ In 'Categories', choose 'Java Web' ⇒ In 'Projects', choose 'Web Application' ⇒ 'Next'.
3. 'Name and Location' ⇒ In 'Project Name', enter 'HelloJSF12' ⇒ In 'Project Location', select a suitable directory to save your works ⇒ Check 'Set as Main Project' ⇒ Next.
4. 'Server and settings' ⇒ choose your server, or 'add' a new server ⇒ Next.
5. 'Frameworks' ⇒ Check 'JavaServer Faces' ⇒ In 'Libraries', 'Registered Libraries', select 'JSF 1.2' ⇒ Finish.
6. A 'WelcomeJSF.jsp' page is generated, as follows: To run this page, right-click on the project ⇒ Run.

Create a new JSF 1.2 Page

1. Right-click on the project ⇒ New ⇒ 'Other...'
2. 'Choose File Type' ⇒ In 'Category', select 'JavaServer Faces' ⇒ In 'File Type', select 'JSF Page' ⇒ Next.
3. 'Name and Location' ⇒ In 'File Name', enter 'HelloJSF12' ⇒ In 'Options', check 'JSP File (Standard Syntax)' ⇒ Finish.
4. In 'HelloJSF12.jsp', enter the following codes:
5. To execute the JSF page, right-click on the project ⇒ Run ⇒ Change the URL to http://localhost:8080/HelloJSF12/faces/HelloJSF12.jsp.

Debugging Web Applications in NetBeans

You can debug a webapp just like standalone application. For example, you can set breakpoints, single-step through the programs, etc.

REFERENCES & RESOURCES

• NetBeans mother site @ http://netbeans.org.
• NetBeans 'Help' menu.

Getting Started with 'Terminal' - MUST READ Before You Start Programming

Programmers use 'Terminal' to issue commands, instead of the graphical user interface - which is meant for common users.

You MUST have some basic knowledge on using the Terminal and the file system. Read 'Unix Survival Guide for Mac & Ubuntu - Terminal, File System and Users'.

How to Install JDK and Get Started with Java Programming on Mac

Read HERE.

Programming Text Editors for Mac

TextEdit for Mac

TextEdit (the default text editor in Mac OS X) is NOT a programming text editor, as it lacks features like syntax highlighting. I strongly suggest you install a programming text editor.

To use TextEdit to write source file, you need to open a new file ⇒ choose 'Format' ⇒ 'Make Plain Text'.

You can open an existing file in TextEdit from Terminal by issuing:

nano (or pico) Command-line Text Editor

nano is a GNU text editor that is available for Unix Systems (including Mac OS X), that is suitable for creating/editing small files. To start nano, open a Terminal and issue:

You can run nano with superuser (for accessing restricted directories), as follows:

JEdit for Mac

jEdit is a popular open-source cross-platform (Mac, Windows, Linux) programming text editor. The mother site is http://www.jedit.org.

Step 1: Download and Install jEdit for Mac

1. Download jEdit package from http://www.jedit.org ⇒ Download ⇒ Select Mac OS X package (stable version).
2. Double click the downloaded Disk Image ('.dmg') file. Drag the 'jEdit' icon to 'Applications' folder.
3. Eject the Disk Image 'jedit.dmg'.

Step 2: Install 'Console' plugins

1. Launch jEdit (from 'Applications').
2. Open plugin manager: From 'Plugins' menu ⇒ Plugin Manager.
3. Select 'Install' tab.
4. Search and select 'Console' plugin. 'ErrorList' plugin will selected automatically ⇒ Install.

Step 3: Write a Hello-World Java Program

1. Open a new file by selecting 'File' menu ⇒ 'New'.
2. Enter the following Java source code and save the file as 'Hello.java'.

Step 4: Compile and Run the Hello-World Java Program

You can start a 'Terminal' to compile and run your Java program as described in the above JDK section.

You can also use the 'Console' plugin:

1. To compile: From Plugins ⇒ Console ⇒ Compile Current Buffer. Click on the 'Console' button to view the console. If message 'Process javac exited with code 0' appears, the program is compiled successfully.
2. To run: From Plugins ⇒ Console ⇒ Run Current Buffer.

gedit for Mac

gedit is the official text editor of the GNOME desktop environment. The mother site for gedit is http://projects.gnome.org/gedit/.

1. Download gedit for Mac (DMG version) from http://projects.gnome.org/gedit/ ⇒ 'gedit mac os x' ⇒ Choose your specific Mac OS version.
2. To install:
   1. Double-click the downloaded Disk Image ('.dmg') file.
   2. Drag the 'gedit' icon to the 'Applications' folder.
   3. Eject the Disk Image 'gedit.dmg'.

Notes: To use 'gedit' commands in Terminal, you need to add '/Applications/gedit.app/Contents/MacOS/' to PATH environment variable.

Sublime

@ http://www.sublimetext.com.

How to Install Eclipse on Mac

Read 'How to Install Eclipse for Mac OS'.

How to Install NetBeans on Mac

Read 'How to Install NetBeans on Mac'.

How to Install MySQL 5.6 on Mac OS X 10.7 Lion

Install MySQL using the DMG Package

Reference: 'Installing MySQL on Mac OS X' @ http://dev.mysql.com/doc/refman/5.6/en/macosx-installation.html.

Step 1: Download and Install MySQL

Download the MySQL 'DMG Archive':

1. Go to http://dev.mysql.com/downloads/mysql/. In platform, select the 'Mac OS X'.
2. Select the appropriate 'DMG Archive' for your specific Mac OS version:
   • Click the Apple logo ⇒ 'About this Mac' to check your Mac OS version.
   • Read http://support.apple.com/kb/ht3696 to check if your OS is 32-bit or 64-bit.
   For example, Choose 'Mac OS X ver. 10.7 (x86, 64-bit), DMG Archive (117.5M)' for Lion and Core i7 processor.
3. Click 'No thanks, just start my download'.

To install MySQL:

1. Go to 'Downloads' ⇒ Double-click '.dmg' file downloaded.
2. Double-click 'mysql-5.5.{xx}-osx10.x-xxx.pkg' ⇒ Follow the instructions to install MySQL. Click continue if 'unindentified developer' warning dialog appeared.
3. MySQL will be installed in '/usr/local/mysql-5.5.{xx}-osx10.x-x86_xx' directory. A symbolic link '/usr/local/mysql' will be created automatically to the MySQL installed directory.
4. Eject the '.dmg' file.

How To Install Mysql On Macos Catalina

Step 2: Configuring MySQL - Change TCP Port Number for MySQL Server

1. The default TCP port number used by MySQL Server is 3306.
2. [For novices: SKIP THIS STEP to run the MySQL Server on port 3306. Goto Step 3.]
   You can change the port number by editing the configuration file 'my.cnf' at directory '/usr/local/mysql'. To create this file, open a new 'Terminal' and run the 'nano' editor using this command: Modify the lines in green and add in the lines in red; and press ctrl-X to exit. (We use the 'nano' editor in this case, you can use any text editor, but run in superuser.)

Notes: On Unix/Mac, the MySQL read the options file in this order: '/etc/my.cnf', 'SYSCONFDIR/mf.cnf', '$MYSQL_HOME/my.cnf', '~/.my.cnf'.

Step 3: Start/Shutdown the MySQL Server

Open a new 'Terminal' and issue these commands to start the MySQL server:

To shutdown the server, start a new terminal and issue:

Step 4: Start/Stop a MySQL Client

Open a new 'Terminal' and issue this command to start a MySQL client with superuser root:

To terminate the client, issue command 'exit' (or 'quit') from the 'mysql>' prompt:

Notes:

1. You can use 'Activity Monitor' (under Applications/Utilities) to check if the MySQL Server is running. Look for process starting with mysqld.
2. The log messages are written to /usr/local/mysql/data/xxx.err, where xxx denotes your machine name. Issue 'sudo cat /usr/local/mysql/data/xxx.err' to view the messages.
3. If you get the following error message when starting a client: 'Can't connect to local MySQL server through socket '....', check your 'Activity Monitor' to see if the MySQL server has been started.

Step 5: (For Java Programmers) Install MySQL JDBC Driver

1. Download the latest JDBC driver from http://www.mysql.com/downloads ⇒ MySQL Connectors ⇒ Connector/J ⇒ Compressed TAR archive (e.g., mysql-connector-java-{5.x.xx}.tar.gz, where {5.x.xx} is the latest release number).
2. Double-click on the downloaded TAR file to expand into folder 'mysql-connector-java-{5.x.xx}'.
3. Open the expanded folder. Copy the JAR file 'mysql-connector-java-{5.x.xx}-bin.jar' to JDK's extension directory at '/Library/Java/Extension'.

How to Uninstall and Remove MySQL 5

1. Open a Terminal ⇒ Run the 'nano' editor to edit /etc/hostconfig, as follows: Delete this line if present: 'MYSQLCOM=-YES-'. Press cntl-x to exit 'nano' and enter 'Y' to save the file. The line 'MYSQLCOM=-YES-' starts MySQL automatically during startup.
2. Make sure that MySQL is not running (Open the 'Activity Monitor' under the 'Applications/Utilities', and check for the process 'mysqld'). Open a Terminal and issue 'rm -r' to remove these directories and their sub-directories (with 'f' indicating no confirmation prompt).

That's all!

(Advanced) Install MySQL using Tarball

Reference: http://dev.mysql.com/doc/refman/5.5/en/macosx-installation-pkg.html.

[TODO]

How to Install Tomcat 7 on Mac

Step 1: Download and Install Tomcat

1. Goto http://tomcat.apache.org ⇒ Download ⇒ Tomcat 7.0 ⇒ 7.0.{xx} (where {xx} denotes the latest release) ⇒ Binary distribution ⇒ Core. Download the 'tar.gz' package (e.g., 'apache-tomcat-7.0.{xx}.tar.gz').
2. To install Tomcat:
   1. Goto '~/Downloads', double-click the downloaded TAR file (e.g., 'apache-tomcat-7.0.{xx}.tar.gz') to expand it into a folder (e.g., 'apache-tomcat-7.0.{xx}').
      (Notes for Advanced Users) Alternatively, you can use the tar command to expand the tarball as follow:
   2. Move the extracted folder (e.g., 'apache-tomcat-7.0.{xx}') to '/Applications'.
   3. Rename the folder 'tomcat', for ease of use.

(Notes for Advanced Users):

1. It is probably better to keep the tomcat in '/usr/local' or '/Library'.
2. Instead of renaming the tomcat's folder, it it better to create a symlink called tomcat as follows:
3. For security reason, you should not run Tomcat as root user. Instead, assign Tomat to user nobody (of group nobody):

Step 2: Configure Tomcat Server

Read 'Configure Tomcat Server'.

Step 3: Start the Tomcat Server

To start the Tomcat server, open a new 'Terminal' (Go ⇒ Utilities ⇒ Terminal) and issue:

Check for the Tomcat server's TCP port number from the console messages. The default is 8080.

To verify if the Tomcat server is started, start a browser (Safari) and issue URL http://localhost:8080, suppose that Tomcat is running on the default TCP port number of 8080.

Also try URL http://localhost:8080/examples which shows the Servlet/JSP examples.

Step 4: Shutdown the Tomcat Server

To shutdown the Tomcat server, you can simply press control-c (NOT command-c) on the tomcat console, or issue command:

Step 5: Servlet API

To write Java servlets, you need to COPY the Servlet API JAR file ('servlet-api.jar') from '/Applications/tomcat/lib' to the JDK's extension directory at '/Library/Java/Extension'.

Installing GCC and Get Started with C/C++ Programming on Mac

To install

1. Goto http://connect.apple.com, and login with your AppleID.
2. Download 'Command Line Tools (OS X xxxx) for XCode' Disk Image (DMG).
3. Double-click the download disk image (DMG) ⇒ Open 'Command Line Tools (xxx).mkpg' ⇒ Follow the instructions to install.
4. Eject the disk image.

To verify:

Installing XCode & Get Started

XCode is the development toolset for Mac, iPhone/iPad, which includes the Mac OS SDK (for Mac) and iOS SDK (for iPhone/iPad).

To install:

1. Goto http://connect.apple.com, and login with your AppleID.
2. Download 'XCode 4.x' Disk Image (DMG) - It is HUGE!
3. Double-click the download disk image (DMG) ⇒ Open 'XCode' ⇒ Follow the instructions to install.
4. XCode will be installed in '/Developer/Applications/Xcode'.
5. Eject the disk image.

To start Xcode, launch 'XCode' from '/Developer/Applications'.

[TODO] Getting Started

More on Terminal & Bash Shell

Goto 'Terminal & Bash Shell'.

Mac's Tips & Tweaks

Root (or Superuser, or Administrator)

In some cases (such as installing software and starting server), you need to be the so-called root user (or superuser or administrator) of your machine to complete some commands that require high privilege. Put 'sudo' (superuser do) in front of your command to run the command as root user, and provide the your password. Only authorized user can issue sudo command. For example, to start the MySQL server:

How to View All Files in Finder

1. Open a terminal and enter this commands:
2. Stop the Finder via:
3. Re-start the Finder. You shall see all the files (including the dot files and dot folders) now.

Miscellanous

• The equivalent of Windows' 'Task Manager' in Mac is called 'Activity Monitor' under 'Applications/Utilities'.
• The page-up, page-down, home and end keys are fn-up-arrow (or command-up-arrow), fn-down-arrow (or command-down-arrow), fn-left-arrow and fn-right-arrow, respectively.

Contributed by Wang Qiang (WANG0586@e.ntu.edu.sg).