package com.database_util;
|
|
import java.util.ArrayList;
|
import java.util.Arrays;
|
import java.util.List;
|
|
public class SqlsUtils {
|
|
/**
|
* db_app_sys.tb_page_paramµÄĬÈϲÎÊýÖеÄid
|
*/
|
static List<Integer> idsDefault;
|
|
/**
|
* db_app_sys.tb_page_param2µÄĬÈϲÎÊýÖеÄid
|
*/
|
static List<Integer> idsDefault2;
|
|
|
/**
|
* db_app_sys.tb_page_paramµÄĬÈÏinsertÓï¾ä
|
*/
|
static ArrayList<String> sqlstb_page_param;
|
/**
|
* db_app_sys.tb_page_param2µÄĬÈÏinsertÓï¾ä
|
*/
|
static ArrayList<String> sqlstb_page_param2;
|
|
|
static {
|
|
Integer[] temp= {1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45};
|
idsDefault = Arrays.asList(temp);
|
|
Integer[] temp2= {1,2,3,4};
|
idsDefault2 = Arrays.asList(temp2);
|
|
sqlstb_page_param2 = new ArrayList<>();
|
String tb_page_param2 = "INSERT INTO `db_app_sys`.`tb_page_param2` VALUES ('1', 'visit_time_first', 'Óû§µÇ¼·ÃÎÊ¿ØÖÆ-·ÃÎÊʱ¼ä×îÔç', '00:00:01', '1');" +
|
"INSERT INTO `db_app_sys`.`tb_page_param2` VALUES ('2', 'visit_time_last', 'Óû§µÇ¼·ÃÎÊ¿ØÖÆ-·ÃÎÊʱ¼ä×îÍí', '23:59:59', '1');" +
|
"INSERT INTO `db_app_sys`.`tb_page_param2` VALUES ('3', 'visit_ip', 'Óû§µÇ¼·ÃÎÊ¿ØÖÆ-·ÃÎÊ¿Í»§¶Ëip-ÔÊÐí', '*', '1');"+
|
"INSERT INTO `db_app_sys`.`tb_page_param2` (`id`, `param`, `label`, `value`, `categoryId`) "+
|
"VALUES ('4', 'audit_cap', 'Éó¼ÆÊý¾Ý¼Ç¼ÈÝÁ¿', '5000', '2');";
|
String[] strs2 = tb_page_param2.split(";");
|
for (int i = 0; i < strs2.length; i++) {
|
sqlstb_page_param2.add(strs2[i]);
|
}
|
|
sqlstb_page_param = new ArrayList<>();
|
String tb_page_param = "INSERT INTO `db_app_sys`.`tb_page_param` VALUES ('1', 'É豸¹¤×÷״̬', '1', '1');" +
|
"INSERT INTO `db_app_sys`.`tb_page_param` VALUES ('2', 'É豸ͨѶ', '1', '1');" +
|
"INSERT INTO `db_app_sys`.`tb_page_param` VALUES ('3', 'É豸ζÈ', '1', '1');" +
|
"INSERT INTO `db_app_sys`.`tb_page_param` VALUES ('4', '¸É½Óµã', '1', '1');" +
|
"INSERT INTO `db_app_sys`.`tb_page_param` VALUES ('5', 'ºËÈÝÖÕÖ¹ÔÒò', '1', '1');" +
|
"INSERT INTO `db_app_sys`.`tb_page_param` VALUES ('6', '²Ù×÷ʧ°ÜÔÒò', '1', '1');" +
|
"INSERT INTO `db_app_sys`.`tb_page_param` VALUES ('7', 'Ê£ÓàÌìÊý', '1', '1');" +
|
"INSERT INTO `db_app_sys`.`tb_page_param` VALUES ('8', '¹¤×÷ģʽ', '1', '1');" +
|
"INSERT INTO `db_app_sys`.`tb_page_param` VALUES ('9', '×é¶Ëµçѹ', '1', '1');" +
|
"INSERT INTO `db_app_sys`.`tb_page_param` VALUES ('10', '·åÖµµçѹ', '1', '1');" +
|
"INSERT INTO `db_app_sys`.`tb_page_param` VALUES ('11', 'Æô¶¯ºËÈݲâÊÔ', '1', '2');" +
|
"INSERT INTO `db_app_sys`.`tb_page_param` VALUES ('12', 'Í£Ö¹²âÊÔ', '1', '2');" +
|
"INSERT INTO `db_app_sys`.`tb_page_param` VALUES ('13', 'ϵͳ²ÎÊýÉèÖÃ', '1', '2');" +
|
"INSERT INTO `db_app_sys`.`tb_page_param` VALUES ('14', 'Çå³ý¸æ¾¯', '1', '2');" +
|
"INSERT INTO `db_app_sys`.`tb_page_param` VALUES ('15', 'Æô¶¯Ñø»¤/³ýÁò', '1', '2');" +
|
"INSERT INTO `db_app_sys`.`tb_page_param` VALUES ('16', 'Í£Ö¹Ñø»¤/³ýÁò', '1', '2');" +
|
"INSERT INTO `db_app_sys`.`tb_page_param` VALUES ('17', 'Æô¶¯ÀëÏßÑø»¤', '1', '2');" +
|
"INSERT INTO `db_app_sys`.`tb_page_param` VALUES ('18', 'Í£Ö¹ÀëÏßÑø»¤', '1', '2');" +
|
"INSERT INTO `db_app_sys`.`tb_page_param` VALUES ('19', '¶¨ÆÚÆô¶¯É豸', '1', '2');" +
|
"INSERT INTO `db_app_sys`.`tb_page_param` VALUES ('20', 'ÖØÆôÉ豸', '1', '2');" +
|
"INSERT INTO `db_app_sys`.`tb_page_param` VALUES ('21', '¾ùºâ¿ØÖƲÎÊýÉèÖà ', '1', '2');" +
|
"INSERT INTO `db_app_sys`.`tb_page_param` VALUES ('31', 'Ðîµç³Øºǫ́¼à¿Ø¹ÜÀíƽ̨', '1', '5');" +
|
"INSERT INTO `db_app_sys`.`tb_page_param` VALUES ('32', 'V1.0.5', '1', '6');" +
|
"INSERT INTO `db_app_sys`.`tb_page_param` VALUES ('33', 'ƽ̨logo', '1', '7');" +
|
"INSERT INTO `db_app_sys`.`tb_page_param` VALUES ('34', 'uKey', '1', '7');" +
|
"INSERT INTO `db_app_sys`.`tb_page_param` VALUES ('35', 'ÈËÁ³Ê¶±ð', '1', '7');" +
|
"INSERT INTO `db_app_sys`.`tb_page_param` VALUES ('36', 'Ç©Ãû', '1', '7');" +
|
"INSERT INTO `db_app_sys`.`tb_page_param` VALUES ('37', 'Ô¶³ÌÐÞ¸Äip', '1', '7');" +
|
"INSERT INTO `db_app_sys`.`tb_page_param` VALUES ('38', 'Æô¶¯·ÅµçÌí¼ÓÈËÁ³Ê¶±ð', '1', '7');" +
|
"INSERT INTO `db_app_sys`.`tb_page_param` VALUES ('39', 'Õ˺ÅɨÃè²ßÂÔ', '1', '8');" +
|
"INSERT INTO `db_app_sys`.`tb_page_param` VALUES ('40', 'Õ˺ŵǼʧ°ÜÏÞÖÆ´ÎÊý', '10', '9');" +
|
"INSERT INTO `db_app_sys`.`tb_page_param` VALUES ('41', 'Õ˺ŵǼʧ°ÜËø¶¨½âËø²ßÂÔ', '2', '9');" +
|
|
"INSERT INTO `db_app_sys`.`tb_page_param` VALUES ('42', 'ÃÜÂëÉèÖùæÔò-λÊý', '8', '10');" +
|
"INSERT INTO `db_app_sys`.`tb_page_param` VALUES ('43', 'ÃÜÂëÉèÖùæÔò-·ûºÅÀàÐÍ', '4', '10');" +
|
"INSERT INTO `db_app_sys`.`tb_page_param` VALUES ('44', 'ÀúÊ·Êý¾ÝµÄÍÕ·å¹øµ×¹¦ÄÜ¿ªÆô', '1', '11');" +
|
"INSERT INTO `db_app_sys`.`tb_page_param` VALUES ('45', 'ÀúÊ·Êý¾ÝµÄÊý¾ÝÏÔʾÁ£¶È', '5', '11');" +
|
"";
|
String[] strs = tb_page_param.split(";");
|
for (int i = 0; i < strs.length; i++) {
|
sqlstb_page_param.add(strs[i]);
|
}
|
}
|
|
// public static void main(String[] args) {
|
// System.out.println("SqlsUtils.sqlstb_page_param2 = " + SqlsUtils.sqlstb_page_param2);
|
// System.out.println("SqlsUtils.sqlstb_page_param = " + SqlsUtils.sqlstb_page_param);
|
// for (int i = 0; i < SqlsUtils.sqlstb_page_param2.size(); i++) {
|
// System.out.println("SqlsUtils.sqls.get(i) = " + SqlsUtils.sqlstb_page_param2.get(i));
|
// }
|
// System.out.println(SqlsUtils.idsDefault.size());
|
// }
|
|
}
|
