java连接数据库SQLserver的dbUtil代码

package edu.yangtzeu.lmis.util;

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

//数据库工具类
public class Dbutil {
	String dbUrl = "jdbc:sqlserver://localhost\\SQLEXPRESS:1433;DatabaseName=LIBRARY";
    String dbUserName = "sa";
    String dbPassword = "123";
    private String jdbcName="com.microsoft.sqlserver.jdbc.SQLServerDriver";//驱动名称
	//获取数据库连接
	public Connection getCon()throws Exception{
		Class.forName(jdbcName);
		Connection con=DriverManager.getConnection(dbUrl, dbUserName, dbPassword);
		return con;
	}
	//关闭连接
	public void closeCon(Connection con)throws Exception{
		if(con!=null){
			con.close();
		}
	}
	public static void main(String[] args) {
		Dbutil dbutil=new Dbutil();
		try {
			dbutil.getCon();
			System.out.println("数据库连接成功");
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			System.out.println("数据库连接失败");
		}
	}
}
/