Java连接Sql server 2005 数据库

1.导入sqljdbc4.jar

2.

<%@page import="java.sql.SQLException"%>
<%@page import="java.sql.DriverManager"%>
<%@page import="java.sql.Statement"%>
<%@page import="java.sql.Connection"%>
<%@page import="java.sql.ResultSet"%>
<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%!//关闭资源
    private void check_close(Connection conn){
        try {
            if(conn!=null){
                conn.close();
            }
        } catch (SQLException e1) {
            e1.printStackTrace();
        }
    }
%>
<%
    Connection conn=null;
    Statement stmt=null;
    ResultSet rst=null;
    try{
        Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver").newInstance(); 
        conn= DriverManager.getConnection("jdbc:sqlserver://127.0.0.1:1433;DatabaseName=asdb","sa","123456");
        stmt=conn.createStatement();
        
        String tmpSql="select top 10 * from k_user ";
        
        rst=stmt.executeQuery(tmpSql);
        while(rst.next())
        {
            System.out.println(rst.getString("Name"));
        }
        
        //关闭连接、释放资源
        check_close(conn);
    }catch(Exception e){
        check_close(conn);
        e.printStackTrace();
    }finally{
        check_close(conn);
    }
%>