資源簡介
SQLServer2014從入門到精通隨書數據庫及案例代碼,值得參考和學習!

代碼片段和文件信息
/*
?*?To?change?this?license?header?choose?License?Headers?in?Project?Properties.
?*?To?change?this?template?file?choose?Tools?|?Templates
?*?and?open?the?template?in?the?editor.
?*/
package?DBHelper;
import?java.sql.Connection;??
import?java.sql.DriverManager;??
import?java.sql.ResultSet;??
import?java.sql.SQLException;??
import?java.sql.Statement;??
/**
?*
?*?@author?Administrator
?*/
public?class?DBConnectionManager?{
????private?String?driverName?=?“com.microsoft.jdbc.sqlserver.SQLServerDriver“;//加載驅動程序??
????private?String?url?=?“jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=ERPMS“;//設置數據庫連接串??
????private?String?user?=?“sa“;//數據庫登錄用戶名??
????private?String?password?=?“root“;//數據庫登錄密碼??
????private?static?String?message?=?“恭喜,數據庫連接正常!“;??
????public?void?setDriverName(String?newDriverName)?{??
????????driverName?=?newDriverName;??
????}??
????public?String?getDriverName()?{??
????????return?driverName;??
????}??
??????
????public?void?setUrl(String?newUrl)?{??
????????url?=?newUrl;??
????}??
????public?String?getUrl()?{??
????????return?url;??
????}??
????public?void?setUser(String?newUser)?{??
????????user?=?newUser;??
????}??
????public?String?getUser()?{??
????????return?user;??
????}??
????public?void?setPassword(String?newPassword)?{??
????????password?=?newPassword;??
????}??
????public?String?getPassword()?{??
????????return?password;??
????}??
????public?Connection?getConnection()?{??
????????try?{??
????????????Class.forName(driverName);??
????????????return?DriverManager.getConnection(url?user?password);??
????????}?catch?(Exception?e)?{??
????????????e.printStackTrace();??
????????????message?=?“數據庫連接失??!“;??
????????????return?null;??
????????}??
????}??
????public?static?void?main(String[]?args)?{??
????????try{??
????????????DBConnectionManager?dcm?=?new?DBConnectionManager();??
????????????Connection??conn?=?dcm.getConnection();??
????????????System.out.println(message);??
????????}catch(Exception?e){??
????????????e.printStackTrace();??
????????}??
????}??
}
?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????文件????????101??2016-11-01?16:42??SQLServer2014從入門到精通隨書數據庫及案例代碼\readme.txt
?????文件????3538944??2016-05-19?23:19??SQLServer2014從入門到精通隨書數據庫及案例代碼\SQL2014隨書數據庫\ERPMS(第19章).LDF
?????文件????4653056??2016-05-19?23:19??SQLServer2014從入門到精通隨書數據庫及案例代碼\SQL2014隨書數據庫\ERPMS(第19章).MDF
?????文件????5242880??2016-07-07?12:14??SQLServer2014從入門到精通隨書數據庫及案例代碼\SQL2014隨書數據庫\RSGL(第20章).mdf
?????文件???10362880??2016-07-07?12:14??SQLServer2014從入門到精通隨書數據庫及案例代碼\SQL2014隨書數據庫\RSGL_log(第20章).ldf
?????文件????5242880??2016-07-07?12:13??SQLServer2014從入門到精通隨書數據庫及案例代碼\SQL2014隨書數據庫\xsxk(統一數據庫).mdf
?????文件????8519680??2016-07-07?12:13??SQLServer2014從入門到精通隨書數據庫及案例代碼\SQL2014隨書數據庫\xsxk_log(統一數據庫).ldf
?????文件????????102??2016-07-05?00:16??SQLServer2014從入門到精通隨書數據庫及案例代碼\第19企業EPR管理系統代碼\ERPMS\build\built-jar.properties
?????文件???????2363??2016-07-05?00:16??SQLServer2014從入門到精通隨書數據庫及案例代碼\第19企業EPR管理系統代碼\ERPMS\build\classes\DBHelper\DBConnectionManager.class
?????文件???????1609??2016-07-05?00:16??SQLServer2014從入門到精通隨書數據庫及案例代碼\第19企業EPR管理系統代碼\ERPMS\build\classes\DBHelper\DBDelete.class
?????文件???????1376??2016-07-05?00:16??SQLServer2014從入門到精通隨書數據庫及案例代碼\第19企業EPR管理系統代碼\ERPMS\build\classes\DBHelper\DBInsert.class
?????文件???????2185??2016-07-05?00:16??SQLServer2014從入門到精通隨書數據庫及案例代碼\第19企業EPR管理系統代碼\ERPMS\build\classes\DBHelper\DBSelect.class
?????文件???????1643??2016-07-05?00:16??SQLServer2014從入門到精通隨書數據庫及案例代碼\第19企業EPR管理系統代碼\ERPMS\build\classes\DBHelper\DBUpdate.class
?????文件????????816??2016-01-11?01:40??SQLServer2014從入門到精通隨書數據庫及案例代碼\第19企業EPR管理系統代碼\ERPMS\build\classes\fr
?????文件????????527??2016-01-11?01:40??SQLServer2014從入門到精通隨書數據庫及案例代碼\第19企業EPR管理系統代碼\ERPMS\build\classes\fr
?????文件???????6645??2016-01-11?01:40??SQLServer2014從入門到精通隨書數據庫及案例代碼\第19企業EPR管理系統代碼\ERPMS\build\classes\fr
?????文件????????734??2016-01-11?01:40??SQLServer2014從入門到精通隨書數據庫及案例代碼\第19企業EPR管理系統代碼\ERPMS\build\classes\fr
?????文件????????734??2016-01-11?01:40??SQLServer2014從入門到精通隨書數據庫及案例代碼\第19企業EPR管理系統代碼\ERPMS\build\classes\fr
?????文件????????734??2016-01-11?01:40??SQLServer2014從入門到精通隨書數據庫及案例代碼\第19企業EPR管理系統代碼\ERPMS\build\classes\fr
?????文件????????734??2016-01-11?01:40??SQLServer2014從入門到精通隨書數據庫及案例代碼\第19企業EPR管理系統代碼\ERPMS\build\classes\fr
?????文件????????734??2016-01-11?01:40??SQLServer2014從入門到精通隨書數據庫及案例代碼\第19企業EPR管理系統代碼\ERPMS\build\classes\fr
?????文件????????734??2016-01-11?01:40??SQLServer2014從入門到精通隨書數據庫及案例代碼\第19企業EPR管理系統代碼\ERPMS\build\classes\fr
?????文件????????734??2016-01-11?01:40??SQLServer2014從入門到精通隨書數據庫及案例代碼\第19企業EPR管理系統代碼\ERPMS\build\classes\fr
?????文件????????531??2016-01-11?01:40??SQLServer2014從入門到精通隨書數據庫及案例代碼\第19企業EPR管理系統代碼\ERPMS\build\classes\fr
?????文件??????10891??2016-01-11?01:40??SQLServer2014從入門到精通隨書數據庫及案例代碼\第19企業EPR管理系統代碼\ERPMS\build\classes\fr
?????文件????????733??2016-01-11?01:40??SQLServer2014從入門到精通隨書數據庫及案例代碼\第19企業EPR管理系統代碼\ERPMS\build\classes\fr
?????文件????????756??2016-01-11?01:40??SQLServer2014從入門到精通隨書數據庫及案例代碼\第19企業EPR管理系統代碼\ERPMS\build\classes\fr
?????文件????????783??2016-01-11?01:40??SQLServer2014從入門到精通隨書數據庫及案例代碼\第19企業EPR管理系統代碼\ERPMS\build\classes\fr
?????文件????????783??2016-01-11?01:40??SQLServer2014從入門到精通隨書數據庫及案例代碼\第19企業EPR管理系統代碼\ERPMS\build\classes\fr
?????文件????????721??2016-01-11?01:40??SQLServer2014從入門到精通隨書數據庫及案例代碼\第19企業EPR管理系統代碼\ERPMS\build\classes\fr
............此處省略122個文件信息
- 上一篇:ojdbc7oracle12連接驅動
- 下一篇:SQL數據庫經典面試題(筆試題)
評論
共有 條評論