Esempio n. 1
0
  @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;
  }