| | |
|---|
| | | boolean bl=DAOHelper.executeUpdate(DBUtil.getConn(), sql, null);
|
|---|
| | | return bl;
|
|---|
| | | }
|
|---|
| | | |
|---|
| | | //设置电池组充电电流阈值
|
|---|
| | | public boolean update_charge(Object obj){
|
|---|
| | | BattInf binf=(BattInf) obj;
|
|---|
| | | String sql = "update db_battinf.tb_battinf set charge_curr_max=? where BattGroupId=?";
|
|---|
| | | boolean bl=DAOHelper.executeUpdate(DBUtil.getConn(), sql, new Object[]{binf.getCharge_curr_max(),binf.getBattGroupId()});
|
|---|
| | | return bl;
|
|---|
| | | }
|
|---|
| | | //删除电池组(多个)
|
|---|
| | | public boolean del(Object obj) {
|
|---|
| | | List<BattInf> list=(List<BattInf>) obj;
|
|---|
| | |
|---|
| | | public int serchByDeviceId(Object obj){
|
|---|
| | | User_inf uinf=(User_inf) obj;
|
|---|
| | | String sql=" SELECT COUNT(DISTINCT fbsdeviceid) number FROM db_battinf.tb_battinf " +
|
|---|
| | | " left outer join db_user.tb_user_battgroup_baojigroup_battgroup on db_user.tb_user_battgroup_baojigroup_battgroup.BattGroupId=db_battinf.tb_battinf.BattGroupId " +
|
|---|
| | | " left outer join db_user.tb_user_battgroup_baojigroup_usr on db_user.tb_user_battgroup_baojigroup_usr.baoji_group_id=db_user.tb_user_battgroup_baojigroup_battgroup.baoji_group_id " +
|
|---|
| | | " left outer join db_user.tb_user_inf on tb_user_inf.uid=db_user.tb_user_battgroup_baojigroup_usr.uid " +
|
|---|
| | | " where db_user.tb_user_inf.uid=? and db_battinf.tb_battinf.Station_install=1 " +
|
|---|
| | | " limit 1";
|
|---|
| | | " where StationId in(" +
|
|---|
| | | " select distinct db_user.tb_user_battgroup_baojigroup_battgroup.StationId from db_user.tb_user_battgroup_baojigroup_battgroup,db_user.tb_user_battgroup_baojigroup_usr where db_user.tb_user_battgroup_baojigroup_battgroup.baoji_group_id=db_user.tb_user_battgroup_baojigroup_usr.baoji_group_id " +
|
|---|
| | | " and db_user.tb_user_battgroup_baojigroup_usr.uId=? " +
|
|---|
| | | " ) " +
|
|---|
| | | " and db_battinf.tb_battinf.station_install=1";
|
|---|
| | | List<BattInf> list=DAOHelper.executeQuery(sql, DBUtil.getConn(), new Object[]{uinf.getUId()}, new CallBack() {
|
|---|
| | |
|
|---|
| | | public List getResults(ResultSet rs) {
|
|---|
| | |
|---|
| | | " left outer join db_user.tb_user_battgroup_baojigroup_usr on db_user.tb_user_battgroup_baojigroup_usr.baoji_group_id=db_user.tb_user_battgroup_baojigroup_battgroup.baoji_group_id " +
|
|---|
| | | " left outer join db_user.tb_user_inf on tb_user_inf.uid=db_user.tb_user_battgroup_baojigroup_usr.uid " +
|
|---|
| | | " where db_user.tb_user_inf.uid=? " +
|
|---|
| | | " limit 1";
|
|---|
| | | " limit 1 ";
|
|---|
| | | List<BattInf> list=DAOHelper.executeQuery(sql, DBUtil.getConn(), new Object[]{uinf.getUId()}, new CallBack() {
|
|---|
| | |
|
|---|
| | | public List getResults(ResultSet rs) {
|
|---|
| | |
|---|
| | | " where db_user.tb_user_battgroup_baojigroup_battgroup.BattGroupId=db_battinf.tb_battinf.BattGroupId " +
|
|---|
| | | " and db_user.tb_user_battgroup_baojigroup_usr.baoji_group_id=db_user.tb_user_battgroup_baojigroup_battgroup.baoji_group_id " +
|
|---|
| | | " and db_user.tb_user_inf.uid=db_user.tb_user_battgroup_baojigroup_usr.uid " +
|
|---|
| | | " and db_user.tb_user_inf.uid=?" +
|
|---|
| | | " and db_user.tb_user_inf.uid=? and db_battinf.tb_battinf.Station_install=1 " +
|
|---|
| | | " limit 1";
|
|---|
| | | List list=DAOHelper.executeQuery(sql, DBUtil.getConn(), new Object[]{uinf.getUId()}, new CallBack() {
|
|---|
| | |
|
|---|
