数据库技术A实验三--使用动态网页显示数据库表信息-CSDN博客

本文链接：https://blog.csdn.net/weixin_57107807/article/details/127785527

说明：新建webLearn动态网页项目，新增deptView.jsp和deptView.java.并修改相关代码片段的参数至符合自己项目结构的要求。

deptView.jsp:

<%@ page language="java" contentType="text/html; charset=utf-8"
    pageEncoding="utf-8" import="java.sql.*" %>
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<title>Jsp网页deptView.jsp</title>
</head>
<body>
SQLserver2019 study2 学生表：
<table border = "1">
<tr>
<td>学号</td>
<td>年级</td>
<td>班级</td>
<td>姓名</td>
<td>性别</td>
<td>民族</td>
<td>来源</td>
<td>校区</td>
</tr>
<%
String url = "jdbc:sqlserver://localhost:10086;DatabaseName=study2";
Connection con = null;
Statement stmt=null;
String query="SELECT * FROM student";
try{
	//加载jdbc驱动程序
	Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
	//建立连接
	con=DriverManager.getConnection(url,"sa1","202005295");
	//创建Statement语句
	stmt=con.createStatement();
	//执行SQL语句
	ResultSet rs=stmt.executeQuery(query);
	while (rs.next()){
		//通过循环语句检索结果
		String ID = rs.getString(1);
		String GRADE = rs.getString(2);
		String CLASS = rs.getString(3);
		String NAME = rs.getString(4);
		String SEX = rs.getString(5);
		String MINZU = rs.getString(6);
		String LAIYUAN = rs.getString(7);
		String XIAOQU = rs.getString(8);
		out.println("<tr><td>"+ID+"</td><td>"+GRADE+"</td><td>"+CLASS+"</td><td>"+NAME+"</td><td>"+SEX+"</td><td>"+MINZU+"</td><td>"+LAIYUAN+"</td><td>"+XIAOQU+"</td></tr>");
	}
}catch (ClassNotFoundException e){
	out.print("类没有找到异常：");
	out.println(e.getMessage());
	
}catch (SQLException e){
	out.println("SQL异常："+e.getMessage());
}finally{
	if (stmt != null){
		try{
			stmt.close();
		}catch (SQLException e){
			
		}
		stmt=null;
	}
	if (con != null){
		try{
			con.close();//关闭连接
		}catch (SQLException e){
			
		}
		con = null;
	}
}
%>
</table>
</body>
</html>

deptView.java:

package Servlet;
import java.sql.*;
import java.io.IOException;
import java.io.PrintWriter;
import java.net.ConnectException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

/**
 * Servlet implementation class deptView_do
 */
@WebServlet("/deptView.do")
public class deptView extends HttpServlet {
	private static final long serialVersionUID = 1L;
       
    /**
     * @see HttpServlet#HttpServlet()
     */
    public deptView() {
        super();
        // TODO Auto-generated constructor stub
    }

	/**
	 * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
	 */
	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		// TODO Auto-generated method stub
		//返回内容
		//response.getWriter().append("Served at: ").append(request.getContextPath());
		response.setContentType("text/html;charset=UTF-8");
		PrintWriter writer=response.getWriter();
		writer.println("<!DOCTYPE html>");
		writer.println("<html lang='en'>");
		writer.println("<head>");
		writer.println("<meta charset='UTF-8'>");
		writer.println("<meta http-equiv='X-UA-Compatible' content='IE=edge'>");
		writer.println("<meta name='viewport' content='width=device-width, initial-scale=1.0'>");
		writer.println("<title>Servlet网页deptView.do</title>");
		writer.println("</head>");
		writer.println("<body>");
		writer.println("SQLserver2019 study2 单位表：");
		writer.println("<table border=1> <!-- 表头 --> <thead><tr><th>单位编号</th><th>单位名称</th></tr></thead> <!--表身--><tbody>");
		//动态网页结构
		//连接数据库
		String driverName="com.microsoft.sqlserver.jdbc.SQLServerDriver";
		  String dbURL="jdbc:sqlserver://localhost:10086;DatabaseName=study2";
		  String userName="sa1";
		  String userPwd="202005295";
		 try
		{
		    Class.forName(driverName);
		    System.out.println("加载驱动成功！");
		}catch(Exception e){
		    e.printStackTrace();
		    System.out.println("加载驱动失败！");
		};
		try{
		    Connection dbConn = DriverManager.getConnection(dbURL,userName,userPwd);
		        System.out.println("连接数据库成功！");
		        //Connection con = DriverManager.getConnection(dbURL, "sa1","202005295");
		        Statement statement = dbConn.createStatement();
		        ResultSet rs = statement.executeQuery("select * from 单位表$");
		        while (rs.next()) {
		        	writer.println("<tr><td>" + rs.getString(1) + "</td><td>" + rs.getString(2) + "</td></tr>");
		            };
		}catch(Exception e)
		{
		    e.printStackTrace();
		    System.out.print("SQL Server连接失败！");
		};	
		writer.println("</tbody>");
		writer.println("</body>");
		writer.println("</html>");
		writer.close();
	}

	/**
	 * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
	 */
	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		// TODO Auto-generated method stub
		doGet(request, response);
	}

}