图书查询借阅管理系统的源码

package com.rain.dao; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.util.ArrayList; import com.rain.bean.AdminBean; import com.rain.bean.BookBean; import com.rain.util.DBUtil; /** * 有关读者账号的连接数据库操作，登录验证，注册，修改账号，修改密码 */ public class AdminDao { /** * 登录验证功能，传入用户名和密码，在数据库中查找，如果找到了，返回true，没找到则返回false * * @param username * @param password * @return */ public boolean Login_verify(String username, String password) { Connection conn = DBUtil.getConnectDb(); PreparedStatement stm = null; ResultSet rs = null; String sql = "select * from admin where username='" + username + " 'and password='" + password + "'"; try { stm = conn.prepareStatement(sql); rs = stm.executeQuery(); if (rs.next()) { return true; } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } finally { DBUtil.CloseDB(rs, stm, conn); } return false; } /** * 注册账号的函数，传入账号，密码，姓名，邮箱，手机号，借阅天数，可借阅数 * * @param username * @param password * @param name * @param email * @param phone * @param times * @param lend_num * @param max_num */ public void Register(String username, String password, String name, String email, String phone, int lend_num, int max_num) { // TODO Auto-generated method stub Connection conn = DBUtil.getConnectDb(); String sql = "insert into admin(status,username,password,name,email,phone,lend_num,max_num) values(?,?,?,?,?,?,?,?)"; int rs = 0; PreparedStatement stm = null; try { stm = conn.prepareStatement(sql); stm.setInt(1, 1); stm.setString(2, username); stm.setString(3, password); stm.setString(4, name); stm.setString(5, email); stm.setString(6, phone); stm.setInt(7, lend_num); stm.setInt(8, max_num); rs = stm.executeUpdate(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } /** * 新增管理员账号，传入账号，密码，姓名，邮箱，手机号 * * @param username * @param password * @param name * @param email * @param phone * @param times * @param lend_num * @param max_num */ public void Register2(String username, String password, String name, String email, String phone) { // TODO Auto-generated method stub Connection conn = DBUtil.getConnectDb(); String sql = "insert into admin(status,username,password,name,email,phone) values(?,?,?,?,?,?)"; int rs = 0; PreparedStatement stm = null; try { stm = conn.prepareStatement(sql); stm.setInt(1, 2); stm.setString(2, username); stm.setString(3, password); stm.setString(4, name); stm.setString(5, email); stm.setString(6, phone); rs = stm.executeUpdate(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } /** * 根据传入的账号，密码，来查找对应的读者信息，返回一个AdminBean类型， * * @param username * @param password * @return */ public AdminBean getAdminInfo(String username, String password) { // TODO Auto-generated method stub AdminBean adminbean = new AdminBean(); Connection conn = DBUtil.getConnectDb(); String sql = "select * from admin where username= '"+username+"' and password= '"+password+"'"; PreparedStatement stm = null; ResultSet rs = null; try { stm = conn.prepareStatement(sql); rs = stm.executeQuery(); if (rs.next()) { adminbean.setAid(rs.getInt("aid")); adminbean.setUsername(rs.getString("username")); adminbean.setName(rs.getString("name")); adminbean.setPassword(rs.getString("password")); adminbean.setEmail(rs.getString("email")); adminbean.setPhone(rs.getString("phone")); adminbean.setTimes(rs.getInt("times")); adminbean.setStatus(rs.getInt("status")); adminbean.setLend_num(rs.getInt("lend_num")); adminbean.setMax_num(rs.getInt("max_num")); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } finally { DBUtil.CloseDB(rs, stm, conn); } return adminbean; } /** * 获取全部用户的信息，其中sql语句中的status=1，表示只查找读者，不显示管理员的 * * @return */ public ArrayList<AdminBean> get_ListInfo() { ArrayList<AdminBean> tag_Array = new ArrayList<AdminBean>(); Connection conn = DBUtil.getConnectDb(); String sql = "select * from admin where status=1"; PreparedStatement stm = null; ResultSet rs = null; try { stm = conn.prepareStatement(sql); rs = stm.executeQuery(); while (rs.next()) { AdminBean adminbean = new AdminBean(); adminbean.setAid(rs.getInt("aid")); adminbean.setUsername(rs.getString("username")); adminbean.setName(rs.getString("name")); adminbean.setPassword(rs.getString("password")); adminbean.setEmail(rs.getString("email")); adminbean.setPhone(rs.getString("phone")); adminbean.setTimes(rs.getInt("times")); adminbean.setStatus(rs.getInt("status")); adminbean.setLend_num(rs.getInt("lend_num")); adminbean.setMax_num(rs.getInt("max_num")); tag_Array.add(adminbean); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } finally { DBUtil.CloseDB(rs, stm, conn); } return tag_Array; } /** * 获取全部用户的信息，其中sql语句中的status=2，表示只查找管理员，不显示读者的 * * @return */ public ArrayList<AdminBean> get_ListInfo2() { ArrayList<AdminBean> tag_Array = new ArrayList<AdminBean>(); Connection conn = DBUtil.getConnectDb(); String sql = "select * from admin where status=2"; PreparedStatement stm = null; ResultSet rs = null; try { stm = conn.prepareStatement(sql); rs = stm.executeQuery(); while (rs.next()) { AdminBean adminbean = new AdminBean(); adminbean.setAid(rs.getInt("aid")); adminbean.setUsername(rs.getString("username")); adminbean.setName(rs.getString("name")); adminbean.setPassword(rs.getString("password")); adminbean.setEmail(rs.getString("email")); adminbean.setPhone(rs.getString("phone")); adminbean.setTimes(rs.getInt("times")); adminbean.setStatus(rs.getInt("status")); tag_Array.add(adminbean); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } finally { DBUtil.CloseDB(rs, stm, conn); } return tag_Array; } /** * 获取全部用户的信息并排序，其中sql语句中的status=1，表示只查找读者，不显示管理员的 * * @return */ public ArrayList<AdminBean> get_ListInfo3() { ArrayList<AdminBean> tag_Array = new ArrayList<AdminBean>(); Connection conn = DBUtil.getConnectDb(); String sql = "select * from admin where status=1 order by times desc"; PreparedStatement stm = null; ResultSet rs = null; try { stm = conn.prepareStatement(sql); rs = stm.executeQuery(); while (rs.next()) { AdminBean adminbean = new AdminBean(); adminbean.setAid(rs.getInt("aid")); adminbean.setUsername(rs.getString("username")); adminbean.setName(rs.getString("name")); adminbean.setPassword(rs.getString("password")); adminbean.setEmail(rs.getString("email")); adminbean.setPhone(rs.getString("phone")); adminbean.setTimes(rs.getInt("times")); adminbean.setStatus(rs.getInt("status")); adminbean.setLend_num(rs.getInt("lend_num")); adminbean.setMax_num(rs.getInt("max_num")); tag_Array.add(adminbean); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } finally { DBUtil.CloseDB(rs, stm, conn); } return tag_Array; } /** * 根据传入的aid，查找到对应的读者的全部信息，返回一个AdminBean类型的数据 * * @param aid * @return */ public AdminBean get_AidInfo(int aid) { AdminBean adminbean = new AdminBean(); Connection conn = DBUtil.getConnectDb(); String sql = "select * from admin where aid=" + aid; PreparedStatement stm = null; ResultSet rs = null