dao
/**
- 查找用戶信息
- **/ public Users findUsersUid(int uId) { Connection con = DBTools.getConnection(); String sql = "select * from users where uId=?";
PreparedStatement preparedStatement=null;
ResultSet resultSet=null;
try {
preparedStatement= con.prepareStatement(sql);
preparedStatement.setInt(1, uId); resultSet= preparedStatement.executeQuery(); Users u = null;
if (resultSet.next()) {
uId = resultSet.getInt(1);
String uQQ = resultSet.getString(2);
String uPwd = resultSet.getString(3);
String uName = resultSet.getString(4);
int uAge = resultSet.getInt(5);
String uGender = resultSet.getString(6);
String uImage = resultSet.getString(7);
String uEmail = resultSet.getString(8);
int uStatus = resultSet.getInt(9);
Date uLastLoginTime = resultSet.getDate(10);
Date uRegisterTime = resultSet.getDate(11);
String uRemark = resultSet.getString(12); u = new Users(uId, uQQ, uPwd, uName, uAge, uGender,
uImage, uEmail, uStatus, uLastLoginTime, uRegisterTime,
uRemark);
}
return u; } catch (SQLException e) { e.printStackTrace();
return null; // 返回-1表示發(fā)生異常
} finally {
DBTools.closeAll(con, preparedStatement, resultSet);
} }
這是查詢的DAO方法,但是怎么調用呢,是不是還要查找賬號
方法調用,無外乎2種,一種靜態(tài)方法,直接類調用,還一種new個對象,通過對象調用
轉載于:https://www.cnblogs.com/cyy-13/p/5718593.html
總結
- 上一篇: 韩国飞中国为什么时间起飞时间晚于降落时间
- 下一篇: 美军为什么空袭喀布尔?