package?測(cè)試sqlserver數(shù)據(jù)庫(kù)連接;

import?java.sql.Connection;
import?java.sql.DriverManager;
import?java.sql.SQLException;

	
	public?class?TestSQL?{?
		public?static?void?main（String[]?srg）?{?
			
		String?driverName?=?“com.microsoft.sqlserver.jdbc.SQLServerDriver“;???//加載JDBC驅(qū)動(dòng)???
		String?dbURL?=?“jdbc:sqlserver://localhost:1433;?DatabaseName=lyl“;???//連接服務(wù)器和數(shù)據(jù)庫(kù)??lyl是數(shù)據(jù)庫(kù)名稱
		String?user?=?“sa“;???
		String?pwd?=?“1234“;?	
			
		Connection?dbConn;
		try?{
			Class.forName（driverName）;
			System.out.println（“數(shù)據(jù)庫(kù)驅(qū)動(dòng)程序注冊(cè)成功“）;?
		}?catch?（ClassNotFoundException?e）?{
			System.out.println（“數(shù)據(jù)庫(kù)驅(qū)動(dòng)程序注冊(cè)失敗“）;?
		}??
		?
		try?{
			dbConn?=?DriverManager.getConnection（dbURLuser?pwd）;
			System.out.println（“數(shù)據(jù)庫(kù)連接成功“）;
		}?catch?（SQLException?e）?{
			System.out.println（“數(shù)據(jù)庫(kù)連接失敗“

?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----

?????文件????????368??2017-08-16?20:48??sqlserverDemo\.classpath

?????文件????????389??2017-08-16?20:48??sqlserverDemo\.project

?????文件????????598??2017-08-16?20:48??sqlserverDemo\.settings\org.eclipse.jdt.core.prefs

?????文件???????1529??2017-08-16?20:48??sqlserverDemo\bin\測(cè)試sqlserver數(shù)據(jù)庫(kù)連接\TestSQL.class

?????文件?????584207??2017-08-16?20:48??sqlserverDemo\sqljdbc4.jar

?????文件????????898??2017-08-16?20:48??sqlserverDemo\src\測(cè)試sqlserver數(shù)據(jù)庫(kù)連接\TestSQL.java

?????目錄??????????0??2017-08-16?20:48??sqlserverDemo\bin\測(cè)試sqlserver數(shù)據(jù)庫(kù)連接

?????目錄??????????0??2017-08-16?20:48??sqlserverDemo\src\測(cè)試sqlserver數(shù)據(jù)庫(kù)連接

?????目錄??????????0??2017-08-16?20:48??sqlserverDemo\.settings

?????目錄??????????0??2017-08-16?20:48??sqlserverDemo\bin

?????目錄??????????0??2017-08-16?20:48??sqlserverDemo\src

?????目錄??????????0??2017-08-16?20:48??sqlserverDemo

-----------?---------??----------?-----??----

???????????????587989????????????????????12