package com.test.t;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;
public class TestPreparedStmt {
public static void main(String[] args) {
Connection conn = null;
PreparedStatement stmt = null;
int age = 88;
String name = "ballaam";
String adr = "HK";
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
String url = "jdbc:oracle:thin:@127.0.0.1:1521:orcl";
conn = DriverManager.getConnection(url,"scott","tiger");
String sql = "insert into dept values(?,?,?)";
stmt = conn.prepareStatement(sql);
stmt.setInt(1,age);
stmt.setString(2, name);
stmt.setString(3, adr);
stmt.executeUpdate();
} catch(ClassNotFoundException e) {
e.printStackTrace();
} catch(SQLException e) {
e.printStackTrace();
} finally {
try{
if(stmt != null) {
stmt.close();
stmt = null;
}
if(conn != null) {
conn.close();
conn = null;
}
} catch(SQLException e){
e.printStackTrace();
}
}
}
}