基于jsp+bootstrap+layui+servlet+mysql的教室信息管理系统

package dao; import entity.JwClass; import util.DBConnection; import java.sql.*; import java.util.ArrayList; import java.util.List; public class JwClassDao { private Connection conn = null; private PreparedStatement ps = null; private ResultSet rs = null; public JwClass selectById(String id){ String sql = "SELECT * FROM jw_class where id = ?"; try { conn = DBConnection.getConnection(); ps = conn.prepareStatement(sql); ps.setString(1,id); rs = ps.executeQuery(); if (rs.next()) { JwClass jwClass = new JwClass(); jwClass.setId(rs.getString("id")); jwClass.setCamp_area_id(rs.getString("camp_area_id")); jwClass.setCamp_area(rs.getString("camp_area")); jwClass.setBuilding_id(rs.getString("building_id")); jwClass.setBuilding_name(rs.getString("building_name")); jwClass.setRoom_name(rs.getString("room_name")); jwClass.setFloor_num(rs.getInt("floor_num")); jwClass.setHouse_num(rs.getInt("house_num")); jwClass.setRoom_type_name(rs.getString("room_type_name")); jwClass.setAllow_num(rs.getInt("allow_num")); jwClass.setArea(rs.getDouble("area")); jwClass.setStatus_flag(rs.getString("status_flag")); jwClass.setCreate_by(rs.getString("create_by")); jwClass.setCreate_time(rs.getTimestamp("create_time")); jwClass.setUpdate_by(rs.getString("update_by")); jwClass.setUpdate_time(rs.getTimestamp("update_time")); return jwClass; } } catch (ClassNotFoundException e) { e.printStackTrace(); } catch (SQLException e) { e.printStackTrace(); } catch (Exception e) { e.printStackTrace(); } return null; } public List<JwClass> selectAll(){ List<JwClass>tqmPlans = new ArrayList<>(); String sql = "SELECT * FROM jw_class"; try { conn = DBConnection.getConnection(); ps = conn.prepareStatement(sql); rs = ps.executeQuery(); while (rs.next()) { JwClass jwClass = new JwClass(); jwClass.setId(rs.getString("id")); jwClass.setCamp_area_id(rs.getString("camp_area_id")); jwClass.setCamp_area(rs.getString("camp_area")); jwClass.setBuilding_id(rs.getString("building_id")); jwClass.setBuilding_name(rs.getString("building_name")); jwClass.setRoom_name(rs.getString("room_name")); jwClass.setFloor_num(rs.getInt("floor_num")); jwClass.setHouse_num(rs.getInt("house_num")); jwClass.setRoom_type_name(rs.getString("room_type_name")); jwClass.setAllow_num(rs.getInt("allow_num")); jwClass.setArea(rs.getDouble("area")); jwClass.setStatus_flag(rs.getString("status_flag")); jwClass.setCreate_by(rs.getString("create_by")); jwClass.setCreate_time(rs.getTimestamp("create_time")); jwClass.setUpdate_by(rs.getString("update_by")); jwClass.setUpdate_time(rs.getTimestamp("update_time")); tqmPlans.add(jwClass); } } catch (ClassNotFoundException e) { e.printStackTrace(); } catch (SQLException e) { e.printStackTrace(); } catch (Exception e) { e.printStackTrace(); } return tqmPlans; } public int insert(JwClass tqmPlan){ String sql = "INSERT INTO jw_class(id,camp_area_id,camp_area,building_id,building_name,room_name,floor_num" + ",house_num,room_type_name,allow_num,area,status_flag,create_by,create_time,update_by" + ",update_time) VALUE (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)"; try { conn = DBConnection.getConnection(); ps = conn.prepareStatement(sql); ps.setString(1,tqmPlan.getId()); ps.setString(2,tqmPlan.getCamp_area_id()); ps.setString(3,tqmPlan.getCamp_area()); ps.setString(4,tqmPlan.getBuilding_id()); ps.setString(5,tqmPlan.getBuilding_name()); ps.setString(6,tqmPlan.getRoom_name()); ps.setInt(7,tqmPlan.getFloor_num()); ps.setInt(8,tqmPlan.getHouse_num()); ps.setString(9,tqmPlan.getRoom_type_name()); ps.setInt(10,tqmPlan.getAllow_num()); ps.setDouble(11,tqmPlan.getArea()); ps.setString(12,tqmPlan.getStatus_flag()); ps.setString(13,tqmPlan.getCreate_by()); ps.setTimestamp(14,tqmPlan.getCreate_time()); ps.setString(15,tqmPlan.getUpdate_by()); ps.setTimestamp(16,tqmPlan.getUpdate_time()); int i = ps.executeUpdate(); return i; } catch (Exception e) { e.printStackTrace(); } return 0; } public int updateById(JwClass tqmPlan){ try { String sql= "UPDATE jw_class SET camp_area_id=?,camp_area=?,building_id=?,building_name=?,room_name=?,floor_num=?," + "house_num=?,room_type_name=?,allow_num=?,area=?,status_flag=?,create_by=?" + ",create_time=?,update_by=?," + "update_time=? where id = ?"; conn = DBConnection.getConnection(); ps = conn.prepareStatement(sql); ps.setString(1,tqmPlan.getCamp_area_id()); ps.setString(2,tqmPlan.getCamp_area()); ps.setString(3,tqmPlan.getBuilding_id()); ps.setString(4,tqmPlan.getBuilding_name()); ps.setString(5,tqmPlan.getRoom_name()); ps.setInt(6,tqmPlan.getFloor_num()); ps.setInt(7,tqmPlan.getHouse_num()); ps.setString(8,tqmPlan.getRoom_type_name()); ps.setInt(9,tqmPlan.getAllow_num()); ps.setDouble(10,tqmPlan.getArea()); ps.setString(11,tqmPlan.getStatus_flag()); ps.setString(12,tqmPlan.getCreate_by()); ps.setTimestamp(13,tqmPlan.getCreate_time()); ps.setString(14,tqmPlan.getUpdate_by()); ps.setTimestamp(15,tqmPlan.getUpdate_time()); ps.setString(16,tqmPlan.getId()); int i = ps.executeUpdate(); return i; } catch (SQLException e) { e.printStackTrace(); } catch (Exception e) { e.printStackTrace(); } return 0; } public int deleteById(String id) { int i = 0; try { conn = DBConnection.getConnection(); String sql = "DELETE FROM jw_class WHERE id = ?"; ps = conn.prepareStatement(sql); ps.setString(1,id); i = ps.executeUpdate(); } catch (Exception e) { e.printStackTrace(); } return i; } }