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.Map;
import com.fgkj.dto.User_inf;

public class MapImpl implements BaseDAO,CallBack{

	public List getResults(ResultSet rs) {
		List list=new ArrayList();
		try {
			while(rs.next()){
				Map map=new Map();
				map.setNum(rs.getInt("num"));
				map.setUsr_id(rs.getInt("usr_id"));
				map.setMap_role(rs.getInt("map_role"));
				map.setMap(rs.getString("map"));
				map.setNote(rs.getString("note"));
				list.add(map);
			}
		} 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) {
		// 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;
	}

	//0.8根据uid查map信息
	public List serchByCondition(Object obj) {
		User_inf uinf=(User_inf) obj;
		String sql="select num,usr_id,map_role,map,note from web_site.tb_map where usr_id=? order by num";
		List list=DAOHelper.executeQuery(sql, DBUtil.getConn(), new Object[]{uinf.getUId()}, new MapImpl());
		return list;
	}

	public List serchByInfo(Object obj) {
		return null;
	}

}