package com.fgkj.dao.impl.ram;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.text.ParseException;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

import com.fgkj.dao.BaseDAO;
import com.fgkj.dao.CallBack;
import com.fgkj.dao.DAOHelper;
import com.fgkj.db.DBUtil;
import com.fgkj.db.IDatabaseName;
import com.fgkj.dto.ram.Hard_dev_sms_state;
import com.fgkj.dto.ram.Server_state;

public class Server_stateImpl implements BaseDAO,CallBack{

	public List getResults(ResultSet rs) {
		List list=new ArrayList();
		try {
			while(rs.next()){
				Server_state sstate=new Server_state();
				sstate.setNum(rs.getInt("num"));
				sstate.setServer_version(rs.getFloat("server_version"));
				sstate.setServer_datetime(rs.getTimestamp("server_datetime"));
				sstate.setMax_mem(rs.getLong("max_mem"));
				sstate.setTotal_mem(rs.getLong("total_mem"));
				sstate.setFree_men(rs.getLong("free_men"));
				sstate.setTotal_disc_space(rs.getLong("total_disc_space"));
				sstate.setFree_disc_space(rs.getLong("free_disc_space"));
				sstate.setDb_conn_max(rs.getInt("db_conn_max"));
				sstate.setDb_conn_count(rs.getInt("db_conn_count"));
				
				sstate.setApp_conn_max(rs.getInt("app_conn_max"));
				sstate.setApp_busy_conn_cnt(rs.getInt("app_busy_conn_cnt"));
				sstate.setApp_idle_conn_cnt(rs.getInt("app_idle_conn_cnt"));
				sstate.setServer_cpu_rate(rs.getFloat("server_cpu_rate"));
				sstate.setServer_network_rate(rs.getFloat("server_network_rate"));
				
				sstate.setNote(DAOHelper.sdf.format(new Date()));
				list.add(sstate);
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} 
		return list;
	}

	public boolean add(Object obj) {
		Server_state ss=(Server_state) obj;
		String sql="insert into db_ram_db.tb_server_state(server_version,server_datetime,max_mem,total_mem," +
				"free_men,total_disc_space,free_disc_space,db_conn_max,db_conn_count) values(?,?,?,?,?,?,?,?,?)";
		Boolean bl=DAOHelper.executeUpdate(DBUtil.getConn(), sql, new Object[]{ss.getServer_version(),ss.getServer_datetime(),
			ss.getMax_mem(),ss.getTotal_mem(),ss.getFree_men(),ss.getTotal_disc_space(),ss.getFree_disc_space(),ss.getDb_conn_max(),
			ss.getDb_conn_count()});
		return bl;
	}

	public boolean update(Object obj) {
		Server_state ss=(Server_state) obj;
		String sql="update db_ram_db.tb_server_state set server_version=?,server_datetime=?,max_mem=?,total_mem=?," +
				"free_men=?,total_disc_space=?,free_disc_space=?,db_conn_max=?,db_conn_count=? where num=?";
		Boolean bl=DAOHelper.executeUpdate(DBUtil.getConn(), sql, new Object[]{ss.getServer_version(),ss.getServer_datetime(),
			ss.getMax_mem(),ss.getTotal_mem(),ss.getFree_men(),ss.getTotal_disc_space(),ss.getFree_disc_space(),ss.getDb_conn_max(),
			ss.getDb_conn_count(),ss.getNum()});
		return bl;
	}

	public boolean del(Object obj) {
		Server_state ss=(Server_state) obj;
		String sql="delete from db_ram_db.tb_server_state where num=?";
		Boolean bl=DAOHelper.executeUpdate(DBUtil.getConn(), sql, new Object[]{ss.getNum()});
		return bl;
	}
    //查询系统的cpu,内存使用率
	public List searchAll() {
		String sql="select num,server_version,server_datetime,max_mem,total_mem,free_men,total_disc_space,free_disc_space,db_conn_max,db_conn_count"
				+ ",app_conn_max,app_busy_conn_cnt,app_idle_conn_cnt,server_cpu_rate,server_network_rate from db_ram_db.tb_server_state";
		List list=DAOHelper.executeQuery(sql, DBUtil.getConn(), null, new Server_stateImpl());
		return list;
	}

	public List serchByCondition(Object obj) {
		Server_state ss=(Server_state) obj;
		String sql="select * from db_ram_db.tb_server_state where num=?";
		List list=DAOHelper.executeQuery(sql, DBUtil.getConn(), new Object[]{ss.getNum()}, new Server_stateImpl());
		return list;
	}

	public List serchByInfo(Object obj) {
		// TODO Auto-generated method stub
		return null;
	}
	public static void main(String[] args) {
		Server_stateImpl si=new Server_stateImpl();
		Server_state ss=new Server_state();
		ss.setNum(1);
		//List<Server_state> list=si.serchByCondition(ss);
		
		List<Server_state> list=si.searchAll();
		System.out.println(list.size());
		for(Server_state h:list){
			System.out.println(h);
		}
	}

}