import java.sql.*; public class PrepStmt{ public static void main(String[] args){ try{ new oracle.jdbc.driver.OracleDriver(); String url = "jdbc:oracle:thin:@localhost:1521:ora8"; Connection conn = DriverManager.getConnection(URL, "scott","tiger"); String sql = "insert into students values(?,?,?,?)"; PreparedStatement stmt=conn.prepareStatement(sql); stmt.setString(1,"Eng002"); stmt.setString(2,"Jerry"); stmt.setInt(3,15); stmt.setString(4,"M"); stmt.executeUpdate(); stmt.close(); conn.close(); }catch(SQLException e){ System.err.println(e); } } }
09-30