String sql = select t.* from t1 where t.state = ? and upper(t.name) like ?
queryList = query(sql, YW, new Object[]{state, "%"+keyword+"%"});
用占位符时注意:oracle会自动加上 ' '
String sql = select t.* from t1 where t.state = ? and upper(t.name) like ?
queryList = query(sql, YW, new Object[]{state, "%"+keyword+"%"});
用占位符时注意:oracle会自动加上 ' '