2-6,通過id查詢女神信息的這個(gè)代碼怎么跟上一節(jié)的對(duì)不上啊
public List<Goddess> query() throws Exception {
Connection conn = DBUtil.getConnection();
Statement stmt = conn.createStatement();
ResultSet rs = stmt
.executeQuery("select user_name,age from imooc_goddess");
List<Goddess> gs = new ArrayList<Goddess>();
Goddess g = null;
while (rs.next()) {
g = new Goddess();
// String username=rs.getString("user_name");
// g.setUserName(username);
g.setUser_name(rs.getString("user_name"));
g.setAge(rs.getInt("age"));
gs.add(g);
}
return gs;
}
2017-08-11
你看的這個(gè)是通過名字進(jìn)行查詢，你想通過ID進(jìn)行查詢只需將sb.append("where user_name = ?")改成sb.append("where id=?")就行了。