67,513
社区成员
发帖
与我相关
我的任务
分享
select number,name from biao where number=?
Connection conn = null;
String sql = "select * from biao where number=?";
PreparedStatement psmt = null;
ResultSet rs = null;
Biao ab = null;//你的实体类,对应的是biao
try {
conn = DatasourceCenter.getInstance().getInstance();
psmt = conn.prepareStatement(sql);
psmt.setInt(1, number);//看你的number是什么类型,是string就用setString()
rs = psmt.executeQuery();
if (rs.next()) {
ab = new Biao();
ab.setNumber(rs.getInt("number"));
ab.setName(rs.getString("name"));
ab.setAge(rs.getInt("age"));
ab.setProfession(rs.getString("profession"));
ab.setBalance(rs.getDouble("balance"));
}
} catch (Exception e) {
e.printStackTrace();
} finally {
try {
if (rs != null) {
rs.close();
}
if (psmt != null) {
psmt.close();
}
if (conn != null) {
conn.close();
}
} catch (Exception e2) {
e2.printStackTrace();
}
}
return ab;