public List getPrs() { ResultSet rs = null; List list = new ArrayList(); try { rs = control.st.executeQuery("select kode,nama,awal,masuk,keluar,adj,returm,returk,prosesm,prosesk,sisa FROM mstockstore order by nama"); muncul(rs, list); rs.close(); } catch(SQLException ex) { ex.printStackTrace(); } return list; } private void muncul(ResultSet rs, List list) throws SQLException { while (rs.next()) { MisStockP p = new MisStockP(); p.setKode(rs.getString(1)); p.setNama(rs.getString(2)); p.setAwal(rs.getDouble(3)); p.setMasuk(rs.getDouble(4)); p.setKeluar(rs.getDouble(5)); p.setAdj(rs.getDouble(6)); p.setReturm(rs.getDouble(7)); p.setReturk(rs.getDouble(8)); p.setProsesm(rs.getDouble(9)); p.setProsesk(rs.getDouble(10)); p.setSisa(rs.getDouble(11)); list.add(p); } }