dbconnection.java

数字校园 j2EE 有完整的说明 可直接用

package utility;
import java.sql.*;
public class DBConnection {
	
	private static final String url = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=DigitalCampus";
	private static final String jdbcClassName = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
	private static final String username = "sa";
	private static final String password = "";
	
	
	public static Connection getConnection() throws Exception{
		Driver driver = (Driver) Class.forName(jdbcClassName).newInstance();
		DriverManager.registerDriver(driver);
		return DriverManager.getConnection(url, username, password);
	}
}