?? goodsdao.java
字號:
package DAO;
import Entity.GoodsBean;
import java.util.*;
import java.sql.*;
public class GoodsDAO {
OperateDB db=new OperateDB();
ResultSet rs=null;
TypeDAO td=new TypeDAO();
public ArrayList<GoodsBean> GetAllGoodsByTypeId(int typeid)
{
ArrayList<GoodsBean> list=new ArrayList<GoodsBean>();
try{
String sql="select * from goods where gtype="+typeid;
System.out.println("查詢商品的所有的信息sql=!"+sql);
rs=db.GetQuery(sql);
while(rs.next())
{
GoodsBean bean=new GoodsBean();
bean.setGid(rs.getInt(1));
bean.setGname(rs.getString(2));
bean.setGprice(rs.getFloat(3));
bean.setGtype(td.GetTypeById(rs.getInt(4)));
bean.setGimage(rs.getString(5));
bean.setGremark(rs.getString(6));
list.add(bean);
}
}catch(Exception ex)
{
System.out.println("查詢商品的所有的信息出現異常!"+ex.toString());
}
return list;
}
public GoodsBean GetGoodsById(int gid)
{
GoodsBean bean=new GoodsBean();
try {
String sql="select * from goods where gid="+gid;
rs=db.GetQuery(sql);
if(rs.next())
{
bean.setGid(rs.getInt(1));
bean.setGname(rs.getString(2));
bean.setGprice(rs.getFloat(3));
bean.setGtype(td.GetTypeById(rs.getInt(4)));
bean.setGimage(rs.getString(5));
bean.setGremark(rs.getString(6));
}
} catch (Exception e) {
System.out.println("根據商品編號查詢商品出現異常!"+e.toString());
}
return bean;
}
public ArrayList<GoodsBean> Search(String sql)
{
ArrayList<GoodsBean> list=new ArrayList<GoodsBean>();
try {
rs=db.GetQuery(sql);
while(rs.next())
{
GoodsBean bean=new GoodsBean();
bean.setGid(rs.getInt(1));
bean.setGname(rs.getString(2));
bean.setGprice(rs.getFloat(3));
bean.setGtype(td.GetTypeById(rs.getInt(4)));
bean.setGimage(rs.getString(5));
bean.setGremark(rs.getString(6));
list.add(bean);
}
} catch (Exception e) {
System.out.println("模糊查詢商品異常!"+e.toString());
}
return list;
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -