Java MySQL DELETE (using Statement)

See also: MySQL XAMPP Connection for Java jdbc Program

Suppose we have folowing table:



Now we want to delete one record at a time by following:

• Create a Java Connection to our MySQL database.
• Create a SQL DELETE statement.
• Then execute a Java Statement, using our SQL DELETE statement.
• Close our Java MySQL database connection.
• Finally catch any SQL exceptions using try-catch clause.

See also:

• Java MySQL SELECT (using Statement)
• Java MySQL INSERT (using Statement)

Reference

Java MySQL INSERT (using Statement)

See also: MySQL XAMPP Connection for Java jdbc Program

First suppose we have a table in out database named user. Or we can create a simple table like below:



Now we want to insert one record in this table. By following some steps we will do that.

• Create a Java Connection to our MySQL database.
• Create a SQL INSERT statement.
• Then execute a Java Statement, using our SQL INSERT statement.
• Close our Java MySQL database connection.
• Finally catch any SQL exceptions using try-catch clause.

quey1 is passing direct values to the table. query2 is passing values through variables. Be careful about quote marks for executing queries.

See also:

• Java MySQL SELECT (using Statement)
• Java MySQL DELETE (using Statement)

Reference

Java MySQL SELECT (using Statement)

See also: MySQL XAMPP Connection for Java jdbc Program

Let's see the following table:



Now follow these steps:

• Create a Java Connection to our MySQL database.
• Define SQL SELECT statement.
• Then execute the SELECT query, getting a Java ResultSet from that query
• Now iterate over the ResultSet, getting the database fields (columns) from each row of data that is returned
• Close our Java MySQL database connection.
• Finally catch any SQL exceptions using try-catch clause.
  

See also:

• Java MySQL INSERT (using Statement)
• Java MySQL DELETE (using Statement)

Reference

MySQL XAMPP Connection for Java jdbc Program

First we will open our XAMPP server.

Then type localhost/phpmyadmin/ in the browser. After that we will create our database. After that, see below java code for setting up connection for the database.

Java Database Connectivity (JDBC) is an application programming interface (API) for the programming language Java, which defines how a client may access a database. It is Java based data access technology and used for Java database connectivity. It is part of the Java Standard Edition platform, from Oracle Corporation.




"jdbc:mysql://localhost:3306/newdatabase" ; here 3306 is the port number for XAMPP server and newdatabase is the name of our database.

Remember : First create the database, otherwise it won't connect simply by coding
These parts seem ok, but you will get error if you didn't add the appropriate library(ies) to the project using Netbeans's library facility. So, let's see how we can do that :

• First Right-click on the project's root node in the Projects tab.
• In the pop-up context menu, click on Properties (on the bottom of the menu).
• Click on Libraries under Categories:. You should see the following screen:
  
  
  
  
  
  
  
• Click on the Add Library...
• Under Global Libraries click on MySQL JDBC Driver and then click the Add Library button. (If you don't have library named MySQL JDBC Driver, then simply download it from internet)
• Finally Click on OK.
  

If you need a specific version of the driver, you can download it, and then after clicking on Add Library... you can click on Create... to add the downloaded version to your library repository. You'd then remove the default JDBC Driver from the project, and add the library containing the specific version.
Following these steps properly will be enough for you to access your database.
See also:

• Java MySQL INSERT (using Statement)
• Java MySQL DELETE (using Statement)
• Java MySQL SELECT (using Statement)

 Reference