JDBC Prepared Statement In Java Example

Chapter: JDBC Last Updated: 18-06-2016 11:32:51 UTC

Program:

            /* ............... START ............... */
                
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;

public class JavaJDBCPreparedStatement {
	
	public static void main(String a[]){
        
        Connection connection = null;
        PreparedStatement preparedStatement = null;
        try {
            Class.forName("oracle.jdbc.driver.OracleDriver");
            connection = DriverManager.
                getConnection("jdbc:oracle:thin:@<hostname>:<port num>:<DB name>"
                    ,"user","password");
            String query = "insert into emp(name,salary) values(?,?)";
            preparedStatement = connection.prepareStatement(query);
            preparedStatement.setString(1, "John");
            preparedStatement.setInt(2, 10000);

            int count = preparedStatement.executeUpdate();
            //Run the same query with different values
            preparedStatement.setString(1, "Cric");
            preparedStatement.setInt(2, 5000);
            count = preparedStatement.executeUpdate();
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        } catch (SQLException e) {
            e.printStackTrace();
        } finally{
            try{
                if(preparedStatement != null) preparedStatement.close();
                if(connection != null) connection.close();
            } catch(Exception ex){}
        }
    }
}
                /* ............... END ............... */
        

Notes:

  • JDBC PreparedStatement can be used when you plan to use the same SQL statement many times.

Tags

JDBC Prepared Statement, Java

Similar Programs Chapter Last Updated
Java Execute Multiple SQL Statements JDBC 10-09-2016
Java JDBC Savepoint And Rollback JDBC 10-09-2016
Java JDBC Commit Statement Example JDBC 10-09-2016
Java JDBC Sort Table Contents JDBC 10-09-2016
Java JDBC Search Table Contents JDBC 10-09-2016
Java JDBC Update Table JDBC 10-09-2016
Java Retrieve Table Contents JDBC 10-09-2016
Java JDBC Table Edit Example JDBC 10-09-2016
Java Connect To Database Example JDBC 10-09-2016
JDBC SQL Cursors Using CallableStatement JDBC 26-06-2016
JDBC Batch Execution In Java Using CallableStatement JDBC 26-06-2016
JDBC Stored Procedure Returns OUT Parameters In Java JDBC 23-06-2016
JDBC Stored Procedure Execution In Java JDBC 23-06-2016
JDBC Prepared Statement With ResultSet In Java Example JDBC 18-06-2016
JDBC Update Query In Java Example JDBC 18-06-2016
JDBC Query Execution In Java Example JDBC 18-06-2016
JDBC Query In Java Example JDBC 18-06-2016
Java JDBC Connection Example JDBC 18-06-2016

1