MVC模式的酒店管理系统jsp

package com.accp.qi.dao; import java.sql.Statement; import java.sql.Connection; import java.sql.ResultSet; import com.accp.qi.javaBean.Rooms; import java.util.ArrayList; import com.accp.qi.javaBean.Client; import java.text.SimpleDateFormat; import java.util.Date; import com.accp.qi.javaBean.NoteMessage; public class RoomDao { public RoomDao() { } public boolean insert(String sql) { boolean flag = false; Connection con = null; Statement st = null; try { con = ConnectionManager.getConnection(); st = con.createStatement(); int count = st.executeUpdate(sql); if (count > 0) { flag = true; } } catch (Exception ex) { ex.printStackTrace(); } finally { ConnectionManager.closeStatement(st); ConnectionManager.closeConnection(con); } return flag; } public boolean hasUsers(String sql) { boolean flag = false; Connection con = null; Statement st = null; ResultSet rs = null; try { con = ConnectionManager.getConnection(); st = con.createStatement(); rs = st.executeQuery(sql); if (rs.next()) { flag = true; } } catch (Exception ex) { ex.printStackTrace(); } finally { ConnectionManager.closeResultSet(rs); ConnectionManager.closeStatement(st); ConnectionManager.closeConnection(con); } return flag; } public ArrayList getroom(String sql) { ArrayList list = new ArrayList(); Connection con = null; Statement st = null; ResultSet rs = null; try { con = ConnectionManager.getConnection(); st = con.createStatement(); rs = st.executeQuery(sql); while (rs.next()) { Rooms room = new Rooms(); room.setRoomid(rs.getInt(1)); room.setRoomtype(rs.getString(2)); room.setPrice(rs.getFloat(3)); room.setStatus(rs.getString(4)); room.setRemark(rs.getString(5)); list.add(room); } } catch (Exception ex) { ex.printStackTrace(); } finally { ConnectionManager.closeResultSet(rs); ConnectionManager.closeStatement(st); ConnectionManager.closeConnection(con); } return list; } public ArrayList getClient(String sql) { ArrayList list = new ArrayList(); Connection con = null; Statement st = null; ResultSet rs = null; try { con = ConnectionManager.getConnection(); st = con.createStatement(); rs = st.executeQuery(sql); while (rs.next()) { Client client =new Client(); client.setClientname(rs.getString(1)); client.setSex(rs.getString(2)); client.setAge(rs.getInt(3)); client.setTel(rs.getString(4)); client.setType(rs.getString(5)); client.setNumber(rs.getString(6)); client.setNum(rs.getInt(7)); client.setRoomid(rs.getInt(8)); client.setOpentime(rs.getString(9)); client.setRemark(rs.getString(10)); list.add(client); } } catch (Exception ex) { ex.printStackTrace(); } finally { ConnectionManager.closeResultSet(rs); ConnectionManager.closeStatement(st); ConnectionManager.closeConnection(con); } return list; } public int getdate(String date) { SimpleDateFormat sdf = new SimpleDateFormat("yy-MM-dd"); Date da = new Date(); String str= sdf.format(da); String sql ="select datediff(dd,'"+date+"','"+str+"')"; Connection con = null; Statement st = null; ResultSet rs = null; String numstr=null; try { con = ConnectionManager.getConnection(); st = con.createStatement(); rs = st.executeQuery(sql); if (rs.next()) { numstr= rs.getString(1); } } catch (Exception ex) { ex.printStackTrace(); } finally { ConnectionManager.closeResultSet(rs); ConnectionManager.closeStatement(st); ConnectionManager.closeConnection(con); } int num = Integer.parseInt(numstr); return num; } public ArrayList getNote(String sql) { ArrayList list = new ArrayList(); Connection con = null; Statement st = null; ResultSet rs = null; try { con = ConnectionManager.getConnection(); st = con.createStatement(); rs = st.executeQuery(sql); while (rs.next()) { NoteMessage nm = new NoteMessage(); nm.setRoomid(rs.getInt(1)); nm.setName(rs.getString(2)); nm.setOpentime(rs.getString(3)); nm.setEndtime(rs.getString(4)); nm.setDatenum(rs.getString(5)); nm.setFee(rs.getString(6)); list.add(nm); } } catch (Exception ex) { ex.printStackTrace(); } finally { ConnectionManager.closeResultSet(rs); ConnectionManager.closeStatement(st); ConnectionManager.closeConnection(con); } return list; } public static void main(String[] args) { RoomDao roomdao = new RoomDao(); } }