81,122
社区成员




public List<Card> queryCardByname(String sname) {
Connection con = null;
PreparedStatement ps = null;
ResultSet rs = null;
List<Card> list = new ArrayList<Card>();
String sql = "select * from card where sname =?";
con = db.getConnection();
try {
// System.out.println("!!!!!:"+rs.isClosed());
ps = con.prepareStatement(sql);
ps.setString(1, sname);
rs = ps.executeQuery();
while (rs.next()) {
Card cd = new Card();
cd.setSname(StringUtil.repairNull(rs.getString("Sname")));
cd.setCardfbid(StringUtil.repairNull(rs.getString("Cardfbid")));
list.add(cd);
}
} catch (SQLException ex) {
ex.printStackTrace();
} finally {
this.close(ps, rs, con);
}
return list;
}