《网上书店信息管理系统的设计与实现》 第6页 共34页
//查询登录商家的所有商品，用于商家管理自己的商品 public ArrayList getAllGoods(){
ArrayList list = new ArrayList(); conn = Connect.getConnection(); try {
statement = conn.createStatement();
String sql = \* from goods a,seller b where a.seller_id=b.seller_id and
b.seller_id='\ //
resultSet = statement.executeQuery(sql); while(resultSet.next()){ }
Seller seller = new Seller();
seller.setName(resultSet.getString(\seller.setAddress(resultSet.getString(\Goods goods = new Goods(); goods.setSeller(seller);
goods.setId(resultSet.getInt(\
goods.setName(resultSet.getString(\goods.setSeller_id(resultSet.getString(\goods.setDiscount(resultSet.getInt(\goods.setNum(resultSet.getInt(\goods.setPrice(resultSet.getInt(\
System.out.println(goods.toString()); list.add(goods);
} catch (SQLException e) {
// TODO Auto-generated catch block e.printStackTrace();
}finally{
try {
《网上书店信息管理系统的设计与实现》 第7页 共34页
}
//查询所有商家的所有商品.用于用户搜索商品 public ArrayList getAllSellerGoods(){
ArrayList list = new ArrayList(); conn = Connect.getConnection(); try {
statement = conn.createStatement();
String sql = \resultSet = statement.executeQuery(sql); while(resultSet.next()){
Seller seller = new Seller();
seller.setName(resultSet.getString(\seller.setAddress(resultSet.getString(\Goods goods = new Goods(); goods.setSeller(seller);
goods.setId(resultSet.getInt(\
goods.setName(resultSet.getString(\goods.setSeller_id(resultSet.getString(\goods.setDiscount(resultSet.getInt(\goods.setNum(resultSet.getInt(\
} return list;
resultSet.close(); statement.close(); conn.close();
} catch (SQLException e) { }
// TODO Auto-generated catch block e.printStackTrace();
《网上书店信息管理系统的设计与实现》 第8页 共34页 //
}
//根据商品号查询商品信息 public Goods getOneGoods(int id){
Goods goods = new Goods(); conn = Connect.getConnection(); try {
statement = conn.createStatement();
String sql = \resultSet = statement.executeQuery(sql); while(resultSet.next()){
}
goods.setPrice(resultSet.getInt(\
System.out.println(goods.toString()); list.add(goods);
} catch (SQLException e) {
// TODO Auto-generated catch block e.printStackTrace();
}finally{ } return list;
try {
resultSet.close(); statement.close(); conn.close();
} catch (SQLException e) { }
// TODO Auto-generated catch block e.printStackTrace();
《网上书店信息管理系统的设计与实现》 第9页 共34页
}
//修改商品信息
public int updateGoods(Goods goods){
int flag = 0;
conn = Connect.getConnection(); try {
statement = conn.createStatement();
}
goods.setId(id);
goods.setName(resultSet.getString(\goods.setPrice(resultSet.getInt(\goods.setNum(resultSet.getInt(\goods.setDiscount(resultSet.getInt(\goods.setSeller_id(resultSet.getString(\goods.setNum(resultSet.getInt(\
} catch (SQLException e) {
// TODO Auto-generated catch block e.printStackTrace();
}finally{ }
return goods;
try {
resultSet.close(); statement.close(); conn.close();
} catch (SQLException e) { }
// TODO Auto-generated catch block e.printStackTrace();
《网上书店信息管理系统的设计与实现》 第10页 共34页
String sql = \goods set goods_name='\
=\
+\=\where
goods_id=\
}
//通过id删除商品 public int deleteById(int id){
int flag = 0;
conn = Connect.getConnection(); try {
statement = conn.createStatement();
String sql = \flag = statement.executeUpdate(sql);
flag = statement.executeUpdate(sql);
} catch (SQLException e) {
// TODO Auto-generated catch block e.printStackTrace();
}finally{ } return flag;
try {
statement.close(); conn.close();
} catch (SQLException e) { }
// TODO Auto-generated catch block e.printStackTrace();
} catch (SQLException e) {