String sql="select uid,name from user";
Vector gifts = new Vector();
PreparedStatement stmt = null;
ResultSet rst = null;
StringBuffer sql = new StringBuffer(SQL_GET_JIFEN);
GiftForm form = null;
Vector args = new Vector();
try {
if(!Utilities.changeNull(giftForm.getUserName()).equals("")){
sql.append(" AND t3.username like ? ");
args.add("%"+String.valueOf(giftForm.getUserName())+"%");
}
if (!Utilities.changeNull(giftForm.getStartDay()).equals("")
&& !Utilities.changeNull(giftForm.getEndDay()).equals("")) {
sql.append(" AND t2.submitdate >= ? ");
sql.append(" AND t2.submitdate <= ? ");
args.add(giftForm.getStartDay());
args.add(giftForm.getEndDay());
}
本文介绍了一种使用SQL进行数据查询的方法,通过动态拼接SQL语句实现更灵活的数据检索功能。具体包括根据用户名模糊匹配、按指定日期范围筛选记录等高级查询技巧。
398

被折叠的 条评论
为什么被折叠?



