📄 searchstudent.jsp
字号:
<%@ page language="java" import="java.sql.*"%>
<%@ include file="author.jsp" %>
<jsp:useBean id="linejdbc" scope="page" class="examinline.DBConnectionBean" />
<%linejdbc.setdrivername();%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>查询删除学生信息</title>
<link href="../img/cssexamin.css" rel="stylesheet" type="text/css">
<style type="text/css">
<!--
.unnamed1 {
font-size: 12px;
font-weight: lighter;
color: #FF0000;
text-decoration: none;
}
-->
</style>
</head>
<body>
<%int id=0;
String sqlstr;
Connection conn = linejdbc.getopenConnection();
PreparedStatement ps;
ResultSet result=null;
/*if (request.getParameter("id")!=null) id=Integer.parseInt(request.getParameter("id"));
if (id!=0)
{
sqlstr="delete from student where id=?";
ps=conn.prepareStatement(sqlstr);
ps.setInt(1,id);
ps.executeUpdate();
//response.sendRedirect("addstudent.jsp");
}
sqlstr="select * from student";
ps=conn.prepareStatement(sqlstr);
result=ps.executeQuery();*/
String xh="";
String xm="";
//session.putValue("xh",xh);
//session.putValue("xm",xm);
//xh=(String)session.getValue("xh");
//xm=(String)session.getValue("xm");
ResultSet Qresult=null;
if (request.getParameter("xh")!="")
{xh=request.getParameter("xh");
}
if (request.getParameter("xm")!="")
{xm=request.getParameter("xm");
session.putValue("xm",xm);
}
if (xh.compareTo("")!=0 && (xm.compareTo("")==0))
{ ps=conn.prepareStatement("select * from student where s_id=?");
ps.setString(1,xh);
Qresult=ps.executeQuery();
}else
if(xh.compareTo("")==0 && (xm.compareTo("")!=0)){
ps=conn.prepareStatement("select * from student where s_name=?");
ps.setString(1,xm);
Qresult=ps.executeQuery();
}else
if((xh.compareTo(""))!=0 && (xm.compareTo("")!=0)){
ps=conn.prepareStatement("select * from student where s_name=? and s_id=? ");
ps.setString(1,xm);
ps.setString(2,xh);
Qresult=ps.executeQuery();
}else {
ps=conn.prepareStatement("select * from student");
Qresult=ps.executeQuery();}
%>
<form action="addstudent.jsp" method="post" name="formsearchstudent" >
<font color='#000000' size="5" ><div align="center">查询结果</div></font>
<p><br>
<table width="75%" border="0" align="center" class="table">
<tr align="center" class="table">
<td width="13%" class="table">学号</td>
<td width="13%" class="table">密码</td>
<td width="13%" class="table">姓名</td>
<td width="8%" class="table">性别</td>
<td width="30%" class="table">专业</td>
<td width="13%" class="table">年级</td>
<td width="10%" class="table">操作</td>
</tr>
<% boolean tag=false;
while(Qresult.next())
{tag=true;%>
<tr align="center" class="table">
<td class="table"><%= Qresult.getString("s_id") %> </td>
<td class="table"><%= Qresult.getString("s_paw") %> </td>
<td class="table"><%= Qresult.getString("s_name") %> </td>
<td class="table"><%= (Qresult.getString("sex")!=null?Qresult.getString("sex"):"") %> </td>
<td class="table"><%= (Qresult.getString("major")!=null?Qresult.getString("major"):"") %> </td>
<td class="table"><%= (Qresult.getString("grade")!=null?Qresult.getString("grade"):"") %> </td>
<input type="hidden" name="xh" value="<%=xh%>" >
<input type="hidden" name="xm" value="<%=xm%>" >
<td class="table"><a href="addstudent.jsp?id=<%=Qresult.getInt("id")%>">删除</a></td>
</tr>
<%
}
%>
<%if(!tag)
{
out.println("<br> </br>");
out.println("<br> </br>");
out.println("<br> </br>");
out.println("<p align='center'><font color='#000080'>Sorry,没有找到符合你要求的结果！！！</font></p>");
%><br><%}
%>
</table><p>
<div align="center"><input type="submit" name="Submit" value="返回"></div>
</form>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -