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
最新资源
- (源码)基于SimPy和贝叶斯优化的流程仿真系统.zip
- (源码)基于Java Web的个人信息管理系统.zip
- (源码)基于C++和OTL4的PostgreSQL数据库连接系统.zip
- (源码)基于ESP32和AWS IoT Core的室内温湿度监测系统.zip
- (源码)基于Arduino的I2C协议交通灯模拟系统.zip
- coco.names 文件
- (源码)基于Spring Boot和Vue的房屋租赁管理系统.zip
- (源码)基于Android的饭店点菜系统.zip
- (源码)基于Android平台的权限管理系统.zip
- (源码)基于CC++和wxWidgets框架的LEGO模型火车控制系统.zip
资源上传下载、课程学习等过程中有任何疑问或建议，欢迎提出宝贵意见哦~我们会及时处理！
点击此处反馈
- 1
- 2
- 3
- 4
- 5
- 6
前往页