~whyclj/BattMonitor_DB_Builder.git

New file
			@@ -0,0 +1,146 @@
			package com.database_util;

			import java.sql.ResultSet;
			import java.sql.SQLException;

			import com.sql.MysqlConnPool;
			import com.sql.Sql_Mysql;


			public class DB_Dev_TestParam {
			public static void init(MysqlConnPool pool, boolean recreate) {

			createDB_Dev_TESTPARAM(pool);

			createBatt_TestParam_Table(pool, recreate); //创建设备历史参数表用于存储次放电前的放电参数



			}

			/**
			* 创建 db_dev_testparam 数据库
			* @param pool
			*/
			public static void createDB_Dev_TESTPARAM(MysqlConnPool pool) {
			Sql_Mysql sql = new Sql_Mysql(pool.getConn());
			try {
			sql.sqlMysqlExecute("CREATE DATABASE IF NOT EXISTS " + Sql_Mysql.DB_DEV_TESTPARAM);
			} catch (SQLException e) {
			e.printStackTrace();
			} finally {
			sql.close_con();
			}
			}


			/**
			* 创建 `db_dev_testparam`.`tb_batt_testparam_` 表
			* @param pool
			* @param recreate
			*/
			public static void createBatt_TestParam_Table(MysqlConnPool pool, boolean recreate) {
			String sql_str_sel = " SELECT FBSDeviceId,BattGroupId " +
			" FROM " + Sql_Mysql.BattInf_Table +
			" WHERE (FLOOR(FBSDeviceId/100000)=8059) " + //充放电一体机
			" OR (FLOOR(FBSDeviceId/10000000)=91) " + //BTS
			" OR ((FLOOR(FBSDeviceId/100000)=6185)) "; //61850
			Sql_Mysql sql = new Sql_Mysql(pool.getConn());
			ResultSet res = null;
			try {
			res = sql.sqlMysqlQuery(sql_str_sel);
			while(res.next()) {
			int battgroupid = res.getInt("BattGroupId");
			if(!sql.sqlMysqlCheckIfTableExist(Sql_Mysql.Batt_TestParam_Table + battgroupid)) {
			sql.sqlMysqlExecute(" CREATE TABLE IF NOT EXISTS " + Sql_Mysql.Batt_TestParam_Table + battgroupid + " (" +
			" `num` bigint(20) NOT NULL AUTO_INCREMENT," +
			" `record_time` datetime NOT NULL DEFAULT '2000-01-01 00:00:00' COMMENT '参数更新时间'," +
			" `BattGroupId` int(11) NOT NULL DEFAULT '1' COMMENT '电池组ID'," +
			" `test_record_count` int(11) NOT NULL DEFAULT '1' COMMENT '电池组放电次数对应db_batt_testdata.tb_batttestdata_inf'," +
			" `op_cmd` int(11) NOT NULL DEFAULT '0'," +
			" `TestCmd` int(11) NOT NULL DEFAULT '0' COMMENT '测试类型'," +
			" `HourRate` int(11) NOT NULL DEFAULT '0' COMMENT '放电小时率'," +
			" `DisCurr` float NOT NULL DEFAULT '0' COMMENT '放电电流(A)'," +
			" `DisCap` float NOT NULL DEFAULT '0' COMMENT '放电容量(AH)'," +
			" `DisTime` int(11) NOT NULL DEFAULT '0' COMMENT '放电时长(分钟)'," +
			" `GroupVol_LOW` float NOT NULL DEFAULT '0' COMMENT '组端下限(V)'," +
			" `MonomerVol_LOW` float NOT NULL DEFAULT '0' COMMENT '单体下限(V)'," +
			" `MonomerLowCount` int(11) NOT NULL DEFAULT '0' COMMENT '单体下限数量'," +
			" `BattGroupNum` int(11) NOT NULL DEFAULT '0' COMMENT '组号'," +
			" `OnlineVolLowAction` int(11) NOT NULL DEFAULT '0' COMMENT '在线电压低处理'," +
			" `DCVolHighLimit` float NOT NULL DEFAULT '0' COMMENT '升压上限(V)'," +
			" `ChargeCurrSet` float NOT NULL DEFAULT '0' COMMENT '充电电流(V)'," +
			" `MonomerTmp_High` float NOT NULL DEFAULT '0' COMMENT '单体温度上限(℃)'," +
			" `AutoTestStartVol` float NOT NULL DEFAULT '0'," +
			" `OnLineVol_Low` float NOT NULL DEFAULT '0' COMMENT '在线电压低阀值'," +
			" `OffLineYH_Cycle` int(11) NOT NULL DEFAULT '0' COMMENT '离线养护周期'," +
			" `OffLineYHstarttime` datetime NOT NULL DEFAULT '2000-01-01 00:00:00' COMMENT '养护计划开始时间'," +
			" `OffLineYHTimes` int(11) NOT NULL DEFAULT '1' COMMENT '离线养护执行次数'," +
			" `OffLineYHOnceCycle` int(11) NOT NULL DEFAULT '1' COMMENT '离线养护每次执行周期'," +
			" `MonCount` int(11) NOT NULL DEFAULT '0' COMMENT '每组单体数'," +
			" `MonVol` float NOT NULL DEFAULT '0' COMMENT '单体电压'," +
			" `DisPower` float NOT NULL DEFAULT '0' COMMENT '预放功率（0.1kw）'," +
			" `DisPreRes` float(11,0) NOT NULL DEFAULT '0' COMMENT '放电阻值(mΩ)'," +
			" `CharCap` int(11) NOT NULL DEFAULT '0' COMMENT '充电容量(AH)'," +
			" `CharTimeLong` int(11) NOT NULL DEFAULT '0' COMMENT '充电时长(min)'," +
			" `FloatCharTimeLong` int(11) NOT NULL DEFAULT '0' COMMENT '浮充时长'," +
			" `CharSotpCurr` float NOT NULL DEFAULT '0' COMMENT '截止电流(0.1A)'," +
			" `MonVolHightLimit` float NOT NULL DEFAULT '0' COMMENT '单体上限(0.01V)'," +
			" `MonVolHightLimitCount` int(11) NOT NULL DEFAULT '0' COMMENT '单体上限数量'," +
			" `CharHighTmp` float(11,0) NOT NULL DEFAULT '45' COMMENT '充电过温'," +
			" `DisWaitTime` int(11) NOT NULL DEFAULT '0' COMMENT '放完静置(0-500分钟)'," +
			" `CharWaitTime` int(11) NOT NULL DEFAULT '0' COMMENT '充完静置(0-500分钟)'," +
			" `FlowOver_Count` int(11) NOT NULL DEFAULT '1' COMMENT '恒流总阶段数[1-3]'," +
			" `FlowOver_CharCurr_1` float NOT NULL DEFAULT '0' COMMENT '恒流1阶段充电电流'," +
			" `FlowOver_CharCurr_2` float NOT NULL DEFAULT '0' COMMENT '恒流2阶段充电电流'," +
			" `FlowOver_CharCurr_3` float NOT NULL DEFAULT '0' COMMENT '恒流3阶段充电电流'," +
			" `FlowOver_CharTime_1` int(11) NOT NULL DEFAULT '0' COMMENT '恒流1阶段充电时长'," +
			" `FlowOver_CharTime_2` int(11) NOT NULL DEFAULT '0' COMMENT '恒流2阶段充电时长'," +
			" `FlowOver_CharTime_3` int(11) NOT NULL DEFAULT '0' COMMENT '恒流3阶段充电时长'," +
			" `ChargeVolt` float NOT NULL DEFAULT '0' COMMENT '充电电压(V)'," +
			" `C_ProtectVol1` float NOT NULL DEFAULT '0' COMMENT '恒流保护电压1'," +
			" `C_ProtectVol2` float NOT NULL DEFAULT '0' COMMENT '恒流保护电压2'," +
			" `C_ProtectVol3` float NOT NULL DEFAULT '0' COMMENT '恒流保护电压3'," +
			" `C_mon_uppervol1` float NOT NULL DEFAULT '0' COMMENT '恒流单体上限1'," +
			" `C_mon_uppervol2` float NOT NULL DEFAULT '0' COMMENT '恒流单体上限2'," +
			" `C_mon_uppervol3` float NOT NULL DEFAULT '0' COMMENT '恒流单体上限3'," +
			" `C_mon_uppernum1` int(11) NOT NULL DEFAULT '0' COMMENT '恒流上限个数1'," +
			" `C_mon_uppernum2` int(11) NOT NULL DEFAULT '0' COMMENT '恒流上限个数2'," +
			" `C_mon_uppernum3` int(11) NOT NULL DEFAULT '0' COMMENT '恒流上限个数3'," +
			" `HV_charge_num` int(11) NOT NULL DEFAULT '0' COMMENT '恒压总阶段数[1~3]'," +
			" `HV_charge_Vol1` float NOT NULL DEFAULT '0' COMMENT '恒压阶段1充电电压'," +
			" `HV_charge_Vol2` float NOT NULL DEFAULT '0' COMMENT '恒压阶段2充电电压'," +
			" `HV_charge_Vol3` float NOT NULL DEFAULT '0' COMMENT '恒压阶段3充电电压'," +
			" `HV_time1` int(11) NOT NULL DEFAULT '0' COMMENT '恒压阶段1充电时间'," +
			" `HV_time2` int(11) NOT NULL DEFAULT '0' COMMENT '恒压阶段2充电时间'," +
			" `HV_time3` int(11) NOT NULL DEFAULT '0' COMMENT '恒压阶段3充电时间'," +
			" `HV_ProtectCurr1` float NOT NULL DEFAULT '0' COMMENT '恒压阶段1保护电流'," +
			" `HV_ProtectCurr2` float NOT NULL DEFAULT '0' COMMENT '恒压阶段2保护电流'," +
			" `HV_ProtectCurr3` float NOT NULL DEFAULT '0' COMMENT '恒压阶段3保护电流'," +
			" `HV_mon_uppervol1` float NOT NULL DEFAULT '0' COMMENT '恒压阶段1单体上限'," +
			" `HV_mon_uppervol2` float NOT NULL DEFAULT '0' COMMENT '恒压阶段2单体上限'," +
			" `HV_mon_uppervol3` float NOT NULL DEFAULT '0' COMMENT '恒压阶段3单体上限'," +
			" `HV_mon_uppernum1` int(11) NOT NULL DEFAULT '0' COMMENT '恒压阶段1上限个数'," +
			" `HV_mon_uppernum2` int(11) NOT NULL DEFAULT '0' COMMENT '恒压阶段2上限个数'," +
			" `HV_mon_uppernum3` int(11) NOT NULL DEFAULT '0' COMMENT '恒压阶段3上限个数'," +
			" PRIMARY KEY (`num`)," +
			" KEY `index_battgroupid` (`BattGroupId`) USING BTREE," +
			" KEY `index_test_record_count` (`test_record_count`) USING BTREE" +
			") ENGINE=InnoDB DEFAULT CHARSET=utf8;");
			}
			}
			} catch (SQLException e) {
			e.printStackTrace();
			} finally {
			if(null != res) {
			try {
			res.close();
			} catch (SQLException e) {
			e.printStackTrace();
			}
			}
			sql.close_con();
			}
			}

			}

	BattMonitor_DB_Builder/src/com/database_util/DB_Dev_TestParam.java	146 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史
	BattMonitor_DB_Builder/src/com/database_util/DB_Pwrdev_Data_Rt.java	4 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史

			@@ -2121,7 +2121,7 @@
			+ " AND column_name='acIn1_switch_st'");
			if(false == res.next()) {
			sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
			+ " ADD COLUMN `acIn1_switch_st` int(11) NOT NULL DEFAULT '0' COMMENT '交流输入1分合闸状态:0---未知(用于兼容以前的)，1-分闸，2-合闸，3-脱扣',;");
			+ " ADD COLUMN `acIn1_switch_st` int(11) NOT NULL DEFAULT '0' COMMENT '交流输入1分合闸状态:0---未知(用于兼容以前的)，1-分闸，2-合闸，3-脱扣';");
			}

			//添加acIn2_switch_st字段
			@@ -2131,7 +2131,7 @@
			+ " AND column_name='acIn2_switch_st'");
			if(false == res.next()) {
			sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
			+ " ADD COLUMN `acIn2_switch_st` int(11) NOT NULL DEFAULT '0' COMMENT '交流输入2分合闸状态 :0---未知(用于兼容以前的)，1-分闸，2-合闸，3-脱扣',;");
			+ " ADD COLUMN `acIn2_switch_st` int(11) NOT NULL DEFAULT '0' COMMENT '交流输入2分合闸状态 :0---未知(用于兼容以前的)，1-分闸，2-合闸，3-脱扣';");
			}