userselfserviceimpl.java

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

package com.tarena.netctoss.model.biz;

import java.util.List;
import com.tarena.util.*;
import com.tarena.netctoss.model.persist.*;
import java.sql.*;

public class UserSelfServiceImpl implements IUserSelfService {

	public List findByDay(Long user_id, int year, int month) {
		Connection con = JDBCFactoryManager.getConnection();
		IUserSelfDAO dao = DAOFactory.getUserSelfDAO();
		List lists = null;
		try {
			con.setAutoCommit(false);
			lists = dao.findAllDay(user_id, 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 lists;
	}

	public List findByMonth(Long user_id, int year, int month) {
		Connection con = JDBCFactoryManager.getConnection();
		IUserSelfDAO dao = DAOFactory.getUserSelfDAO();
		List lists = null;
		try {
			con.setAutoCommit(false);
			lists = dao.findAllMonth(user_id, 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 lists;
	}
}