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