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

public class Positiomap_usrImpl implements BaseDAO,CallBack{

	public List getResults(ResultSet rs) {
		// TODO Auto-generated method stub
		return null;
	}
    //使用replace into实现添加数据
	public boolean add(Object obj) {
		Positiomap_usr pusr=(Positiomap_usr) obj;
		String sql="REPLACE INTO web_site.tb_positiomap_usr(map_longitude,map_latitude,map_level,uid) VALUES (?,?,?,?);";
		boolean bl=DAOHelper.executeUpdate(DBUtil.getConn(), sql, new Object[]{pusr.getMap_longitude(),pusr.getMap_latitude(),pusr.getMap_level(),pusr.getUid()});
		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;
	}
    //根据用户查询地图对应的中心坐标
	public List serchByCondition(Object obj) {
		User_inf uinf=(User_inf) obj;
		String sql=" select distinct num,map_longitude,map_latitude,map_level,uid,note " +
				   " from web_site.tb_positiomap_usr " +
				   " where uid=?  ";
		List list=DAOHelper.executeQuery(sql, DBUtil.getConn(), new Object[]{uinf.getUId()}, new CallBack() {
			
			public List getResults(ResultSet rs) {
				List list=new ArrayList();
				try {
					while(rs.next()){
						Positiomap_usr pusr=new Positiomap_usr();
						pusr.setNum(rs.getInt("num"));
						pusr.setMap_longitude(rs.getFloat("map_longitude"));
						pusr.setMap_latitude(rs.getFloat("map_latitude"));
						pusr.setMap_level(rs.getInt("map_level"));
						pusr.setUid(rs.getInt("uid"));
						pusr.setNote(rs.getString("note"));
						list.add(pusr);
					}
				} 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) {
		 Positiomap_usr pusr=new Positiomap_usr();
		 pusr.setMap_latitude((float) 111.11);
		 pusr.setMap_longitude((float) 33.55);
		 pusr.setUid(1001);
		 pusr.setMap_level(13);
		 Positiomap_usrImpl pimpl=new Positiomap_usrImpl();
		 boolean bl=pimpl.add(pusr);
		 System.out.println(bl);
	}
}