（JSP运行在tomcat中，需要提前将tomcat和NetBeans进行连接，如果安装NetBeans的时候装了tomcat8也行）
<%@page contentType="text/html" pageEncoding="UTF-8"%>
<%@page language="java" import="java.sql.*" import="java.util.*" %>
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>JSP Page</title>
</head>
<body>
<%
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver").newInstance();
String url = "jdbc:sqlserver://127.0.0.1:1433;databaseName=strand";
String user="sa";
String password="123456";
//创建连接对象 Connection
Connection con = DriverManager.getConnection(url,user,password);
//构造Statement(语句)对象，传递SQL语句载体
//Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
Statement stmt = con.createStatement();
String sql = "select * from student ";
//返回结果集
ResultSet rs = stmt.executeQuery(sql);
while(rs.next()){
String name = rs.getString("name");
out.println(name+"<br>");
}
%>
<%
//关闭连接对象
rs.close();
stmt.close();
con.close();
%>
</body>
</html>
运行结果如图:
JSP连接SQLServer2014（NetBeans + tomcat）
原文：http://www.cnblogs.com/hcy1994/p/6241320.html