public String doSelect() {
String back = "";
Connection con = null;
PreparedStatement pstmt = null;
ResultSet rs = null;
String qq =
"select external_id,device_id,name,asset_num,"
+ " serial_num,screen_size,model,type,"
+ "vertical_resolution,horizontal_resolution,"
+ "manufacturer,"
+ "date_format(received,'%m/%d/%Y'),"
+ "expected_age,status,notes,editable "
+ " from monitors where id=?";
con = Helper.getConnection();
if (con == null) {
back = "Could not connect to DB";
addError(back);
return back;
} else {
try {
if (debug) {
logger.debug(qq);
}
pstmt = con.prepareStatement(qq);
pstmt.setString(1, id);
rs = pstmt.executeQuery();
if (rs.next()) {
setExternal_id(rs.getString(1));
setDevice_id(rs.getString(2));
setName(rs.getString(3));
setAsset_num(rs.getString(4));
setSerial_num(rs.getString(5));
setScreen_size(rs.getString(6));
setModel(rs.getString(7));
setType(rs.getString(8));
setVertical_resolution(rs.getString(9));
setHorizontal_resolution(rs.getString(10));
setManufacturer(rs.getString(11));
setReceived(rs.getString(12));
setExpected_age(rs.getString(13));
setStatus(rs.getString(14));
setNotes(rs.getString(15));
setEditable(rs.getString(16));
} else {
return "Record " + id + " Not found";
}
} catch (Exception ex) {
back += ex + ":" + qq;
logger.error(back);
addError(back);
} finally {
Helper.databaseDisconnect(con, pstmt, rs);
}
}
return back;
}
public Monitor(
boolean deb,
String _id,
String _external_id,
String _device_id,
String _name,
String _asset_num,
String _serial_num,
String _screen_size,
String _model,
String _type,
String _vertical_resolution,
String _horizontal_resolution,
String _manufacturer,
String _received,
String _expected_age,
String _status,
String _notes,
String _editable) {
debug = deb;
setId(_id);
setExternal_id(_external_id);
setDevice_id(_device_id);
setName(_name);
setAsset_num(_asset_num);
setSerial_num(_serial_num);
setScreen_size(_screen_size);
setModel(_model);
setType(_type);
setVertical_resolution(_vertical_resolution);
setHorizontal_resolution(_horizontal_resolution);
setManufacturer(_manufacturer);
setReceived(_received);
setExpected_age(_expected_age);
setStatus(_status);
setNotes(_notes);
setEditable(_editable);
}
