Home Tutorial Java Jdbc Inserting a row using PreparedStatement

 
 

Share on Google+Share on Google+
Inserting a row using PreparedStatement
Posted on: June 4, 2010 at 12:00 AM
Advertisement
In this section ,we will insert data in table of database using "PreparedStatement".

INSERING 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 THIS CODE

Advertisement

Related Tags for Inserting a row using PreparedStatement:


Follow us on Twitter, or add us on Facebook or Google Plus to keep you updated with the recent trends of Java and other open source platforms.

Posted on: June 4, 2010

Recommend the tutorial

Advertisements Advertisements
 

 

 

DMCA.com