用JSP开发的影院售票系统

package dao; import java.sql.*; import java.util.ArrayList; import java.util.HashMap; import java.util.List; import entity.Film; public class DBUtil { private Connection con = null; private PreparedStatement pst = null; private ResultSet rs = null; /** * 连接数据库的方法 * @return 数据库连接 */ public Connection getConnection(){ try { Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver"); return DriverManager.getConnection("jdbc:sqlserver://localhost:1433;databaseName=film", "sa", "sa"); } catch (ClassNotFoundException e) { // TODO Auto-generated catch block e.printStackTrace(); System.out.println("加载驱动失败"); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); System.out.println("连接数据库失败"); } return null; } /** * 关闭数据库连接 , 释放资源 */ public void close(){ try { if (rs != null){ rs.close(); } if (pst != null){ pst.close(); } if (con != null){ con.close(); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } /** * 更新所座位号状态的方法 * @return */ public boolean update(){ boolean flag = false; try { con = getConnection(); pst = con.prepareStatement("update film set state=0"); int row = pst.executeUpdate(); flag = row > 0 ? true : false; } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } finally { close(); } return flag; } /** * 根据座位号更新座位状态 * @param seatId 座位号 * @return */ public boolean update(String seatId){ boolean flag = false; try { con = getConnection(); pst = con.prepareStatement("update film set state=1 where seatId=?"); pst.setString(1, seatId); int row = pst.executeUpdate(); flag = row > 0 ? true : false; } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } finally { close(); } return flag; } public HashMap<String, List<Film>> getAll(){ HashMap<String, List<Film>> map = new HashMap<String, List<Film>>(); try { con = getConnection(); pst = con.prepareStatement("select * from film order by seatId"); rs = pst.executeQuery(); List<Film> list; String key = "null"; Film f; list = new ArrayList<Film>(); while (rs.next()) { f = new Film(); f.setSeatId(rs.getString(1)); if (!f.getSeatId().substring(0,1).equals(key)){ if (list.size() > 0){ map.put(key, list); } list = new ArrayList<Film>(); key = f.getSeatId().substring(0,1); } f.setState(rs.getInt(2)); list.add(f); } map.put(key, list); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } finally{ close(); } return map; } }