import?java.sql.Connection;
import?java.sql.DriverManager;
import?java.sql.ResultSet;
import?java.sql.Statement;
import?java.text.ParseException;
import?java.text.SimpleDateFormat;
import?java.util.Date;

public?class?DatabaseUtil?{
	private?final?static?String?driver?=?“com.mysql.jdbc.Driver“;
	private?String?user?=?“root“;
	private?String?password?=?““;
	private?String?url?=?“jdbc:mysql://127.0.0.1:3306/earth_db?useSSL=false“;

	private?Connection?con?=?null;
	private?Statement?stm?=?null;
	private?ResultSet?res?=?null;

	public?void?initDatabaseParam（String?url?String?user?String?password）?{
		this.url?=?url;
		this.user?=?user;
		this.password?=?password;
	}

	public?boolean?connectDatabase（）?{
		try?{
			Class.forName（driver）.newInstance（）;

			con?=?DriverManager.getConnection（url?user?password）;
			if?（con?!=?null）?{
				stm?=?this.con.createStatement（）;
				System.out.println（“connect?create?success“）;
			}
		}?catch?（Exception?e）?{
			System.err.println（e.getStackTrace（）.toString（））;
			return?false;
		}
		return?true;
	}
	
	public?static?boolean?testConnection（String?url?String?user?String?password）?{
		try?{
			Class.forName（driver）.newInstance（）;

			Connection?_con?=?DriverManager.getConnection（url?user?password）;
			if?（_con?!=?null）?{
				System.out.println（“connect?create?success“）;
			}
		}?catch?（Exception?e）?{
			System.err.println（e.getStackTrace（）.toString（））;
			return?false;
		}
		return?true;
	}

	public?boolean?insertDB（String?Time?String?Value?String?fileName）?{
		boolean?flag?=?false;
		String?sql?=?null;

		String?fName?=?fileName;
		String?dbFlag?=?fName.substring（0?1）;
		String?D?=?fName.substring（1?9）;
		String?Month?=?fName.substring（5?7）;
		String?Hour?=?fName.substring（9?11）;
		String?Caiji?=?fName.substring（14?15）;
		String?Jiance?=?fName.substring（16?17）;
		String?tableName?=?fName.substring（18?21）;
		int?hour?=?Integer.parseInt（Hour）;
		int?time?=?Integer.parseInt（Time）;
		int?caiji?=?Integer.parseInt（Caiji）;
		int?jiance?=?Integer.parseInt（Jiance）;
		//System.out.println（Month）;
		if?（tableName.equals（“ACC“）?&&?dbFlag.equals（“h“））?{
			int?value?=?Integer.parseInt（Value）;
			sql?=?“insert?into?2018“+Month+“HACC?values（‘“?+?D?+?“‘“?+?hour?+?““?+?caiji?+?““?+?jiance?+?““?+?time?+?““?+?value
					+?“）“;
		}
		if?（tableName.equals（“VEL“）?&&?dbFlag.equals（“h“））?{
			double?value?=?Double.parseDouble（Value）;
			sql?=?“insert?into?2018“+Month+“HVEL?values（‘“?+?D?+?“‘“?+?hour?+?““?+?caiji?+?““?+?jiance?+?““?+?time?+?““?+?value
					+?“）“;
		}
		if?（tableName.equals（“ACC“）?&&?dbFlag.equals（“d“））?{
			int?value?=?Integer.parseInt（Value）;
			sql?=?“insert?into?2018“+Month+“DACC?values（‘“?+?D?+?“‘“?+?caiji?+?““?+?jiance?+?““?+?time?+?““?+?value?+?“）“;
		}
		if?（tableName.equals（“VEL“）?&&?dbFlag.equals（“d“））?{
			double?value?=?Double.parseDouble（Value）;
			sql?=?“insert?into?2018“+Month+“DVEL?values（‘“?+

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2018-11-18?16:03??AutoRead\
?????文件?????????450??2018-11-07?09:03??AutoRead\.classpath
?????文件?????????378??2018-11-07?00:28??AutoRead\.project
?????目錄???????????0??2018-11-18?16:02??AutoRead\.settings\
?????文件??????????70??2018-11-07?09:17??AutoRead\.settings\org.eclipse.core.resources.prefs
?????文件?????????598??2018-11-07?00:28??AutoRead\.settings\org.eclipse.jdt.core.prefs
?????目錄???????????0??2018-11-18?16:02??AutoRead\bin\
?????文件????????5200??2018-11-12?19:05??AutoRead\bin\DatabaseUtil.class
?????文件?????????663??2018-11-12?19:05??AutoRead\bin\FileFilterBySuffix.class
?????文件????????6726??2018-11-13?12:35??AutoRead\bin\FileMonitor.class
?????文件?????????760??2018-11-12?19:05??AutoRead\bin\GUIPrintStream$1.class
?????文件????????1090??2018-11-12?19:05??AutoRead\bin\GUIPrintStream.class
?????文件?????????783??2018-11-12?19:05??AutoRead\bin\MainWindow$1.class
?????文件????????2015??2018-11-12?19:05??AutoRead\bin\MainWindow$2.class
?????文件????????1480??2018-11-12?19:05??AutoRead\bin\MainWindow$3.class
?????文件????????1494??2018-11-12?19:05??AutoRead\bin\MainWindow$4.class
?????文件????????4471??2018-11-12?19:05??AutoRead\bin\MainWindow.class
?????目錄???????????0??2018-11-18?16:02??AutoRead\lib\
?????文件??????999635??2018-10-09?17:43??AutoRead\lib\mysql-connector-java-5.1.44-bin.jar
?????文件?????????400??2018-11-18?15:53??AutoRead\README.txt
?????目錄???????????0??2018-11-18?16:02??AutoRead\src\
?????文件????????4673??2018-11-12?18:58??AutoRead\src\DatabaseUtil.java
?????文件?????????363??2018-10-26?09:11??AutoRead\src\FileFilterBySuffix.java
?????文件????????5697??2018-11-13?12:35??AutoRead\src\FileMonitor.java
?????文件?????????882??2018-10-26?10:55??AutoRead\src\GUIPrintStream.java
?????文件????????6703??2018-10-26?16:39??AutoRead\src\MainWindow.java