内容综合软件包com amaker implimport java sql userdaoimpl.pdf
packagecom.amaker.dao.impl;
importjava.sql.Connection;
importjava.sql.PreparedStatement;
importjava.sql.ResultSet;
importjava.sql.SQLException;
importcom.amaker.dao.UserDao;
importcom.amaker.entity.User;
importcom.amaker.util.DBUtil;
/**
*
*@author
*û¼DAO
*/
publicclassUserDaoImplimplementsUserDao{
/**
*û¼¼User¼null
*/
publicUserlogin(Stringaccount,Stringpassword){
//SQL
Stringsql=selectid,account,passworme,permission,remark+
fromuserTbl+
whereaccount=?andpassword=?;
//
DBUtilutil=newDBUtil();
//
Connectionconn=util.openConnection();
try{
//
PreparedStatementpstmt=conn.prepareStatement(sql);
//ò
pstmt.setString(1,account);
pstmt.setString(2,password);
//в
ResultSetrs=pstmt.executeQuery();
//жû
if(rs.next()){
//û
intid=rs.getInt(1);
Stringname=rs.getString(4);
intpermission=rs.getInt(5);
Stringremark=rs.getString(6);
//û
Useru=newUser();
u.setId(id);
u.setAccount(account);
u.setPassword(password);
u.setName(name);
u.setPermission(permission);
u.setRemark(remark);
returnu;
}
}catch(SQLExceptione){
e.printStackTrace();
}finally{
util.closeConn(conn);
}
returnnull;
}
publicstaticvoidmain(String[]args){
UserDaodao=newUserDaoImpl();
Useru=dao.login(admin,123);
System.out.println(u.getAccount());
}
}