JDBC以SQL Server身份验证方式连接SQL Server2014

1.正确下载并安装SQL Server2014下载地址：http://www.itellyou.cn/

2.安装JDK以及eclipse，配置好环境变量

3.登陆微软官网下载适合自己JDK版本的JDBC，网址：https://www.microsoft.com/zh-cn/download/details.aspx?id=11774

4.下载好JDBC之后双击打开会自动解压，打开解压包将适合自己的.jar文件复制到\Jre\lib\ext目录下，对应的dll文件复制到\Jre\bin目录下

5.打开eclipse，Windows->Preferences->Java->Installed JREs,选中相应的Jre点击Edit->Add External JARs..->选中刚刚复制进去的.jar文件，单机打开->finish->apply->ok

6.以SQL Server身份验证方式登陆SQL Server2014，编写测试代码进行测试

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

public class DBHelper{
	
	private static final String url = "jdbc:sqlserver://localhost:1433;databasename=sales";//连接字符串
	private static final String driverName = "com.microsoft.sqlserver.jdbc.SQLServerDriver";//驱动程序
	private static final String user = "sa";//用户名
	private static final String password = "225821zyy";//密码
	
	public Connection conn = null;
	public PreparedStatement pst = null;
	
	public DBHelper(String sql){
		try{
			Class.forName(driverName);//加载驱动程序
			conn = DriverManager.getConnection(url, user, password);//连接数据库
			pst = conn.prepareStatement(sql);//预编译SQL语句
		}catch(Exception e){
			e.printStackTrace();
		}
	}
	
	public void close(){
		try{
			this.conn.close();
			this.pst.close();
		}catch(SQLException e){
			e.printStackTrace();
		}
	}
}

import java.sql.ResultSet;
import java.sql.SQLException;

public class Demo {
	
	static String sql = null;
	static DBHelper db1 = null;
	static ResultSet ret = null;
	
	public static void main(String[] args){
		
		sql = "select * from Orders";
		db1 = new DBHelper(sql);
		
		try {
			ret = db1.pst.executeQuery();//执行查询返回结果集
			while(ret.next()){//逐行读取结果集
				String orderId = ret.getString(1);
				String customerId = ret.getString(2);
				String salesId = ret.getString(3);
				String orderDate = ret.getString(4);
				System.out.println(orderId + "\t" + customerId + "\t" + salesId + "\t" + orderDate);
			}
			db1.pst.close();
			db1.close();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		
	}
}