jdbc.jar连接Sql Server 2012数据库

首先下载sqljdbc4.jar包，注意只需要这一个jar包就行了，不要同时导入其他的驱动包了如sqljdbc.jar包，有可能会冲突

导入到（直接复制粘贴就行了），稍后我会附上下载地址

package com.beijing.manyi.utils;

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

public class JdbcConnection {
	private final static String driver = "com.microsoft.sqlserver.jdbc.SQLServerDriver";//连接mySql数据库的驱动
	private final static String url = "jdbc:sqlserver://192.168.6.2:1433;DatabaseName=数据库名";//1433是端口号
	private final static String user = "sa";
	private final static String password = "qaz!123";
	static {

		try {
			Class.forName(driver);
		} catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
	public static Connection getConnection(){
		Connection conn = null;

		try {
			conn = DriverManager.getConnection(url,user,password);
		} catch (SQLException e) {
			// TODO Auto-generated catch block

			e.printStackTrace();
		}

		return conn;


	}
	public static void close(Connection conn){
		try {
			conn.close();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
}

参考：http://blog.csdn.net/stewen_001/article/details/19553173