@Override
  public boolean doCreate(Supplier Supplier) throws Exception {
    boolean flag = false;
    String sql =
        "INSERT INTO t_supplier(supplier_userid,supplier_yingyezhizhao,supplier_shuiwu,supplier_jigou,supplier_liutong,supplier_anquan,supplier_renzheng,supplier_jingyingaddr,supplier_shengchanaddr) VALUES (?,?,?,?,?,?,?,?,?)";
    this.pstmt = this.conn.prepareStatement(sql);
    this.pstmt.setInt(1, Supplier.getSupplier_userid());
    this.pstmt.setString(2, Supplier.getSupplier_yingyezhizhao());
    this.pstmt.setString(3, Supplier.getSupplier_shuiwu());
    this.pstmt.setString(4, Supplier.getSupplier_jigou());
    this.pstmt.setString(5, Supplier.getSupplier_liutong());
    this.pstmt.setString(6, Supplier.getSupplier_anquan());
    this.pstmt.setString(7, Supplier.getSupplier_renzheng());
    this.pstmt.setString(8, Supplier.getSupplier_jingyingaddr());
    this.pstmt.setString(9, Supplier.getSupplier_shengchanaddr());

    if (this.pstmt.executeUpdate() > 0) {
      flag = true;
    }
    this.pstmt.close();
    return flag;
  }
 @Override
 public Supplier findById(int supplier_id) throws Exception {
   Supplier Supplier = null;
   String sql = "SELECT * FROM t_supplier WHERE supplier_id=?";
   this.pstmt = this.conn.prepareStatement(sql);
   this.pstmt.setInt(1, supplier_id);
   ResultSet rs = this.pstmt.executeQuery();
   if (rs.next()) {
     Supplier = new Supplier();
     Supplier.setSupplier_id(rs.getInt("supplier_id"));
     Supplier.setSupplier_userid(rs.getInt("supplier_userid"));
     Supplier.setSupplier_yingyezhizhao(rs.getString("supplier_yingyezhizhao"));
     Supplier.setSupplier_shuiwu(rs.getString("supplier_shuiwu"));
     Supplier.setSupplier_jigou(rs.getString("supplier_jigou"));
     Supplier.setSupplier_liutong(rs.getString("supplier_liutong"));
     Supplier.setSupplier_anquan(rs.getString("supplier_anquan"));
     Supplier.setSupplier_renzheng(rs.getString("supplier_renzheng"));
     Supplier.setSupplier_jingyingaddr(rs.getString("supplier_jingyingaddr"));
     Supplier.setSupplier_shengchanaddr(rs.getString("supplier_shengchanaddr"));
   }
   this.pstmt.close();
   return Supplier;
 }
 @Override
 public List<Supplier> findAll(String keyWord) throws Exception {
   List<Supplier> result = new ArrayList<Supplier>();
   String sql =
       "SELECT * FROM t_supplier WHERE supplier_userid  LIKE ?  OR supplier_jingyingaddr  LIKE ?";
   this.pstmt = this.conn.prepareStatement(sql);
   this.pstmt.setString(1, "%" + keyWord + "%");
   this.pstmt.setString(2, "%" + keyWord + "%");
   ResultSet rs = this.pstmt.executeQuery();
   Supplier Supplier = null;
   while (rs.next()) {
     Supplier = new Supplier();
     Supplier.setSupplier_id(rs.getInt("supplier_id"));
     Supplier.setSupplier_userid(rs.getInt("supplier_userid"));
     Supplier.setSupplier_yingyezhizhao(rs.getString("supplier_yingyezhizhao"));
     Supplier.setSupplier_shuiwu(rs.getString("supplier_shuiwu"));
     Supplier.setSupplier_jigou(rs.getString("supplier_jigou"));
     Supplier.setSupplier_liutong(rs.getString("supplier_liutong"));
     Supplier.setSupplier_anquan(rs.getString("supplier_anquan"));
     Supplier.setSupplier_renzheng(rs.getString("supplier_renzheng"));
     Supplier.setSupplier_jingyingaddr(rs.getString("supplier_jingyingaddr"));
     Supplier.setSupplier_shengchanaddr(rs.getString("supplier_shengchanaddr"));
     result.add(Supplier);
   }
   this.pstmt.close();
   return result;
 }