rs = null;
}
if(stat != null)
{
stat.close();
stat = null;
}
if(conn != null)
{
conn.close();
conn = null;
}
%>
select_for_id.jsp
<%@ page language=“java” import=“java.util.*” pageEncoding=“UTF-8”%>
<%@ page import=“java.sql.*”%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+“😕/”+request.getServerName()+“:”+request.getServerPort()+path+“/”;
%>
<%
request.setCharacterEncoding(“UTF-8”);
String id = request.getParameter(“id”);
Connection conn = null;
Statement stat = null;
ResultSet rs = null;
Class.forName(“com.mysql.jdbc.Driver”);
String url = “jdbc:mysql://localhost:3306/jsp”;
String user = “root”;
String password = “root”;
conn = DriverManager.getConnection(url,user,password);
stat = conn.createStatement();
rs = stat.executeQuery(“select * from student where id=” + id + “”);
%>
符合条件的学生信息
<%
if(rs.next())
{
out.print(“”);
out.print(“” + rs.getInt(“id”) + “”);
out.print(“” + rs.getString(“name”) + “”);
out.print(“” + rs.getInt(“age”) + “”);
out.print(“” + rs.getString(“gender”) + “”);
out.print(“” + rs.getString(“major”) + “”);
%>
<%
out.print(“”);
}
else{
out.print(“
不存在此条件的信息!
”);}
%>
返回查询页面
<%
if(rs != null)
{
rs.close();
rs = null;
}
if(stat != null)
{
stat.close();
stat = null;
}
if(conn != null)
{
conn.close();
conn = null;
}
%>
select_for_major.jsp
<%@ page language=“java” import=“java.util.*” pageEncoding=“UTF-8”%>
<%@ page import=“java.sql.*”%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+“😕/”+request.getServerName()+“:”+request.getServerPort()+path+“/”;
%>
<%
request.setCharacterEncoding(“UTF-8”);
// String id=request.getParameter(“id”);
// String name=request.getParameter(“name”);
// String age=request.getParameter(“age”);
// String gender=request.getParameter(“gender”);
String major=request.getParameter(“major”);
//major=;
Connection conn = null;
Statement stat = null;
ResultSet rs = null;
Class.forName(“com.mysql.jdbc.Driver”);
String url = “jdbc:mysql://localhost:3306/jsp”;
String user = “root”;
String password = “root”;
conn = DriverManager.getConnection(url,user,password);
stat = conn.createStatement();
rs = stat.executeQuery(“select * from student where major='” + major + “'”);
%>
符合条件的学生信息
<%
while(rs.next())
{
out.print(“”);
out.print(“” + rs.getInt(“id”) + “”);
out.print(“” + rs.getString(“name”) + “”);
out.print(“” + rs.getInt(“age”) + “”);
out.print(“” + rs.getString(“gender”) + “”);
out.print(“” + rs.getString(“major”) + “”);
%>
<%
out.print(“”);
}
%>
返回查询页面
<%
if(rs != null)
{
rs.close();
rs = null;
}
if(stat != null)
{
stat.close();
stat = null;
}
if(conn != null)
{
conn.close();
conn = null;
}
%>
select_for_name.jsp
<%@ page language=“java” import=“java.util.*” pageEncoding=“UTF-8”%>
<%@ page import=“java.sql.*”%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+“😕/”+request.getServerName()+“:”+request.getServerPort()+path+“/”;
%>
<%
request.setCharacterEncoding(“UTF-8”);
String name = request.getParameter(“name”);
Connection conn = null;
Statement stat = null;
ResultSet rs = null;
Class.forName(“com.mysql.jdbc.Driver”);
String url=“jdbc:mysql://localhost:3306/jsp”;
String user = “root”;
String password = “root”;
conn = DriverManager.getConnection(url,user,password);
stat = conn.createStatement();
rs = stat.executeQuery(“select * from student where name='” + name + “'”);
%>
符合条件的学生信息
<%
while(rs.next())
{
out.print(“”);
out.print(“” + rs.getInt(“id”) + “”);
out.print(“” + rs.getString(“name”) + “”);
out.print(“” + rs.getInt(“age”) + “”);
out.print(“” + rs.getString(“gender”) + “”);
out.print(“” + rs.getString(“major”) + “”);
%>
<%
out.print(“”);
}
%>
返回查询页面
<%
if(rs != null)
{
rs.close();
rs = null;
}
if(stat != null)
{
stat.close();
stat = null;
}
if(conn != null)
{
conn.close();
conn = null;
}
%>
showInfo.jsp
<%@ page language=“java” import=“java.util.*” pageEncoding=“UTF-8”%>
<%@ page import=“java.sql.*”%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+“😕/”+request.getServerName()+“:”+request.getServerPort()+path+“/”;
%>
<%
response.setCharacterEncoding(“UTF-8”);
request.setCharacterEncoding(“UTF-8”);
String id = request.getParameter(“id”);
String name = request.getParameter(“name”);
String age = request.getParameter(“age”);
String gender = request.getParameter(“gender”);
String major = request.getParameter(“major”);
Connection conn = null;
Statement stat = null;
ResultSet rs = null;
Class.forName(“com.mysql.jdbc.Driver”);
String url = “jdbc:mysql://localhost:3306/jsp”;
String user = “root”;
String password = “root”;
conn = DriverManager.getConnection(url,user,password);
stat = conn.createStatement();
rs = stat.executeQuery(“select * from student”);
%>
学生信息
全部学生信息如下
<%
while(rs.next())
{
out.print(“”);
out.print(“” + rs.getInt(“id”) + “”);
out.print(“” + rs.getString(“name”) + “”);
out.print(“” + rs.getInt(“age”) + “”);
out.print(“” + rs.getString(“gender”) + “”);
out.print(“” + rs.getString(“major”) + “”);
%>
<%
out.print(“”);
}
%>
按学号查询:
按姓名查询:
按年龄查询:
按性别查询:
按专业查询:
返回添加学生信息页面
<%
if(rs != null)
{
rs.close();
rs = null;
}
if(stat != null)
{