?? stockregioninfodao.java
字號:
package com.wl.dao;
import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.List;
import com.wl.dbconnection.DBManager;
import com.wl.entity.StockRegionInfo;
/**
* 商品所在區域表封裝方法
* @author tian xiaoshun
*
*/
public class StockRegionInfoDAO {
DBManager db = new DBManager();
boolean flag;
ResultSet rs = null;
/**
* 查村所有商品所在區域
* @return
*/
public List<StockRegionInfo> selectAllStrockRegionInfo(){
List<StockRegionInfo> list= new ArrayList<StockRegionInfo>();
flag=db.openDB();
if(flag){
try{
db.ps=db.conn.prepareStatement("select * from stockregioninfotable");
rs=db.ps.executeQuery();
while(rs.next()){
StockRegionInfo stockregioninfo=new StockRegionInfo(rs.getInt(1),rs.getString(2),rs.getString(3));
list.add(stockregioninfo);
}
}
catch(Exception e){
System.out.print("出錯了!");
}
finally{
db.closeDB();
}
}
else{
System.out.print("數據庫打開失??!");
}
return list;
}
/**
* 封裝按名字查詢商品所在區域信息!
* @param StockRegionName
* @return
*/
public StockRegionInfo selectStockRegionInfoByName(String stockRegionName){
flag=db.openDB();
StockRegionInfo stockRegioninfo=null;
if(flag){
try{
db.ps=db.conn.prepareStatement("select * from stockregioninfotable where stockregionname=?");
db.ps.setString(1,stockRegionName);
rs=db.ps.executeQuery();
while(rs.next()){
stockRegioninfo=new StockRegionInfo(rs.getInt(1),rs.getString(2),rs.getString(3));
}
}
catch(Exception e){
System.out.print("查詢出錯了!");
}
finally{
db.closeDB();
}
}
else{
System.out.print("數據庫打開失敗");
}
return stockRegioninfo;
}
/**
* 封裝按id查詢商品所在區域信息!
* @param id
* @return
*/
public StockRegionInfo selectStockRegionInfoById(int id){
flag=db.openDB();
StockRegionInfo stockRegioninfo=null;
if(flag){
try{
db.ps=db.conn.prepareStatement("select * from stockregioninfotable where id=?");
db.ps.setInt(1,id);
rs=db.ps.executeQuery();
while(rs.next()){
stockRegioninfo=new StockRegionInfo(rs.getInt(1),rs.getString(2),rs.getString(3));
}
}
catch(Exception e){
System.out.print("查詢出錯了!");
}
finally{
db.closeDB();
}
}
else{
System.out.print("數據庫打開失敗");
}
return stockRegioninfo;
}
public static void main(String[] args){
StockRegionInfoDAO mm=new StockRegionInfoDAO();
System.out.print(mm.selectStockRegionInfoById(1));
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -