qxdao.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.QxVO;

public class QxDao {
	public  Connection  conn=null;
	public PreparedStatement pstmt=null;
	/*
	 * 根据区县编号获取区县信息
	 */
	public String getQxByQxID(int qxid){
		String qx="";
		String sql="select qx from tbl_qx where qxid=?";
		try {
			conn=DBUtil.getConn();
			pstmt=conn.prepareStatement(sql);
			pstmt.setInt(1, qxid);
			ResultSet rs=pstmt.executeQuery();
			while(rs.next()){
				qx=rs.getString("qx");
			}
			rs.close();
			pstmt.close();
			conn.close();
		} catch (Exception e) {
			e.printStackTrace();
		}
		
		return qx;
	}
	/*
	 * 获取所有的区县信息
	 */
	public Vector getAllQxInfo(){
		Vector vc=new Vector();
		String sql="select * from tbl_qx";
		conn=DBUtil.getConn();
		try {
			pstmt=conn.prepareStatement(sql);
			ResultSet rs=pstmt.executeQuery();
			while(rs.next()){
				QxVO vo=new QxVO();
				vo.setQxid(rs.getInt("qxid"));
				vo.setQx(rs.getString("qx"));
				vc.add(vo);
			}
		} catch (Exception e) {
			e.printStackTrace();
		}
		return vc;
	}

}