testdb.java

通过JDBC连接到数据库

import java.sql.*;



public class TestDB {
public static void main(String[] args) {
String driverName = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
String dbURL = "jdbc:microsoft:sqlserver://localhost:1433; DatabaseName=资料库";
String userName = "sa";
String userPwd = "nuaa";

Connection dbConn=null;


try {
Class.forName(driverName);
dbConn = DriverManager.getConnection(dbURL, userName, userPwd);
System.out.println("数据库连接成功!");
}
catch (Exception e) {
System.out.println(e.getMessage());
}
 finally{
	 try{
         if (dbConn!=null){
             dbConn.close();
		 }
	 }
	 catch(SQLException ex){
		 System.out.println(ex.getMessage());
	 }
 }
}
}