Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery(sql);
ArrayList list = new ArrayList();
while (rs.next())
{
PerfArticle article = new PerfArticleImpl();
article.setArticleId(new Long(rs.getLong("ARTICLE_ID")));
article.setArticleName(rs.getString("ARTICLE_NAME"));
article.setMinimumStock(rs.getInt("MINIMUM_STOCK"));
article.setPrice(rs.getDouble("PRICE"));
article.setUnit(rs.getString("UNIT"));
article.setStock(rs.getInt("STOCK"));
article.setSupplierId(rs.getInt("SUPPLIER_ID"));
list.add(article);
}
rs.close();
stmt.close();
releaseConnection();