private Medication cursorToMedi(ResultSet result) {
Medication medi = new Medication();
try {
medi.setId(result.getLong(1)); // KEY_ROWID
medi.setTitle(result.getString(2)); // KEY_TITLE
medi.setAuth(result.getString(3)); // KEY_AUTH
medi.setAtcCode(result.getString(4)); // KEY_ATCCODE
medi.setSubstances(result.getString(5)); // KEY_SUBSTANCES
medi.setRegnrs(result.getString(6)); // KEY_REGNRS
medi.setAtcClass(result.getString(7)); // KEY_ATCCLASS
medi.setTherapy(result.getString(8)); // KEY_THERAPY
medi.setApplication(result.getString(9)); // KEY_APPLICATION
medi.setIndications(result.getString(10)); // KEY_INDICATIONS
medi.setCustomerId(result.getInt(11)); // KEY_CUSTOMER_ID
medi.setPackInfo(result.getString(12)); // KEY_PACK_INFO
medi.setAddInfo(result.getString(13)); // KEY_ADD_INFO
medi.setSectionIds(result.getString(14)); // KEY_SECTION_IDS
medi.setSectionTitles(result.getString(15)); // KEY_SECTION_TITLES
medi.setContent(result.getString(16)); // KEY_CONTENT
// KEY_STYLE... (ignore)
medi.setPackages(result.getString(18)); // KEY_PACKAGES
} catch (SQLException e) {
System.err.println(">> SqlDatabase: SQLException in cursorToMedi");
}
return medi;
}
