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、配置完数据库一定要重启一下数据库。
