Inserting a row using PreparedStatement

Inserting a row using PreparedStatement


Posted in : Core Java Posted on : October 18, 2010 at 3:45 PM Comments : [ 0 ]

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 :

C:\Program Files\Java\jdk1.6.0_18\bin>java Insertprepared
Roll No√?¬†√?¬†√?¬†√?¬†√?¬†√?¬†√?¬†√?¬†√?¬†√?¬†√?¬†√?¬†√?¬†√?¬†√?¬†√?¬†√?¬† Name√?¬†√?¬†√?¬†√?¬†√?¬†√?¬†√?¬†√?¬†√?¬†√?¬†√?¬†√?¬† Date of Birth
2147483647√?¬†√?¬†√?¬†√?¬†√?¬†√?¬†√?¬†√?¬†√?¬† Ankit√?¬†√?¬†√?¬†√?¬†√?¬†√?¬†√?¬†√?¬†√?¬†√?¬†√?¬†√?¬†√?¬† 1985-06-06
2147483648√?¬†√?¬†√?¬†√?¬†√?¬†√?¬†√?¬†√?¬†√?¬† Somesh√?¬†√?¬†√?¬†√?¬†√?¬†√?¬†  √?¬† 1984-05-05
2147483649√?¬†√?¬†√?¬†√?¬†√?¬†√?¬†√?¬†√?¬†√?¬† Rajiv√?¬†√?¬†√?¬†√?¬†√?¬†√?¬†√?¬†√?¬†√?¬†√?¬†√?¬†√?¬†√?¬† 1985-06-06
2147483649√?¬†√?¬†√?¬†√?¬†√?¬†√?¬†√?¬†√?¬†√?¬† Rahul√?¬†√?¬†√?¬†√?¬†√?¬†√?¬†√?¬†√?¬†√?¬†√?¬†√?¬†√?¬† 1985-06-06

Download Source Code

Go to Topic «PreviousHomeNext»

Your Comment:


Your Name (*) :
Your Email :
Subject (*):
Your Comment (*):
  Reload Image
 
 

 
Tutorial Topics