Java框架房屋出租系统

package com.ljf.dao; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.util.ArrayList; import java.util.List; import com.ljf.model.House; import com.ljf.model.Users; public class HouseDao extends BaseDao { /** * 增加一条租房信息 * * @param info * @return */ public boolean saveHourse(House info) { boolean isflat = false; String sql = "insert into t_house(p_id,h_title,h_qx,h_jd,h_shi,h_ting,h_type,h_price,h_per,h_tel,h_remark) " + "values(?,?,?,?,?,?,?,?,?,?,?)"; Connection conn = this.getConn(); try { PreparedStatement ps = conn.prepareStatement(sql); ps.setInt(1, info.getP_id()); ps.setString(2, info.getH_title()); ps.setString(3, info.getH_qx()); ps.setString(4, info.getH_jd()); ps.setInt(5, info.getH_shi()); ps.setInt(6, info.getH_ting()); ps.setString(7, info.getH_type()); ps.setDouble(8, info.getH_price()); ps.setString(9, info.getH_per()); ps.setString(10, info.getH_tel()); ps.setString(11, info.getH_remark()); int count = ps.executeUpdate(); if (count > 0) { isflat = true; } } catch (SQLException e) { e.printStackTrace(); } finally { this.closeConn(conn); } return isflat; } /** * 获取所有租房信息 * * @return */ public List getAllHouseInofo() { List list = new ArrayList(); String sql = "select h_id,h_title,h_price,h_date from t_house"; Connection conn = getConn(); try { PreparedStatement ps = conn.prepareStatement(sql); ResultSet rs = ps.executeQuery(); while (rs.next()) { House info = new House(); info.setH_id(rs.getInt("h_id")); info.setH_title(rs.getString("h_title")); info.setH_price(rs.getDouble("h_price")); info.setH_date(rs.getDate("h_date")); list.add(info); } } catch (SQLException e) { e.printStackTrace(); } finally { this.closeConn(conn); } return list; } /** * 根据用户获取其发布的租房信息 * * @param per * @return */ public List getHouseInfoByPer(Users per) { List list = new ArrayList(); String sql = "select h_id,h_title,h_price,h_date from t_house where p_id=?"; Connection conn = getConn(); ResultSet rs = null; try { PreparedStatement ps = conn.prepareStatement(sql); ps.setInt(1, per.getId()); rs = ps.executeQuery(); while (rs.next()) { House info = new House(); info.setH_id(rs.getInt("h_id")); info.setH_title(rs.getString("h_title")); info.setH_price(rs.getDouble("h_price")); info.setH_date(rs.getDate("h_date")); list.add(info); } } catch (SQLException e) { e.printStackTrace(); } finally { closeResultSet(rs); // 关闭数据库连接 this.closeConn(conn); } return list; } /** * 根据标题模糊查询 * * @param key * @return */ public List getHouseInfoBylike(String key) { List list = new ArrayList(); String sql = "select h_id,h_title,h_price,h_date from t_house where h_title like ?"; Connection conn = getConn(); ResultSet rs = null; try { PreparedStatement ps = conn.prepareStatement(sql); ps.setString(1, "%" + key.trim() + "%"); rs = ps.executeQuery(); while (rs.next()) { House info = new House(); info.setH_id(rs.getInt("h_id")); info.setH_title(rs.getString("h_title")); info.setH_price(rs.getDouble("h_price")); info.setH_date(rs.getDate("h_date")); list.add(info); } } catch (SQLException e) { e.printStackTrace(); } finally { closeResultSet(rs); this.closeConn(conn); } return list; } /** * 根据租房信息id获取租房信息 * * @param h_id * @return */ public House getHouseInfo(int h_id) { House info = null; String sql = "select * from t_house where h_id=?"; Connection conn = getConn(); ResultSet rs = null; try { PreparedStatement ps = conn.prepareStatement(sql); ps.setInt(1, h_id); rs = ps.executeQuery(); while (rs.next()) { info = new House(); info.setH_id(rs.getInt("h_id")); info.setH_title(rs.getString("h_title")); info.setH_per(rs.getString("h_per")); info.setH_tel(rs.getString("h_tel")); info.setH_type(rs.getString("h_type")); info.setH_shi(rs.getInt("h_shi")); info.setH_ting(rs.getInt("h_ting")); info.setH_price(rs.getDouble("h_price")); info.setH_qx(rs.getString("h_qx")); info.setH_jd(rs.getString("h_jd")); info.setH_date(rs.getDate("h_date")); info.setH_remark(rs.getString("h_remark")); } } catch (SQLException e) { e.printStackTrace(); } finally { closeResultSet(rs); this.closeConn(conn); } return info; } /** * 修改租房信息 * * @param info * @return */ public boolean updateHouse(House info) { boolean isflat = false; String sql = "update t_house set h_title=?,h_qx=?,h_jd=?,h_shi=?,h_ting=?,h_type=?,h_price=?,h_per=?,h_tel=?,h_remark=? where h_id=?"; Connection conn = this.getConn(); try { PreparedStatement ps = conn.prepareStatement(sql); ps.setString(1, info.getH_title()); ps.setString(2, info.getH_qx()); ps.setString(3, info.getH_jd()); ps.setInt(4, info.getH_shi()); ps.setInt(5, info.getH_ting()); ps.setString(6, info.getH_type()); ps.setDouble(7, info.getH_price()); ps.setString(8, info.getH_per()); ps.setString(9, info.getH_tel()); ps.setString(10, info.getH_remark()); ps.setInt(11, info.getH_id()); int count = ps.executeUpdate(); if (count > 0) { isflat = true; } } catch (SQLException e) { e.printStackTrace(); } finally { this.closeConn(conn); } return isflat; } /** * 删除租房信息 * * @param id * @return */ public boolean deleteHouseById(int id) { boolean isflat = false; String sql = "delete from t_house where h_id=?"; Connection conn = this.getConn(); try { PreparedStatement ps = conn.prepareStatement(sql); ps.setInt(1, id); int ncount = ps.executeUpdate(); if (ncount > 0) { isflat = true; } } catch (SQLException e) { e.printStackTrace(); } finally { this.closeConn(conn); } return isflat; } }