?? producebean.java
字號(hào):
package com.qrsx.buyflowers.beans;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.Collection;
public class ProduceBean extends DBConnection{
// 聲明實(shí)體
private ProduceClass produceClass;
private PreparedStatement ptst;
private ResultSet rs;
private Collection collection;
public ProduceBean() throws ClassNotFoundException, SQLException {
super();
// TODO Auto-generated constructor stub
}
public Collection getAllProduce(){
String sql="select * from produce";
try {
ptst=con.prepareStatement(sql);
rs=ptst.executeQuery();
collection=new ArrayList();
while(rs.next()){
produceClass=new ProduceClass();
produceClass.setProduceId(rs.getString("produceId"));
produceClass.setProduceName(rs.getString("produceName"));
collection.add(produceClass);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return collection;
}
// 按ID查詢廠商
public Collection getProduceByProduceId(String produceId) {
String sql = "select * from produceDetails where produceId=?;";
ProduceDetailsClass pd=null;
try {
ptst = con.prepareStatement(sql);
ptst.setString(1, produceId);
rs = ptst.executeQuery();
collection = new ArrayList();
while (rs.next()) {
pd = new ProduceDetailsClass();
pd.setProduceId(rs.getString("produceId"));
pd.setProduceName(rs.getString("produceName"));
pd.setGoodsId(rs.getString("goodsId"));
pd.setSortId(rs.getString("sortId"));
collection.add(pd);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return collection;
}
}
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -