jsp项目 会议室预定

package dao; import java.sql.Connection; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.PreparedStatement; import java.util.*; import dao.*; import entity.*; import entity.BoardRoom; public class BoardRoomDao { Connection con=null; PreparedStatement pstmt=null; ResultSet rs=null; public ArrayList search(){ ArrayList list=new ArrayList(); String sql="select * from dbo.destineinfo order by destine_time desc"; con=BaseDao.getConnection(); try { pstmt=con.prepareStatement(sql); rs=pstmt.executeQuery(); while(rs.next()){ BoardRoom boardroom=new BoardRoom(); boardroom.setDestine_name(rs.getString("destine_name")); boardroom.setDestine_time(rs.getString("destine_time")); boardroom.setId(rs.getInt("id")); boardroom.setRoom_name(rs.getString("Room_name")); list.add(boardroom); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return list; } public int addroom(BoardRoom boardRoom){ int i=0; try{ con =BaseDao.getConnection(); pstmt = con.prepareStatement("insert into destineinfo (room_name,destine_name,destine_time) values(?,?,?)"); pstmt.setString(1,boardRoom.getRoom_name()); pstmt.setString(2,boardRoom.getDestine_name()); pstmt.setString(3,boardRoom.getDestine_time()); pstmt.executeUpdate(); }catch(Exception ex){ ex.printStackTrace(); } return i; } }