String sqlc ="select *from books bo_name like ?"
PreparedStatement pstmtc = con.prepareStatement(sqlc);
pstmtc.setString(1, "x");
我想得到 sqlc 的参数被替换后的语句select *from books bo_name like 'x';怎么得到呢?有没有这个方法?请前辈指点,谢!
PreparedStatement pstmtc = con.prepareStatement(sqlc);
pstmtc.setString(1, "x");
我想得到 sqlc 的参数被替换后的语句select *from books bo_name like 'x';怎么得到呢?有没有这个方法?请前辈指点,谢!
void findBooks(String bookname)
{
//...
String sqlc ="select * from books bo_name like ?"
PreparedStatement pstmtc = con.prepareStatement(sqlc);
pstmtc.setString(1, bookname);
log.debug("sqlc=" + sqlc.replaceAll("?", bookname));
//...
}