public AnnotationVO getTFWStringFromDB(String registrationID) {
BaseDAO baseDAO = new BaseDAO();
StringBuffer query = new StringBuffer();
ArrayList list = new ArrayList();
Connection conn = null;
Statement stmt = null;
AnnotationVO vo = null;
try {
conn = baseDAO.getStandAloneConnectionForOracle();
stmt = conn.createStatement();
query
.append(" select CX, RX, RY, CY, IX, IY ")
.append("from MOUSE_SPATIAL_REGISTRY ")
.append("where REGISTRATION_ID = '" + registrationID + "' ");
System.out.println("getImageRegistrationDataForSliceID - Query is - " + query.toString());
ResultSet rs = stmt.executeQuery(query.toString());
while (rs.next()) {
vo = new AnnotationVO();
vo.setTfwLine1(rs.getString("CX"));
vo.setTfwLine2(rs.getString("RX"));
vo.setTfwLine3(rs.getString("RY"));
vo.setTfwLine4(rs.getString("CY"));
vo.setTfwLine5(rs.getString("IX"));
vo.setTfwLine6(rs.getString("IY"));
}
} catch (SQLException sqle) {
sqle.printStackTrace();
} catch (Exception e) {
e.printStackTrace();
}
return vo;
}
