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.dto.Echarts_usr;

public class Echarts_usrImpl implements BaseDAO,CallBack{

	public List getResults(ResultSet rs) {
		// TODO Auto-generated method stub
		return null;
	}
    //添加或修改
	public boolean add(Object obj) {
		Echarts_usr echarts=(Echarts_usr) obj;
		String sql=" REPLACE into web_site.tb_echarts_usr(uid,echarts1_enable,echarts2_enable,echarts3_enable,echarts4_enable,echarts5_enable,echarts6_enable,echarts7_enable,echarts8_enable,echarts9_enable,echarts10_enable) " +
				   " VALUES(?,?,?,?,?,?,?,?,?,?,?)";
		boolean bl=DAOHelper.executeUpdate(DBUtil.getConn(), sql, new Object[]{echarts.getUid(),echarts.getEcharts1_enable(),echarts.getEcharts2_enable(),echarts.getEcharts3_enable(),echarts.getEcharts4_enable(),echarts.getEcharts5_enable()
			,echarts.getEcharts6_enable(),echarts.getEcharts7_enable(),echarts.getEcharts8_enable(),echarts.getEcharts9_enable(),echarts.getEcharts10_enable()});
		return bl;
	}

	public boolean update(Object obj) {
		// TODO Auto-generated method stub
		return false;
	}

	public boolean del(Object obj) {
		// TODO Auto-generated method stub
		return false;
	}
     
	public List searchAll() {
		// TODO Auto-generated method stub
		return null;
	}
    //根据用户id查询图标的使能
	public List serchByCondition(Object obj) {
		Echarts_usr echarts=(Echarts_usr) obj;
		String sql=" select distinct uid,echarts1_enable,echarts2_enable,echarts3_enable,echarts4_enable,echarts5_enable,echarts6_enable,echarts7_enable,echarts8_enable,echarts9_enable,echarts10_enable " +
				"    from web_site.tb_echarts_usr " +
				"    where uid=? ";
		List list=DAOHelper.executeQuery(sql, DBUtil.getConn(), new Object[]{echarts.getUid()}, new CallBack() {
			
			public List getResults(ResultSet rs) {
				List list=new ArrayList();
				try {
					while(rs.next()){
						Echarts_usr e=new Echarts_usr();
						e.setUid(rs.getInt("uid"));
						e.setEcharts1_enable(rs.getInt("echarts1_enable"));
						e.setEcharts2_enable(rs.getInt("echarts2_enable"));
						e.setEcharts3_enable(rs.getInt("echarts3_enable"));
						e.setEcharts4_enable(rs.getInt("echarts4_enable"));
						e.setEcharts5_enable(rs.getInt("echarts5_enable"));
						e.setEcharts6_enable(rs.getInt("echarts6_enable"));
						e.setEcharts7_enable(rs.getInt("echarts7_enable"));
						e.setEcharts8_enable(rs.getInt("echarts8_enable"));
						e.setEcharts9_enable(rs.getInt("echarts9_enable"));
						e.setEcharts10_enable(rs.getInt("echarts10_enable"));
						list.add(e);
					}
				} catch (SQLException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}
				return list;
			}
		});
		return list;
	}

	public List serchByInfo(Object obj) {
		// TODO Auto-generated method stub
		return null;
	}
    public static void main(String[] args) {
		 Echarts_usrImpl eimpl=new Echarts_usrImpl();
		 Echarts_usr e=new Echarts_usr();
		 e.setUid(1002);
		 e.setEcharts1_enable(0);
		 e.setEcharts2_enable(0);
		 e.setEcharts3_enable(0);
		 e.setEcharts4_enable(0);
		 e.setEcharts5_enable(0);
		 e.setEcharts6_enable(0);
		 e.setEcharts7_enable(0);
		 e.setEcharts8_enable(0);
		 e.setEcharts9_enable(0);
		 e.setEcharts10_enable(0);
		 /*List list=eimpl.serchByCondition(e);
		 System.out.println(list.size());*/
		 boolean bl=eimpl.add(e);
		 System.out.println(bl);
	}
}