如何输出置值之后的PreparedStatement
, 即输出sql语句 有没有用过,呀. 预编译之后到底能不能输出呀. 比如
String strSql = "select * from emp where empno = ? " ;
PreparedStatement pstmt = conn.prepareStatement(strSql);
pstmt.setString(1,"2000");
到此时,我想输出 "select * from emp where empno = '2000' ,
该如何?
我暂时没找到.
, 即输出sql语句 有没有用过,呀. 预编译之后到底能不能输出呀. 比如
String strSql = "select * from emp where empno = ? " ;
PreparedStatement pstmt = conn.prepareStatement(strSql);
pstmt.setString(1,"2000");
到此时,我想输出 "select * from emp where empno = '2000' ,
该如何?
我暂时没找到.
String strSql = "select * from emp where empno {0}";
strSql = MessageFormat.format(strSql, "= '2000'");
out.println(strSql);
都成字符串了输出丝毫没有意义