select_for_age.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+"/";
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<base href="<%=basePath%>">
<title>按年龄查询</title>
<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="expires" content="0">
<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
<meta http-equiv="description" content="This is my page">
<!--
<link rel="stylesheet" type="text/css" href="styles.css">
-->
</head>
<body background="pic/background.jpg">
<%
request.setCharacterEncoding("UTF-8");
String age = request.getParameter("age");
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 age=" + age + "");
%>
<br>
<h3>符合条件的学生信息</h3><hr>
<br>
<table width="450" border="100" cellSpacing=1 style="font-size:15pt;border:dashed 1pt">
<tr>
<td>学号</td>
<td>姓名</td>
<td>年龄</td>
<td>性别</td>
<td>专业</td>
</tr>
<%
while(rs.next())
{
out.print("<tr>");
out.print("<td>" + rs.getInt("id") + "</td>");
out.print("<td>" + rs.getString("name") + "</td>");
out.print("<td>" + rs.getInt("age") + "</td>");
out.print("<td>" + rs.getString("gender") + "</td>");
out.print("<td>" + rs.getString("major") + "</td>");
%>
<td><a href="delete.jsp?id=<%=rs.getInt("id") %>">删除</a></td>
<td><a href="update.jsp?id=<%=rs.getInt("id") %>">修改</a></td>
<%
out.print("</tr>");
}
%>
</table>
<br>
<br>
<h4><a href=showInfo.jsp>返回查询页面</a></h4>
<%
if(rs != null)
{
rs.close();
rs = null;
}
if(stat != null)
{
stat.close();
stat = null;
}
if(conn != null)
{
conn.close();
conn = null;
}
%>
</body>
</html>
select_for_gender
<%@ 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+"/";
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<base href="<%=basePath%>">
<title>按性别查询</title>
<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="expires" content="0">
<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
<meta http-equiv="description" content="This is my page">
<!--
<link rel="stylesheet" type="text/css" href="styles.css">
-->
</head>
<body background="pic/background.jpg">
<%
request.setCharacterEncoding("UTF-8");
String gender = request.getParameter("gender");
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 gender='" + gender + "'");
%>
<br>
<h3>符合条件的学生信息</h3><hr>
<br>
<table width="450" border="100" cellSpacing=1 style="font-size:15pt;border:dashed 1pt">
<tr>
<td>学号</td>
<td>姓名</td>
<td>年龄</td>
<td>性别</td>
<td>专业</td>
</tr>
<%
while(rs.next())
{
out.print("<tr>");
out.print("<td>" + rs.getInt("id") + "</td>");
out.print("<td>" + rs.getString("name") + "</td>");
out.print("<td>" + rs.getInt("age") + "</td>");
out.print("<td>" + rs.getString("gender") + "</td>");
out.print("<td>" + rs.getString("major") + "</td>");
%>
<td><a href="delete.jsp?id=<%=rs.getInt("id") %>">删除</a></td>
<td><a href="update.jsp?id=<%=rs.getInt("id") %>">修改</a></td>
<%
out.print("</tr>");
}
%>
</table>
<br>
<br>
<h4><a href=showInfo.jsp>返回查询页面</a></h4>
<%
if(rs != null)
{
rs.close();
rs = null;
}
if(stat != null)
{
stat.close();
stat = null;
}
if(conn != null)
{
conn.close();
conn = null;
}
%>
</body>
</html>
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+"/";
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<base href="<%=basePath%>">
<title>按学号条件查询</title>
<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="expires" content="0">
<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
<meta http-equiv="description" content="This is my page">
<!--
<link rel="stylesheet" type="text/css" href="styles.css">
-->
</head>
<body background="pic/background.jpg">
<%
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 + "");
%>
<br>
<h3>符合条件的学生信息</h3><hr>
<br>
<table width="450" border="100" cellSpacing=1 style="font-size:15pt;border:dashed 1pt">
<tr>
<td>学号</td>
<td>姓名</td>
<td>年龄</td>
<td>性别</td>
<td>专业</td>
</tr>
<%
if(rs.next())
{
out.print("<tr>");
out.print("<td>" + rs.getInt("id") + "</td>");
out.print("<td>" + rs.getString("name") + "</td>");
out.print("<td>" + rs.getInt("age") + "</td>");
out.print("<td>" + rs.getString("gender") + "</td>");
out.print("<td>" + rs.getString("major") + "</td>");
%>
<td><a href="delete.jsp?id=<%=rs.getInt("id") %>">删除</a></td>
<td><a href="update.jsp?id=<%=rs.getInt("id") %>">修改</a></td>
<%
out.print("</tr>");
}
else{
out.print("<h4>不存在此条件的信息！</h4>");
}
%>
</table>
<br>
<br>
<h4><a href=showInfo.jsp>返回查询页面</a></h4>
<%
if(rs != null)
{
rs.close();
rs = null;
}
if(stat != null)
{
stat.close();
stat = null;
}
if(conn != null)
{
conn.close();
conn = null;
}
%>
</body>
</html>
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+"/";
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<base href="<%=basePath%>">
<title>按专业查询</title>
<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="expires" content="0">
<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
<meta http-equiv="description" content="This is my page">
<!--
<link rel="stylesheet" type="text/css" href="styles.css">
-->
</head>
<body background="pic/background.jpg">
<%
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 + "'");
%>
<br>
<h3>符合条件的学生信息</h3><hr>
<br>
<table width="450" border="100" cellSpacing=1 style="font-size:15pt;border:dashed 1pt">
<tr>
<td>学号</td>
<td>姓名</td>
<td>年龄</td>
<td>性别</td>
<td>专业</td>
</tr>
<%
while(rs.next())
{
out.print("<tr>");
out.print("<td>" + rs.getInt("id") + "</td>");
out.print("<td>" + rs.getString("name") + "</td>");
out.print("<td>" + rs.getInt("age") + "</td>");
out.print("<td>" + rs.getString("gender") + "</td>");
out.print("<td>" + rs.getString("major") + "</td>");
%>
<td> <a href="delete.jsp?id=<%=rs.getInt("id") %>">删除</a></td>
<td><a href="update.jsp?id=<%=rs.getInt("id") %>">修改</a></td>
<%
out.print("</tr>");
}
%>
</table>
<br>
<br>
<h4><a href=showInfo.jsp>返回查询页面</a></h4>
<%
if(rs != null)
{
rs.close();
rs = null;
}
if(stat != null)
{
stat.close();
stat = null;
}
if(conn != null)
{
conn.close();
conn = null;
}
%>
</body>
</html>
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+"/";
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<base href="<%=basePath%>">
<title>按姓名查询</title>
<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="expires" content="0">
<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
<meta http-equiv="description" content="This is my page">
<!--
<link rel="stylesheet" type="text/css" href="styles.css">
-->
</head>
<body background="pic/background.jpg">
<%
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 + "'");
%>
<br>
<h3>符合条件的学生信息</h3><hr>
<br>
<table width="450" border="100" cellSpacing=1 style="font-size:15pt;border:dashed 1pt">
<tr>
<td>学号</td>
<td>姓名</td>
<td>年龄</td>
<td>性别</td>
<td>专业</td>
</tr>
<%
while(rs.next())
{
out.print("<tr>");
out.print("<td>" + rs.getInt("id") + "</td>");
out.print("<td>" + rs.getString("name") + "</td>");
out.print("<td>" + rs.getInt("age") + "</td>");
out.print("<td>" + rs.getString("gender") + "</td>");
out.print("<td>" + rs.getString("major") + "</td>");
%>
<td><a href="delete.jsp?id=<%=rs.getInt("id") %>">删除</a></td>
<td><a href="update.jsp?id=<%=rs.getInt("id") %>">修改</a></td>
<%
out.print("</tr>");
}
%>
</table>
<br>
<br>
<h4><a href=showInfo.jsp>返回查询页面</a></h4>
<%
if(rs != null)
{
rs.close();
rs = null;
}
if(stat != null)
{
stat.close();
stat = null;
}
if(conn != null)
{
conn.close();
conn = null;
}
%>
</body>
</html>
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+"/";
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<base href="<%=basePath%>">
<title>学生信息</title>
<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="expires" content="0">
<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
<meta http-equiv="description" content="This is my page">
<!--
<link rel="stylesheet" type="text/css" href="styles.css">
-->
</head>
<body background="pic/background.jpg">
<%
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");
%>
<br>
<h2>学生信息</h2> <hr>
<br>
<h3>全部学生信息如下</h3>
<table width="450" border="100" cellSpacing=3 style="font-size:15pt;border:dashed 1pt">
<tr>
<td>学号</td>
<td>姓名</td>
<td>年龄</td>
<td>性别</td>
<td>专业</td>
</tr>
<%
while(rs.next())
{
out.print("<tr>");
out.print("<td>" + rs.getInt("id") + "</td>");
out.print("<td>" + rs.getString("name") + "</td>");
out.print("<td>" + rs.getInt("age") + "</td>");
out.print("<td>" + rs.getString("gender") + "</td>");
out.print("<td>" + rs.getString("major") + "</td>");
%>
<td><a href="delete.jsp?id=<%=rs.getInt("id") %>">删除</a></td>
<td><a href="update.jsp?id=<%=rs.getInt("id") %>">修改</a></td>
<%
out.print("</tr>");
}
%>
</table>
<br>
<form action="select_for_id.jsp" method="post">
<h3>按学号查询:<input type="text" name="id" value="" title="学号不能为空" ></input>
<input type="submit" value="查询"/></h3>
<br>
</form>
<form action="select_for_name.jsp" method="post">
<h3>按姓名查询:<input type="text" name="name" value="" title="姓名不能为空"></input>
<input type="submit" value="查询" /></h3>
<br>
</form>
<form action="select_for_age.jsp" method="post">
<h3> 按年龄查询:<input type="text" name="age" value="" title="年龄不能为空"></input>
<input type="submit" value="查询"/></h3>
<br>
</form>
<form action="select_for_gender.jsp" method="post">
<h3> 按性别查询:<input type="text" name="gender" value="" title="性别不能为空"></input>
<input type="submit" value="查询"/></h3>
<br>
</form>
<form action="select_for_major.jsp" method="post">
<h3> 按专业查询:<input type="text" name="major" value="" title="专业不能为空"></input>
<input type="submit" value="查询"/></h3>
<br>
</form>
<br>
<h3><a href=addStuInfo.jsp>返回添加学生信息页面</a></h3>
<br>
<%
if(rs != null)
{
rs.close();
rs = null;
}
if(stat != null)
{
stat.close();
stat = null;
}
if(conn != null)
{
conn.close();
conn = null;
}
%>
</body>
</html>
楼主QQ：496056171
