Java tutorial
/** * The contents of this file are subject to the Mozilla Public License * Version 1.1 (the "License"); you may not use this file except in * compliance with the License. You may obtain a copy of the License at * http://www.mozilla.org/MPL/ * * Software distributed under the License is distributed on an "AS IS" * basis, WITHOUT WARRANTY OF ANY KIND, either express or implied. See the * License for the specific language governing rights and limitations under * the License. * * The Original Code is OpenELIS code. * * Copyright (C) The Minnesota Department of Health. All Rights Reserved. * * Contributor(s): CIRG, University of Washington, Seattle WA. */ package us.mn.state.health.lims.testanalyte.daoimpl; import java.util.List; import java.util.Vector; import org.apache.commons.beanutils.PropertyUtils; import us.mn.state.health.lims.audittrail.dao.AuditTrailDAO; import us.mn.state.health.lims.audittrail.daoimpl.AuditTrailDAOImpl; import us.mn.state.health.lims.common.action.IActionConstants; import us.mn.state.health.lims.common.daoimpl.BaseDAOImpl; import us.mn.state.health.lims.common.exception.LIMSRuntimeException; import us.mn.state.health.lims.common.util.StringUtil; import us.mn.state.health.lims.common.util.SystemConfiguration; import us.mn.state.health.lims.common.log.LogEvent; import us.mn.state.health.lims.hibernate.HibernateUtil; import us.mn.state.health.lims.test.valueholder.Test; import us.mn.state.health.lims.testanalyte.dao.TestAnalyteDAO; import us.mn.state.health.lims.testanalyte.valueholder.TestAnalyte; /** * @author diane benz */ public class TestAnalyteDAOImpl extends BaseDAOImpl implements TestAnalyteDAO { public void deleteData(List testAnalytes) throws LIMSRuntimeException { //add to audit trail try { AuditTrailDAO auditDAO = new AuditTrailDAOImpl(); for (int i = 0; i < testAnalytes.size(); i++) { TestAnalyte data = (TestAnalyte) testAnalytes.get(i); TestAnalyte oldData = (TestAnalyte) readTestAnalyte(data.getId()); TestAnalyte newData = new TestAnalyte(); String sysUserId = data.getSysUserId(); String event = IActionConstants.AUDIT_TRAIL_DELETE; String tableName = "TEST_ANALYTE"; auditDAO.saveHistory(newData, oldData, sysUserId, event, tableName); } } catch (Exception e) { //bugzilla 2154 LogEvent.logError("TestAnalyteDAOImpl", "AuditTrail deleteData()", e.toString()); throw new LIMSRuntimeException("Error in TestAnalyte AuditTrail deleteData()", e); } try { for (int i = 0; i < testAnalytes.size(); i++) { TestAnalyte data = (TestAnalyte) testAnalytes.get(i); //bugzilla 2206 data = (TestAnalyte) readTestAnalyte(data.getId()); HibernateUtil.getSession().delete(data); HibernateUtil.getSession().flush(); HibernateUtil.getSession().clear(); } } catch (Exception e) { //bugzilla 2154 LogEvent.logError("TestAnalyteDAOImpl", "deleteData()", e.toString()); throw new LIMSRuntimeException("Error in TestAnalyte deleteData()", e); } } public boolean insertData(TestAnalyte testAnalyte) throws LIMSRuntimeException { try { String id = (String) HibernateUtil.getSession().save(testAnalyte); testAnalyte.setId(id); //bugzilla 1824 inserts will be logged in history table AuditTrailDAO auditDAO = new AuditTrailDAOImpl(); String sysUserId = testAnalyte.getSysUserId(); String tableName = "TEST_ANALYTE"; auditDAO.saveNewHistory(testAnalyte, sysUserId, tableName); HibernateUtil.getSession().flush(); HibernateUtil.getSession().clear(); } catch (Exception e) { //bugzilla 2154 LogEvent.logError("TestAnalyteDAOImpl", "insertData()", e.toString()); throw new LIMSRuntimeException("Error in TestAnalyte insertData()", e); } return true; } public void updateData(TestAnalyte testAnalyte) throws LIMSRuntimeException { TestAnalyte oldData = (TestAnalyte) readTestAnalyte(testAnalyte.getId()); TestAnalyte newData = testAnalyte; //add to audit trail try { AuditTrailDAO auditDAO = new AuditTrailDAOImpl(); String sysUserId = testAnalyte.getSysUserId(); String event = IActionConstants.AUDIT_TRAIL_UPDATE; String tableName = "TEST_ANALYTE"; auditDAO.saveHistory(newData, oldData, sysUserId, event, tableName); } catch (Exception e) { //bugzilla 2154 LogEvent.logError("TestAnalyteDAOImpl", "AuditTrail updateData()", e.toString()); throw new LIMSRuntimeException("Error in TestAnalyte AuditTrail updateData()", e); } try { HibernateUtil.getSession().merge(testAnalyte); HibernateUtil.getSession().flush(); HibernateUtil.getSession().clear(); HibernateUtil.getSession().evict(testAnalyte); HibernateUtil.getSession().refresh(testAnalyte); } catch (Exception e) { //bugzilla 2154 LogEvent.logError("TestAnalyteDAOImpl", "updateData()", e.toString()); throw new LIMSRuntimeException("Error in TestAnalyte updateData()", e); } } public TestAnalyte getData(TestAnalyte testAnalyte) throws LIMSRuntimeException { try { TestAnalyte anal = (TestAnalyte) HibernateUtil.getSession().get(TestAnalyte.class, testAnalyte.getId()); HibernateUtil.getSession().flush(); HibernateUtil.getSession().clear(); if (anal != null) { PropertyUtils.copyProperties(testAnalyte, anal); } else { testAnalyte.setId(null); } return anal; } catch (Exception e) { //bugzilla 2154 LogEvent.logError("TestAnalyteDAOImpl", "getData()", e.toString()); throw new LIMSRuntimeException("Error in TestAnalyte getData()", e); } } public List getAllTestAnalytes() throws LIMSRuntimeException { List list = new Vector(); try { String sql = "from TestAnalyte"; org.hibernate.Query query = HibernateUtil.getSession().createQuery(sql); list = query.list(); HibernateUtil.getSession().flush(); HibernateUtil.getSession().clear(); } catch (Exception e) { //bugzilla 2154 LogEvent.logError("TestAnalyteDAOImpl", "getAllTestAnalytes()", e.toString()); throw new LIMSRuntimeException("Error in TestAnalyte getAllTestAnalytes()", e); } return list; } public List getPageOfTestAnalytes(int startingRecNo) throws LIMSRuntimeException { List list = new Vector(); try { // calculate maxRow to be one more than the page size int endingRecNo = startingRecNo + (SystemConfiguration.getInstance().getDefaultPageSize() + 1); String sql = "from TestAnalyte t order by t.id"; org.hibernate.Query query = HibernateUtil.getSession().createQuery(sql); query.setFirstResult(startingRecNo - 1); query.setMaxResults(endingRecNo - 1); list = query.list(); HibernateUtil.getSession().flush(); HibernateUtil.getSession().clear(); } catch (Exception e) { //bugzilla 2154 LogEvent.logError("TestAnalyteDAOImpl", "getPageOfTestAnalytes()", e.toString()); throw new LIMSRuntimeException("Error in TestAnalyte getPageOfTestAnalytes()", e); } return list; } public TestAnalyte readTestAnalyte(String idString) { TestAnalyte ta = null; try { ta = (TestAnalyte) HibernateUtil.getSession().get(TestAnalyte.class, idString); HibernateUtil.getSession().flush(); HibernateUtil.getSession().clear(); } catch (Exception e) { //bugzilla 2154 LogEvent.logError("TestAnalyteDAOImpl", "readTestAnalyte()", e.toString()); throw new LIMSRuntimeException("Error in TestAnalyte readTestAnalyte()", e); } return ta; } // this is for autocomplete //TODO: need to convert to hibernate ( not in use??? ) public List getTestAnalytes(String filter) throws LIMSRuntimeException { return null; /* try { DatabaseSession aSession = getSession(); ReadAllQuery query = new ReadAllQuery(TestAnalyte.class); ExpressionBuilder builder = new ExpressionBuilder(); Expression exp = null; if (filter != null) { exp = builder.get("testAnalyteName").toUpperCase().like( filter.toUpperCase() + "%"); } else { exp = builder.get("testAnalyteName").like(filter + "%"); } // Expression exp1 = builder.get("isActive").equal(true); // exp = exp.and(exp1); query.setSelectionCriteria(exp); query.addAscendingOrdering("testAnalyteName"); System.out.println("This is query " + query.getSQLString()); List testAnalytes = (Vector) aSession.executeQuery(query); System.out.println("This is size of list retrieved " + testAnalytes.size() + " " + testAnalytes.get(0)); return testAnalytes; } catch (Exception e) { throw new LIMSRuntimeException( "Error in TestAnalyte getTestAnalytes(String filter)", e); } */ } public List getNextTestAnalyteRecord(String id) throws LIMSRuntimeException { return getNextRecord(id, "TestAnalyte", TestAnalyte.class); } public List getPreviousTestAnalyteRecord(String id) throws LIMSRuntimeException { return getPreviousRecord(id, "TestAnalyte", TestAnalyte.class); } public TestAnalyte getTestAnalyteById(TestAnalyte testAnalyte) throws LIMSRuntimeException { TestAnalyte newTestAnalyte = null; try { newTestAnalyte = (TestAnalyte) HibernateUtil.getSession().get(TestAnalyte.class, testAnalyte.getId()); HibernateUtil.getSession().flush(); HibernateUtil.getSession().clear(); } catch (Exception e) { //bugzilla 2154 LogEvent.logError("TestAnalyteDAOImpl", "getTestAnalyteById()", e.toString()); throw new LIMSRuntimeException("Error in TestAnalyte getTestAnalyteById()", e); } return newTestAnalyte; } public List getAllTestAnalytesPerTest(Test test) throws LIMSRuntimeException { //bugzilla 2203 minor mods - does this fix the error? //more likely that data fix in 2223 fixed it - can no longer reproduce List list = new Vector(); if (test == null || StringUtil.isNullorNill(test.getId())) return list; try { String sql = "from TestAnalyte t where t.test = :testId order by t.sortOrder asc"; org.hibernate.Query query = HibernateUtil.getSession().createQuery(sql); query.setInteger("testId", Integer.parseInt(test.getId())); list = query.list(); HibernateUtil.getSession().flush(); HibernateUtil.getSession().clear(); } catch (Exception e) { //bugzilla 2154 LogEvent.logError("TestAnalyteDAOImpl", "getAllTestAnalytesPerTest()", e.toString()); throw new LIMSRuntimeException("Error in TestAnalyte getAllTestAnalytesPerTest()", e); } return list; } }