Question

怎么获得PreparedStatement最终执行的sql语句

Answer 1

获得链接部分省略……

String sql = "insert into dept(deptno,deptname,deptadress) values(?,?,?)";
// 获得PreapareStatment 对象
PreapareStatment pst=con.preaparestatment(sql);
// 给占位符赋值

pst.setInt(1,11);
pst.setString(2,"zhangsan");
pst.setString(2,"zhongguoshanxishengxi'anshi");】
//执行sql 语句

int rows=pst.excutUpdate();
System.out.println(rows);
//释放资源
pst.close();
con.close();