-
大小: 1.61M文件類(lèi)型: .zip金幣: 1下載: 0 次發(fā)布日期: 2023-06-24
- 語(yǔ)言: Java
- 標(biāo)簽:
資源簡(jiǎn)介
Java 將Excel表中的內(nèi)容保存到數(shù)據(jù)庫(kù)(基礎(chǔ)篇-實(shí)例483).zip
代碼片段和文件信息
import?java.sql.*;
public?class?JDBCUtil?{
????
????Connection?conn?=?null;
????
????public?Connection?getConn()?{
????????try?{
????????????Class.forName(“net.sourceforge.jtds.jdbc.Driver“);
????????}?catch?(ClassNotFoundException?e)?{
????????????e.printStackTrace();
????????}
????????String?url?=?“jdbc:jtds:sqlserver://localhost:1433;DatabaseName=db_database21“;?//?連接數(shù)據(jù)庫(kù)URL
????????String?userName?=?“sa“;?//?連接數(shù)據(jù)庫(kù)的用戶(hù)名
????????String?passWord?=?““;?//?連接數(shù)據(jù)庫(kù)密碼
????????try?{
????????????conn?=?DriverManager.getConnection(url?userName?passWord);?//?獲取數(shù)據(jù)庫(kù)連接
????????????if?(conn?!=?null)?{
????????????????System.out.println(“數(shù)據(jù)庫(kù)連接成功!“);
????????????}
????????}?catch?(SQLException?e)?{
????????????e.printStackTrace();
????????}
????????return?conn;?//?返回Connection對(duì)象
?屬性????????????大小?????日期????時(shí)間???名稱(chēng)
-----------?---------??----------?-----??----
?????文件?????????352??2013-11-19?11:33??.classpath
?????文件?????????379??2010-09-10?15:22??.project
?????文件??????????49??2013-11-20?09:56??readme.txt
?????文件???????16896??2013-11-20?09:46??temp.xls
?????文件?????????629??2010-09-10?15:22??.settings\org.eclipse.jdt.core.prefs
?????文件????????2142??2013-11-21?08:42??bin\JDBCUtil.class
?????文件????????2531??2013-11-21?08:42??bin\ReadToDateba
?????文件??????294726??2013-11-19?11:28??lib\jtds-1.2.2.jar
?????文件?????1539291??2013-11-19?11:14??lib\poi-3.6-20091214.jar
?????文件????????1393??2010-09-10?15:22??src\JDBCUtil.java
?????文件????????2225??2010-09-10?15:22??src\ReadToDateba
評(píng)論
共有 條評(píng)論