fwlxdao.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.FwlxVO;

public class FwlxDao {
	public  Connection  conn=null;
	public PreparedStatement pstmt=null;
	//根据房屋类型的编号获取房屋类型的值
	public String getFwlxByID(int lxid){
		String fwlx="";
		String sql="select fwlx from tbl_fwlx where lxid=?";
		try {
			conn=DBUtil.getConn();
			pstmt=this.conn.prepareStatement(sql);
			pstmt.setInt(1, lxid);
			ResultSet rs=pstmt.executeQuery();
			while(rs.next()){
				fwlx=rs.getString("fwlx");
			}
			rs.close();
			pstmt.close();
			conn.close();
		} catch (Exception e) {
			e.printStackTrace();
		}

		return fwlx;

	}
	/*
	 *获取所有的房屋类型
	 */
	public Vector getAllFwlxInfo(){
		Vector vc=new Vector();
		String sql="select * from tbl_fwlx";
		conn=DBUtil.getConn();
		try {
			pstmt=conn.prepareStatement(sql);
			ResultSet rs=pstmt.executeQuery();
			while(rs.next()){
				FwlxVO vo=new FwlxVO();
				vo.setLxid(rs.getInt("lxid"));
				vo.setFwlx(rs.getString("fwlx"));
				vc.add(vo);
			}
		} catch (Exception e) {
			e.printStackTrace();
		}
		return vc;
	}

}