package com.sl.dao;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import com.sl.entity.User;
import com.sl.util.ConnectionFactory;
import com.sl.util.ResourceClose;
public class UserDaoImpl implements UserDao{
private Connection conn;
private PreparedStatement pstmt;
private ResultSet rs;
public int addUser(User user) {
conn=ConnectionFactory.getConnection();
int num=0;
try {
String sql="insert into t_users values(null,?,?,?,?,?,?,?,?,?,?)";
pstmt=conn.prepareStatement(sql);
pstmt.setString(1,user.getUsername());
pstmt.setString(2,user.getPassword());
pstmt.setString(3,user.getName());
pstmt.setString(4,user.getNic());
pstmt.setString(5,user.getSex());
pstmt.setInt(6,user.getAge());
pstmt.setString(7,user.getEmail());
pstmt.setString(8,user.getPhone());
pstmt.setString(9,user.getSelfshow());
pstmt.setInt(10,user.getRoleId());
num=pstmt.executeUpdate();
} catch (SQLException e) {
e.printStackTrace();
}
finally
{
ResourceClose.close(rs, pstmt, conn);
}
return num;
}
public boolean login(User user) {
conn=ConnectionFactory.getConnection();
boolean flag=false;
try {
String sql="select * from t_users where username=? and password=?";
pstmt=conn.prepareStatement("select * from t_users where username=? and password=?");
pstmt.setString(1, user.getUsername());
pstmt.setString(2,user.getPassword());
rs=pstmt.executeQuery();
if(rs.next())
{
user.setId(rs.getInt(1));
user.setUsername(rs.getString(2));
user.setPassword(rs.getString(3));
user.setName(rs.getString(4));
user.setNic(rs.getString(5));
user.setSex(rs.getString(6));
user.setAge(rs.getInt(7));
user.setEmail(rs.getString(8));
user.setPhone(rs.getString(9));
user.setSelfshow(rs.getString(10));
user.setRoleId(rs.getInt(11));
flag=true;
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
finally
{
ResourceClose.close(rs, pstmt, conn);
}
return flag;
}
public User selectUserInfo(int id) {
User user=new User();
conn=ConnectionFactory.getConnection();
try {
String sql="select * from t_users where id=?";
pstmt=conn.prepareStatement(sql);
pstmt.setInt(1,id);
rs=pstmt.executeQuery();
while(rs.next())
{
user.setId(rs.getInt(1));
user.setUsername(rs.getString(2));
user.setPassword(rs.getString(3));
user.setName(rs.getString(4));
user.setNic(rs.getString(5));
user.setSex(rs.getString(6));
user.setAge(rs.getInt(7));
user.setEmail(rs.getString(8));
user.setPhone(rs.getString(9));
user.setSelfshow(rs.getString(10));
user.setRoleId(rs.getInt(11));
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
finally
{
ResourceClose.close(rs, pstmt, conn);
}
return user;
}
public List findAllUsers() {
List userList=new ArrayList();
conn=ConnectionFactory.getConnection();
try {
String sql="select * from t_users where roleid=0";
pstmt=conn.prepareStatement(sql);
rs=pstmt.executeQuery();
while(rs.next())
{
User user=new User();
user.setId(rs.getInt(1));
user.setUsername(rs.getString(2));
user.setPassword(rs.getString(3));
user.setName(rs.getString(4));
user.setNic(rs.getString(5));
user.setSex(rs.getString(6));
user.setAge(rs.getInt(7));
user.setEmail(rs.getString(8));
user.setPhone(rs.getString(9));
user.setSelfshow(rs.getString(10));
user.setRoleId(rs.getInt(11));
userList.add(user);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
finally
{
ResourceClose.close(rs, pstmt, conn);
}
return userList;
}
/**
* 删除用户
*/
public int deleteUser(int id) {
// TODO Auto-generated method stub
conn=ConnectionFactory.getConnection();
int count=0;
try {
pstmt=conn.prepareStatement("delete from t_users where id=?");
pstmt.setInt(1,id);
count=pstmt.executeUpdate();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
finally
{
ResourceClose.close(rs, pstmt, conn);
}
return count;
}
/**
* 查找所有管理员信息
*/
public List findAllAdmins() {
// TODO Auto-generated method stub
List adminList=new ArrayList();
conn=ConnectionFactory.getConnection();
try {
pstmt=conn.prepareStatement("select * from t_users where roleid=1");
rs=pstmt.executeQuery();
while(rs.next())
{
User user=new User();
user.setId(rs.getInt(1));
user.setUsername(rs.getString(2));
user.setPassword(rs.getString(3));
user.setName(rs.getString(4));
user.setNic(rs.getString(5));
user.setSex(rs.getString(6));
user.setAge(rs.getInt(7));
user.setEmail(rs.getString(8));
user.setPhone(rs.getString(9));
user.setSelfshow(rs.getString(10));
user.setRoleId(rs.getInt(11));
adminList.add(user);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
finally
{
ResourceClose.close(rs, pstmt, conn);
}
return adminList;
}
/**
* 查找新增用户
*/
public List findNewUsers() {
List newuserList=new ArrayList();
conn=ConnectionFactory.getConnection();
try {
String sql="select * from t_users where roleid=0 order by id desc limit 5";
pstmt=conn.prepareStatement(sql);
rs=pstmt.executeQuery();
while(rs.next())
{
User user=new User();
user.setId(rs.getInt(1));
user.setUsername(rs.getString(2));
user.setPassword(rs.getString(3));
user.setName(rs.getString(4));
user.setNic(rs.getString(5));
user.setSex(rs.getString(6));
user.setAge(rs.getInt(7));
user.setEmail(rs.getString(8));
user.setPhone(rs.getString(9));
user.setSelfshow(rs.getString(10));
user.setRoleId(rs.getInt(11));
newuserList.add(user);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
finally
{
ResourceClose.close(rs, pstmt, conn);
}
return newuserList;
}
/**
* 修改用户信息
*/
public int modifyUserInfo(User user) {
// TODO Auto-generated method stub
conn=ConnectionFactory.getConnection();
int num=0;
try {
pstmt=conn.prepareStatement("update t_users set username=?,password=?,name=?,nic=?,sex=?,age=?,email=?,"
+"phone=?,selfshow=?,roleid=? where id=?");
pstmt.setString(1,user.getUsername());
pstmt.setString(2,user.getPassword());
pstmt.setString(3,user.getName());
pstmt.setString(4,user.getNic());
pstmt.setString(5,user.getSex());
pstmt.setInt(6,user.getAge());
pstmt.setString(7,user.getEmail());
pstmt.setString(8,user.getPhone());
pstmt.setString(9,user.getSelfshow());
pstmt.setInt(10,user.getRoleId());
pstmt.setInt(11,user.getId());
num=pstmt.executeUpdate();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
finally
{
ResourceClose.close(rs, pstmt, conn);
}
return num;
}
public int getUserid(String us
Myeclipse（struts2实现增删改查）+mysql数据库 （106个子文件） 
UserDaoImpl.class 8KB User.class 2KB UserServiceImpl.class 2KB AddAdminAction.class 2KB AdminDeleteUserAction.class 2KB AdminDeleteAdminAction.class 2KB LoginAction.class 2KB SelectAllAdminAction.class 1KB ModifyDispatchAction.class 1KB UserScanAction.class 1KB AddUserAction.class 1KB GetAllUserInterceptor.class 1KB ResourceClose.class 1KB AdminModifyAction.class 1KB UserModifyAction.class 1KB GetAllUserAction.class 1KB IfAddAdminAction.class 1KB AdminGetDataAction.class 1KB AdminScanAction.class 1KB ConnectionFactory.class 1KB IfAddUserAction.class 1KB UserExitAction.class 681B UserService.class 531B UserDao.class 519B .classpath 746B org.eclipse.wst.common.component 462B org.eclipse.wst.jsdt.ui.superType.container 49B admin.css 2KB admin.css 2KB
admin_p.gif 24KB bt_login.gif 300B menu_icon.gif 64B UserDaoImpl.java 10KB UserServiceImpl.java 2KB User.java 2KB AddAdminAction.java 1KB AdminDeleteUserAction.java 1KB LoginAction.java 1KB SelectAllAdminAction.java 1KB AdminDeleteAdminAction.java 1009B UserScanAction.java 947B ModifyDispatchAction.java 904B GetAllUserInterceptor.java 870B UserModifyAction.java 856B GetAllUserAction.java 837B AddUserAction.java 797B IfAddAdminAction.java 779B ResourceClose.java 774B AdminModifyAction.java 711B AdminScanAction.java 678B AdminGetDataAction.java 664B ConnectionFactory.java 627B IfAddUserAction.java 606B UserService.java 539B UserDao.java 526B UserExitAction.java 296B
login.jpg 46KB header_left.jpg 26KB header_bg.jpg 3KB title_bg2.jpg 3KB login_5.jpg 2KB menu_bt.jpg 2KB login_4.jpg 718B login_3.jpg 595B menu_bg.jpg 341B title_bg1.jpg 320B shadow_bg.jpg 311B clock.js 1KB .jsdtscope 500B menu.jsp 3KB userinfo.jsp 3KB selectAllAdmins.jsp 3KB adminselectuser.jsp 3KB newuserlist.jsp 3KB AddAdmin.jsp 3KB login.jsp 3KB main.jsp 3KB AddUser.jsp 3KB usermodify.jsp 3KB showadmins.jsp 3KB othersmodify.jsp 3KB deleteadmin.jsp 3KB deleteuser.jsp 3KB adminmodify.jsp 3KB modify_user_error.jsp 2KB modify_user_success.jsp 2KB addadmin_success.jsp 2KB modify_success.jsp 2KB failure.jsp 2KB adduser_success.jsp 2KB header.jsp 1KB index.jsp 1KB MANIFEST.MF 36B .mymetadata 297B .mystrutsdata 240B org.eclipse.wst.jsdt.ui.superType.name 6B com.genuitec.eclipse.j2eedt.core.prefs 1009B org.eclipse.jdt.core.prefs 364B com.genuitec.eclipse.core.prefs 165B org.eclipse.core.resources.prefs 57B共 106 条
- 1
- 2
资源评论
花泽木2017-07-03界面友好，个人感觉还不错，就是jdbc链接路径不对，需要修改，回头连下数据库试试
qwer5280
- 粉丝: 3
- 资源: 5
最新资源
- Python爬虫资源：全面掌握爬虫技术的综合指南
- 人工智能-智能助手-凤希AI伴侣：多功能整合，效率提升利器
- 新冠病毒密接者跟踪系统设计与实现(代码+数据库+LW)
- Xmind-for-Windows-x64bit-24.01.13311-畅享版
- XMind2023-v23.11.04336-x64-Repack-畅享版
- XMind2024-mac畅享版
- 基于Spring Boot的夕阳红公寓管理系统的设计与实现(代码+数据库+LW)
- 基于神经音频编解码器的高效语音分离技术研究-Codecformer模型
- 源感知神经音频编解码器SD-Codec的技术与应用
- 导师信息评价-导师评价（包含全国各大高校各个专业）.xls
- 源码程序，前端vue，后端php，前后端全开源
- 手边酒店V25.0.22小程序前端+后端.zip
- 基于java的简易版营业厅宽带系统+jsp源码（java毕业设计完整源码+LW）.zip
- 11基于java的旅游管理系统设计新版源码+数据库+说明
- mmexport1735574041820.jpg
资源上传下载、课程学习等过程中有任何疑问或建议，欢迎提出宝贵意见哦~我们会及时处理！
点击此处反馈
