package com.fgkj.dao.impl;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
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.App_Param;

public class App_ParamImpl implements BaseDAO,CallBack{

	public List getResults(ResultSet rs) {
		List list=new ArrayList();
		try {
			while(rs.next()){
				App_Param param=new App_Param();
				param.setNum(rs.getInt("num"));
				param.setParam_name(rs.getString("param_name"));
				param.setParam_value(rs.getFloat("param_value"));
				param.setParam_caption(rs.getString("param_caption"));
				
				list.add(param);
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return list;
	}

	public boolean add(Object obj) {
		// TODO Auto-generated method stub
		return false;
	}
    //修改参数
	public boolean update(Object obj) {
		App_Param param=(App_Param) obj;
		String sql="update db_param.tb_app_param set param_value=? where num=? ";
		Boolean bl=DAOHelper.executeUpdate(DBUtil.getConn(), sql, new Object[]{param.getNum()});
		return bl;
	}

	//修改参数
	public String updatePro(Object obj) {
		App_Param param=(App_Param) obj;
		String sql="update db_param.tb_app_param set param_value="+param.getParam_value()+" where num="+param.getNum();
		return sql;
	}
	
	public boolean del(Object obj) {
		// TODO Auto-generated method stub
		return false;
	}

	public List searchAll() {
		// TODO Auto-generated method stub
		return null;
	}
     
	public List serchByCondition(Object obj) {
		// TODO Auto-generated method stub
		return null;
	}
    //根据discharge/charge/poweroff查询
	public List serchByInfo(Object obj) {
		App_Param param=(App_Param) obj;
		String sql="select num,param_name,param_value,param_caption " +
				"from db_param.tb_app_param  where param_name like ? order by num " ;
		List list=DAOHelper.executeQuery(sql, DBUtil.getConn(), new Object[]{param.getParam_name()+"%"}, new App_ParamImpl());
		return list;
	}
    public static void main(String[] args) {
		App_ParamImpl pimpl=new App_ParamImpl();
		App_Param param=new App_Param();
		param.setParam_name("charge");
		List list=pimpl.serchByInfo(param);
		System.out.println(list.size());
	}
}