From 20fdc04c03983a07cc91015d37eb453720f972b7 Mon Sep 17 00:00:00 2001
From: 81041 <81041@192.168.10.28>
Date: 星期三, 24 十月 2018 09:39:15 +0800
Subject: [PATCH] 饼状图管理
---
gx_tieta/src/com/fgkj/services/Echarts_usrService.java | 43 +++++++
gx_tieta/src/com/fgkj/dao/BaseDAO.java | 2
gx_tieta/src/com/fgkj/dao/impl/Echarts_usrImpl.java | 103 +++++++++++++++++
gx_tieta/src/com/fgkj/actions/Echarts_usrAction.java | 39 ++++++
gx_tieta/src/com/fgkj/dto/Echarts_usr.java | 139 +++++++++++++++++++++++
gx_tieta/src/com/fgkj/dao/BaseDAOFactory.java | 2
6 files changed, 328 insertions(+), 0 deletions(-)
diff --git a/gx_tieta/src/com/fgkj/actions/Echarts_usrAction.java b/gx_tieta/src/com/fgkj/actions/Echarts_usrAction.java
new file mode 100644
index 0000000..3fe1fb4
--- /dev/null
+++ b/gx_tieta/src/com/fgkj/actions/Echarts_usrAction.java
@@ -0,0 +1,39 @@
+package com.fgkj.actions;
+
+import com.fgkj.dto.Echarts_usr;
+import com.fgkj.dto.ServiceModel;
+import com.fgkj.dto.User_inf;
+import com.fgkj.services.Echarts_usrService;
+
+public class Echarts_usrAction extends ActionUtil{
+ private Echarts_usrService service = new Echarts_usrService();
+ private String result;
+ private String json;
+ //娣诲姞鎴栦慨鏀�
+ public String add() {
+ Echarts_usr echarts = getGson().fromJson(json, Echarts_usr.class);
+ User_inf uinf=(User_inf) getUser();
+ echarts.setUid(uinf.getUId());
+ ServiceModel model = service.add(echarts);
+ result = tojson(model);
+ return SUCCESS;
+ }
+ //鏍规嵁鐢ㄦ埛id鏌ヨ鍥炬爣鐨勪娇鑳�
+ public String serchByCondition() {
+ Echarts_usr echarts = new Echarts_usr();
+ User_inf uinf=(User_inf) getUser();
+ echarts.setUid(uinf.getUId());
+ ServiceModel model = service.serchByCondition(echarts);
+ result = tojson(model);
+ return SUCCESS;
+ }
+
+ public String getResult() {
+ return result;
+ }
+ public void setJson(String json) {
+ this.json = json;
+ }
+
+
+}
diff --git a/gx_tieta/src/com/fgkj/dao/BaseDAO.java b/gx_tieta/src/com/fgkj/dao/BaseDAO.java
index 6fc6937..812d302 100644
--- a/gx_tieta/src/com/fgkj/dao/BaseDAO.java
+++ b/gx_tieta/src/com/fgkj/dao/BaseDAO.java
@@ -186,6 +186,8 @@
public static final int BTS_STATION_EVENT=91;
+ public static final int ECHARTS_USR=92;
+
public boolean add(Object obj); // 娣诲姞
public boolean update(Object obj); // 鏇存柊
diff --git a/gx_tieta/src/com/fgkj/dao/BaseDAOFactory.java b/gx_tieta/src/com/fgkj/dao/BaseDAOFactory.java
index aec31e6..e742d57 100644
--- a/gx_tieta/src/com/fgkj/dao/BaseDAOFactory.java
+++ b/gx_tieta/src/com/fgkj/dao/BaseDAOFactory.java
@@ -43,6 +43,7 @@
import com.fgkj.dao.impl.Database_backupImpl;
import com.fgkj.dao.impl.Dev_paramImpl;
import com.fgkj.dao.impl.Devstate_usrImpl;
+import com.fgkj.dao.impl.Echarts_usrImpl;
import com.fgkj.dao.impl.Fbsdev_Statechange_infImpl;
import com.fgkj.dao.impl.MapImpl;
import com.fgkj.dao.impl.Positiomap_usrImpl;
@@ -192,6 +193,7 @@
case 89:return new Bts_station_stateImpl();
case 90:return new Fbs9100s_dfu_stateImpl();
case 91:return new Bts_station_eventImpl();
+ case 92:return new Echarts_usrImpl();
default :return null;
}
}
diff --git a/gx_tieta/src/com/fgkj/dao/impl/Echarts_usrImpl.java b/gx_tieta/src/com/fgkj/dao/impl/Echarts_usrImpl.java
new file mode 100644
index 0000000..d488205
--- /dev/null
+++ b/gx_tieta/src/com/fgkj/dao/impl/Echarts_usrImpl.java
@@ -0,0 +1,103 @@
+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);
+ }
+}
diff --git a/gx_tieta/src/com/fgkj/dto/Echarts_usr.java b/gx_tieta/src/com/fgkj/dto/Echarts_usr.java
new file mode 100644
index 0000000..6a30ab4
--- /dev/null
+++ b/gx_tieta/src/com/fgkj/dto/Echarts_usr.java
@@ -0,0 +1,139 @@
+package com.fgkj.dto;
+
+import java.io.Serializable;
+
+public class Echarts_usr implements Serializable {
+ private int num;
+ private int uid;
+ private int echarts1_enable;
+ private int echarts2_enable;
+ private int echarts3_enable;
+ private int echarts4_enable;
+ private int echarts5_enable;
+ private int echarts6_enable;
+ private int echarts7_enable;
+ private int echarts8_enable;
+ private int echarts9_enable;
+ private int echarts10_enable;
+ private String note;
+
+ public int getNum() {
+ return num;
+ }
+
+ public void setNum(int num) {
+ this.num = num;
+ }
+
+ public int getUid() {
+ return uid;
+ }
+
+ public void setUid(int uid) {
+ this.uid = uid;
+ }
+
+ public int getEcharts1_enable() {
+ return echarts1_enable;
+ }
+
+ public void setEcharts1_enable(int echarts1_enable) {
+ this.echarts1_enable = echarts1_enable;
+ }
+
+ public int getEcharts2_enable() {
+ return echarts2_enable;
+ }
+
+ public void setEcharts2_enable(int echarts2_enable) {
+ this.echarts2_enable = echarts2_enable;
+ }
+
+ public int getEcharts3_enable() {
+ return echarts3_enable;
+ }
+
+ public void setEcharts3_enable(int echarts3_enable) {
+ this.echarts3_enable = echarts3_enable;
+ }
+
+ public int getEcharts4_enable() {
+ return echarts4_enable;
+ }
+
+ public void setEcharts4_enable(int echarts4_enable) {
+ this.echarts4_enable = echarts4_enable;
+ }
+
+ public int getEcharts5_enable() {
+ return echarts5_enable;
+ }
+
+ public void setEcharts5_enable(int echarts5_enable) {
+ this.echarts5_enable = echarts5_enable;
+ }
+
+ public int getEcharts6_enable() {
+ return echarts6_enable;
+ }
+
+ public void setEcharts6_enable(int echarts6_enable) {
+ this.echarts6_enable = echarts6_enable;
+ }
+
+ public int getEcharts7_enable() {
+ return echarts7_enable;
+ }
+
+ public void setEcharts7_enable(int echarts7_enable) {
+ this.echarts7_enable = echarts7_enable;
+ }
+
+ public int getEcharts8_enable() {
+ return echarts8_enable;
+ }
+
+ public void setEcharts8_enable(int echarts8_enable) {
+ this.echarts8_enable = echarts8_enable;
+ }
+
+ public int getEcharts9_enable() {
+ return echarts9_enable;
+ }
+
+ public void setEcharts9_enable(int echarts9_enable) {
+ this.echarts9_enable = echarts9_enable;
+ }
+
+ public int getEcharts10_enable() {
+ return echarts10_enable;
+ }
+
+ public void setEcharts10_enable(int echarts10_enable) {
+ this.echarts10_enable = echarts10_enable;
+ }
+
+ public String getNote() {
+ return note;
+ }
+
+ public void setNote(String note) {
+ this.note = note;
+ }
+
+ @Override
+ public String toString() {
+ return "Echarts_usr [num=" + num + ", uid=" + uid
+ + ", echarts1_enable=" + echarts1_enable + ", echarts2_enable="
+ + echarts2_enable + ", echarts3_enable=" + echarts3_enable
+ + ", echarts4_enable=" + echarts4_enable + ", echarts5_enable="
+ + echarts5_enable + ", echarts6_enable=" + echarts6_enable
+ + ", echarts7_enable=" + echarts7_enable + ", echarts8_enable="
+ + echarts8_enable + ", echarts9_enable=" + echarts9_enable
+ + ", echarts10_enable=" + echarts10_enable + ", note=" + note
+ + "]";
+ }
+
+
+
+}
diff --git a/gx_tieta/src/com/fgkj/services/Echarts_usrService.java b/gx_tieta/src/com/fgkj/services/Echarts_usrService.java
new file mode 100644
index 0000000..518055e
--- /dev/null
+++ b/gx_tieta/src/com/fgkj/services/Echarts_usrService.java
@@ -0,0 +1,43 @@
+package com.fgkj.services;
+
+import java.util.List;
+
+import com.fgkj.dao.BaseDAO;
+import com.fgkj.dao.BaseDAOFactory;
+import com.fgkj.dto.ServiceModel;
+
+public class Echarts_usrService {
+ private BaseDAO dao;
+ private ServiceModel model;
+
+ public Echarts_usrService() {
+ super();
+ dao=BaseDAOFactory.getBaseDAO(BaseDAO.ECHARTS_USR);
+ }
+ //娣诲姞鎴栦慨鏀�
+ public ServiceModel add(Object obj) {
+ Boolean bl = dao.add(obj);
+ if (bl) {
+ model.setCode(1);
+ model.setMsg("娣诲姞鎴愬姛!");
+ } else {
+ model.setMsg("娣诲姞澶辫触!");
+ }
+ return model;
+
+ }
+ //鏍规嵁鐢ㄦ埛id鏌ヨ鍥炬爣鐨勪娇鑳�
+ public ServiceModel serchByCondition(Object obj){
+ List list=dao.serchByCondition(obj);
+ if(list!=null && list.size()>0){
+ model.setCode(1);
+ model.setMsg("鏌ヨ鎴愬姛!");
+ model.setData(list);
+ }else{
+ model.setCode(0);
+ model.setMsg("鏌ヨ澶辫触!");
+ }
+ return model;
+ }
+
+}
--
Gitblit v1.9.1