ProductCL

原创于 2018-05-22 22:37:41 发布 · 162 阅读

0 ·

CC 4.0 BY-SA版权

本文介绍了一个使用Java实现的商品数据查询类。该类提供了从数据库中检索所有商品信息及随机选择三个商品的功能。通过连接数据库并执行SQL语句，能够获取商品ID、名称、数量和描述等字段。

public class ProductbeanCL {

Connection cn = null;
boolean flag = false;

public ArrayList<Productbean> selectallproducts(){

ArrayList<Productbean> products=new ArrayList<>();
String mysql = "select * from goods";
try{
cn = (new Conn()).getConn();
Statement myst = cn.createStatement();
ResultSet myrs = myst.executeQuery(mysql);
while(myrs.next()){
Productbean ul = new Productbean();
ul.setId(myrs.getString(1));
ul.setName(myrs.getString(2));
ul.setNum(myrs.getString(3));
ul.setDes(myrs.getString(4));
products.add(ul);
}
}catch(Exception e){

}

return products;
}

public ArrayList<Productbean> selectthree(){
ArrayList<Productbean> products = new ArrayList<>();
String mysql = "select * from goods ORDER BY RAND() limit 3";
try{
cn = (new Conn()).getConn();
Statement myst = cn.createStatement();
ResultSet myrs = myst.executeQuery(mysql);
while(myrs.next()){
Productbean p = new Productbean();
p.setId(myrs.getString(1));
p.setName(myrs.getString(2));
p.setNum(myrs.getString(3));
p.setDes(myrs.getString(4));
products.add(p);
}
}catch(Exception e){
}
return products;
}
}