教学导入：
提问：回顾常见的数据查询结果显示在页面中如何完成？进一步思考常见的表单查询如何完成？
引入本节知识点：JDBC完成表单查询应用。
知识点：
Jsp页面设计Form表单，提供用户对于查询要求的输入。通过Connect、Statement、ResultSet的协同开发完成数据查询；数据查询结果在jsp页面显示。
案例：JDBC完成表单查询应用
通过jsp页面表单完成查询条件的输入，点击表单按钮，能够根据查询条件获得查询结果并能在页面显示查询结果。
Queryteacher.jsp:
<%@ page language="java"contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTDHTML 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>
<form action = "TeacherInfo.jsp"method = "post">
请输入待查询的教师姓名：<input type="text" name= "teacherName"></input>
<input type = "submit" value= "查询"></input>
</form>
</body>
</html>
Teacherinfo.jsp:
<%@ page language="java"contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%@page import="java.sql.*"%>
<!DOCTYPE html PUBLIC "-//W3C//DTDHTML 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>
<%
request.setCharacterEncoding("utf-8");
String name = request.getParameter("teacherName");
Stringurl = "jdbc:sqlserver://localhost;databaseName=salary";
try {
Connection con = DriverManager
.getConnection(url,"sa","123456");
Statement stmt = con.createStatement();
String sql = "select * from teacherinfo where teachername ='"+name+"'";
System.out.println(sql);
ResultSet rs = stmt
.executeQuery(sql);
while (rs.next()) {
%>
你要查询的教师信息如下：<br>
<%=rs.getString("tno")%>
<%=rs.getString("teachername")%>
<%=rs.getString("sex")%>
<%=rs.getInt("age")%>
<%=rs.getString("title")%>
<%
}
}catch(Exception ex) {
ex.printStackTrace();
}
%>
</body>
</html>
练习：
1.按编号查询教师信息
2.按姓查询教师信息
3.按姓名和性别查询教师信息
关键代码：
<form action = "TeacherInfo.jsp" method = "post">
按年龄段查询教师信息：<br>
起始年龄：<input type="text" name = "name"></input>
结束年龄：<input type="text" name = "sex"></input>
<input type = "submit" value = "查询"></input>
</form>
TeacherInfo.jsp:
<body>
<%
request.setCharacterEncoding("utf-8");
String name= request.getParameter("name");
String sex= request.getParameter("sex");
String url = "jdbc:sqlserver://localhost;databaseName=salary";
try {
Connection con = DriverManager
.getConnection(url, "sa", "123456");
Statement stmt = con.createStatement();
String sql = "SELECT * FROM teacherinfo where teachername='"+name+"' and sex ='"+sex+"'";
ResultSet rs = stmt.executeQuery(sql);
while (rs.next()) {
%>
你要查询的教师信息如下：<br>
<%=rs.getString("tno")%>
<%=rs.getString("teachername")%>
<%=rs.getString("sex")%>
<%=rs.getInt("age")%>
<%=rs.getString("title")%>
<%
}
} catch (Exception ex) {
ex.printStackTrace();
}
%>
</body>
