| | |
|---|
| | | package com.database_util;
|
|---|
| | |
|
|---|
| | | import java.sql.ResultSet;
|
|---|
| | | import java.sql.SQLException;
|
|---|
| | | import java.util.Date;
|
|---|
| | |
|
|---|
| | |
|---|
| | | " UNIQUE KEY `idx_power_device_id` (`power_device_id`) USING BTREE" +
|
|---|
| | | ") ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='测控电源信息表';";
|
|---|
| | | Sql_Mysql sql = new Sql_Mysql(pool.getConn());
|
|---|
| | | ResultSet res = null;
|
|---|
| | | try {
|
|---|
| | | if(true == recreate) {
|
|---|
| | | sql.sqlMysqlExecute(sql_str01);
|
|---|
| | | }
|
|---|
| | | sql.sqlMysqlExecute(sql_str02);
|
|---|
| | | |
|---|
| | | //新增字段pwr_dev_ip
|
|---|
| | | res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
|---|
| | | + " WHERE table_schema='db_ckpwrdev_inf'"
|
|---|
| | | + " AND table_name='tb_ckpwrdev_inf'"
|
|---|
| | | + " AND column_name='pwr_dev_ip'");
|
|---|
| | | if(!res.next()) {
|
|---|
| | | //修改字段st
|
|---|
| | | sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Ckpwrdev_Inf_Table |
|---|
| | | + " ADD column `pwr_dev_ip` varchar(64) NOT NULL DEFAULT '127.0.0.1' COMMENT '紫晶61850协转IP地址';");
|
|---|
| | | }
|
|---|
| | | |
|---|
| | | //新增字段zjdy_record__time
|
|---|
| | | res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
|---|
| | | + " WHERE table_schema='db_ckpwrdev_inf'"
|
|---|
| | | + " AND table_name='tb_ckpwrdev_inf'"
|
|---|
| | | + " AND column_name='zjdy_record__time'");
|
|---|
| | | if(!res.next()) {
|
|---|
| | | //修改字段st
|
|---|
| | | sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Ckpwrdev_Inf_Table |
|---|
| | | + " ADD column `zjdy_record__time` datetime NOT NULL DEFAULT '2000-01-01 00:00:00' COMMENT '紫晶电源协转数据更新时间';");
|
|---|
| | | }
|
|---|
| | | } catch (SQLException e) {
|
|---|
| | | e.printStackTrace();
|
|---|
| | | } finally {
|
|---|
