chaxun.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>查询界面</title>
</head>
<body>
<form action="" method="get">
<table align="center" border="1" width="500">
<tr>
<td>课程查询： </td>
<td>
<input type="text" name="classname"/>
</td>
</tr>
<tr>
<td>教师：</td>
<td>
<input type="text" name="teacher"/>
</td>
</tr>
<tr align="center">
<td colspan="2">
<input type="submit" value="查询"/>
</td>
</tr>
</table>
</form>
<%
request.setCharacterEncoding("UTF-8");
String name = request.getParameter("teacher");
String name1 = request.getParameter("classname");
if(true){
Class.forName("com.mysql.jdbc.Driver");
Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/runoob?seUnicode=true&characterEncoding=UTF-8","root","root");
Statement st = conn.createStatement();
ResultSet rs = st.executeQuery("select * from class where teacher ='" + name + "' or name='"+name1+"'");
out.print("<table border='1' align='center'>");
while (rs.next()) {
out.print("<tr>");
out.print("<td>" + rs.getInt("id") + "</td>");
out.print("<td>" + rs.getString("name") + "</td>");
out.print("<td>" + rs.getString("date") + "</td>");
out.print("<td>" + rs.getString("tip") + "</td>");
out.print("<td>" + rs.getString("teacher") + "</td>");
out.print("</tr>");
}
out.print("</table>");
rs.close();
st.close();
conn.close();
}
%>
</body>
</html>
标签：getString,rs,超级,print,课程表,close,out
From： https://www.cnblogs.com/cinan/p/16854964.html