Java MySQL DELETE (using Statement)

See also: MySQL XAMPP Connection for Java jdbc Program

Suppose we have folowing table:

	create table user (
	id int unsigned auto_increment not null,
	first_name varchar(25) not null,
	last_name varchar(25) not null,
	age int not null,
	primary key (id)
	);

view raw table.sql hosted with ❤ by GitHub

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.

	package mysqlconn;
	import java.sql.*;
	import java.util.*;
	public class Mysqlconn {
	public static void main(String[] args)throws SQLException {
	try {
	String url="jdbc:mysql://localhost:3306/newdatabase";
	Properties prop=new Properties();
	prop.setProperty("user","root");
	prop.setProperty("password","");
	Driver d = new com.mysql.jdbc.Driver();
	Connection con = d.connect(url,prop);
	if(con == null) {
	System.out.println("connection failed");
	return;
	}
	// these are variables to insert
	String fname = "Tarek";
	String query1 = "DELETE FROM user WHERE first_name = 'Sifat';
	String query2 = "DELETE FROM user WHERE first_name = '" + fname + "'";
	Statement state = con.createStatement();
	ResultSet result = null;
	state.executeUpdate(query1);
	state.executeUpdate(query2);
	state.close();
	} catch (Exception e)
	{
	System.err.println("Got an exception!");
	System.err.println(e.getMessage());
	}
	}
	}

view raw SQL DELETE.java hosted with ❤ by GitHub

See also:

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

Reference