Javafx Database

In this section, I'll be showing you how to connect to a web server database using mysql as the driver. In this tutorial, we are assume the table has been created in the database.

Database: cppjj_name

Table: User

FirstName	Age

1) Get your IP address " White Listed "

If your ip address isn't white listed on your host, you would not have access to the database. If you don't know how to do that, you can contact your host admin
and tell them you want to get your "Internet IP address" white listed, they should be able to help you with that.

Here is what I did:

1) I login to my server host, which is www.hostmonster.com. Once I'm logged in, I go to Remote MySQL then I typed in my "Internet IP address" and add it to my server.

( Note, each time you are using a different network for Internet, you have to white list the IP address in order for you to have permission to connect to the data base)

2) Download the Driver

We need to have a driver for us to create a connection to our database. There are different drivers you can download to use, in this tutorial I'm using the MySql Java-Connect 5.1.14. You can download
the driver here. After you download the driver, unzip it anywhere that you can easily browse it.

Now, we have everything we need open the NetBeans, create a new Javafx script project.

/* This shows how to store values into the database */ import javafx.stage.Stage; import javafx.scene.Scene; import java.sql.*; import java.lang.*; import javafx.scene.text.Text; /** * @author JJ */ //DriverName var driverName = 'com.mysql.jdbc.Driver'; //The shared ip address of the web server, will connect to cppjj_name database var url = 'jdbc:mysql://61.247.340.453:3306/cppjj_name'; //User name that associate to the database var user = 'cppjj_admin'; //The password var password = '123'; //Database object var con : Connection = null; var stmt : Statement = null; try { //Load the driver Class.forName(driverName); //Connect to the database con = DriverManager.getConnection(url, user, password); //Create Database statement stmt = con.createStatement(); //Insert into table user to column FirstName, and age stmt.executeUpdate("INSERT INTO User (FirstName,age) VALUES('Tommy',25)"); //Close all the connection stmt.close(); con.close(); } catch(e:Exception) { e.printStackTrace(); } Stage { title: "Store Values to Database" scene: Scene { width: 300 height: 300 content: [ Text { layoutX:50 layoutY:50 content:"Your value has been stored" visible:true } ] } }

Here are the things we need to do before we run the above example

1) Right click on your project, then go to properties

2) Go to libraries, on the right click on ADD JAR/FOLDER, browse to where you unzip the mysql java connector. Select mysql-connector-java-5.1.14-bin.jar

3) Make sure you are connect to the Internet, and your IP address is white listed.

( Note, some internet changes IP address each time you connect so you would have to white list the IP address again.)

Lets look at a different example, this example will load data from the Database

/* * Connect to the database using javafx, load data from it * */ import javafx.stage.Stage; import javafx.scene.Scene; import java.lang.*; import java.sql.*; import javafx.scene.text.Text; /** * @author JJ */ //The Driver for the database var driverClassName ='com.mysql.jdbc.Driver'; //Connect to the database from this url var url = 'jdbc:mysql://61.247.340.453:3306/cppjj_name'; //The user name that associate to the database var user = 'cppjj_admin'; //The password of the database var password = '123'; //Database objects var con : Connection = null; var stmt : Statement = null; var rs : ResultSet = null; var getName : String = ""; try { //Load Driver Class.forName(driverClassName); try { //Create a connection to database con = DriverManager.getConnection(url,user,password); stmt = con.createStatement(); //Select and print tasks rs = stmt.executeQuery("SELECT * FROM User"); /* * It will loop to the end of the table, read the last element * Store the last element into getName */ while(rs.next()) { getName = rs.getString('FirstName'); } } //Catch all the exception and close all the connection catch(e:SQLException) { e.printStackTrace(); } finally { if(null != rs) { rs.close(); } if(null != stmt) { try { } catch(e:SQLException) { e.printStackTrace(); } finally { stmt.close(); } } if(null != con) { con.close(); } } } catch(e:Exception) { e.printStackTrace(); } var getText = Text { layoutX:50 layoutY:50 visible:true content:getName } Stage { title: "DataBase Load Values" scene: Scene { width: 250 height: 250 content: [ getText ] } }

Again, do the steps we did from the example, add the mysql connector-java to the library path, make sure your ip address is white listed.