67,513
社区成员
发帖
与我相关
我的任务
分享
public List<HouseBean> searchHouseDesc(String paraValue){
String paraValu=paraValue;
System.out.println(paraValue);
List<HouseBean> list=new ArrayList<HouseBean>();
Connection conn=null;
Statement st =null;
ResultSet rs=null;
String sql="select area_no, house_no,house_desc from bi_global_warehouse_info";
if(paraValu.equals("YT")){
sql=sql+" where area_no='YT'";
}else if(paraValu.equals("HF")){
sql=sql+" where area_no='HF'";
}
try {
conn=DBdao.getconn();
st = conn.createStatement();
rs=st.executeQuery(sql);
while(rs.next()){
String area_no=rs.getString("area_no");
String house_no=rs.getString("house_no");
String house_desc=rs.getString("house_desc");
HouseBean bean=new HouseBean(area_no,house_no,house_desc);
list.add(bean);
}
} catch (SQLException e){
e.printStackTrace();
}finally{
DBdao.closeconn(rs, st, conn);
}
return list;