权限管理系统（源码+数据库）

package com.qxglxt.DAO; 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 java.util.Vector; import com.qxglxt.VO.Company_VO; import com.qxglxt.VO.Groupmanager_VO; import com.qxglxt.VO.Master_VO; import com.qxglxt.VO.SectorVO; import com.qxglxt.struts.form.MasterForm; import com.qxglxt.util.LinkDB; import org.apache.struts.util.LabelValueBean; public class Master_daoImp { public String selectCompanyName_Company(int id){ String name = null; PreparedStatement ps = null; ResultSet rs = null; Connection con = null; con = LinkDB.getConnection(); String sql = "select companyName from company where companyId = ?"; try{ ps = con.prepareStatement(sql); ps.setInt(1, id); rs = ps.executeQuery(); while(rs.next()){ name = rs.getString("companyName"); } }catch(SQLException e){ e.printStackTrace(); }finally{ try{ rs.close(); ps.close(); con.close(); }catch(SQLException e){} } return name; } //根据人员ID查询其所在部门 public String selectsectorName_Sector(int id){ String name = null; PreparedStatement ps = null; ResultSet rs = null; Connection con = null; con = LinkDB.getConnection(); String sql = "select sectorName from sector where masterId = ?"; try{ ps = con.prepareStatement(sql); ps.setInt(1, id); rs = ps.executeQuery(); while(rs.next()){ name = rs.getString("sectorName"); } }catch(SQLException e){ e.printStackTrace(); }finally{ try{ rs.close(); ps.close(); con.close(); }catch(SQLException e){} } return name; } public Vector selectMaster(){ Vector V = new Vector(); PreparedStatement ps = null; ResultSet rs = null; Connection con = null; con = LinkDB.getConnection(); String sql ="select * from master"; try{ ps = con.prepareStatement(sql); rs = ps.executeQuery(); while(rs.next()){ Master_VO vo = new Master_VO(); vo.setMasterId(rs.getInt("masterId")); vo.setUserName(rs.getString("userName")); vo.setPassword(rs.getString("password")); vo.setTrueName(rs.getString("trueName")); vo.setSex(rs.getInt("sex")); vo.setCompanyId(rs.getInt("companyId")); vo.setSectorId(rs.getInt("sectorId")); vo.setPost(rs.getString("post")); vo.setEmail(rs.getString("email")); vo.setType(rs.getInt("type")); V.add(vo); } }catch(SQLException e){ e.printStackTrace(); }finally{ try{ rs.close(); ps.close(); con.close(); }catch(SQLException e){} } return V; } public Vector<LabelValueBean> selectCompany(){ Vector<LabelValueBean> V = new Vector<LabelValueBean>(); PreparedStatement ps = null; ResultSet rs = null; Connection con = null; con = LinkDB.getConnection(); String sql ="select companyId,companyName from company"; try{ ps = con.prepareStatement(sql); rs = ps.executeQuery(); while(rs.next()){ // Company_VO vo = new Company_VO(); // vo.setCompanyId(rs.getInt("companyId")); // vo.setCompanyName(rs.getString("companyName")); V.add(new LabelValueBean(rs.getString("companyName"),rs.getString("companyId"))); } }catch(SQLException e){ e.printStackTrace(); }finally{ try{ rs.close(); ps.close(); con.close(); }catch(SQLException e){} } return V; } //查询所有部门 public ResultSet selectSector(){ PreparedStatement ps = null; ResultSet rs = null; Connection con = null; con = LinkDB.getConnection(); String sql ="select sectorId,sectorName,companyId from sector"; try{ ps = con.prepareStatement(sql); //ps.setInt(1, id); rs = ps.executeQuery(); }catch(SQLException e){ e.printStackTrace(); } return rs; } //查询角色表，获得角色ID和角色名称 public List<LabelValueBean> selectGroupmanager(){ List<LabelValueBean> actionList=new ArrayList<LabelValueBean>(); PreparedStatement ps = null; ResultSet rs = null; Connection con = null; con = LinkDB.getConnection(); String sql ="select groupId,groupName from groupmanager"; try{ ps = con.prepareStatement(sql); rs = ps.executeQuery(); while(rs.next()){ actionList.add(new LabelValueBean(rs.getString("groupId"),rs.getString("groupName"))); } }catch(SQLException e){ e.printStackTrace(); }finally{ try{ rs.close(); ps.close(); con.close(); }catch(SQLException e){} } return actionList; } //根据公司ID查询他所有的部门名称和ID public Vector selectSectorNew(int id){ Vector V = new Vector(); PreparedStatement ps = null; ResultSet rs = null; Connection con = null; con = LinkDB.getConnection(); String sql ="select sectorId,sectorName from sector where companyId = ?"; try{ ps = con.prepareStatement(sql); ps.setInt(1, id); rs = ps.executeQuery(); while(rs.next()){ SectorVO vo = new SectorVO(); vo.setSectorId(rs.getInt("sectorId")); vo.setSectorName(rs.getString("sectorName")); V.add(vo); } }catch(SQLException e){ e.printStackTrace(); }finally{ try{ rs.close(); ps.close(); con.close(); }catch(SQLException e){} } return V; } //根据公司ID查询公司名称 public String selectCompanyName_id(int id){ String name = null; PreparedStatement ps = null; ResultSet rs = null; Connection con = null; con = LinkDB.getConnection(); String sql ="select companyName from company where companyId =?"; try{ ps = con.prepareStatement(sql); ps.setInt(1, id); rs = ps.executeQuery(); while(rs.next()){ name = rs.getString("companyName"); } }catch(SQLException e){ e.printStackTrace(); }finally{ try{ rs.close(); ps.close(); con.close(); }catch(SQLException e){} } return name; } //条件查询人员表 public Vector select(int id1,int id2){ Vector V= new Vector(); PreparedStatement ps = null; ResultSet rs = null; Connection con = null; con = LinkDB.getConnection(); String sql ="select masterId,trueName,companyId,sectorId,sex,post,type from master where companyId=? and sectorId=?"; try{ ps = con.prepareStatement(sql); ps.setInt(1, id1); ps.setInt(2, id2); rs = ps.executeQuery(); while(rs.next()){ Master_VO vo = new Master_VO(); vo.setMasterId(rs.getInt("masterId")); vo.setTrueName(rs.getString("trueName")); vo.setSex(rs.getInt("sex")); vo.setCompanyId(rs.getInt("companyId")); vo.setSectorId(rs.getInt("sectorId")); vo.setPost(rs.getString("post")); vo.setType(rs.getInt("type")); V.add(vo); } }catch(SQLException e){ e.printStackTrace(); }finally{ try{ rs.close(); ps.close(); con.close(); }catch(SQLException e){} } return V; } //根据ID删除方法 public void deleteMaster(int id)throws SQLException{ PreparedStatement ps = null; Connection con = null; con = LinkDB.getConnection(); String sql = "delete master where masterId =?"; ps = con.prepareStatement(sql); ps.setInt(1,id); int count = ps.executeUpdate(); if (count > 0) { //System.out.println("删除成功!"); } else { //System.out.println("删除失败!"); } con = LinkDB.getConnection(); String sql1 ="delete mastergroup where masterId =?"; ps=con.prepareStatement(sql1); ps.setInt(1, id); ps.execute(); } public ResultSet queryMasterId(String userName)throws SQLException{ ResultSet rs = null; Connection con = null; PreparedStatement ps = null; con = LinkDB.getConnection(); String sql ="select masterId,userName from master where userName='"+userName+"'"; ps = con.prepareStatement(sql); rs = ps.executeQuery(); retu