jddao.java

北大青鸟的租房网练习文件

package com.newer.dao;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.Vector;

import com.newer.common.DBUtil;
import com.newer.entity.JdVO;

public class JdDao {
	public  Connection  conn=null;
	public PreparedStatement pstmt=null;
	/*
	 * 通过街道编号获取该街道的名称
	 */
	public String getJdByID(int jdid){
		String jd="";
		String sql="select jd from tbl_jd where jdid=?";
		try {
			conn=DBUtil.getConn();
			pstmt=conn.prepareStatement(sql);
			pstmt.setInt(1, jdid);
			ResultSet rs=pstmt.executeQuery();
			while(rs.next()){
				jd=rs.getString("jd").trim();
			}
			rs.close();
			pstmt.close();
			conn.close();
		} catch (Exception e) {
			e.printStackTrace();
		}
		return jd;
	}
	/*
	 * 获取所有接到的信息
	 */
	public Vector getAllJdInfo(){
		Vector vc=new Vector();
		String sql="select * from tbl_jd";
		conn=DBUtil.getConn();
		try {
			pstmt=conn.prepareStatement(sql);
			ResultSet rs=pstmt.executeQuery();
			while(rs.next()){
				JdVO jdvo=new JdVO();
				jdvo.setJdid(rs.getInt("jdid"));
				jdvo.setJd(rs.getString("jd"));
				jdvo.setQxid(rs.getInt("qxid"));
				vc.add(jdvo);
			}
		} catch (Exception e) {
			e.printStackTrace();
		}
		return vc;
	}
	

}