onerecordservicejdbcimpl.java

医院化验单系统

package com.asnk120.EMH.model.servicejdbcimpl;

import java.sql.Connection;

import com.asnk120.EMH.model.entity.OneRecord;
import com.asnk120.EMH.model.service.OneRecordService;
import com.asnk120.EMH.persist.JdbcUtil;
import com.asnk120.EMH.persist.DAO.OneRecordDAO;
import com.asnk120.EMH.persist.DAOFactory.OneRecordDAOFactory;

public class OneRecordServiceJdbcImpl implements OneRecordService {
	private OneRecordDAO dao = OneRecordDAOFactory.getDAO();

	public void insertOneRecord(OneRecord or) {
		// TODO Auto-generated method stub
		Connection con = null;
		try {
			con = JdbcUtil.getConnection();
			dao.insertOneRecord(or, con);
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			//这就更不用设置con.rollback();了，默认的就是真诚模式的提交
		} finally {
			JdbcUtil.release(con);
		}
	}

	public OneRecord execQuery(String number) {
		// TODO Auto-generated method stub
		OneRecord or = null;
		Connection con = null;
		try {
			con = JdbcUtil.getConnection();
			or = dao.getOneRecord(number, con);
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			//这就更不用设置con.rollback();了，默认的就是真诚模式的提交
		} finally {
			JdbcUtil.release(con);
		}
		return or;
	}

}