@Override public ArrayList<Order> selectBySeller(int sId) { DBConn db = new DBConn(); db.getConn(); ArrayList<Order> a = new ArrayList<Order>(); ResultSet rs = null; rs = db.doSelect("select * from t_order where sellerId=" + sId); try { while (rs.next()) { Order o = new Order(); o.setBuyerId(rs.getInt("buyerId")); o.setSellerId(rs.getInt("sellerId")); o.setoId(rs.getInt("oId")); o.setCreateTime(rs.getTimestamp("createTime")); o.setProductId(rs.getInt("productId")); o.setPruductNumber(rs.getInt("productNumber")); a.add(o); } db.close(rs); } catch (SQLException e) { e.printStackTrace(); } catch (Exception e) { e.printStackTrace(); } return a; }
@Override public void add(Order ord) { DBConn db = new DBConn(); db.getConn(); db.doInsert( "insert into t_order values(null," + ord.getBuyerId() + "," + ord.getSellerId() + "," + ord.getProductId() + "," + ord.getPruductNumber() + ",null)"); try { db.close(); } catch (SQLException e) { e.printStackTrace(); } catch (Exception e) { e.printStackTrace(); } }