java，jsp连接SQL Server 2008r2数据库。

1

2、SQL Server 2008 r2按上面虚讨那个指导教程默认配置;

关独杰于java相关配置不再详述，直丽关舍接开门见山，看图操作。

1、Example.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"

pageEncoding="UTF-8"%>

<%@ page import="java.sql.*"%>

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">

<html>

<head>

<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">

<title>Insert title here</title>

</head>

<body>

<%

Connection con = null;

Statement sql = null;

ResultSet rs = null;

try {

Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");

} catch (ClassNotFoundException e) {

}

String url = "jdbc:sqlserver://127.0.0.1:1433;DatabaseName=pubs";

con = DriverManager.getConnection(url, "sa", "root");

sql = con.createStatement();

rs = sql.executeQuery("select * from students");

out.print("<table border='1'>");

out.print("<tr>");

out.print("<th width='100'>学号");

out.print("<th width='100'>姓名");

out.print("<th width='100'>数学成绩");

out.print("<th width='100'>英语成绩");

out.print("<th width='100'>物理成绩");

out.print("</tr>");

while (rs.next()) {

out.print("<tr>");

out.print("<td>" + rs.getString(1) + "</td>");

out.print("<td>" + rs.getString(2) + "</td>");

out.print("<td>" + rs.getString(3) + "</td>");

out.print("<td>" + rs.getString(4) + "</td>");

out.print("<td>" + rs.getString(5) + "</td>");

out.print("</tr>");

}

out.print("</table>");

con.close();

%>

</body>

</html>

至此，jsp操作SQL Server 2008 r2数据库完成。

2、配置完数据库一定要重启一下数据库。