📄 searchscore.jsp
字号:
<%@ page language="java" import="java.sql.*"%>
<%@ include file="change.jsp" %>
<%@ include file="author.jsp" %>
<%//request.setCharacterEncoding("gb2312");%>
<jsp:useBean id="linejdbc" scope="page" class="examinline.DBConnectionBean" />
<%linejdbc.setdrivername();%>
<html>
<head>
<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>
<%
String xh="";
String xm="";
String km="";
String str="";
boolean tag=false;
int id=0;
Connection conn = linejdbc.getopenConnection();
PreparedStatement ps;
//ResultSet result=null;
if (request.getParameter("id")!=null) id=Integer.parseInt(request.getParameter("id"));
/*if (id!=0)
{
String sqlstr="delete from score where id=?";
ps=conn.prepareStatement(sqlstr);
ps.setInt(1,id);
ps.executeUpdate();
}
sqlstr="select * from score";
ps=conn.prepareStatement(sqlstr);
result=ps.executeQuery();*/
if (request.getParameter("xh")!="") xh=request.getParameter("xh");
System.out.println("000000"+xh);
if (request.getParameter("xm")!="") xm=getGBString(request.getParameter("xm"));
System.out.print("11111"+xm);
if (request.getParameter("km")!="") km=getGBString(request.getParameter("km"));
System.out.print("22222222"+km);
if (xh.compareTo("")!=0 && (xm.compareTo("")==0) &&(km.compareTo("")==0))
{ //i=1;
str="select * from score where s_id like '"+xh+"'";
}
if (xh.compareTo("")!=0 && (xm.compareTo("")!=0) &&(km.compareTo("")!=0))
{ // i=2;
str="select * from score where s_id='"+xh+"' and s_name='"+xm+"' and subject='"+km+"'";
}
if (xh.compareTo("")!=0 && (xm.compareTo("")==0) &&(km.compareTo("")!=0))
{ //i=3;
str="select * from score where s_id='"+xh+"' and subject='"+km+"'";
}
if (xh.compareTo("")==0 && (xm.compareTo("")==0) &&(km.compareTo("")!=0))
{ //i=4;
str="select * from score where subject='"+km+"'";
}
if (xh.compareTo("")==0 && (xm.compareTo("")!=0) &&(km.compareTo("")==0))
{ //i=5;
str="select * from score where s_name='"+xm+"'";
}
if (xh.compareTo("")==0 && (xm.compareTo("")==0) &&(km.compareTo("")==0))
{ //i=6;
str="select * from score";
}
if (xh.compareTo("")!=0 && (xm.compareTo("")!=0) &&(km.compareTo("")==0))
{ //i=7;
str="select * from score where s_id='"+xh+"' and s_name='"+xm+"'";
}
if (xh.compareTo("")==0 && (xm.compareTo("")!=0) &&(km.compareTo("")!=0))
{ //i=8;
str="select * from score where s_name='"+xm+"' and subject='"+km+"'";
}
//Connection conn = linejdbc.getopenConnection();
ps=conn.prepareStatement(str);
ResultSet result=ps.executeQuery();
//Statement stmt=conn.createStatement();
//ResultSet result=stmt.executeQuery(str);
%>
<form action="forscore.jsp" method="post" name="formsearchscore" >
<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="22%" class="table">学号</td>
<td width="22%" class="table">姓名</td>
<td width="22%" class="table">科目</td>
<td width="22%" class="table">成绩</td>
</tr>
<%while (result.next())
{tag=true;%>
<tr align="center" class="table">
<td class="table"><%= result.getString("s_id") %> </td>
<td class="table"><%= result.getString("s_name") %> </td>
<td class="table"><%= result.getString("subject") %> </td>
<td class="table"><%= result.getInt("score") %> </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>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -