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; }