proservicejdbcimpl.java

医院化验单系统

package com.asnk120.EMH.model.servicejdbcimpl;

import java.sql.Connection;

import com.asnk120.EMH.model.entity.Pro;
import com.asnk120.EMH.model.service.ProService;
import com.asnk120.EMH.persist.JdbcUtil;
import com.asnk120.EMH.persist.DAO.ProDAO;
import com.asnk120.EMH.persist.DAOFactory.ProDAOFactory;

public class ProServiceJdbcImpl implements ProService {
	private ProDAO dao = ProDAOFactory.getDAO();

	public void addPro(Pro pro) {
		// TODO Auto-generated method stub

	}

	public String[] findAllProNames() {
		// TODO Auto-generated method stub
		Connection con = null;
		String[] allProNames = null;
		try {
			con = JdbcUtil.getConnection();
			allProNames = dao.findAllNames(con);
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} finally {
			JdbcUtil.release(con);
		}
		return allProNames;
	}

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

	public int findProId(String proName) {
		// TODO Auto-generated method stub
		Connection con = null;
		int id = -1;// 这个数是个假数，根本不存在这中情况的，除非proNameList中没有东西才有可能出异常
		try {
			con = JdbcUtil.getConnection();
			id = dao.findIdByName(proName, con);
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} finally {
			JdbcUtil.release(con);
		}
		return id;
	}

	public int getLast3Number(String proName) {
		// TODO Auto-generated method stub
		Connection con = null;
		int lastNumber = 0;// 这个数是个假数，根本不存在这中情况的，除非proNameList中没有东西才有可能出异常
		try {
			con = JdbcUtil.getConnection();
			lastNumber = dao.countRecords(proName, con);
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} finally {
			JdbcUtil.release(con);
		}
		return lastNumber;
	}

}