資源簡介
需求:每年的法定節假日都是不固定的,我們需要把固定的那些日子存入數據庫中,每年12月份頒布下一年的節假日,將這些節假日和調班數據更新到庫表中。這樣就可以知道下一年的節假日情況了
代碼片段和文件信息
package?com.softbankc.nyl;
import?java.sql.Connection;
import?java.sql.DriverManager;
import?java.sql.ResultSet;
import?java.sql.Statement;
import?java.util.Calendar;
import?java.util.Date;
import?java.util.UUID;
import?com.softbankc.util.DatePattern;
import?com.softbankc.util.DateUtil;
public?class?AddDay2DB?{
public?static?void?main(String[]?args)?{
//1、初始化數據庫配置
Connection?conn?=?null;
????????try?{
?
????????????//?加載mysql驅動程序
????????????Class.forName(“com.mysql.jdbc.Driver“);
????????????//?連接localhost上的mysql并指定使用test數據庫,用戶名為root密碼為***
????????????conn?=?DriverManager.getConnection(“jdbc:mysql://localhost:3306/dbname?allowMultiQueries=true“
???????????????????????????????????????????????“dbname“?“j!xsxlax2$xzx“);
????????????if?(!conn.isClosed
?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????文件????????440??2017-06-22?19:02??Holiday\.classpath
?????文件????????383??2017-06-22?18:15??Holiday\.project
?????文件????????598??2017-06-22?18:15??Holiday\.settings\org.eclipse.jdt.core.prefs
?????文件???????3740??2017-07-17?17:21??Holiday\bin\com\softbankc\nyl\AddDay2DB.class
?????文件????????994??2017-07-17?17:19??Holiday\bin\com\softbankc\util\DatePattern.class
?????文件???????9489??2017-07-17?17:19??Holiday\bin\com\softbankc\util\DateUtil.class
?????文件?????284220??2017-06-22?18:45??Holiday\libs\commons-lang-2.6.jar
?????文件?????875336??2017-06-22?19:02??Holiday\libs\mysql-connector-java-5.1.28.jar
?????文件???????3603??2017-07-17?17:21??Holiday\src\com\softbankc\nyl\AddDay2DB.java
?????文件???????1004??2017-06-22?18:44??Holiday\src\com\softbankc\util\DatePattern.java
?????文件??????13396??2017-06-22?18:44??Holiday\src\com\softbankc\util\DateUtil.java
?????目錄??????????0??2017-07-17?17:25??Holiday\bin\com\softbankc\nyl
?????目錄??????????0??2017-07-17?17:25??Holiday\bin\com\softbankc\util
?????目錄??????????0??2017-07-17?17:25??Holiday\src\com\softbankc\nyl
?????目錄??????????0??2017-07-17?17:25??Holiday\src\com\softbankc\util
?????目錄??????????0??2017-07-17?17:25??Holiday\bin\com\softbankc
?????目錄??????????0??2017-07-17?17:25??Holiday\src\com\softbankc
?????目錄??????????0??2017-07-17?17:25??Holiday\bin\com
?????目錄??????????0??2017-07-17?17:25??Holiday\src\com
?????目錄??????????0??2017-07-17?17:25??Holiday\.settings
?????目錄??????????0??2017-07-17?17:25??Holiday\bin
?????目錄??????????0??2017-07-17?17:25??Holiday\libs
?????目錄??????????0??2017-07-17?17:25??Holiday\src
?????目錄??????????0??2017-07-17?17:25??Holiday
-----------?---------??----------?-----??----
??????????????1193203????????????????????24
- 上一篇:西門子PLC接口以及協議 整理版
- 下一篇:FDizard.zip
評論
共有 條評論