struts图书管理系统

package com.gton.bean.db; import java.sql.*; import com.gton.bean.*; import com.gton.util.*; import java.util.*; public class DataBean { private Connection conn = null; private java.sql.Statement statement=null; private ResultSet res = null; private java.sql.PreparedStatement prepar = null; // private java.sql.CallableStatement proc = null; public int pagecount = 0; public int Pagecount1; public int Pagecount; public DataBean() { //构造函数 try { Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver"); conn = DriverManager .getConnection( "jdbc:microsoft:sqlserver://127.0.0.1:1433;databasename=book", "sa", "520156"); System.out.println("连接成功"); } catch (SQLException ex) { System.out.println(ex.getMessage() + "路径错误"); } catch (ClassNotFoundException ex) { System.out.println(ex.getMessage() + "驱动错误"); } } public void Close() { //关闭方法 try { if (res != null) { res.close(); } if (prepar != null) { prepar.close(); } if (conn != null) { conn.close(); } } catch (SQLException ex) { ex.printStackTrace(); } System.out.println("关闭成功"); } ///////////////////////////////////////////////////////////////////////////////////////// /////////////////////////////////Admin登陆方法///////////////////////////////////////////////// public boolean checkAdminLogin(AdminBean ab) { // 验证登陆 boolean result = false; if (!MyString.checkParameter(ab.getAdmin_Name() + ab.getAdmin_Pwd())) { System.out.println("有非法字符！"); return result; } try { String sql = "select count(*) from Admin where Admin_Name=? and Admin_Pwd=?"; prepar = conn.prepareStatement(sql); prepar.setString(1, ab.getAdmin_Name()); prepar.setString(2, ab.getAdmin_Pwd()); res = prepar.executeQuery(); if (res.next()) { if (res.getInt(1) > 0) { result = true; } } } catch (Exception e) { e.printStackTrace(); } return result; } public AdminBean getAdminBean(AdminBean ab) { // 获取AdminBean持久化 AdminBean admin = null; try { String sql = "select * from Admin where Admin_Name=? and Admin_Pwd=?"; prepar = conn.prepareStatement(sql); prepar.setString(1, ab.getAdmin_Name()); prepar.setString(2, ab.getAdmin_Pwd()); res = prepar.executeQuery(); if (res.next()) { admin = new AdminBean(); admin.setAdmin_ID(res.getInt("Admin_ID")); admin.setAdmin_Name(res.getString("Admin_Name")); admin.setAdmin_Pwd(res.getString("Admin_Pwd")); admin.setAdmin_Flag(res.getString("Admin_Flag")); } } catch (Exception e) { e.printStackTrace(); } return admin; } ///////////////////////////////////////////////////////////////////////////////////////// /////////////////////////////////User登陆方法///////////////////////////////////////////////// public boolean checkUserLogin(UserBean ub) { // 验证登陆 boolean result = false; if (!MyString.checkParameter(ub.getUsers_Name() + ub.getUsers_Pwd())) { return result; } try { String sql = "select count(*) from Users where Users_Name=? and Users_Pwd=?"; prepar = conn.prepareStatement(sql); prepar.setString(1, ub.getUsers_Name()); prepar.setString(2, ub.getUsers_Pwd()); res = prepar.executeQuery(); if (res.next()) { if (res.getInt(1) > 0) { result = true; } } } catch (Exception e) { e.printStackTrace(); } return result; } public UserBean getUserBean(UserBean ub) { // 获取UserBean持久化 UserBean user = null; try { String sql = "select * from Users where Users_Name=? and Users_Pwd=?"; prepar = conn.prepareStatement(sql); prepar.setString(1, ub.getUsers_Name()); prepar.setString(2, ub.getUsers_Pwd()); res = prepar.executeQuery(); if (res.next()) { user = new UserBean(); user.setUsers_ID(res.getInt("Users_ID")); user.setUsers_Name(res.getString("Users_Name")); user.setUsers_Pwd(res.getString("Users_Pwd")); user.setUsers_Adds(res.getString("Users_Adds")); user.setUsers_Class(res.getString("Users_Class")); user.setUsers_Count(res.getInt("Users_Count")); user.setUsers_Phone(res.getString("Users_Phone")); user.setUsers_Sex(res.getString("Users_Sex")); } } catch (Exception e) { e.printStackTrace(); } return user; } public UserBean getUserBean(int users_ID) { // 获取UserBean持久化 UserBean user = null; try { String sql = "select * from Users where Users_ID=?"; prepar = conn.prepareStatement(sql); prepar.setInt(1, users_ID); res = prepar.executeQuery(); if (res.next()) { user = new UserBean(); System.out.println("UserID:"+res.getInt("Users_ID")); System.out.println("Username:"+res.getString("Users_Name")); user.setUsers_ID(res.getInt("Users_ID")); user.setUsers_Name(res.getString("Users_Name")); user.setUsers_Pwd(res.getString("Users_Pwd")); user.setUsers_Adds(res.getString("Users_Adds")); user.setUsers_Class(res.getString("Users_Class")); user.setUsers_Count(res.getInt("Users_Count")); user.setUsers_Phone(res.getString("Users_Phone")); user.setUsers_Sex(res.getString("Users_Sex")); } } catch (Exception e) { e.printStackTrace(); } return user; } ///////////////////////////////////////////////////////////////////////////////////////// /////////////////////////////////User注册方法///////////////////////////////////////////////// public boolean regUser(UserBean ub) { try { prepar = conn.prepareStatement( "insert into Users (Users_Name,Users_Pwd,Users_Class,Users_Sex,Users_Count,Users_Phone,Users_Adds) values(?,?,?,?,?,?,?)"); prepar.setString(1, ub.getUsers_Name()); prepar.setString(2, ub.getUsers_Pwd()); prepar.setString(3, ub.getUsers_Class()); prepar.setString(4, ub.getUsers_Sex()); prepar.setInt(5, ub.getUsers_Count()); prepar.setString(6, ub.getUsers_Phone()); prepar.setString(7, ub.getUsers_Adds()); int flag = prepar.executeUpdate(); if (flag == 0) { return false; } } catch (SQLException ex) { ex.printStackTrace(); return false; } return true; } public boolean isHasName(String userName) { try { prepar