package?測試sqlserver數據庫連接;

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驅動???
		String?dbURL?=?“jdbc:sqlserver://localhost:1433;?DatabaseName=lyl“;???//連接服務器和數據庫??lyl是數據庫名稱
		String?user?=?“sa“;???
		String?pwd?=?“1234“;?	
			
		Connection?dbConn;
		try?{
			Class.forName（driverName）;
			System.out.println（“數據庫驅動程序注冊成功“）;?
		}?catch?（ClassNotFoundException?e）?{
			System.out.println（“數據庫驅動程序注冊失敗“）;?
		}??
		?
		try?{
			dbConn?=?DriverManager.getConnection（dbURLuser?pwd）;
			System.out.println（“數據庫連接成功“）;
		}?catch?（SQLException?e）?{
			System.out.println（“數據庫連接失敗“

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件????????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\測試sqlserver數據庫連接\TestSQL.class

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

?????文件????????898??2017-08-16?20:48??sqlserverDemo\src\測試sqlserver數據庫連接\TestSQL.java

?????目錄??????????0??2017-08-16?20:48??sqlserverDemo\bin\測試sqlserver數據庫連接

?????目錄??????????0??2017-08-16?20:48??sqlserverDemo\src\測試sqlserver數據庫連接

?????目錄??????????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