📄 goodsbean.java
字号:
{
Statement statement = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
ResultSet resultset = statement.executeQuery("select * from Goods where goodsId ='" + i1 + "'");
while(resultset.next())
{
goods = new GoodsClass();
int i=resultset.getInt(1);
String s1=resultset.getString(2);
String s2=resultset.getString(3);
String s3=resultset.getString(4);
String s4=resultset.getString(5);
float f=resultset.getFloat(6);
String s5=resultset.getString(7);
String s6=resultset.getString(8);
String s7=resultset.getString(9);
String s8=resultset.getString(10);
String s9=resultset.getString(11);
goods.setGoodsId(i);
goods.setGoodsName(s1);
goods.setGoodsmaterial(s2);
goods.setGoodsPackage(s3);
goods.setGoodsLanguage(s4);
goods.setGoodsPrice(f);
goods.setGoodsCent(s5);
goods.setGoodsScope(s6);
goods.setGoodsPlace(s7);
goods.setGoodsHabitus(s8);
goods.setSortName(s9);
arraylist.add(goods);
}
statement.close();
con.close();
}
catch(Exception e)
{
e.printStackTrace();
}
return arraylist;
}
public Collection getGoodsByGoodsName(String s)
{
GoodsClass goods;
ArrayList arraylist = new ArrayList();
try
{
Statement statement = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
ResultSet resultset = statement.executeQuery("select * from Goods where goodsName ='" + s + "'");
while(resultset.next())
{
goods = new GoodsClass();
int i=resultset.getInt(1);
String s1=resultset.getString(2);
String s2=resultset.getString(3);
String s3=resultset.getString(4);
String s4=resultset.getString(5);
float f=resultset.getFloat(6);
String s5=resultset.getString(7);
String s6=resultset.getString(8);
String s7=resultset.getString(9);
String s8=resultset.getString(10);
String s9=resultset.getString(11);
goods.setGoodsId(i);
goods.setGoodsName(s1);
goods.setGoodsmaterial(s2);
goods.setGoodsPackage(s3);
goods.setGoodsLanguage(s4);
goods.setGoodsPrice(f);
goods.setGoodsCent(s5);
goods.setGoodsScope(s6);
goods.setGoodsPlace(s7);
goods.setGoodsHabitus(s8);
goods.setSortName(s9);
arraylist.add(goods);
}
statement.close();
con.close();
}
catch(Exception e)
{
e.printStackTrace();
}
return arraylist;
}
public Collection getGoodsByGoodsPrice(String s)
{
GoodsClass goods;
ArrayList arraylist = new ArrayList();
try
{
Statement statement = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
ResultSet resultset = statement.executeQuery("select * from Goods where goodsPrice ='"+s+"'");
while(resultset.next())
{
goods = new GoodsClass();
int i=resultset.getInt(1);
String s1=resultset.getString(2);
String s2=resultset.getString(3);
String s3=resultset.getString(4);
String s4=resultset.getString(5);
float f=resultset.getFloat(6);
String s5=resultset.getString(7);
String s6=resultset.getString(8);
String s7=resultset.getString(9);
String s8=resultset.getString(10);
String s9=resultset.getString(11);
goods.setGoodsId(i);
goods.setGoodsName(s1);
goods.setGoodsmaterial(s2);
goods.setGoodsPackage(s3);
goods.setGoodsLanguage(s4);
goods.setGoodsPrice(f);
goods.setGoodsCent(s5);
goods.setGoodsScope(s6);
goods.setGoodsPlace(s7);
goods.setGoodsHabitus(s8);
goods.setSortName(s9);
arraylist.add(goods);
}
statement.close();
con.close();
}
catch(Exception e)
{
e.printStackTrace();
}
return arraylist;
}
public Collection getGoodsByLowerSelect(String m,String n)
{
GoodsClass goods;
ArrayList arraylist = new ArrayList();
try
{
Statement statement = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
ResultSet resultset = statement.executeQuery("select * from Goods where goodsName like '%"+m+"%' and sortName like '"+n+"'");
while(resultset.next())
{
goods = new GoodsClass();
int i=resultset.getInt(1);
String s1=resultset.getString(2);
String s2=resultset.getString(3);
String s3=resultset.getString(4);
String s4=resultset.getString(5);
float f=resultset.getFloat(6);
String s5=resultset.getString(7);
String s6=resultset.getString(8);
String s7=resultset.getString(9);
String s8=resultset.getString(10);
String s9=resultset.getString(11);
goods.setGoodsId(i);
goods.setGoodsName(s1);
goods.setGoodsmaterial(s2);
goods.setGoodsPackage(s3);
goods.setGoodsLanguage(s4);
goods.setGoodsPrice(f);
goods.setGoodsCent(s5);
goods.setGoodsScope(s6);
goods.setGoodsPlace(s7);
goods.setGoodsHabitus(s8);
goods.setSortName(s9);
arraylist.add(goods);
}
statement.close();
con.close();
}
catch(Exception e)
{
e.printStackTrace();
}
return arraylist;
}
public Collection getGoodsByHeightSelect(String m,String n,String x,String y)
{
GoodsClass goods;
ArrayList arraylist = new ArrayList();
try
{
Statement statement = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
ResultSet resultset=null;
if(n.equals("商品名称"))
{
resultset = statement.executeQuery("select * from Goods where goodsName like '%"+m+"%' and sortName like '"+y+"' and (goodsPrice between 0 and "+x+")");
}
else if(n.equals("品牌"))
{
resultset = statement.executeQuery("select * from Goods where goodsName like '%"+m+"%' and sortName like '"+y+"' and (goodsPrice between 0 and "+x+")");
}
else if(n.equals("花材"))
{
resultset = statement.executeQuery("select * from Goods where goodsmaterial like '%"+m+"%' and sortName like '"+y+"' and (goodsPrice between 0 and "+x+")");
}
while(resultset.next())
{
goods = new GoodsClass();
int i=resultset.getInt(1);
String s1=resultset.getString(2);
String s2=resultset.getString(3);
String s3=resultset.getString(4);
String s4=resultset.getString(5);
float f=resultset.getFloat(6);
String s5=resultset.getString(7);
String s6=resultset.getString(8);
String s7=resultset.getString(9);
String s8=resultset.getString(10);
String s9=resultset.getString(11);
goods.setGoodsId(i);
goods.setGoodsName(s1);
goods.setGoodsmaterial(s2);
goods.setGoodsPackage(s3);
goods.setGoodsLanguage(s4);
goods.setGoodsPrice(f);
goods.setGoodsCent(s5);
goods.setGoodsScope(s6);
goods.setGoodsPlace(s7);
goods.setGoodsHabitus(s8);
goods.setSortName(s9);
arraylist.add(goods);
}
resultset.close();
statement.close();
con.close();
}
catch(Exception e)
{
e.printStackTrace();
}
return arraylist;
}
public void addGoods(GoodsClass goods)
{
try
{
System.out.println(goods.getGoodsName());
System.out.println(goods.getGoodsmaterial());
System.out.println(goods.getGoodsPackage());
System.out.println(goods.getGoodsLanguage());
System.out.println(goods.getGoodsPrice());
System.out.println(goods.getGoodsCent());
System.out.println(goods.getGoodsScope());
System.out.println(goods.getGoodsPlace());
System.out.println(goods.getGoodsHabitus());
System.out.println(goods.getSortName());
//System.out.println(product.getCategory()+" "+product.getName()+" "+product.getProducer()+" "+product.getPrice()+" "+product.getDescription()+" ***1");
PreparedStatement preparedstatement = con.prepareStatement("insert into goods values(?,?,?,?,?,?,?,?,?,?)");
//System.out.println(product.getCategory()+" "+product.getName()+" "+product.getProducer()+" "+product.getPrice()+" "+product.getDescription()+" ***2");
preparedstatement.setString(1, goods.getGoodsName());
preparedstatement.setString(2, goods.getGoodsmaterial());
preparedstatement.setString(3, goods.getGoodsPackage());
preparedstatement.setString(4, goods.getGoodsLanguage());
preparedstatement.setFloat(5, goods.getGoodsPrice());
preparedstatement.setString(6, goods.getGoodsCent());
preparedstatement.setString(7, goods.getGoodsScope());
preparedstatement.setString(8, goods.getGoodsPlace());
preparedstatement.setString(9, goods.getGoodsHabitus() );
preparedstatement.setString(10, goods.getSortName());
preparedstatement.execute();
//System.out.println(product.getCategory()+" "+product.getName()+" "+product.getProducer()+" "+product.getPrice()+" "+product.getDescription()+" ***3");
}
catch(Exception e)
{
e.printStackTrace();
}
}
public void deleteGoods(String s)
{
try
{
int i=Integer.parseInt(s);
Statement statement = con.createStatement();
statement.execute("delete from goods where goodsId='" +i+ "'");
}
catch(Exception e)
{
e.printStackTrace();
}
}
public GoodsClass getGoodsInfo(String s)
{
GoodsClass goods = new GoodsClass();
try
{
Statement statement = con.createStatement();
ResultSet resultset = statement.executeQuery("select * from goods where goodsId='" + s + "'");
while(resultset.next())
{
int i=resultset.getInt(1);
String s1=resultset.getString(2);
String s2=resultset.getString(3);
String s3=resultset.getString(4);
String s4=resultset.getString(5);
float f=resultset.getFloat(6);
String s5=resultset.getString(7);
String s6=resultset.getString(8);
String s7=resultset.getString(9);
String s8=resultset.getString(10);
String s9=resultset.getString(11);
goods.setGoodsId(i);
goods.setGoodsName(s1);
goods.setGoodsmaterial(s2);
goods.setGoodsPackage(s3);
goods.setGoodsLanguage(s4);
goods.setGoodsPrice(f);
goods.setGoodsCent(s5);
goods.setGoodsScope(s6);
goods.setGoodsPlace(s7);
goods.setGoodsHabitus(s8);
goods.setSortName(s9);
}
}
catch(Exception e)
{
e.printStackTrace();
}
return goods;
}
public void modifyGoods(GoodsClass goods)
{
try
{
//System.out.println(product.getProductId()+"****2");
//System.out.println(product.getCategory()+" "+product.getName()+" "+product.getProducer()+" "+product.getPrice()+" "+product.getDescription()+"*****1");
PreparedStatement preparedstatement = con.prepareStatement("update goods set goodsName=?,goodsmaterial=?,goodsPackage=?,goodsLanguage=?,goodsPrice=?,goodsCent=?,goodsScope=?,goodsPlace=?,goodsHabitus=?,sortName=? where goodsId=?");
preparedstatement.setString(1, goods.getGoodsName());
preparedstatement.setString(2, goods.getGoodsmaterial());
preparedstatement.setString(3, goods.getGoodsPackage());
preparedstatement.setString(4, goods.getGoodsLanguage());
preparedstatement.setFloat(5, goods.getGoodsPrice());
preparedstatement.setString(6, goods.getGoodsCent());
preparedstatement.setString(7, goods.getGoodsScope());
preparedstatement.setString(8, goods.getGoodsPlace());
preparedstatement.setString(9, goods.getGoodsHabitus());
preparedstatement.setString(10, goods.getSortName());
preparedstatement.setInt(11, goods.getGoodsId());
//System.out.println(product.getCategory()+" "+product.getName()+" "+product.getProducer()+" "+product.getPrice()+" "+product.getDescription()+"*****2");
preparedstatement.execute();
//System.out.println(product.getCategory()+" "+product.getName()+" "+product.getProducer()+" "+product.getPrice()+" "+product.getDescription()+"*****3");
}
catch(Exception e)
{
e.printStackTrace();
}
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -