求大神幫幫忙 數(shù)據(jù)庫(kù)檢查了沒(méi)問(wèn)題 不知道代碼有啥問(wèn)題呢?

public List<Goddess> query(List<Map<String,Object>> params) throws Exception {

//查詢女神 可能返回多個(gè)女神 所以創(chuàng)建一個(gè)List

Connection conn =DBUtil.getConnection();

//3.通過(guò)數(shù)據(jù)庫(kù)的連接操作數(shù)據(jù)庫(kù) 實(shí)現(xiàn)增刪改查

StringBuilder sb = new StringBuilder();

sb.append(" select * from database.imooc_goddess where 1=1 "); //小技巧 1=1肯定成立

if(params!=null&&params.size()>0) {

for(int i=0; i<params.size(); i++) {

Map<String,Object> map = params.get(i);

//查詢什么？關(guān)系是什么？值是什么 都能傳進(jìn)來(lái)

sb.append(" and? " + map.get("name") + " " + map.get("rela") + " "+ map.get("value") + " " );?

}

}

PreparedStatement ptmt = conn.prepareStatement(sb.toString());

System.out.println(sb.toString());

ResultSet rs = ptmt.executeQuery(); //返回一個(gè)ResultSet

List<Goddess> gs = new ArrayList<Goddess>();

Goddess g = null;

while(rs.next()) {? //看下一個(gè)是否為空 如果true則有下一個(gè)

g = new Goddess();

g.setId(rs.getInt("id"));

g.setUser_name(rs.getString("user_name"));

g.setAge(rs.getInt("age"));

g.setSex(rs.getInt("sex"));

g.setBirthday(rs.getDate("birthday")); ? //從數(shù)據(jù)庫(kù)傳過(guò)來(lái)的sql的類(lèi)型再轉(zhuǎn)為util不需要轉(zhuǎn) 因?yàn)閡til是父集

g.setEmail(rs.getString("email"));

g.setMobile(rs.getString("mobile"));

g.setCreate_date(rs.getDate("create_date"));

g.setCreate_user(rs.getString("create_user"));

g.setUpdate_date(rs.getDate("update_date"));

g.setUpdate_user(rs.getString("update_user"));

g.setId(rs.getInt("isdel"));

gs.add(g);

}

return gs;

}

public class TestAction {

public static void main(String[] args) throws Exception {

// TODO Auto-generated method stub

GoddessAction action = new GoddessAction();?

//新增

Goddess g = new Goddess();

g.setUser_name("Stark");

g.setSex(1);

g.setAge(299);

g.setBirthday(new Date());

g.setEmail("tonystark@yahoo.com");

g.setMobile("13871445748");

g.setIsdel(0);

g.setId(9);

// action.add(g);

// action.edit(g);

// action.del(9);

List<Map<String, Object>>params = new ArrayList<Map<String, Object>>();

Map<String, Object>map = new HashMap<String, Object>();

map.put("name", "id");

map.put("rela", "=");

map.put("value",5);

params.add(map);

List<Goddess> result =action.query(params);

for (Goddess goddess : result) {

System.out.println(goddess.toString());

}

}

}