serverdetaildaoimpl.java

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

package com.tarena.netctoss.model.persist;

import java.util.*;
import com.tarena.util.*;
import java.sql.*;
import com.tarena.netctoss.model.biz.entity.*;

public class ServerDetailDAOImpl implements IServerDetailDAO {

	@SuppressWarnings("unchecked")
	public List findAllByMonth(int year, int month) {
		List lists =new ArrayList();
		Connection con = JDBCFactoryManager.getConnection();
		Statement stmt = null;
		ResultSet rs = null;
		String sql = "select lab_ip,time_duration from t_monthwdd where to_char(logout_date,'YYYY-MM') ="
				+ "'"
				+ year
				+ (month < 10 ? "-0" : "-")
				+ month
				+ "'";
		try {
			stmt = con.createStatement();
			rs = stmt.executeQuery(sql);
			while(rs.next()){
				ServerDetailProcess detail = new ServerDetailProcess();
				detail.setLab_ip(rs.getString("lab_ip"));
				detail.setTime_duration(rs.getDouble("time_duration"));
				lists.add(detail);
			}
		} catch (SQLException e) {
			e.printStackTrace();
		} finally{
			JDBCFactoryManager.release(rs, stmt, null);
		}
		return lists;
	}

	@SuppressWarnings("unchecked")
	public List findAllByYear(int year) {
		List lists =new ArrayList();
		Connection con = JDBCFactoryManager.getConnection();
		Statement stmt = null;
		ResultSet rs = null;
		String sql = "select lab_ip,time_duration from t_yearwdd where to_char(logout_date,'YYYY') ="
				+ "'"
				+ year+ "'";
		try {
			stmt = con.createStatement();
			rs = stmt.executeQuery(sql);
			while(rs.next()){
				ServerDetailProcess detail = new ServerDetailProcess();
				detail.setLab_ip(rs.getString("lab_ip"));
				detail.setTime_duration(rs.getDouble("time_duration"));
				lists.add(detail);
			}
		} catch (SQLException e) {
			e.printStackTrace();
		} finally{
			JDBCFactoryManager.release(rs, stmt, null);
		}
		return lists;
	}

	@SuppressWarnings("unchecked")
	public List findByMonth(int year, int month, String lab_ip) {
		List lists =new ArrayList();
		Connection con = JDBCFactoryManager.getConnection();
		PreparedStatement ps = null;
		ResultSet rs = null;
		String sql = "select lab_ip,time_duration from t_daywdd where to_char(logout_date,'YYYY-MM') ="
				+ "'"
				+ year
				+ (month < 10 ? "-0" : "-")
				+ month
				+ "' and lab_ip=?";
		try {
			ps = con.prepareStatement(sql);
			ps.setString(1, lab_ip);
			rs = ps.executeQuery();
			while(rs.next()){
				ServerDetailProcess detail = new ServerDetailProcess();
				detail.setLab_ip(rs.getString("lab_ip"));
				detail.setTime_duration(rs.getDouble("time_duration"));
				lists.add(detail);
			}
		} catch (SQLException e) {
			e.printStackTrace();
		} finally{
			JDBCFactoryManager.release(rs, ps, null);
		}
		return lists;
	}

	@SuppressWarnings("unchecked")
	public List findByYear(int year, String lab_ip) {
		List lists =new ArrayList();
		Connection con = JDBCFactoryManager.getConnection();
		PreparedStatement ps = null;
		ResultSet rs = null;
		String sql = "select lab_ip,time_duration from t_monthwdd where to_char(logout_date,'YYYY') ="
				+ "'"
				+ year+ "' and lab_ip=?";
		try {
			ps =con.prepareStatement(sql);
			ps.setString(1, lab_ip);
			rs = ps.executeQuery();
			while(rs.next()){
				ServerDetailProcess detail = new ServerDetailProcess();
				detail.setLab_ip(rs.getString("lab_ip"));
				detail.setTime_duration(rs.getDouble("time_duration"));
				lists.add(detail);
			}
		} catch (SQLException e) {
			e.printStackTrace();
		} finally{
			JDBCFactoryManager.release(rs, ps, null);
		}
		return lists;
	}
}