Beispiel #1
0
 @Override
 public int deleteBill(Bill bill) throws Exception {
   int rowAffects = 0;
   con = BaseDao.getConnection();
   String sql = "delete from t_bill where bill_id=?";
   pstmt = con.prepareStatement(sql);
   pstmt.setInt(1, bill.getBill_id());
   rowAffects = pstmt.executeUpdate();
   BaseDao.closeAll(null, pstmt, con);
   return rowAffects;
 }
Beispiel #2
0
 @Override
 public int updateBill(Bill bill) throws Exception {
   int rowAffects = 0;
   con = BaseDao.getConnection();
   String sql =
       "update t_bill  set productname = ?,suppliername=?,amount=?,price=?,pay=?,billtime=?,saleworker=? where bill_id=?";
   pstmt = con.prepareStatement(sql);
   pstmt.setString(1, bill.getproductName());
   pstmt.setString(2, bill.getsupplierName());
   pstmt.setInt(3, bill.getAmount());
   pstmt.setFloat(4, bill.getPrice());
   pstmt.setFloat(5, bill.getPay());
   pstmt.setString(6, bill.getBilltime());
   pstmt.setString(7, bill.getsaleworker());
   pstmt.setInt(8, bill.getBill_id());
   rowAffects = pstmt.executeUpdate();
   BaseDao.closeAll(null, pstmt, con);
   return rowAffects;
 }