文档详情

内容综合软件包com amaker implimport java sql userdaoimpl.pdf

发布:2025-04-14约3.25千字共3页下载文档
文本预览下载声明

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());

}

}

显示全部
相似文档