Posted in: JDBC
package com.javastuff.jdbc;
import java.sql.*;
/**
* @author Javastuff
*/
public class PreparedStatement{
public static void main(String s[]) throws Exception {
Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
Connection con= DriverManager.getConnection (
"jdbc:oracle:thin:@mysys:1521:JavaStuff","scott","tiger");
String query="insert into mytable values (?,?,?)";
//Step1: Get PreparedStatement
PreparedStatement ps=con.prepareStatement (query);
//Step2: set parameters
ps.setString(1,"Java");
ps.setInt(2,38);
ps.setDouble(3,158.75);
//Step3: execute the query
int i=ps.executeUpdate();
System.out.println("record inserted count:"+i);
//To execute the query once again
ps.setString(1,"abc2");
ps.setInt(2,39);
ps.setDouble(3,158.75);
i=ps.executeUpdate();
System.out.println("query executed for the second time count: "+i);
con.close();
}//main
}//class
Note : To execute the following example you can replace username and password with your actual user name and password.