新生报名管理系统

/* * * * * 对专业设置和管理员的操作 * * */ package com.test2; import java.io.Serializable; 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.test1.ConnectionUtils; //第一模块 public class Student_adminDao implements Serializable{ //查找管理员信息 String search_admin = "select type from adminstrator where admin_name = ? and mima = ?"; //查询专业信息 String search_major = "select zhuanye_num,zhuanye_name,yuanxi,class_num,feiyong from zhuanye limit ?,?"; //查找某个专业信息 String search_rows = "select zhuanye_num,zhuanye_name,yuanxi,class_num,feiyong from zhuanye where zhuanye_num=?"; // 2增加管理员 String add_admin = "insert into adminstrator values(?,?,?)"; // 3删除管理员 String del_admin = "delete from adminstrator where admin_name = ?"; // 4显示所有用户 String fenye_admin = "select admin_name,mima,type from adminstrator limit ?,?"; // 5显示一条管理员信息 String one_msg = "select mima,type from adminstrator where admin_name = ?"; // 6更新一条管理员信息 String xin_msg = "update adminstrator set mima=?,type=? where admin_name=?"; // 7新增一个管理员 String xinzeng = "insert into adminstrator values (?,?,?)"; // 8查找管理员信息 String chazhao = "select * from adminstrator where admin_name = ?"; public int find_admin(Adminstrator admin){ //管理员设置 int flag = -1; Connection conn = null; PreparedStatement state = null; ResultSet res = null; try { conn = ConnectionUtils.openConnection(); state = conn.prepareStatement(search_admin); state.setString(1, admin.getName()); state.setString(2, admin.getMima()); res = state.executeQuery(); if(res.next()){ flag =res.getInt(1); } } catch (SQLException e) { e.printStackTrace(); }finally{ ConnectionUtils.closeConnection(conn); } return flag; } // 增加管理员 public void AddAdmin(Adminstrator admin){ Connection conn = null; PreparedStatement state = null; try { conn = ConnectionUtils.openConnection(); state = conn.prepareStatement(add_admin); state.setString(1, admin.getName()); state.setString(2, admin.getMima()); state.setInt(1, admin.getType()); state.executeUpdate(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } // 删除管理员 public void DelAdmin(String name){ Connection conn = null; PreparedStatement state = null; try { conn = ConnectionUtils.openConnection(); state = conn.prepareStatement(del_admin); state.setString(1, name); state.executeUpdate(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } // 分页后页数 public int FenYe(int perpages){ int pages = 0; int num = 0; String admin_num = "select count(*) from adminstrator"; Connection conn = null; PreparedStatement state = null; ResultSet res = null; try { conn = ConnectionUtils.openConnection(); state = conn.prepareStatement(admin_num); res = state.executeQuery(); if(res.next()){ num = res.getInt(1); if(num%perpages == 0){ pages = num / perpages; }else{ pages = num / perpages + 1; } } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return pages; } // 查找当前页面的数据 public List<Adminstrator> fenYe_admin(int page,int perpages){ List<Adminstrator> list = new ArrayList<Adminstrator>(); Connection conn = null; PreparedStatement state = null; ResultSet res = null; try { conn = ConnectionUtils.openConnection(); state = conn.prepareStatement(fenye_admin); state.setInt(1, (page-1)*perpages); state.setInt(2, perpages); res = state.executeQuery(); while(res.next()){ Adminstrator admin = new Adminstrator(); admin.setName(res.getString(1)); admin.setMima(res.getString(2)); admin.setType(res.getInt(3)); list.add(admin); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return list; } // 显示一条管理员信息 public Adminstrator find_One(String name){ Adminstrator admin = new Adminstrator(); Connection conn = null; PreparedStatement state = null; ResultSet res = null; try { conn = ConnectionUtils.openConnection(); state = conn.prepareStatement(one_msg); state.setString(1, name); res = state.executeQuery(); if(res.next()){ admin.setName(name); admin.setMima(res.getString(1)); admin.setType(res.getInt(2)); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return admin; } // 更新一条管理员信息 public void GengXin(Adminstrator admin){ Connection conn = null; PreparedStatement state = null; try { conn = ConnectionUtils.openConnection(); state = conn.prepareStatement(xin_msg); state.setString(1, admin.getMima()); state.setInt(2, admin.getType()); state.setString(3, admin.getName()); System.out.println(admin.getType()); state.executeUpdate(); } catch (SQLException e) { e.printStackTrace(); } } // 新增一名管理员 public void XingZeng(Adminstrator admin){ Connection conn = null; PreparedStatement state = null; try { conn = ConnectionUtils.openConnection(); state = conn.prepareStatement(xinzeng); state.setString(1, admin.getName()); state.setString(2, admin.getMima()); state.setInt(3, admin.getType()); state.executeUpdate(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } //查询所有院系 public List<yuanxi_bean> find_yuanxiall(){ List<yuanxi_bean> list=new ArrayList<yuanxi_bean>(); String sql="select yuanxi_num,yuanxi_name from yuanxi"; Connection conn = null; PreparedStatement state = null; ResultSet res = null; try { conn = ConnectionUtils.openConnection(); state=conn.prepareStatement(sql); res=state.executeQuery(); while(res.next()){ yuanxi_bean yuanxi=new yuanxi_bean(); yuanxi.setYuanxi_num(res.getInt(1)); yuanxi.setYuanxi_name(res.getString(2)); list.add(yuanxi); } } catch (SQLException e) { e.printStackTrace(); }finally{ ConnectionUtils.closeConnection(conn); } return list; } //判断专业是否存在 public int judge_zhuanye(int major_num,String major_name){ int flag=0; int count=0; String sql="select count(*) from zhuanye where zhuanye_num=? or zhuanye_name=?"; Connection conn = null; PreparedStatement state = null; ResultSet res = null; try { conn = ConnectionUtils.openConnection(); state=conn.prepareStatement(sql); state.setInt(1, major_num); state.setString(2, major_name); res=state.executeQuery(); while(res.next()){ count=res.getInt(1); if(count!=0){ flag=0; }else{ flag=1; } } } catch (SQLException e) { e.printStackTrace(); }finally{ ConnectionUtils.closeConnection(conn); } return flag; } public void insert_zhuanye(int major_num,String major_name,String yuanxi_name,double zhuanye_money){ String sql="insert into zhuanye(zhuanye_num,zhuanye_name,yuanxi,class_num,feiyong) values(?,?,?,?,?)"; Connection conn = null; PreparedStatement state = null; ResultSet res = null; try { conn = ConnectionUtils.openConnection(); state=conn.prepareStatement(sql); state.setInt(1, major_num); state.setString(2, major_name); state.setString(3, yuanxi_name); state.setInt(4, 0); state.setDouble(5, zhuanye_money); state.executeUpdate(); } catch (SQLException e) { e.printStackTrace(); }fina