a07ae2ffaaa0001d1351cdb1ca03511e

来自「实习的时候做的数字校园系统」· 代码 · 共 35 行

package com.xxgl.data;

import java.sql.Connection;
import java.sql.DriverManager;

public class DBconnection {

	public static Connection getConnection(){
		String jdbcDriver = "com.microsoft.jdbc.sqlserver.SQLServerDriver"; 
		String connectionString = "jdbc:microsoft:sqlserver://127.0.0.1:1433;databasename=dbname";// 数据库连接字符串
		String username = "sa"; // 数据库用户名
		String password = ""; // 数据库密码 
		
		Connection con = null;

		try {
			Class.forName(jdbcDriver);
		} catch (ClassNotFoundException e) {
			System.err.println(e.toString());
		}
		try {
			con = DriverManager.getConnection(connectionString, username, password);
		} catch (Exception e) {
			e.printStackTrace();
		}
		return con;

}
	public static void main(String[] args) {
		Connection con = DBconnection.getConnection();
		DBUtil.close(con);
		System.out.println(con);

	}
}