小区物业管理系统web项目，带Mysql数据库sql文件，带配置说明书，采用mvc设计模式，使用html,js,jsp等

package Work; import Util.mysqlUtil; import java.sql.*; import java.util.ArrayList; import java.util.List; public class WorkBo { private Connection connection=null; mysqlUtil my=new mysqlUtil(); public WorkBo() { // TODO Auto-generated constructor stub } public List<WorkVo> getAllRecords(){//获取工作人员信息 ResultSet rs=null; Statement stmt=null; ArrayList<WorkVo> list=new ArrayList<WorkVo>(); try { //获取数据库连接(url,username,password) connection = my.getConnection(); if(connection==null) System.out.println("error"); //准备执行数据库查询 String sql="SELECT no,name,tel,sex,job,wages FROM have_wages"; //准备SQL执行; stmt =connection.createStatement(); //执行数据库查询，获取结果集 rs=stmt.executeQuery(sql); while(rs.next()){ WorkVo user=new WorkVo(); user.setNo(rs.getString(1)); user.setName(rs.getString(2)); user.setSex(rs.getString(3)); user.setTel(rs.getString(4)); user.setJob(rs.getString(5)); user.setWages(rs.getString(6)); list.add(user); } //关闭表达式对象 stmt.close(); //关闭数据库 connection.close(); }catch (SQLException e) { e.printStackTrace(); } finally{ try{ if (connection!=null && (!connection.isClosed())){ connection.close(); } }catch(SQLException e){ e.printStackTrace(); } } return list; } public WorkVo getRecord(String userid){ ResultSet rs=null; Statement stmt=null; WorkVo user=null; try { //获取数据库连接(url,username,password) connection = my.getConnection(); if(connection==null) System.out.println("error"); //准备执行数据库查询 // String sql="SELECT Hno, no,name,tel,sex FROM house_fee where no='"+userid+"'"; String sql="SELECT no,name,tel,sex,job,wages FROM have_wages where no='"+userid+"'"; //准备SQL执行; stmt =connection.createStatement(); //执行数据库查询，获取结果集 rs=stmt.executeQuery(sql); while(rs.next()){//执行完sql语句后，rs指向第一条结果的前面，所以必须执行一次next()操作 user=new WorkVo(); user.setNo(rs.getString(1)); user.setName(rs.getString(2)); user.setTel(rs.getString(3)); user.setSex(rs.getString(4)); user.setJob(rs.getString(5)); user.setWages(rs.getString(6)); } //关闭表达式对象 stmt.close(); //关闭数据库 connection.close(); //return user; }catch (SQLException e) { e.printStackTrace(); } finally{ try{ if (connection!=null && (!connection.isClosed())){ connection.close(); } }catch(SQLException e){ e.printStackTrace(); } } return user; } public boolean insertRecord(WorkVo record, String birthday)//插入员工表 { PreparedStatement pstmt1=null; PreparedStatement pstmt2=null; PreparedStatement pstmt3=null; String sql1="insert into login values(?,?,?)";//账号。密码。类型 String sql2="insert into wages values(?,?,?,?,?)";//账号，职务，工资 String sql3="insert into user1 values(?,?,?,?,?)";//账号，密码，电话，性别，生日 if(record==null) return false; boolean result=false; int number1=0,number2=0,number3=0; try{ connection = my.getConnection(); pstmt1=connection.prepareStatement(sql1); pstmt1.setString(1, record.getNo()); pstmt1.setString(2, "123"); pstmt1.setString(3, "3"); number1=pstmt1.executeUpdate();//显示影响行数 pstmt2=connection.prepareStatement(sql2); pstmt2.setString(1, record.getNo()); pstmt2.setString(2, record.getJob()); pstmt2.setString(3, record.getWages()); pstmt2.setString(4, "0"); pstmt2.setString(5,"0"); number2=pstmt2.executeUpdate();//显示影响行数 pstmt3=connection.prepareStatement(sql3); pstmt3.setString(1, record.getNo()); pstmt3.setString(2, record.getName()); pstmt3.setString(3, record.getTel()); pstmt3.setString(4, record.getSex()); pstmt3.setString(5, birthday); number3=pstmt3.executeUpdate();//显示影响行数 //关闭表达式对象 pstmt1.close(); pstmt2.close(); pstmt3.close(); //关闭数据库 connection.close(); }catch (SQLException e) { e.printStackTrace(); } finally{ try{ if (connection!=null ){ connection.close(); } }catch(SQLException e){ e.printStackTrace(); } } //System.out.println("***"+number); if(number3>0) result=true; return result; } public boolean deleteRecord(WorkVo record)//删除业主信息 { PreparedStatement pstmt1=null; PreparedStatement pstmt2=null; PreparedStatement pstmt3=null; String sql1="delete from user1 where no=?";//此处直接删除user表中的数据 String sql2="delete from login where no=?";//此处直接删除login表中的数据 String sql3="delete from wages where no=?";//此处直接删除wages表中的数据 if(record==null) return false; boolean result=false; int number1=0,number2=0,number3=0; try{ connection = my.getConnection(); pstmt1=connection.prepareStatement(sql1); pstmt2=connection.prepareStatement(sql2); pstmt3=connection.prepareStatement(sql3); pstmt1.setString(1, record.getNo()); pstmt2.setString(1, record.getNo()); pstmt3.setString(1, record.getNo()); number1=pstmt1.executeUpdate();//显示影响行数 number2=pstmt2.executeUpdate();//显示影响行数 number3=pstmt3.executeUpdate();//显示影响行数 pstmt1.close(); pstmt2.close(); pstmt3.close(); //关闭数据库 connection.close(); }catch (SQLException e) { e.printStackTrace(); } finally{ try{ if (connection!=null && (!connection.isClosed())){ connection.close(); } }catch(SQLException e){ e.printStackTrace(); } } if(number3>0) result=true; return result; } public boolean updateRecord(WorkVo beforeRecord,WorkVo afterRecord) { if(beforeRecord==null || afterRecord==null) return false; PreparedStatement pstmt1=null; PreparedStatement pstmt2=null; String sql1="update wages set job=?,wages=?"+"where no="+beforeRecord.getNo();//更新wage