@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; }