package service;
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 pojo.User;
import utils.DBOperator;
public class UserServices {
public List<User> findAllUsers(){
List<User> list=new ArrayList<User>();
Connection conn=DBOperator.getConnection();
PreparedStatement ps=null;
ResultSet rs=null;
try {
ps=conn.prepareStatement("SELECT * from user as u left join department as d on u.departid=d.toid");
rs=ps.executeQuery();
while(rs.next()){
User user=new User();
user.setToid(rs.getInt(1));
user.setUsername(rs.getString(2));
user.setPassword(rs.getString(3));
user.setRealname(rs.getString(4));
user.setSex((rs.getString(5)));
user.setBirthday(rs.getString(6));
user.setEmail(rs.getString(7));
user.setAddress(rs.getString(8));
user.setTelphone(rs.getString(9));
user.setQq(rs.getString(10));
user.setSalary(rs.getFloat(11));
user.setDepartid(rs.getInt(12));
user.setRole(rs.getString(13));
user.setDepartname(rs.getString(15));
list.add(user);
}
} catch (SQLException e) {
e.printStackTrace();
}finally{
DBOperator.close(rs, ps, conn);
}
return list;
}
public User getUserbyID(int toid){
Connection conn=DBOperator.getConnection();
User user=new User();
PreparedStatement ps=null;
ResultSet rs=null;
try {
ps=conn.prepareStatement("select * from user where toid=?");//as u inner join department as d
ps.setInt(1, toid);
rs=ps.executeQuery();
while(rs.next()){
user.setToid(rs.getInt(1));
user.setUsername(rs.getString(2));
user.setPassword(rs.getString(3));
user.setRealname(rs.getString(4));
user.setSex((rs.getString(5)));
user.setBirthday(rs.getString(6));
user.setEmail(rs.getString(7));
user.setAddress(rs.getString(8));
user.setTelphone(rs.getString(9));
user.setQq(rs.getString(10));
user.setSalary(rs.getFloat(11));
user.setDepartid(rs.getInt(12));
user.setRole(rs.getString(13));
// user.setDepartname(rs.getString(15));
}
} catch (SQLException e) {
e.printStackTrace();
}finally{
DBOperator.close(rs, ps, conn);
}
return user;
}
public void AltUser(User user){
Connection conn=DBOperator.getConnection();
PreparedStatement ps=null;
ResultSet rs=null;
try {
ps=conn.prepareStatement("update user set realname= ?, email=?, address=?,telphone=?, salary=?,role=? where toid=?");
ps.setString(1, user.getRealname() );
ps.setString(2, user.getEmail());
ps.setString(3, user.getAddress() );
ps.setString(4, user.getTelphone());
ps.setFloat(5, user.getSalary());
ps.setString(6, user.getRole() );
ps.setInt(7, user.getToid());
ps.executeUpdate();
} catch (SQLException e) {
e.printStackTrace();
} DBOperator.close(rs, ps, conn);
}
public void DelUserbyId(int toid){
Connection conn=DBOperator.getConnection();
PreparedStatement ps=null;
ResultSet rs=null;
try {
ps=conn.prepareStatement("delete from user where toid=? ");
ps.setInt(1, toid);
ps.executeUpdate();
} catch (SQLException e) {
e.printStackTrace();
} finally {
DBOperator.close(rs, ps, conn);
}
}
public void AddUser(User user){
Connection conn=DBOperator.getConnection();
PreparedStatement ps=null;
ResultSet rs=null;
try {
ps=conn.prepareStatement("insert into user (username,realname,password,sex,email,address,telphone,salary,departid,role) values(?,?,?,?,?,?,?,?,?,?)");
ps.setString(1, user.getUsername());
ps.setString(2,user.getRealname());
ps.setString(3, user.getPassword());
ps.setString(4,user.getSex());
ps.setString(5,user.getEmail());
ps.setString(6,user.getAddress());
ps.setString(7,user.getTelphone());
ps.setFloat(8, user.getSalary());
ps.setInt(9,user.getDepartid());
ps.setString(10,user.getRole());
ps.executeUpdate();
} catch (SQLException e) {
e.printStackTrace();
}DBOperator.close(rs, ps, conn);
}
public List<User> findUserByDepat(int toid){
List<User> list=new ArrayList<User>();
Connection conn=DBOperator.getConnection();
PreparedStatement ps=null;
ResultSet rs=null;
try {
ps=conn.prepareStatement("SELECT * from user as u inner join department as d on u.departid=d.toid and u.departid=?");
ps.setInt(1, toid);
rs=ps.executeQuery();
while(rs.next()){
User user=new User();
user.setToid(rs.getInt(1));
user.setUsername(rs.getString(2));
user.setPassword(rs.getString(3));
user.setRealname(rs.getString(4));
user.setSex((rs.getString(5)));
user.setBirthday(rs.getString(6));
user.setEmail(rs.getString(7));
user.setAddress(rs.getString(8));
user.setTelphone(rs.getString(9));
user.setQq(rs.getString(10));
user.setSalary(rs.getFloat(11));
user.setDepartid(rs.getInt(12));
user.setRole(rs.getString(13));
user.setDepartname(rs.getString(15));
list.add(user);
}
} catch (SQLException e) {
e.printStackTrace();
}finally{
DBOperator.close(rs, ps, conn);
}
return list;
}
public List<User> SearchUser(int toid,String key){
List<User> list=new ArrayList<User>();
Connection conn=DBOperator.getConnection();
PreparedStatement ps=null;
ResultSet rs=null;
try {
ps=conn.prepareStatement("SELECT * from user as u inner join department as d on u.departid=d.toid and u.departid=? and u.realname=?");
ps.setInt(1, toid);
ps.setString(2, key);
rs=ps.executeQuery();
while(rs.next()){
User user=new User();
user.setToid(rs.getInt(1));
user.setUsername(rs.getString(2));
user.setPassword(rs.getString(3));
user.setRealname(rs.getString(4));
user.setSex((rs.getString(5)));
user.setBirthday(rs.getString(6));
user.setEmail(rs.getString(7));
user.setAddress(rs.getString(8));
user.setTelphone(rs.getString(9));
user.setQq(rs.getString(10));
user.setSalary(rs.getFloat(11));
user.setDepartid(rs.getInt(12));
user.setRole(rs.getString(13));
user.setDepartname(rs.getString(15));
list.add(user);
}
} catch (SQLException e) {
e.printStackTrace();
}finally{
DBOperator.close(rs, ps, conn);
}
return list;
}
public List<User> searchUser(String name){
List<User> list=new ArrayList<User>();
Connection conn=DBOperator.getConnection();
PreparedStatement ps=null;
ResultSet rs=null;
try {
ps=conn.prepareStatement("SELECT * from user as u inner join department as d on u.departid=d.toid and u.realname=?");
ps.setString(1, name);
rs=ps.executeQuery();
while(rs.next()){
User user=new User();
user.setToid(rs.getInt(1));
user.setUsername(rs.getString(2));
user.setPassword(rs.getString(3));
user.setRealname(rs.getString(4));
user.setSex((rs.getString(5)));
user.setBirthday(rs.getString(6));
user.setEmail(rs.getString(7));
user.setAddress(rs.getString(8));
user.setTelphone(rs.getString(9));
user.setQq(rs.getString(10));
user.setSalary(rs.getFloat(11));
user.setDepartid(rs.getInt(12));
user.setRole(rs.getString(13));
user.setDepartname(rs.getString(15));
list.add(user);
}
} catch (SQLException e) {
e.printStackTrace();
}finally{
DBOperator.close(rs, ps, conn);
}
return list;
}
public void AltAccount(String username,String password,int toid){
Connection conn=DBOperator.getConnection();
PreparedStatement ps=null;
OA办公自动化系统源码 （364个子文件） 
all-wcprops 4KB all-wcprops 652B all-wcprops 596B all-wcprops 575B all-wcprops 552B all-wcprops 504B all-wcprops 489B all-wcprops 440B all-wcprops 432B all-wcprops 430B all-wcprops 422B all-wcprops 378B all-wcprops 340B all-wcprops 299B all-wcprops 242B all-wcprops 200B all-wcprops 196B all-wcprops 188B all-wcprops 186B all-wcprops 174B all-wcprops 174B all-wcprops 93B all-wcprops 89B all-wcprops 87B all-wcprops 84B all-wcprops 81B all-wcprops 80B UserServices.class 8KB OrderService.class 6KB MessageService.class 4KB CheckCodeServlet.class 4KB DepartService.class 4KB AltOrder.class 3KB ProductServices.class 3KB AddOrder.class 3KB EmpBiz.class 3KB User.class 3KB SearchUser.class 3KB Orders.class 3KB AltUser.class 3KB AddUser.class 3KB UserLogin.class 3KB SetMyAcount.class 3KB LoginTest.class 3KB AltDepart.class 2KB SendMessege.class 2KB FilterOsLogin.class 2KB EveryMessage.class 2KB OrderList.class 2KB UserPageList.class 2KB AltAccount.class 2KB DBOperator.class 2KB AltProduct.class 2KB AddDepart.class 2KB MessageList.class 2KB AddProduct.class 2KB LookMessage.class 2KB DepartList.class 2KB ProductList.class 2KB PageBean.class 2KB DelProduct.class 1KB DelMessage.class 1KB DelDepart.class 1KB DelOrder.class 1KB Message.class 1KB DelUser.class 1KB QuitLogin.class 1KB FilterEncoding.class 1KB Department.class 1KB Product.class 928B .classpath 452B org.eclipse.wst.jsdt.ui.superType.container 49B datepicker.css 5KB base.css 5KB datepicker.css 5KB main.css 1KB menu.css 1005B WdatePicker.css 158B entries 5KB entries 980B entries 900B entries 797B entries 783B entries 779B entries 706B entries 682B entries 663B entries 656B entries 627B entries 621B entries 604B entries 502B entries 476B entries 382B entries 367B entries 364B entries 363B entries 355B entries 350B entries 332B共 364 条
- 1
- 2
- 3
- 4
战歌IT
- 粉丝: 122
- 资源: 2394
最新资源
- 微电网（两台）主从控制孤岛－并网平滑切的分析 分析了： 1.孤岛下VF控制 2.并网下PQ控制 3.孤岛下主从控制 4.孤岛到并网的平滑切控制 5.除模型外还对分布式发电与主动配电网一些常见问题做了
- 第四组二手产品.zip
- MVIMG_20241222_194113.jpg
- 基于小程序的在线疫苗预约小程序源代码（java+小程序+mysql+LW）.zip
- 基于小程序的岳阳市美术馆预约平台源代码（java+小程序+mysql+LW）.zip
- 基于小程序的音乐播放器小程序源代码（java+小程序+mysql+LW）.zip
- 多功能知识付费源码下载实现流量互导多渠道变现+搭建教程
- 3. Kafka入门-安装与基本命令
- 基于小程序的养老院管理系统源代码（java+小程序+mysql+LW）.zip
- 基于小程序的新冠抗原自测平台小程序源代码（java+小程序+mysql+LW）.zip
资源上传下载、课程学习等过程中有任何疑问或建议，欢迎提出宝贵意见哦~我们会及时处理！
点击此处反馈
- 1
- 2
- 3
- 4
- 5
- 6
前往页