修改首页地图上机房的经纬度

星伟

2018-09-26 e96ae5524e6fda4922f9da4ab5fea887eaf25e6e

修改首页地图上机房的经纬度

 gx_tieta/src/com/fgkj/dao/impl/BattMap_informationImpl.java

@@ -130,7 +130,7 @@
    //9.1查询已经添加物理信息的机房(用户管理的)

    public List serchInBattMapByUid(Object obj) {

        User_inf uinf=(User_inf) obj;

        String sql="select tb_battmap_information.num,tb_battmap_information.StationId,tb_battmap_information.StationName,address,longitude,latitude,information,db_battinf.tb_battinf.FBSDeviceId  " +

        String sql="select distinct tb_battmap_information.num,tb_battmap_information.StationId,tb_battmap_information.StationName,address,longitude,latitude,information,db_battinf.tb_battinf.FBSDeviceId  " +

                "  from web_site.tb_battmap_information,db_battinf.tb_battinf " +

                "  where  tb_battmap_information.StationId=db_battinf.tb_battinf.StationId " +

                "  and tb_battmap_information.StationId in (" +


 gx_tieta/src/com/fgkj/dao/impl/Batt_enduranceImpl.java

@@ -1,10 +1,16 @@
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.Batt_endurance;

import com.mysql.fabric.xmlrpc.base.Array;



public class Batt_enduranceImpl implements BaseDAO,CallBack{



@@ -34,8 +40,58 @@
    }

    //续航时间的查询

    public List serchByCondition(Object obj) {

		
        return null;

        Batt_endurance bendurance=(Batt_endurance) obj;

        String sql="select distinct num,deviceid,tb_batt_endurance.stationid,endurance_state,real_cap,tb_batt_endurance.moncapstd,real_curr,endurance_timelong " +

                ",db_battinf.tb_battinf.StationName " +

                " from web_site.tb_batt_endurance,db_battinf.tb_battinf " +

                " where tb_batt_endurance.stationid=db_battinf.tb_battinf.stationid " ;

        //机房筛选

        String stationSql=" and tb_batt_endurance.stationid like ?";

        sql+=stationSql;

        //续航状态

        String enduranceSqlT=" and endurance_state=? ";

        String enduranceSqlF=" and endurance_state!=? ";//全部

        if(bendurance.getEndurance_state()==0){

            sql+=enduranceSqlF;

        }else{

            sql+=enduranceSqlT;

        }

        //续航时间

        String timelongSqlT=" and endurance_timelong<=? ";//小于某一时间

        String timelongSqlF=" and endurance_timelong!=?";//全部

        if(bendurance.getEndurance_timelong()==0){

            sql+=timelongSqlF;

        }else{

            sql+=timelongSqlT;

        }

        //排序时间

        String orderSql=" order by endurance_timelong asc";

        List list=DAOHelper.executeQuery(sql, DBUtil.getConn(), new Object[]{"%"+bendurance.getStationid()+"%",bendurance.getEndurance_state(),bendurance.getEndurance_timelong()}, new CallBack() {

			
            public List getResults(ResultSet rs) {

                List list=new ArrayList();

                try {

                    while(rs.next()){

                        Batt_endurance b=new Batt_endurance();

                        b.setNum(rs.getInt("num"));

                        b.setDeviceId(rs.getInt("deviceId"));

                        b.setStationid(rs.getString("stationid"));

                        b.setEndurance_state(rs.getInt("endurance_state"));

                        b.setReal_cap(rs.getFloat("real_cap"));

                        b.setMoncapstd(rs.getFloat("moncapstd"));

                        b.setReal_curr(rs.getFloat("real_curr"));

                        b.setEndurance_timelong(rs.getInt("endurance_timelong"));

                        b.setNote(rs.getString("stationname"));

                        list.add(b);

                    }

                } catch (SQLException e) {

                    // TODO Auto-generated catch block

                    e.printStackTrace();

                }

                return list;

            }

        });

        return list;

    }



    public List serchByInfo(Object obj) {


 gx_tieta/src/com/fgkj/dto/Batt_endurance.java

@@ -11,6 +11,7 @@
    private float moncapstd;

    private float real_curr;

    private int endurance_timelong;

    private String note;

    public int getNum() {

        return num;

    }

@@ -59,15 +60,23 @@
    public void setEndurance_timelong(int endurance_timelong) {

        this.endurance_timelong = endurance_timelong;

    }

    public String getNote() {

        return note;

    }

    public void setNote(String note) {

        this.note = note;

    }

    @Override

    public String toString() {

        return "Batt_endurance [num=" + num + ", deviceId=" + deviceId

                + ", stationid=" + stationid + ", endurance_state="

                + endurance_state + ", real_cap=" + real_cap + ", moncapstd="

                + moncapstd + ", real_curr=" + real_curr

                + ", endurance_timelong=" + endurance_timelong + "]";

                + ", endurance_timelong=" + endurance_timelong + ", note="

                + note + "]";

    }

    

    

	


}