| | |
| | | } |
| | | } |
| | | |
| | | private static void createBattscrap_TABLE(MysqlConnPool pool, boolean recreate) { |
| | | String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.Battscrap_TABLE; |
| | | String sql_str02 = "CREATE TABLE IF NOT EXISTS " + Sql_Mysql.Battscrap_TABLE + " (" + |
| | | private static void createBattspare_TABLE(MysqlConnPool pool, boolean recreate) { |
| | | String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.Battspare_TABLE; |
| | | String sql_str02 = "CREATE TABLE IF NOT EXISTS " + Sql_Mysql.Battspare_TABLE + " (" + |
| | | " `num` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键'," + |
| | | " `battProducer` varchar(15) DEFAULT '理士' COMMENT '电池品牌'," + |
| | | " `BattModel` varchar(15) DEFAULT 'DJ300' COMMENT '电池型号'," + |
| | |
| | | } |
| | | } |
| | | |
| | | private static void createBattspare_TABLE(MysqlConnPool pool, boolean recreate) { |
| | | String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.Battspare_TABLE; |
| | | String sql_str02 = "CREATE TABLE IF NOT EXISTS " + Sql_Mysql.Battspare_TABLE + " (" + |
| | | private static void createBattscrap_TABLE(MysqlConnPool pool, boolean recreate) { |
| | | String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.Battscrap_TABLE; |
| | | String sql_str02 = "CREATE TABLE IF NOT EXISTS " + Sql_Mysql.Battscrap_TABLE + " (" + |
| | | " `num` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键'," + |
| | | " `battProducer` varchar(15) DEFAULT '理士' COMMENT '电池品牌'," + |
| | | " `BattModel` varchar(15) DEFAULT 'DJ300' COMMENT '电池型号'," + |