serverdetailserviceimpl.java

来自「电信计费项目 该系统在Sun Solaris下开发,运行于Apache Tom」· Java 代码 · 共 100 行

package com.tarena.netctoss.model.biz;

import java.util.List;
import java.sql.*;

import com.tarena.netctoss.model.persist.*;
import com.tarena.util.JDBCFactoryManager;

public class ServerDetailServiceImpl implements IServerDetailService {

	public List findAllByMonth(int year, int month) {
		Connection con = JDBCFactoryManager.getConnection();
		IServerDetailDAO dao = DAOFactory.getServerDetailDAO();
		List list = null;
		try {
			con.setAutoCommit(false);
			list = dao.findAllByMonth(year, month);
			con.commit();
		} catch (SQLException e) {
			e.printStackTrace();
			try {
				if(con!=null)
					con.rollback();
			} catch (SQLException e1) {
				e1.printStackTrace();
			}
		} finally{
			JDBCFactoryManager.release(con);
		}
		return list;
	}

	public List findAllByYear(int year) {
		Connection con = JDBCFactoryManager.getConnection();
		IServerDetailDAO dao = DAOFactory.getServerDetailDAO();
		List list = null;
		try {
			con.setAutoCommit(false);
			list = dao.findAllByYear(year);
			con.commit();
		} catch (SQLException e) {
			e.printStackTrace();
			try {
				if(con!=null)
					con.rollback();
			} catch (SQLException e1) {
				e1.printStackTrace();
			}
		} finally{
			JDBCFactoryManager.release(con);
		}
		return list;
	}

	public List findByMonth(int year, int month, String lab_ip) {
		Connection con = JDBCFactoryManager.getConnection();
		IServerDetailDAO dao = DAOFactory.getServerDetailDAO();
		List list = null;
		try {
			con.setAutoCommit(false);
			list = dao.findByMonth(year, month, lab_ip);
			con.commit();
		} catch (SQLException e) {
			e.printStackTrace();
			try {
				if(con!=null)
					con.rollback();
			} catch (SQLException e1) {
				e1.printStackTrace();
			}
		} finally{
			JDBCFactoryManager.release(con);
		}
		return list;
	}

	public List findByYear(int year, String lab_ip) {
		Connection con = JDBCFactoryManager.getConnection();
		IServerDetailDAO dao = DAOFactory.getServerDetailDAO();
		List list = null;
		try {
			con.setAutoCommit(false);
			list = dao.findByYear(year, lab_ip);
			con.commit();
		} catch (SQLException e) {
			e.printStackTrace();
			try {
				if(con!=null)
					con.rollback();
			} catch (SQLException e1) {
				e1.printStackTrace();
			}
		} finally{
			JDBCFactoryManager.release(con);
		}
		return list;
	}

}