JDBC简易步骤

注册
DriverManager.registerDriver(driver);

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection conn = DriverManager.getConnection("jdbc:odbc:oradsn","scott","tiger");
stmt = conn.createStatement();
String query = "insert into product values(" + prodID + ",'" + prodName +
          "'," + prodPrice + "," + discount + ")";
stmt.execute(query);

PreparedStatement pStmt = conn.preparedStatement("insert into emp (empno , ename) values(?,?)");
CallableStatement 用于执行 SQL 存储过程
CallableStatement cStmt = conn.prepareCall("{call showEmployees(?,?)}");