?? goodsstoremanager.java
字號:
package supercms;
import java.sql.*;
import superdb.*;
import supershopmanager.*;
import java.util.*;
/*
* 完成對庫存信息的插入,修改,刪除,
* 并可對庫存商品進行查詢和統(tǒng)計
*
*
* */
public class GoodsStoreManager {
private SuperDBConn sdb;
private SuperInfoManager sim;
private Statement stmt;
public GoodsStoreManager()
{
sdb=new SuperDBConn();
sim=new SuperInfoManager(sdb.getConn());
stmt=sim.getStmt();
}
/*----------完成對庫存信息的插入----------*/
public void addGoodsStore(GoodsStore goodsStore)
{
String sql="insert into goodsstore(goodsid,storesum," +
"safestoresum," +
"remarks)values('"+goodsStore.getGoodsid()+"','"+goodsStore.getStoresum()+"','"+goodsStore.getSafestoresum()+"','"+goodsStore.getRemarks()+"')";
try
{
stmt.executeUpdate(sql);
System.out.println("庫存信息插入--------成功!!!!");
}catch(Exception e)
{
System.out.println("庫存信息插入--------失敗!!!!");
}
}
/*----------完成對庫存信息的查詢----------*/
public Vector selectGoodsStore(GoodsStore goodsStore,int type)
{
Vector allGoodsStore=new Vector();
String sql="";
if(type==1)//說明按庫存編號查詢
{
sql="select * from goodsstore where id="+goodsStore.getId();
}
if(type==2)//說明按商編號進行查詢
{
sql="select * from goodsstore where goodsid='"+goodsStore.getGoodsid()+"'";
}
try
{
ResultSet rs=stmt.executeQuery(sql);//執(zhí)行查詢
while(rs.next())
{
GoodsStore gs=new GoodsStore();
gs.setId(rs.getInt("id"));
gs.setGoodsid(rs.getInt("goodsid"));
gs.setStoresum(rs.getInt("storesum"));
gs.setSafestoresum(rs.getInt("safestoresum"));
gs.setRemarks(rs.getString("remarks"));
allGoodsStore.add(gs);
System.out.println("庫存信息查詢------成功!!!!");
}
}catch(Exception e)
{
e.printStackTrace();
System.out.println("庫存信息查詢------失敗!!!!");
}
return allGoodsStore;
}
/*--------------完成對庫存信息的修改----------*/
public void updateGoodsStore(GoodsStore goodsStore)
{
String sql="update goodsstore set goodsid='"+goodsStore.getGoodsid()+"'," +
"storesum='"+goodsStore.getStoresum()+"',safestoresum='"+goodsStore.getSafestoresum()+"'," +
"remarks='"+goodsStore.getRemarks()+"' where id="+goodsStore.getId();
try
{
stmt.executeUpdate(sql);
System.out.println("庫存信息修改------成功!!!!");
}catch(Exception e)
{
System.out.println("庫存信息修改------失敗!!!!");
}
}
/*-----------------完成對庫存信息的刪除------------------*/
public void deleteGoodsStore(GoodsStore goodsStore)
{
String sql="delete from goodsstore where id="+goodsStore.getId();
try
{
stmt.executeUpdate(sql);
System.out.println("庫存信息刪除------成功!!!!");
}catch(Exception e)
{
System.out.println("庫存信息刪除------失敗!!!!");
}
}
/*------------------完成對庫存信息的統(tǒng)計------------------*/
/*------查詢分頁-----*/
public List getAllInfo(int pagesize,int nowpage) throws Exception
{List allinfo=new ArrayList();
String sql="select * from goodsstore order by id";
ResultSet rs=stmt.executeQuery(sql);
rs.last();// 定位到最后一條記錄
int rows=rs.getRow();
int num=pagesize;
int pagecount=rows/pagesize;//總頁數(shù)
if(rows%pagesize>0){pagecount++;}
if(nowpage>0&&nowpage<=pagecount)
{
if(nowpage==1){rs.beforeFirst();}
if(nowpage>1){rs.absolute((nowpage-1)*pagesize);}
while(rs.next()&&num>0)
{
GoodsStore gs=new GoodsStore();
gs.setId(rs.getInt("id"));
gs.setGoodsid(rs.getInt("goodsid"));
gs.setSafestoresum(rs.getInt("storesum"));
gs.setSafestoresum(rs.getInt("safestoresum"));
gs.setRemarks(rs.getString("remarks"));
num--;
allinfo.add(gs);
}
return allinfo;
}
return null;
}
public int getcount()throws Exception
{
int count=0;
String sql="select * from goodsstore order by id";
ResultSet rs=stmt.executeQuery(sql);
rs.last();
count=rs.getRow();
return count;
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -