Miscellany

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