コード例 #1
0
  public ArrayList<RefSupplier> MonitorRefSupplier() {
    ArrayList<RefSupplier> refSupplier = new ArrayList<RefSupplier>();

    try {
      DBConnectionFactory myFactory = DBConnectionFactory.getInstance();
      Connection conn = myFactory.getConnection();
      PreparedStatement pstmt = conn.prepareStatement("SELECT * FROM `ref_supplier`");

      ResultSet rs = pstmt.executeQuery();
      while (rs.next()) {
        RefSupplier newRefSupplier = new RefSupplier();

        newRefSupplier.setSupplierID(rs.getInt("supplierID"));
        newRefSupplier.setItemCode(rs.getInt("itemCode"));
        newRefSupplier.setItemName(rs.getString("itemName"));
        newRefSupplier.setCompanyName(rs.getString("companyName"));
        newRefSupplier.setCompanyAddress(rs.getString("companyAddress"));
        newRefSupplier.setContactPerson(rs.getString("contactPerson"));
        newRefSupplier.setContactNumber(rs.getInt("contactNumber"));

        refSupplier.add(newRefSupplier);
        System.out.println(refSupplier.get(0).getCompanyName());
      }

      pstmt.close();
      rs.close();
      conn.close();

      return refSupplier;

    } catch (SQLException ex) {
      Logger.getLogger(RefSupplierDAO.class.getName()).log(Level.SEVERE, null, ex);
    }
    return null;
  }
コード例 #2
0
  public ArrayList<RefSupplier> searchSupplier(String itemName) throws SQLException {
    DBConnectionFactory myFactory = DBConnectionFactory.getInstance();
    Connection conn = myFactory.getConnection();

    String query = "SELECT * FROM `ref_supplier` WHERE itemName LIKE '%" + itemName + "%'";
    PreparedStatement ps = conn.prepareStatement(query);
    ArrayList<RefSupplier> RefSupplierList = new ArrayList();
    ResultSet rs = ps.executeQuery();
    while (rs.next()) {
      RefSupplier RefSupplierN = new RefSupplier();
      RefSupplierN.setSupplierID(rs.getInt("supplierID"));
      RefSupplierN.setItemCode(rs.getInt("itemCode"));
      RefSupplierN.setItemName(rs.getString("itemName"));
      RefSupplierN.setCompanyName(rs.getString("companyName"));
      RefSupplierN.setCompanyAddress(rs.getString("companyAddress"));
      RefSupplierN.setContactPerson(rs.getString("contactPerson"));
      RefSupplierN.setContactNumber(rs.getInt("contactNumber"));
      RefSupplierList.add(RefSupplierN);
    }
    rs.close();
    return RefSupplierList;
  }