Inserting a row using PreparedStatement

This section contains the detail about the Inserting a row using PreparedStatement in java.

Inserting a row using PreparedStatement

If you want to execute a statement many time , "PreparedStatement " reduces execution time. Unlike a "Statement" object ,it is given an 'Sql' statement when it is created. This SQL statement is sent to the DBMS right away, where it is compiled. This means that when the PreparedStatement is executed, the DBMS can just run the PreparedStatement SQL statement without having to compile it first.

The advantage of using "PreparedStatement " is that you can use the same statement and supply it with different values each time you execute it.

Insertprepared.java

import java.sql.*;

public class Insertprepared{

   public static void main(String args[]) {

        Connection con = null;
        PreparedStatement pst = null;
        ResultSet rs = null;

        String url = "jdbc:mysql://192.168.10.13:3306/";
        String db = "ankdb";
        String driver = "com.mysql.jdbc.Driver";
        String user = "root";
        String pass = "root";

	try {
		Class.forName(driver);
		con = DriverManager.getConnection(url + db, user, pass);
		con.setAutoCommit(false);// Disables auto-commit.

		String sql = "insert into student values(?,?,?) ";
		pst = con.prepareStatement(sql);

		pst.setInt(1,1642);
		pst.setString(2, "Rahul");
		pst.setString(3,"1985-06-06");
		

		pst.executeUpdate();

		sql = "select * from student";
		rs = pst.executeQuery(sql);

		System.out.println("Roll No  \tName   \t\tDate of Birth");
		while (rs.next()) {
			System.out.print(rs.getInt(1) + "     \t");
			System.out.print(rs.getString(2) + "     \t");
			System.out.print(rs.getDate(3) + "     \t");
			System.out.println("");
		}
		rs.close();
		pst.close();
		con.close();

	} catch (Exception e) {
		System.out.println(e);
	}
   }
}

Output :

Download Source Code