一、实验目的 掌握怎样使用JSP连接Mysql |
二、实验项目内容(实验题目) 编写代码,掌握JSP连接Mysql。 |
三、源代码以及执行结果截图: 源代码: inputNumber.jsp: <%@ page language="java" contentType="text/html; charset=utf-8" pageEncoding="utf-8"%> <!DOCTYPE html> <style> #tom{ font-family:宋体;font-size:28;color:black } </style> <html> <head> <meta charset="utf-8"> <title>Insert title here</title> </head> <body bgcolor=#ffccff> <form action="queryShow.jsp" id=tom method=post> 输入学号或者姓名查询成绩:<br> <input type="text" id=tom name="mess"/><br> <input type="submit" id=tom name="submit" value="按姓名查询"/> <input type="submit" id=tom name="submit" value="按学号查询"/> </form> </body> </html> queryShow.jsp: <%@ page contentType= "text/html" pageEncoding = "utf-8"%> <%@ page import="java.sql.*" %> <!DOCTYPE html> <style> #tom{ font-family:宋体;font-size:18;color:blue } </style> <html> <head> <meta charset="utf-8"> <title>Insert title here</title> </head> <body bgcolor=#EEDDFF> <% request.setCharacterEncoding("utf-8"); String mess = request.getParameter("mess"); mess = mess.trim(); String submit = request.getParameter("submit"); out.print(submit); if(mess.length() == 0){ response.sendRedirect("inputNumber.jsp"); return; } Connection con=null; Statement sql; ResultSet rs; try{ Class.forName("com.mysql.cj.jdbc.Driver"); } catch(Exception e){ out.print("<h1>"+e); } String url = "jdbc:mysql://localhost:3306/Student?useSSL=false&serverTimezone=CST&characterEncoding=utf-8"; String user ="root"; String password ="root"; out.print("<table border=1>"); out.print("<tr>"); out.print("<th id=tom width=100>"+"学号"); out.print("<th id=tom width=100>"+"姓名"); out.print("<th id=tom width=50>"+"数学成绩"); out.print("<th id=tom width=50>"+"英语成绩"); out.print("</tr>"); try{ con = DriverManager.getConnection(url,user,password); sql=con.createStatement(); String SQL = null; if(submit.contains("姓名")){ SQL = "SELECT * FROM score_report where name like '%"+mess+"%'"; } else if(submit.contains("学号")){ SQL = "SELECT * FROM score_report where id='"+mess+"'"; } rs=sql.executeQuery(SQL); while(rs.next()) { out.print("<tr>"); out.print("<td id=tom>"+rs.getString(1)+"</td>"); out.print("<td id=tom>"+rs.getString(2)+"</td>"); out.print("<td id=tom>"+rs.getInt(3)+"</td>"); out.print("<td id=tom>"+rs.getInt(4)+"</td>"); out.print("</tr>") ; } out.print("</table>"); con.close(); } catch(SQLException e) { out.print("<h1>"+e); } %> </body> </html> (空间不够,可加附页) |