基于Servlet房屋租赁管理信息系统(含前后台)(Java+Servlet+jsp+mysql)

package com.bean; import java.sql.ResultSet; import java.text.SimpleDateFormat; import java.util.ArrayList; import java.util.Calendar; import java.util.List; import com.util.Constant; import com.util.DBO; public class HouseBean { private List list; private ResultSet rs; private String date = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(Calendar.getInstance().getTime()); //////////////////////////////////////////////////////////////////////////////////////////////////////// 出租 //// 房屋的基本信息，地址，大小，房价，户型，视频 ////////户型 视频 面积 价格 联系人 电话 地址 介绍 发布时间 public int addOut(String type, String video, String sum, String price, String tel, String linkman, String address, String intro) { String sql = "insert into outhouse(type,video,sum,price,tel,linkman,address,intro,addtime)" + "values('" + type + "','" + video + "','" + sum + "','" + price + "','" + tel + "','" + linkman + "','" + address + "','" + intro + "','" + date + "')"; DBO dbo = new DBO(); dbo.open(); try { int i = dbo.executeUpdate(sql); if (i == 1) { return Constant.SUCCESS; } else { return Constant.SYSTEM_ERROR; } } catch (Exception e) { e.printStackTrace(); return Constant.SYSTEM_ERROR; } finally { dbo.close(); } } public int upOut(String id, String type, String video, String sum, String price, String tel, String linkman, String address, String intro) { String sql = "update outhouse set type='" + type + "',video='" + video + "',sum='" + sum + "',price='" + price + "',tel='" + tel + "',linkman='" + linkman + "'," + "address='" + address + "',intro='" + intro + "' where id ='" + id + "'"; DBO dbo = new DBO(); dbo.open(); try { int i = dbo.executeUpdate(sql); if (i == 1) { return Constant.SUCCESS; } else { return Constant.SYSTEM_ERROR; } } catch (Exception e) { e.printStackTrace(); return Constant.SYSTEM_ERROR; } finally { dbo.close(); } } public int delOut(String id) { String sql = "delete from outhouse where id='" + id + "'"; DBO dbo = new DBO(); dbo.open(); try { int i = dbo.executeUpdate(sql); if (i == 1) { return Constant.SUCCESS; } else { return Constant.SYSTEM_ERROR; } } catch (Exception e) { e.printStackTrace(); return Constant.SYSTEM_ERROR; } finally { dbo.close(); } } public List getAllOut() { String sql = "select * from outhouse order by id desc"; DBO dbo = new DBO(); list = new ArrayList(); dbo.open(); try { rs = dbo.executeQuery(sql); while (rs.next()) { List list2 = new ArrayList(); list2.add(rs.getString(1)); list2.add(rs.getString(2)); list2.add(rs.getString(3)); list2.add(rs.getString(4)); list2.add(rs.getString(5)); list2.add(rs.getString(6)); list2.add(rs.getString(7)); list2.add(rs.getString(8)); list2.add(rs.getString(9)); list2.add(rs.getString(10)); list.add(list2); } return list; } catch (Exception e) { e.printStackTrace(); return list; } finally { dbo.close(); } } public List get15Out() { String sql = "select * from outhouse order by id desc limit 0,15"; DBO dbo = new DBO(); list = new ArrayList(); dbo.open(); try { rs = dbo.executeQuery(sql); while (rs.next()) { List list2 = new ArrayList(); list2.add(rs.getString(1)); list2.add(rs.getString(2)); list2.add(rs.getString(3)); list2.add(rs.getString(4)); list2.add(rs.getString(5)); list2.add(rs.getString(6)); list2.add(rs.getString(7)); list2.add(rs.getString(8)); list2.add(rs.getString(9)); list2.add(rs.getString(10)); list.add(list2); } return list; } catch (Exception e) { e.printStackTrace(); return list; } finally { dbo.close(); } } public List getOneOut(int id) { String sql = "select * from outhouse where id='" + id + "'"; DBO dbo = new DBO(); list = new ArrayList(); dbo.open(); try { rs = dbo.executeQuery(sql); while (rs.next()) { list.add(rs.getString(1)); list.add(rs.getString(2)); list.add(rs.getString(3)); list.add(rs.getString(4)); list.add(rs.getString(5)); list.add(rs.getString(6)); list.add(rs.getString(7)); list.add(rs.getString(8)); list.add(rs.getString(9)); list.add(rs.getString(10)); } return list; } catch (Exception e) { e.printStackTrace(); return list; } finally { dbo.close(); } } public List getAllOut(String sql) { DBO dbo = new DBO(); list = new ArrayList(); dbo.open(); System.out.println(sql); try { rs = dbo.executeQuery(sql); while (rs.next()) { List list2 = new ArrayList(); list2.add(rs.getString(1)); list2.add(rs.getString(2)); list2.add(rs.getString(3)); list2.add(rs.getString(4)); list2.add(rs.getString(5)); list2.add(rs.getString(6)); list2.add(rs.getString(7)); list2.add(rs.getString(8)); list2.add(rs.getString(9)); list2.add(rs.getString(10)); list.add(list2); } return list; } catch (Exception e) { e.printStackTrace(); return list; } finally { dbo.close(); } } //////////////////////////////////////////////////////////////////////////////////////////////////////// 出售 // 房屋的基本信息，地址，大小，房价，户型，视频 ////////户型 视频 面积 价格 联系人 电话 地址 介绍 发布时间 public int addSale(String type, String video, String sum, String price, String tel, String linkman, String address, String intro) { String sql = "insert into salehouse(type,video,sum,price,tel,linkman,address,intro,addtime)" + "values('" + type + "','" + video + "','" + sum + "','" + price + "','" + tel + "','" + linkman + "','" + address + "','" + intro + "','" + date + "')"; DBO dbo = new DBO(); dbo.open(); try { int i = dbo.executeUpdate(sql); if (i == 1) { return Constant.SUCCESS; } else { return Constant.SYSTEM_ERROR; } } catch (Exception e) { e.printStackTrace(); return Constant.SYSTEM_ERROR; } finally { dbo.close(); } } public int upSale(String id, String type, String video, String sum, String price, String tel, String linkman, String address, String intro) { String sql = "update salehouse set type='" + type + "',video='" + video + "',sum='" + sum + "',price='" + price + "',tel='" + tel + "',linkman='" + linkman + "'," + "address='" + address + "',intro='" + intro + "' where id ='" + id + "'"; DBO dbo = new DBO(); dbo.open(); try { int i = dbo.executeUpdate(sql); if (i == 1) { return Constant.SUCCESS; } else { return Constant.SYSTEM_ERROR; } } catch (Exception e) { e.printStackTrace(); return Constant.SYSTEM_ERROR; } finally { dbo.close(); } } public int delSale(String id) { String sql = "delete from salehouse where id='" + id + "'"; DBO dbo = new DBO(); dbo.open(); try { int i = dbo.executeUpdate(sql); if (i == 1) { return Constant.SUCCESS; } else { return Constant.SYSTEM_ERROR; } } catch (Exception e) { e.printStackTrace(); return Constant.SYSTEM_ERROR; } finally { dbo.close(); } } public List getAllSale() { String sql = "select * from salehouse order by id desc"; DBO dbo = new DBO(); list = new ArrayList(); dbo.open(); try { rs = dbo.executeQuery(sql); while (rs.next()) { List list2 = new ArrayList(); list2.add(rs.getString(1)); list2.add(rs.getString(2)); list2.add(rs.getString(3)); list2.add(rs.getString(4)); list2.add(rs.getString(5)); list2.add(rs.getString(6)); list2.add(rs.getString(7));