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