毕业设计SpringBoot2.3Vue2Es8.zip

package utils; import java.io.File; import java.io.FileInputStream; import java.net.InetAddress; import java.net.NetworkInterface; import java.sql.Timestamp; import java.text.DecimalFormat; import java.text.SimpleDateFormat; import java.util.*; import java.util.regex.Matcher; import java.util.regex.Pattern; public class StringUtil { /** * * @param type * 1代表SqlServer 2代表Oracle 3代表Mysql 4代表Access 5代表Sqlite 6代表Sybase * 7代表Dbase 8代表Foxpro 10代表Hive * @param ip * 数据库连接ip地址 * @param DataBaseName * 数据库名称 * @param Port * 端口 * @return 返回Url、Driver列表 */ public static List<String> getDBDriver(String type, String ip, String DataBaseName, String Port) { List<String> list = new ArrayList<String>(); if (type.equals("1")) // SqlServer { String Url = "jdbc:sqlserver://" + ip + ":" + Port + ";" + "DatabaseName=" + DataBaseName;// 拼接URL String Driver = "com.microsoft.sqlserver.jdbc.SQLServerDriver"; list.add(Url);// 添加到list列表 list.add(Driver); return list; } if (type.equals("2")) // Orcal { String Url = "jdbc:oracle:thin:@" + ip + ":" + Port + ":"+DataBaseName; String Driver = "oracle.jdbc.OracleDriver"; list.add(Url);// 添加到list列表 list.add(Driver); return list; } if (type.equals("3")) // MySql { String Url = "jdbc:mysql://" + ip + ":" + Port + "/" + DataBaseName;// 拼接URL String Driver = "com.mysql.jdbc.Driver"; list.add(Url);// 添加到list列表 list.add(Driver); return list; } if (type.equals("4")) // Access { return null; } if (type.equals("5")) // Sqllite { return null; } if (type.equals("6")) // Sybase { return null; } if (type.equals("7")) // Dbase { return null; } if (type.equals("8")) // Foxpro { return null; } if (type.equals("9")) // Foxpro { String Url = "jdbc:oscar://" + ip + ":" + Port + "/" + DataBaseName;// 拼接URL String Driver = "com.oscar.Driver"; list.add(Url);// 添加到list列表 list.add(Driver); return list; } if (type.equals("10")) // Hive { return null; } return null; } /** * 解析时间格式 ZhangSiWei * * @param Excute_Type * 0为每日执行 1为周日执行 * @param interval_type * 间隔类型 -1为日 0为周 1为月 * @param inteval_value * 具体每个月的哪天执行 * @param task_time * 具体执行时间 * @return 返回解析过后的时间格式 * @throws Exception */ public static String AnalyticalTime(String Excute_Type, String interval_type, String inteval_value, String task_time) throws Exception { Date time = null; Calendar now = Calendar.getInstance(); try { now.clear(); time = StringUtil.str2datetime(task_time); now.setTime(time); } catch (Exception e) { // TODO Auto-generated catch block e.printStackTrace(); } // int YEAR = now.get(Calendar.YEAR); // int MONTH = now.get(Calendar.MONTH) + 1; // int Day = now.get(Calendar.DAY_OF_MONTH); int HOUR = now.get(Calendar.HOUR_OF_DAY); int MINUTE = now.get(Calendar.MINUTE); int SECOND = now.get(Calendar.SECOND); if (Excute_Type.equals("0")) // 每日执行 执行解析task_time { // 0 15 10 ? * * 每天10点15分触发 每天执行时间书写格式 return SECOND + " " + MINUTE + " " + HOUR + " " + "? " + "* " + "*"; } if (Excute_Type.equals("1")) // 周期执行 如果是周期执行则判断间隔类型 { if (interval_type.equals("-1")) // 如果是-1则为每日执行 { return SECOND + " " + MINUTE + " " + HOUR + " " + "? " + "* " + "*"; } if (interval_type.equals("0")) // 如果是0则为每周执行 { if (inteval_value.equals("1")) { return SECOND + " " + MINUTE + " " + HOUR + " " + "? " + "* " + "MON"; } if (inteval_value.equals("2")) { return SECOND + " " + MINUTE + " " + HOUR + " " + "? " + "* " + "TUE"; } if (inteval_value.equals("3")) { return SECOND + " " + MINUTE + " " + HOUR + " " + "? " + "* " + "WED"; } if (inteval_value.equals("4")) { return SECOND + " " + MINUTE + " " + HOUR + " " + "? " + "* " + "THU"; } if (inteval_value.equals("5")) { return SECOND + " " + MINUTE + " " + HOUR + " " + "? " + "* " + "FRI"; } if (inteval_value.equals("6")) { return SECOND + " " + MINUTE + " " + HOUR + " " + "? " + "* " + "SAT"; } if (inteval_value.equals("7")) { return SECOND + " " + MINUTE + " " + HOUR + " " + "? " + "* " + "SUN"; } } if (interval_type.equals("1")) // 如果是1则每月执行 { // 0 15 10 15 * ? 每月15号上午10点15分触发 return SECOND + " " + MINUTE + " " + HOUR + " " + inteval_value + " " + "* " + "?"; } } return ""; } /** * 将String字符串转换为java.sql.Timestamp格式日期,用于数据库保存 * * @param strDate * 表示日期的字符串 * @param dateFormat * 传入字符串的日期表示格式（如："yyyy-MM-dd HH:mm:ss"） * @return java.sql.Timestamp类型日期对象（如果转换失败则返回null） */ public static Timestamp strToSqlDate(String strDate) throws Exception { SimpleDateFormat sf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss"); Date date = null; date = sf.parse(strDate); Timestamp dateSQL = new Timestamp(date.getTime()); return dateSQL; } /** * * @return */ public static String dateonly2str(Date date) throws Exception { SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd"); return sdf.format(date); } /** * jsy 2012-05-08 add * * @param date * @return * @throws Exception */ public static String dateonly2strSplit(Date date) throws Exception {// SimpleDateFormat sdf = new SimpleDateFormat("yyyyMMdd"); return sdf.format(date); } public static String date2str(Date date) throws Exception { SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss.SSS"); return sdf.format(date); } public static Date dateTimeStamp(Date date) throws Exception { if (date == null) return new Timestamp(new Date().getTime()); return new Timestamp(date.getTime()); } public static String datetime2str(Date date) throws Exception { if (date == null) return ""; SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss"); return sdf.format(date); } /** * * @param str * @return * @throws Exception */ public static Date str2date(String str) throws Exception { if (str == null || str.isEmpty()) return null; SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss.SSS"); return sdf.parse(str); } public static Date str2dateDd(String str) throws Exception { if (str == null || str.isEmpty()) return null; SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd"); return sdf.parse(str); } public static Date str2datetime(String str) throws Exception { SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss"); return sdf.parse(str); } public static Date str2date(String str, String style) throws Exception { SimpleDateFormat sdf = new SimpleDateFormat(style); return sdf.parse(str); } public static String long2str(long l) throws Exception { Long ll = l; return ll.toString(); } public static String int2str(int i) throws Exception { Integer ii = i; return ii.toString(); } public static Date long2date(long str) throws Exception { SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss"); return sdf.parse(sdf.format(str)); } public static long date2long(Date str) throws Exception { SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss"); return sdf.parse(sdf.format(str)).getTime(); } /** * * 字符串转换成十六进制字符串 * */ public static String str2HexStr(String str) { char[] chars = "0123456789ABCDEF".toCharArray();