prservicejdbcimpl.java

医院化验单系统

package com.asnk120.EMH.model.servicejdbcimpl;

import java.sql.Connection;
import java.sql.SQLException;

import com.asnk120.EMH.model.entity.PR;
import com.asnk120.EMH.model.service.PRService;
import com.asnk120.EMH.persist.JdbcUtil;
import com.asnk120.EMH.persist.DAO.PRDAO;
import com.asnk120.EMH.persist.DAOFactory.PRDAOFactory;

public class PRServiceJdbcImpl implements PRService {
	private PRDAO dao = PRDAOFactory.getDAO();

	public void createPp(PR pp) {
		// TODO Auto-generated method stub
		Connection con = null;
		try {
			con = JdbcUtil.getConnection();
			con.setAutoCommit(false);
			dao.createTable(pp, con);
			con.commit();
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			try {
				con.rollback();
			} catch (SQLException e1) {
				// TODO Auto-generated catch block
				e1.printStackTrace();
			}
		} finally {
			JdbcUtil.release(con);
		}
	}

	public PR findPpByName(String proName) {
		// TODO Auto-generated method stub
		PR pp = null;
		Connection con = null;
		try {
			con = JdbcUtil.getConnection();
			pp = dao.findPpByName(proName, con);
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} finally {
			JdbcUtil.release(con);
		}
		return pp;
	}
}