Update of /cvsroot/oscarmcmaster/oscar_mcmaster/web/WEB-INF/classes/src/oscar/oscarEncounter/oscarMeasurements/bean
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv15186
Modified Files:
EctMeasurementsDataBeanHandler.java
Log Message:
updated mysql query
Index: EctMeasurementsDataBeanHandler.java
===================================================================
RCS file: /cvsroot/oscarmcmaster/oscar_mcmaster/web/WEB-INF/classes/src/oscar/oscarEncounter/oscarMeasurements/bean/EctMeasurementsDataBeanHandler.java,v
retrieving revision 1.6
retrieving revision 1.7
diff -C2 -d -r1.6 -r1.7
*** EctMeasurementsDataBeanHandler.java 16 Apr 2004 17:54:56 -0000 1.6
--- EctMeasurementsDataBeanHandler.java 7 Jan 2005 21:21:36 -0000 1.7
***************
*** 44,48 ****
}
! public boolean init(String demo) {
boolean verdict = true;
try {
--- 44,48 ----
}
! /*public boolean init(String demo) {
boolean verdict = true;
try {
***************
*** 54,58 ****
"AND mt.measuringInstruction = m.measuringInstruction AND mt.validation = v.id ORDER BY m.type ASC," +
"m.dateEntered DESC";
! System.out.println("sql: " + sql);
ResultSet rs;
String canPlot = null;
--- 54,59 ----
"AND mt.measuringInstruction = m.measuringInstruction AND mt.validation = v.id ORDER BY m.type ASC," +
"m.dateEntered DESC";
!
! System.out.println(" EctMeasurementDataBeanHandler sql: " + sql);
ResultSet rs;
String canPlot = null;
***************
*** 80,85 ****
}
return verdict;
! }
public boolean init(String demo, String type) {
--- 81,117 ----
}
return verdict;
! }*/
!
! public boolean init(String demo) {
! boolean verdict = true;
! try {
! DBHandler db = new DBHandler(DBHandler.OSCAR_DATA);
! String sql ="SELECT mt.type, mt.typeDisplayName, mt.typeDescription, mt.measuringInstruction FROM measurements m," +
! "measurementType mt WHERE m.demographicNo='" + demo + "' AND m.type = mt.type " +
! "GROUP BY mt.id ORDER BY m.type ASC";
!
! System.out.println(" EctMeasurementDataBeanHandler sql: " + sql);
! ResultSet rs;
! String canPlot = null;
! for(rs = db.GetSQL(sql); rs.next(); )
! {
! EctMeasurementsDataBean data = new EctMeasurementsDataBean();
! data.setType(rs.getString("type"));
! data.setTypeDisplayName(rs.getString("typeDisplayName"));
! data.setTypeDescription(rs.getString("typeDescription"));
! data.setMeasuringInstrc(rs.getString("measuringInstruction"));
! //System.out.println("Measurments: " + rs.getString("type") + " " + rs.getString("typeDisplayName") + " " + rs.getString("typeDescription"));
! measurementsDataVector.add(data);
! }
+ rs.close();
+ db.CloseConn();
+ }
+ catch(SQLException e) {
+ System.out.println(e.getMessage());
+ verdict = false;
+ }
+ return verdict;
+ }
public boolean init(String demo, String type) {
***************
*** 87,91 ****
try {
DBHandler db = new DBHandler(DBHandler.OSCAR_DATA);
! String sql ="SELECT m.id, mt.type, mt.typeDisplayName, m.demographicNo, m.providerNo, m.dataField, m.measuringInstruction,"+
"m.comments, m.dateObserved, m.dateEntered , p.first_name AS provider_first, p.last_name AS provider_last," +
"v.isNumeric AS numericValidation, v.name AS validationName FROM measurements m, provider p, validations v," +
--- 119,123 ----
try {
DBHandler db = new DBHandler(DBHandler.OSCAR_DATA);
! String sql ="SELECT m.id, mt.type, mt.typeDisplayName, mt.typeDescription, m.demographicNo, m.providerNo, m.dataField, m.measuringInstruction,"+
"m.comments, m.dateObserved, m.dateEntered , p.first_name AS provider_first, p.last_name AS provider_last," +
"v.isNumeric AS numericValidation, v.name AS validationName FROM measurements m, provider p, validations v," +
***************
*** 103,107 ****
canPlot = null;
//System.out.println("canPlot value: " + canPlot);
! EctMeasurementsDataBean data = new EctMeasurementsDataBean(rs.getInt("id"), rs.getString("type"), rs.getString("typeDisplayName"), rs.getString("demographicNo"),
rs.getString("provider_first"), rs.getString("provider_last"),
rs.getString("dataField"), rs.getString("measuringInstruction"),
--- 135,139 ----
canPlot = null;
//System.out.println("canPlot value: " + canPlot);
! EctMeasurementsDataBean data = new EctMeasurementsDataBean(rs.getInt("id"), rs.getString("type"), rs.getString("typeDisplayName"), rs.getString("typeDescription"), rs.getString("demographicNo"),
rs.getString("provider_first"), rs.getString("provider_last"),
rs.getString("dataField"), rs.getString("measuringInstruction"),
|