摘要:
1预编译
1.1预编译中使用 like
在值的地方加%号,是这样用的
String sql = "select * from t_Content where tle like ?";
ResultSet rs;
rs = null;
try {
rs = db.getResult(sql, new String[]{"%我省手机%"},0);
不是这样用的
String sql = "select * from t_Content where tle like %?%";
ResultSet rs;
rs = null;
try {
rs = db.getResult(sql, new String[]{"我省手机"},0);
1.2javaSQL 预编译异常
if (!isOpened()) {
openConn();
}
params[2]="aabbcc";
PreparedStatement stmt = session.connecon().prepareStatement(sql);
if (params == null) {
params = new Object[0];
}
for (int i = 0; i < params.length; i++) {