public static void main(String args[]) { /*try { Workbook book= Workbook.getWorkbook(new File("f://user.xls")); Sheet sheet=book.getSheet(0); ReadUser ru = new ReadUser(); Sheet sheet=book.getSheet(2); ReadUser ru = new ReadUser(); ru.save(sheet); book.close(); } catch(Exception e) { System.out.println(e); } */ DataRead dr = new DataRead(); dr.chooseFilePath("f:/s.sql"); dr.read(); }
public void readValues(DataRead dr) throws BasicException { m_PaymentType = dr.getString(1); m_PaymentValue = dr.getDouble(2); }
public void readValues(DataRead dr) throws BasicException { m_SalesTaxName = dr.getString(1); m_SalesTaxes = dr.getDouble(2); }
public Object readValues(DataRead dr) throws BasicException { CustomerInfoExt c = new CustomerInfoExt(dr.getString(1)); c.setTaxid(dr.getString(2)); c.setSearchkey(dr.getString(3)); c.setName(dr.getString(4)); c.setCard(dr.getString(5)); c.setTaxCustomerID(dr.getString(6)); c.setNotes(dr.getString(7)); c.setMaxdebt(dr.getDouble(8)); c.setVisible(dr.getBoolean(9).booleanValue()); c.setCurdate(dr.getTimestamp(10)); c.setCurdebt(dr.getDouble(11)); c.setFirstname(dr.getString(12)); c.setLastname(dr.getString(13)); c.setEmail(dr.getString(14)); c.setPhone(dr.getString(15)); c.setPhone2(dr.getString(16)); c.setFax(dr.getString(17)); c.setAddress(dr.getString(18)); c.setAddress2(dr.getString(19)); c.setPostal(dr.getString(20)); c.setCity(dr.getString(21)); c.setRegion(dr.getString(22)); c.setCountry(dr.getString(23)); return c; }