sql在java施用中的拼接

2012-11-23

sql在java使用中的拼接String sqlselect uid,name from userVector gifts new Vector()PreparedSta

sql在java使用中的拼接

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());
???}