JDBC链接SQLServer数据库

工具类

package com.lihf.db;

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

public class DBUtil {

	private static final String URL ="jdbc:sqlserver://localhost:1433;" +
			"databaseName=test";
	private static final String NAME="ehs";
	private static final String PASSWORD="ehs";
	
	private static Connection conn = null;
	
	static{
		//1.加载驱动程序
		try {
			Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
			//2.获取数据库的链接
			conn = DriverManager.getConnection(URL, NAME, PASSWORD);
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}
	
	public static Connection getConnection(){
		return conn;
	}
	
	
	public static void main(String[] args) throws ClassNotFoundException, SQLException {
		//1.加载驱动程序
		Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
		//2.获取数据库的链接
		Connection conn = DriverManager.getConnection(URL, NAME, PASSWORD);
		//3.操作数据库
		Statement stmt = conn.createStatement();
		ResultSet rs = stmt.executeQuery("select user_name,age from imooc_goddess");
		while(rs.next()){
			System.out.println(rs.getString("user_name"));
			System.out.println(rs.getInt("age"));
		}
		
	}
}

Dao层

package com.lihf.dao;

import java.sql.CallableStatement;
import java.sql.Connection;
import java.sql.Da