📄 pubsdaoimpl.java

📁 房产交易平台服务器端建议代码。工厂模型。
💻 JAVA
📖 第 1 页 / 共 2 页
字号:
12 下一页
package com.fc.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.fc.dao.conn.DBConn;

public class PubsDaoImpl implements PubsDao {
	public PubsDaoImpl() {
	}

	/* (non-Javadoc)
	 * @see com.fc.dao.PubsDao#findByID(long)
	 */
	/* (non-Javadoc)
	 * @see com.fc.dao.PubsDao#findByID(long)
	 */
	/* (non-Javadoc)
	 * @see com.fc.dao.PubsDao#findByID(long)
	 */
	public Pubs findByID(long id) {
		Pubs p = null;
		Connection conn = null;
		PreparedStatement prst = null;
		ResultSet rs = null;

		try {
			conn = DBConn.getConnection();
			prst = conn
					.prepareStatement("select id,type,uid,pubstime,title,xiaoqu,quyu,addr,huxing,wuyeleixing,mianji,jiaoyijiage,miaoshu from pubs where id=?");

			prst.setLong(1, id);
			rs=prst.executeQuery();
			if(rs.next()){
				p=new Pubs();
				p.setId(rs.getLong(1));
				p.setType(rs.getInt(2));
				p.setUid(rs.getLong(3));
				p.setPubsTime(rs.getString(4));
				p.setTitle(rs.getString(5));
				p.setXiaoqu(rs.getString(6));
				p.setQuyu(rs.getString(7));
				p.setAddr(rs.getString(8));
				p.setHuxing(rs.getString(9));
				p.setWuyeleixing(rs.getString(10));
				p.setMianji(rs.getInt(11));
				p.setJiaoyijiage(rs.getInt(12));
				p.setMiaoshu(rs.getString(13));
			}
		} catch (SQLException ea) {
			ea.printStackTrace();
		} finally {
			if (conn != null)
				try {
					conn.close();
				} catch (SQLException e) {
					e.printStackTrace();
				}
		}
		return p;
	}
	
	
	/* (non-Javadoc)
	 * @see com.fc.dao.PubsDao#findByType(int)
	 */
	public List findByType(int type) {
		Pubs p = null;
		Connection conn = null;
		PreparedStatement prst = null;
		ResultSet rs = null;
		List<Pubs> list=new ArrayList<Pubs>();
		try {
			conn = DBConn.getConnection();
			prst = conn
					.prepareStatement("select id,type,uid,pubstime,title,xiaoqu,quyu,addr,huxing,wuyeleixing,mianji,jiaoyijiage,miaoshu  from pubs where type=? order by pubstime desc limit 1,10");

			prst.setInt(1, type);
			rs=prst.executeQuery();
			while(rs.next()){
				p=new Pubs();
				p.setId(rs.getLong(1));
				p.setType(rs.getInt(2));
				p.setUid(rs.getLong(3));
				p.setPubsTime(rs.getString(4));
				p.setTitle(rs.getString(5));
				p.setXiaoqu(rs.getString(6));
				p.setQuyu(rs.getString(7));
				p.setAddr(rs.getString(8));
				p.setHuxing(rs.getString(9));
				p.setWuyeleixing(rs.getString(10));
				p.setMianji(rs.getInt(11));
				p.setJiaoyijiage(rs.getInt(12));
				p.setMiaoshu(rs.getString(13));
				list.add(p);
			}
		} catch (SQLException ea) {
			ea.printStackTrace();
		} finally {
			if (conn != null)
				try {
					conn.close();
				} catch (SQLException e) {
					e.printStackTrace();
				}
		}
		return list;
	}
	
	
	/* (non-Javadoc)
	 * @see com.fc.dao.PubsDao#findByUser(com.fc.dao.User)
	 */
	/* (non-Javadoc)
	 * @see com.fc.dao.PubsDao#findByUser(com.fc.dao.User)
	 */
	/* (non-Javadoc)
	 * @see com.fc.dao.PubsDao#findByUser(com.fc.dao.User)
	 */
	public Pubs findByUser(User u) {
		Pubs p = null;
		Connection conn = null;
		PreparedStatement prst = null;
		ResultSet rs = null;

		try {
			conn = DBConn.getConnection();
			prst = conn
					.prepareStatement("select id,type,uid,pubstime,title,xiaoqu,quyu,addr,huxing,wuyeleixing,mianji,jiaoyijiage,miaoshu from pubs where uid=?");

			prst.setLong(1, u.getId());
			rs=prst.executeQuery();
			if(rs.next()){
				p=new Pubs();
				p.setId(rs.getLong(1));
				p.setType(rs.getInt(2));
				p.setUid(rs.getLong(3));
				p.setPubsTime(rs.getString(4));
				p.setTitle(rs.getString(5));
				p.setXiaoqu(rs.getString(6));
				p.setQuyu(rs.getString(7));
				p.setAddr(rs.getString(8));
				p.setHuxing(rs.getString(9));
				p.setWuyeleixing(rs.getString(10));
				p.setMianji(rs.getInt(11));
				p.setJiaoyijiage(rs.getInt(12));
				p.setMiaoshu(rs.getString(13));
			}
		} catch (SQLException ea) {
			ea.printStackTrace();
		} finally {
			if (conn != null)
				try {
					conn.close();
				} catch (SQLException e) {
					e.printStackTrace();
				}
		}
		return p;
	}
	
	
	
	
	/* (non-Javadoc)
	 * @see com.fc.dao.PubsDao#findByPubsTime(java.lang.String)
	 */
	/* (non-Javadoc)
	 * @see com.fc.dao.PubsDao#findByPubsTime(java.lang.String)
	 */
	/* (non-Javadoc)
	 * @see com.fc.dao.PubsDao#findByPubsTime(java.lang.String)
	 */
	public List findByPubsTime(String pubstime) {
		Pubs p = null;
		Connection conn = null;
		PreparedStatement prst = null;
		ResultSet rs = null;
		List<Pubs> list=new ArrayList<Pubs>();
		try {
			conn = DBConn.getConnection();
			prst = conn
					.prepareStatement("select id,type,uid,pubstime,title,xiaoqu,quyu,addr,huxing,wuyeleixing,mianji,jiaoyijiage,miaoshu  from pubs where pubstime>? order by pubstime desc limit 1,10");

			prst.setString(1, pubstime);
			rs=prst.executeQuery();
			while(rs.next()){
				p=new Pubs();
				p.setId(rs.getLong(1));
				p.setType(rs.getInt(2));
				p.setUid(rs.getLong(3));
				p.setPubsTime(rs.getString(4));
				p.setTitle(rs.getString(5));
				p.setXiaoqu(rs.getString(6));
				p.setQuyu(rs.getString(7));
				p.setAddr(rs.getString(8));
				p.setHuxing(rs.getString(9));
				p.setWuyeleixing(rs.getString(10));
				p.setMianji(rs.getInt(11));
				p.setJiaoyijiage(rs.getInt(12));
				p.setMiaoshu(rs.getString(13));
				list.add(p);
			}
		} catch (SQLException ea) {
			ea.printStackTrace();
		} finally {
			if (conn != null)
				try {
					conn.close();
				} catch (SQLException e) {
					e.printStackTrace();
				}
		}
		return list;
	}
	
	
	/* (non-Javadoc)
	 * @see com.fc.dao.PubsDao#findByPubsTime()
	 */
	/* (non-Javadoc)
	 * @see com.fc.dao.PubsDao#findByPubsTime()
	 */
	public List findByPubsTime() {
		Pubs p = null;
		Connection conn = null;
		PreparedStatement prst = null;
		ResultSet rs = null;
		List<Pubs> list=new ArrayList<Pubs>();
		try {
			conn = DBConn.getConnection();
			prst = conn
					.prepareStatement("select id,type,uid,pubstime,title,xiaoqu,quyu,addr,huxing,wuyeleixing,mianji,jiaoyijiage,miaoshu  from pubs  order by pubstime desc limit 1,10");

			rs=prst.executeQuery();
			while(rs.next()){
				p=new Pubs();
				p.setId(rs.getLong(1));
				p.setType(rs.getInt(2));
				p.setUid(rs.getLong(3));
				p.setPubsTime(rs.getString(4));
				p.setTitle(rs.getString(5));
				p.setXiaoqu(rs.getString(6));
				p.setQuyu(rs.getString(7));
				p.setAddr(rs.getString(8));
				p.setHuxing(rs.getString(9));
				p.setWuyeleixing(rs.getString(10));
				p.setMianji(rs.getInt(11));
				p.setJiaoyijiage(rs.getInt(12));
				p.setMiaoshu(rs.getString(13));
				list.add(p);
			}
		} catch (SQLException ea) {
			ea.printStackTrace();
		} finally {
			if (conn != null)
				try {
					conn.close();
				} catch (SQLException e) {
					e.printStackTrace();
				}
		}
		return list;
	}
	
	
	/* (non-Javadoc)
	 * @see com.fc.dao.PubsDao#findByQuyu(com.fc.dao.Pubs)
	 */
	/* (non-Javadoc)
	 * @see com.fc.dao.PubsDao#findByQuyu(com.fc.dao.Pubs)
	 */
	/* (non-Javadoc)
	 * @see com.fc.dao.PubsDao#findByQuyu(com.fc.dao.Pubs)
	 */
	public List findByQuyu(Pubs pubs) {
		Pubs p = null;
		Connection conn = null;
		PreparedStatement prst = null;
		ResultSet rs = null;
		List<Pubs> list=new ArrayList<Pubs>();
		try {
			conn = DBConn.getConnection();
			prst = conn
					.prepareStatement("select id,type,uid,pubstime,title,xiaoqu,quyu,addr,huxing,wuyeleixing,mianji,jiaoyijiage,miaoshu  from pubs where quyu=? and type=? order by pubstime desc");

			prst.setString(1, pubs.getQuyu());
			prst.setInt(2, pubs.getType());
			rs=prst.executeQuery();
			while(rs.next()){
				p=new Pubs();
				p.setId(rs.getLong(1));
				p.setType(rs.getInt(2));
				p.setUid(rs.getLong(3));
				p.setPubsTime(rs.getString(4));
				p.setTitle(rs.getString(5));
				p.setXiaoqu(rs.getString(6));
				p.setQuyu(rs.getString(7));
				p.setAddr(rs.getString(8));
				p.setHuxing(rs.getString(9));
				p.setWuyeleixing(rs.getString(10));
				p.setMianji(rs.getInt(11));
				p.setJiaoyijiage(rs.getInt(12));
				p.setMiaoshu(rs.getString(13));
				list.add(p);
			}
		} catch (SQLException ea) {
			ea.printStackTrace();
		} finally {
			if (conn != null)
				try {
					conn.close();
				} catch (SQLException e) {
					e.printStackTrace();
				}
		}
		return list;
	}
	
	
	/* (non-Javadoc)
	 * @see com.fc.dao.PubsDao#findByHuxing_Quyu(com.fc.dao.Pubs)
	 */
	/* (non-Javadoc)
	 * @see com.fc.dao.PubsDao#findByHuxing_Quyu(com.fc.dao.Pubs)
	 */
	/* (non-Javadoc)
	 * @see com.fc.dao.PubsDao#findByHuxing_Quyu(com.fc.dao.Pubs)
	 */
	public List findByHuxing_Quyu(Pubs pubs) {
		Pubs p = null;
		Connection conn = null;
		PreparedStatement prst = null;
		ResultSet rs = null;
		List<Pubs> list=new ArrayList<Pubs>();
		try {
			conn = DBConn.getConnection();
			prst = conn
					.prepareStatement("select id,type,uid,pubstime,title,xiaoqu,quyu,addr,huxing,wuyeleixing,mianji,jiaoyijiage,miaoshu  from pubs where huxing=? and quyu=? and type=? order by pubstime desc");

			prst.setString(1, pubs.getHuxing());
			prst.setString(2, pubs.getQuyu());
			prst.setInt(3, pubs.getType());
			rs=prst.executeQuery();
			while(rs.next()){
				p=new Pubs();
				p.setId(rs.getLong(1));
				p.setType(rs.getInt(2));
				p.setUid(rs.getLong(3));
				p.setPubsTime(rs.getString(4));
				p.setTitle(rs.getString(5));
				p.setXiaoqu(rs.getString(6));
				p.setQuyu(rs.getString(7));
				p.setAddr(rs.getString(8));
				p.setHuxing(rs.getString(9));
				p.setWuyeleixing(rs.getString(10));
				p.setMianji(rs.getInt(11));
				p.setJiaoyijiage(rs.getInt(12));
				p.setMiaoshu(rs.getString(13));
				list.add(p);
			}
		} catch (SQLException ea) {
			ea.printStackTrace();
		} finally {
			if (conn != null)
				try {
					conn.close();
				} catch (SQLException e) {
					e.printStackTrace();
				}
		}
		return list;
	}
	
	
	/* (non-Javadoc)
	 * @see com.fc.dao.PubsDao#findByWuyeleixing_Quyu(com.fc.dao.Pubs)
	 */
	/* (non-Javadoc)
	 * @see com.fc.dao.PubsDao#findByWuyeleixing_Quyu(com.fc.dao.Pubs)
	 */
	/* (non-Javadoc)
	 * @see com.fc.dao.PubsDao#findByWuyeleixing_Quyu(com.fc.dao.Pubs)
	 */
	public List findByWuyeleixing_Quyu(Pubs pubs) {
		Pubs p = null;
		Connection conn = null;
		PreparedStatement prst = null;
		ResultSet rs = null;
		List<Pubs> list=new ArrayList<Pubs>();
		try {
			conn = DBConn.getConnection();
			prst = conn
					.prepareStatement("select id,type,uid,pubstime,title,xiaoqu,quyu,addr,huxing,wuyeleixing,mianji,jiaoyijiage,miaoshu  from pubs where wuyeleixing=? and quyu=? and type=? order by pubstime desc");

			prst.setString(1, pubs.getWuyeleixing());
			prst.setString(2, pubs.getQuyu());
			prst.setInt(3, pubs.getType());
			rs=prst.executeQuery();
			while(rs.next()){
				p=new Pubs();
				p.setId(rs.getLong(1));
				p.setType(rs.getInt(2));
				p.setUid(rs.getLong(3));
				p.setPubsTime(rs.getString(4));
				p.setTitle(rs.getString(5));
				p.setXiaoqu(rs.getString(6));
				p.setQuyu(rs.getString(7));
				p.setAddr(rs.getString(8));
				p.setHuxing(rs.getString(9));
				p.setWuyeleixing(rs.getString(10));
				p.setMianji(rs.getInt(11));
				p.setJiaoyijiage(rs.getInt(12));
				p.setMiaoshu(rs.getString(13));
				list.add(p);
			}
		} catch (SQLException ea) {
			ea.printStackTrace();
		} finally {
			if (conn != null)
				try {
					conn.close();
				} catch (SQLException e) {
					e.printStackTrace();
				}
		}
		return list;
	}
	
	/* (non-Javadoc)
	 * @see com.fc.dao.PubsDao#findByXiaoQu_Quyu(com.fc.dao.Pubs)
	 */
	/* (non-Javadoc)
	 * @see com.fc.dao.PubsDao#findByXiaoQu_Quyu(com.fc.dao.Pubs)
	 */
	/* (non-Javadoc)
	 * @see com.fc.dao.PubsDao#findByXiaoQu_Quyu(com.fc.dao.Pubs)
	 */
	public List findByXiaoQu_Quyu(Pubs pubs) {
		Pubs p = null;
		Connection conn = null;
		PreparedStatement prst = null;
		ResultSet rs = null;
		List<Pubs> list=new ArrayList<Pubs>();
12 下一页
💿 文件大小 314 K
👤 上传用户 oujk123
📂 所属分类其他
🏷️ 相关标签

#服务器 #代码 #工厂 #模型
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -