package com.jf;
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.jf.DbUtils;
import com.jf.Page;
import com.jf.User;
public class UserService {
public User findUserByUsernameAndPassword(String username,String password,String usertype) {
Connection con = DbUtils.getConnection();
PreparedStatement ps = null;
User user = null;
try {
String sql="select * from table_user where username=? and password=? and usertype=?";
ps = con.prepareStatement(sql);
ps.setString(1, username);
ps.setString(2, password);
ps.setString(3, usertype);
ResultSet rs = ps.executeQuery();
while (rs.next()) {
Integer id=rs.getInt(1);
String uname=rs.getString(2);
String passw=rs.getString(3);
String no=rs.getString(4);
String name=rs.getString(5);
String sex=rs.getString(6);
String department=rs.getString(7);
String telephone=rs.getString(8);
String email=rs.getString(9);
String usert=rs.getString(10);
user=new User();
user.setId(id);
user.setUsername(uname);
user.setPassword(passw);
user.setNo(no);
user.setName(name);
user.setSex(sex);
user.setDepartment(department);
user.setTelephone(telephone);
user.setEmail(email);
user.setUsertype(usert);
break;
}
DbUtils.closeConnection(con,ps,rs);
}catch(SQLException e) {
e.printStackTrace();
}
return user;
}
public boolean addUser(User user) {
Connection conn = DbUtils.getConnection();
PreparedStatement ps = null;
String sql = "insert into table_user (username,password,no,name,sex,department,email,telephone,usertype) values(?,?,?,?,?,?,?,?,?)";
try {
ps = conn.prepareStatement(sql);
ps.setString(1, user.getUsername());
ps.setString(2, user.getPassword());
ps.setString(3, user.getNo());
ps.setString(4, user.getName());
ps.setString(5, user.getSex());
ps.setString(6, user.getDepartment());
ps.setString(7, user.getEmail());
ps.setString(8, user.getTelephone());
ps.setString(9, user.getUsertype());
int rows = ps.executeUpdate();
DbUtils.closeConnection(conn,ps,null);
if(rows>0) {
return true;
}
}catch(SQLException e) {
return false;
}
return false;
}
public List<User> getUserList(){
List<User> userList = new ArrayList<User>();
Connection con = DbUtils.getConnection();
PreparedStatement ps = null;
User user = null;
try {
String sql="select * from table_user";
ps = con.prepareStatement(sql);
ResultSet rs = ps.executeQuery();
while (rs.next()) {
Integer id=rs.getInt(1);
String uname=rs.getString(2);
String passw=rs.getString(3);
String no=rs.getString(4);
String name=rs.getString(5);
String sex=rs.getString(6);
String department=rs.getString(7);
String telephone=rs.getString(8);
String email=rs.getString(9);
String usert=rs.getString(10);
user=new User();
user.setId(id);
user.setUsername(uname);
user.setPassword(passw);
user.setNo(no);
user.setName(name);
user.setSex(sex);
user.setDepartment(department);
user.setTelephone(telephone);
user.setEmail(email);
user.setUsertype(usert);
userList.add(user);
}
DbUtils.closeConnection(con,ps,rs);
}catch(SQLException e) {
e.printStackTrace();
}
return userList;
}
public Page getPage(int pageNow) {
// 记录总数
int recordCount = 0;
//当前页面具体数据集合
List<User> recordList = new ArrayList<User>();
Connection con = DbUtils.getConnection();
PreparedStatement ps = null;
try {
String sql="select count(*) from table_user where usertype <> '系统管理员'";
ps = con.prepareStatement(sql);
ResultSet rs = ps.executeQuery();
while(rs.next()) {
recordCount = rs.getInt(1);
}
String pageSql = "select top 5 * from table_user where id not in (select top " + (pageNow - 1) * 5 + "id from table_user where usertype <> '系统管理员') and usertype <> '系统管理员' ";
ps = con.prepareStatement(pageSql);
rs = ps.executeQuery();
while (rs.next()) {
Integer id=rs.getInt(1);
String uname=rs.getString(2);
String passw=rs.getString(3);
String no=rs.getString(4);
String name=rs.getString(5);
String sex=rs.getString(6);
String department=rs.getString(7);
String telephone=rs.getString(8);
String email=rs.getString(9);
String usert=rs.getString(10);
User user=new User();
user.setId(id);
user.setUsername(uname);
user.setPassword(passw);
user.setNo(no);
user.setName(name);
user.setSex(sex);
user.setDepartment(department);
user.setTelephone(telephone);
user.setEmail(email);
user.setUsertype(usert);
recordList.add(user);
}
DbUtils.closeConnection(con,ps,rs);
}catch(SQLException e) {
e.printStackTrace();
}
Page page = new Page(pageNow,recordCount,recordList);
return page;
}
public User getUserById(int id) {
Connection con = DbUtils.getConnection();
PreparedStatement ps = null;
User user = null;
try {
String sql="select * from table_user where id=?";
ps = con.prepareStatement(sql);
ps.setInt(1, id);
ResultSet rs = ps.executeQuery();
while (rs.next()) {
Integer dbId=rs.getInt(1);
String uname=rs.getString(2);
String passw=rs.getString(3);
String no=rs.getString(4);
String name=rs.getString(5);
String sex=rs.getString(6);
String department=rs.getString(7);
String telephone=rs.getString(8);
String email=rs.getString(9);
String usert=rs.getString(10);
user=new User();
user.setId(dbId);
user.setUsername(uname);
user.setPassword(passw);
user.setNo(no);
user.setName(name);
user.setSex(sex);
user.setDepartment(department);
user.setTelephone(telephone);
user.setEmail(email);
user.setUsertype(usert);
break;
}
DbUtils.closeConnection(con,ps,rs);
}catch(Exception e) {
e.printStackTrace();
}
return user;
}
public boolean updateUser(User user) {
Connection conn = DbUtils.getConnection();
PreparedStatement ps = null;
String sql = "update table_user set username=?,password=?,no=?,name=?,sex=?,department=?,email=?,telephone=?,usertype=? where id=?";
try {
ps = conn.prepareStatement(sql);
ps.setString(1, user.getUsername());
ps.setString(2, user.getPassword());
ps.setString(3, user.getNo());
ps.setString(4, user.getName());
ps.setString(5, user.getSex());
ps.setString(6, user.getDepartment());
ps.setString(7, user.getEmail());
ps.setString(8, user.getTelephone());
ps.setString(9, user.getUsertype());
ps.setInt(10, user.getId());
int rows = ps.executeUpdate();
DbUtils.closeConnection(conn,ps,null);
if(rows>0) {
return true;
}
}catch(Exception e) {
return false;
}
return false;
}
public boolean deleteUserById(int id) {
Connection conn = DbUtils.getConnection();
PreparedStatement ps = null;
String sql = "delete from table_user where id=?";
try {
ps = conn.prepareStatement(sql);
ps.setInt(1, id);
int rows = ps.executeUpdate();
DbUtils.closeConnection(conn, ps, null);
if (rows > 0) {
return true;
}
} catch (Exception e) {
e.printStackTrace();
}
return false;
}
public List<Computer> getComputerList(){
List<Computer> comList=new ArrayList<Computer>();
Connection con=DbUtils.getConnection();
PreparedStatement ps=null;
Computer computer=null;
try{
String sql="select * from table_computer";
ps = con.prepareStatement(sql);
ResultSet rs =
java web课程设计 机房管理系统
需积分: 45 80 浏览量
2019-03-29
16:58:13
上传
评论 14
收藏 10.62MB ZIP 举报
java web课程设计 机房管理系统 （202个子文件） 
UserService.class 25KB UserService_jadmin.class 17KB ManagerServlet_jadmin.class 15KB UserService_sadmin.class 14KB ManagerServlet.class 12KB ManagerServlet_sadmin.class 12KB ManagerServlet_stu.class 9KB LimitServlet.class 8KB UploadServlet_com.class 7KB UploadServlet.class 7KB OutputServlet.class 5KB OrderServlet.class 5KB Computer.class 3KB User.class 3KB MenuServlet.class 3KB LoginServlet.class 2KB Page.class 2KB Use.class 2KB Use.class 2KB LogoutServlet.class 2KB Limit.class 2KB Log.class 1KB Appoint.class 1KB DbUtils.class 1KB Repair.class 1KB UseCount.class 1KB StringUtil.class 664B .classpath 844B org.eclipse.wst.common.component 479B org.eclipse.wst.jsdt.ui.superType.container 49B
diamond.gif 889KB 2.gif 243KB 1.gif 32KB
jfreechart-1.0.19.jar 1.49MB jxl.jar 688KB standard.jar 384KB jcommon-1.0.16.jar 302KB commons-httpclient-3.1.jar 298KB jtds-1.2.jar 289KB gnujaxp-1.4.4.jar 226KB commons-io-1.4.jar 106KB commons-logging-1.1.1.jar 59KB commons-codec-1.4.jar 57KB commons-fileupload-1.2.jar 52KB jstl.jar 20KB UserService.java 32KB UserService_jadmin.java 22KB ManagerServlet_jadmin.java 20KB ManagerServlet.java 20KB UserService_sadmin.java 17KB ManagerServlet_sadmin.java 17KB ManagerServlet_stu.java 12KB LimitServlet.java 7KB UploadServlet_com.java 6KB UploadServlet.java 6KB OutputServlet.java 5KB OrderServlet.java 4KB MenuServlet.java 3KB Computer.java 2KB LoginServlet.java 2KB User.java 2KB Page.java 2KB LogoutServlet.java 1KB Use.java 1KB Use.java 1KB DbUtils.java 992B Limit.java 949B Appoint.java 900B Log.java 874B Repair.java 809B UseCount.java 769B StringUtil.java 463B
bgss1.jpg 1017KB bgs.jpg 1009KB bgs2.jpg 622KB bgss.jpg 374KB co.jpg 105KB type2.jpg 68KB type1.jpg 68KB 302.jpg 40KB 303.jpg 40KB 304.jpg 40KB 301.jpg 40KB bg.jpg 32KB password.jpg 14KB edit.jpg 13KB exit.jpg 12KB find.jpg 11KB add.jpg 11KB myorder.jpg 7KB order.jpg 6KB menu.jpg 6KB manage.jpg 6KB us.jpg 4KB contact.jpg 3KB home.jpg 3KB p.jpg 3KB .jsdtscope 567B add2.jsp 7KB find_use_ja.jsp 7KB共 202 条
- 1
- 2
- 3
资源评论
