一、使用PreparedStatement完成DML语句
Connection conn = null;
PreparedStatement ps = null;
ResultSet rs = null;
核心语句 :
String sql = "insert into dept(deptno, dname, loc) value(?, ?, ?)";
ps = conn.prepareStatement(sql);
ps.setInt(1, 60);
ps.setString(2, "programming");
ps.setString(3, "peking");
String sql = "update dept set dname = ?, loc = ? where deptno = ?";
ps = conn.prepareStatement(sql);
ps.setString(1,"programming");
ps.setString(2,"xian");
ps.setInt(3,60);
String sql = "delete from dept where deptno = ?";
ps = conn.prepareStatement(sql);
ps.setInt(1,60);
执行SQL语句
int count = ps.executeUpdate();
二、 处理查询结果集
ResultSet rs = null;
String sql = "select * from emp where deptno = ?";
ps.prepareStatement(sql);
ps.setString(1, "100");
rs = ps.executeQuery();
while(rs.next()) {
System.out.println(rs.getString("ename"));
}