package com.struts.dao;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.List;
import com.struts.dao.impl.HouseNewDaoImpl;
import com.struts.entity.HouseNews;
public class HouseNewDao implements HouseNewDaoImpl {
Connection conn = null;
PreparedStatement met = null;
ResultSet set = null;
public int addHouse(HouseNews house) {
String sql = "insert into TBL_FWXX values(?,?,?,?,?,?,?,?,?,?,?,?)";
int a = 0;
Object[] o = { house.getUid(), house.getQxid(), house.getJdid(),
house.getLxid(), house.getShi(), house.getTing(),
house.getFwxx(), house.getZj(), house.getTitle(),
house.getDate(), house.getTelephone(), house.getLxr() };
try {
conn = BaseDao.getConn();
met = conn.prepareStatement(sql);
for (int i = 0; i < o.length; i++) {
met.setObject(i + 1, o[i]);
}
a = met.executeUpdate();
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
} finally {
BaseDao.closeAll(null, met, conn);
}
return a;
}
public int deleHuse(int id) {
String sql = "delete from TBL_FWXX where fwid=?";
int a = 0;
try {
conn = BaseDao.getConn();
met = conn.prepareStatement(sql);
met.setInt(1, id);
a = met.executeUpdate();
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
} finally {
BaseDao.closeAll(null, met, conn);
}
return a;
}
public List<HouseNews> findList() {
List<HouseNews> listHouse = new ArrayList<HouseNews>();
String sql = "select * from TBL_FWXX";
try {
conn = BaseDao.getConn();
met = conn.prepareStatement(sql);
set = met.executeQuery();
while (set.next()) {
HouseNews houseNew = new HouseNews();
houseNew.setFwid(set.getInt("fwid"));
houseNew.setUid(set.getInt("uid"));
houseNew.setQxid(set.getInt("qxid"));
houseNew.setJdid(set.getInt("jdid"));
houseNew.setLxid(set.getInt("lxid"));
houseNew.setShi(set.getInt("shi"));
houseNew.setTing(set.getInt("ting"));
houseNew.setFwxx(set.getString("fwxx"));
houseNew.setZj(set.getDouble("zj"));
houseNew.setTitle(set.getString("title"));
houseNew.setDate(set.getTimestamp("date").toString());
houseNew.setTelephone(set.getString("telephone"));
houseNew.setLxr(set.getString("lxr"));
listHouse.add(houseNew);
}
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
} finally {
BaseDao.closeAll(set, met, conn);
}
return listHouse;
}
public int updateHouse(HouseNews house) {
String sql = "update TBL_FWXX set uid=?,qxid=?,jdid=?,lxid=?,shi=?,ting=?,fwxx=?,zj=?,title=?,date=?,telephone=?,lxr=? where fwid=?";
int a = 0;
Object[] o = { house.getUid(), house.getQxid(), house.getJdid(),
house.getLxid(), house.getShi(), house.getTing(),
house.getFwxx(), house.getZj(), house.getTitle(),
house.getDate(), house.getTelephone(), house.getLxr(),house.getFwid() };
try {
conn = BaseDao.getConn();
met = conn.prepareStatement(sql);
for (int i = 0; i < o.length; i++) {
met.setObject(i + 1, o[i]); //免于转型
}
a = met.executeUpdate();
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
} finally {
BaseDao.closeAll(null, met, conn);
}
return a;
}
public List<HouseNews> listpage(int page) {
int curentPage = 0;
if (page > 1) {
curentPage = (page - 1) * 10;
}
List<HouseNews> listHouse = new ArrayList();
String sql = "select top 10 * from TBL_FWXX where fwid not in(select top "
+ curentPage
+ " fwid from TBL_FWXX order by date desc) order by date desc";
try {
conn = BaseDao.getConn();
met = conn.prepareStatement(sql);
set = met.executeQuery();
while (set.next()) {
HouseNews houseNew = new HouseNews();
houseNew.setFwid(set.getInt("fwid"));
houseNew.setUid(set.getInt("uid"));
houseNew.setQxid(set.getInt("qxid"));
houseNew.setJdid(set.getInt("jdid"));
houseNew.setLxid(set.getInt("lxid"));
houseNew.setShi(set.getInt("shi"));
houseNew.setTing(set.getInt("ting"));
houseNew.setFwxx(set.getString("fwxx"));
houseNew.setZj(set.getDouble("zj"));
houseNew.setTitle(set.getString("title"));
houseNew.setDate(set.getTimestamp("date").toString());
houseNew.setTelephone(set.getString("telephone"));
houseNew.setLxr(set.getString("lxr"));
listHouse.add(houseNew);
}
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
} finally {
BaseDao.closeAll(set, met, conn);
}
return listHouse;
}
public HouseNews findHouse(int fwid) {
HouseNews houseNew = new HouseNews();
String sql = "select * from TBL_FWXX where fwid=?";
try {
conn = BaseDao.getConn();
met = conn.prepareStatement(sql);
met.setInt(1, fwid);
set = met.executeQuery();
while (set.next()) {
houseNew.setFwid(set.getInt("fwid"));
houseNew.setUid(set.getInt("uid"));
houseNew.setQxid(set.getInt("qxid"));
houseNew.setJdid(set.getInt("jdid"));
houseNew.setLxid(set.getInt("lxid"));
houseNew.setShi(set.getInt("shi"));
houseNew.setTing(set.getInt("ting"));
houseNew.setFwxx(set.getString("fwxx"));
houseNew.setZj(set.getDouble("zj"));
houseNew.setTitle(set.getString("title"));
houseNew.setDate(set.getTimestamp("date").toString());
houseNew.setTelephone(set.getString("telephone"));
houseNew.setLxr(set.getString("lxr"));
}
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
} finally {
BaseDao.closeAll(set, met, conn);
}
return houseNew;
}
/*
* 采用List集合接受查询
*/
public List<HouseNews> searchHouse(HouseNews house,double lastZj) {
List<HouseNews> list =new ArrayList();
String sql = "select * from TBL_FWXX where 1=1";
if(!house.getTitle().trim().equals("")&&!house.getTitle().equals("请输入关键字")){
sql+=" and title like '%"+house.getTitle()+"%' ";
}if(house.getQxid()!=0){
sql+=" and qxid="+house.getQxid();
}if(house.getJdid()!=0){
sql+=" and jdid="+house.getJdid();
}if(lastZj!=0.0){
sql+=" and zj between "+house.getZj()+" and "+lastZj;
}if(house.getShi()!=0){
sql+=" and shi="+house.getShi();
}if(house.getTing()!=0){
sql+=" and ting="+house.getTing();
}if(house.getLxid()!=0){
sql+=" and lxid="+house.getLxid();
}if(!house.getDate().equals("0")){
sql+=" and date between dateadd(dd,-"+(Integer.parseInt(house.getDate())+1)+",getdate()) and getdate()";
}
sql+=" order by date desc";
System.out.println(sql);
try{
conn = BaseDao.getConn();
met = conn.prepareStatement(sql);
set = met.executeQuery();
while (set.next()) {
HouseNews houseNew = new HouseNews();
houseNew.setFwid(set.getInt("fwid"));
houseNew.setUid(set.getInt("uid"));
houseNew.setQxid(set.getInt("qxid"));
houseNew.setJdid(set.getInt("jdid"));
houseNew.setLxid(set.getInt("lxid"));
houseNew.setShi(set.getInt("shi"));
houseNew.setTing(set.getInt("ting"));
houseNew.setFwxx(set.getString("fwxx"));
houseNew.setZj(set.getDouble("zj"));
houseNew.setTitle(set.getString("title"));
houseNew.setDate(set.getTimestamp("date").toString());
houseNew.setTelephone(set.getString("telephone"));
houseNew.setLxr(set.getString("lxr"));
list.add(houseNew);
}
}catch(Exception e){
e.printStackTrace();
}finally{
BaseDao.closeAll(set, met, conn);
}
return list;
}
public List<HouseNews> searchHouse(HouseNews house,double lastZj,int page) {
int crentPage=0;
if(page>1){
crentPage=(page-1)*20;
}
List<HouseNews> list =new ArrayList();
String sql = "select top 20 * from TBL_FWXX whe
没有合适的资源?快使用搜索试试~ 我知道了~
web课程设计-Java web的租房管理系统(源码+数据库).zip
共101个文件
java:26个
class:26个
jpg:13个
1.该资源内容由用户上传,如若侵权请联系客服进行举报
2.虚拟产品一经售出概不退款(资源遇到问题,请及时私信上传者)
2.虚拟产品一经售出概不退款(资源遇到问题,请及时私信上传者)
版权申诉
5星 · 超过95%的资源 4 下载量 163 浏览量
2022-04-14
22:59:55
上传
评论 6
收藏 1.07MB ZIP 举报
温馨提示
课设高分,顺利通过
资源推荐
资源详情
资源评论
收起资源包目录
web课程设计-Java web的租房管理系统(源码+数据库).zip (101个子文件)
HouseNewDao.class 10KB
HouseAction.class 6KB
UserAction.class 5KB
UtilDao.class 5KB
HouseTest.class 5KB
HouseNewForm.class 4KB
UserDao.class 4KB
QxAjaxServlet.class 3KB
HouseNews.class 3KB
ListPage.class 3KB
LoginFilter.class 2KB
EncodeFilter.class 2KB
IndexFilter.class 2KB
ErrorFilter.class 2KB
UserForm.class 1KB
BaseDao.class 1KB
UserTest.class 1KB
BaseAction.class 1KB
UserBiz.class 1KB
User.class 907B
Fwjd.class 898B
Fwlx.class 722B
Fwqx.class 716B
HouseBiz.class 485B
HouseNewDaoImpl.class 345B
UserDaoImpl.class 243B
.classpath 749B
btn.css 3KB
mycss.css 2KB
text.css 297B
layout_24.gif 945B
standard.jar 385KB
jstl.jar 21KB
HouseNewDao.java 10KB
HouseAction.java 7KB
UserAction.java 6KB
UtilDao.java 5KB
HouseTest.java 4KB
ListPage.java 3KB
HouseNewForm.java 3KB
UserDao.java 3KB
LoginFilter.java 2KB
HouseNews.java 2KB
QxAjaxServlet.java 2KB
IndexFilter.java 1KB
EncodeFilter.java 1KB
UserForm.java 1KB
ErrorFilter.java 1KB
BaseDao.java 1KB
BaseAction.java 767B
UserBiz.java 518B
UserTest.java 464B
User.java 463B
Fwjd.java 433B
Fwlx.java 319B
Fwqx.java 305B
HouseNewDaoImpl.java 291B
HouseBiz.java 238B
UserDaoImpl.java 189B
top.jpg 111KB
middle1.jpg 36KB
bottom.jpg 14KB
404-1.jpg 11KB
middle4.jpg 9KB
middle2.jpg 9KB
404-6.jpg 4KB
404-3.jpg 3KB
error0.jpg 3KB
error.jpg 2KB
404-5.jpg 1KB
404-4.jpg 865B
404-2.jpg 834B
index.jsp 12KB
login.jsp 9KB
post.jsp 8KB
update.jsp 7KB
list.jsp 6KB
my.jsp 4KB
detail.jsp 3KB
post_confirm.jsp 3KB
error.jsp 3KB
reg.jsp 3KB
login_form.jsp 2KB
house_log.LDF 504KB
house.mdf 2.19MB
.struts-config.mex 6KB
MANIFEST.MF 36B
.mymetadata 294B
.mystrutsdata 262B
org.eclipse.jdt.core.prefs 330B
.project 1KB
ApplicationResources.properties 90B
ApplicationResources.properties 90B
struts-html.tld 72KB
struts-nested.tld 70KB
struts-logic.tld 14KB
struts-bean.tld 9KB
struts-tiles.tld 8KB
validator-rules.xml 13KB
web.xml 3KB
共 101 条
- 1
- 2
资源评论
- 你我山巅自相逢8962023-06-13资源中能够借鉴的内容很多,值得学习的地方也很多,大家一起进步!
- ☞1542023-12-28资源很不错,内容和描述一致,值得借鉴,赶紧学起来!
- 林南竺2022-06-19用户下载后在一定时间内未进行评价,系统默认好评。
- bang_bang_de2023-03-27支持这个资源,内容详细,主要是能解决当下的问题,感谢大佬分享~
等天晴i
- 粉丝: 3490
- 资源: 10万+
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功