///1.jsp
<%@ page contentType="text/html; charset=gb2312"%>
<%@page import="java.sql.*"%>
<%@page import="java.util.*"%>
<%@page import="com.hua.domain.StudentForm"%>
<script language="javascript">
function checkEmpty(){
if(document.ff.shu.value=="")
{
alert("您没有输入数据");
return false;
}
}
</script>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>赛为杯编程竞赛的后台</title>
</head>
<link href="css/css.css" rel="stylesheet" type="text/css">
<body>
<jsp:include page="bg_up.jsp" flush="true"/>
<table width="996" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="219" height="712"valign="top"><jsp:include page="bg_left.jsp" flush="true" /></td>
<td width="777" align="center" valign="top" bgcolor="#FFFFFF"> <br>
<table width="770" height="35" border="0" cellpadding="0"
cellspacing="0" background="images/bg_right03.jpg">
<tr>
<td>
<table width="772" border="1" cellspacing="1" cellpadding="1">
<tr>
<td width="50%" height="26" align="center">
<strong><a href="studentAction.do?action=19">查看学生初赛成绩</a></strong>
</td>
<td width="50%" align="center">
<strong><a href="#">发布参加决赛的名单</a></strong>
</td>
</tr>
</table></td>
</tr>
</table>
<p><br/>
<br/>
</p>
<form name="ff" method="post" action="studentAction.do?action=37" onSubmit="return checkEmpty()">
<p> 根据初赛的成绩,取前
<input type="text" name="shu">
名进入决赛</p>
<p> </p>
<input type="submit" value="确定">
<input type="button" onClick="javasrcipt:history.go(-1)"value="取消">
</form>
<p> </p>
</table>
<jsp:include page="bg_down.jsp" flush="true" />
</body>
</html>
///
数据库语句:
public ActionForward bg_fabujuesainame(ActionMapping mapping, ActionForm form,
HttpServletRequest request, HttpServletResponse response) {
Integer num=Integer.valueOf(request.getParameter("shu"));
List list = dao.bg_fabujuesainame(num);
int pageNumber = list.size(); // 计算出有多少条记录
int maxPage = pageNumber; // 计算有多少页数
String number = request.getParameter("i");
if (maxPage % 16 == 0) {
maxPage = maxPage / 16;
} else {
maxPage = maxPage / 16 + 1;
}
if (number == null) {
number = "0";
}
request.getSession().setAttribute("test",list);
request.setAttribute("number", String.valueOf(number));
request.setAttribute("maxPage", String.valueOf(maxPage));
request.setAttribute("pageNumber", String.valueOf(pageNumber));
request.setAttribute("list", list);
return mapping.findForward("bg_fabujuesainame");
}
、、、、、、、、、、、、、、、、、、、、、、、、、、、、、、、、、、、、、、、、、、、、、、、、、、
//全部查询信息操作
public List bg_fabujuesainame(Integer num) {
List list = new ArrayList();
StudentForm member = null;
int temp = num;
try{ String sql = "SELECT TOP " + String.valueOf(temp) + " * from tb_student order by yu_score DESC";
//ps = connection.prepareStatement("select * from tb_student order by id ASC");
ps = connection.prepareStatement(sql);
ResultSet rs = ps.executeQuery();
while (rs.next()) {
member = new StudentForm();
member.setId(Integer.valueOf(rs.getString(1)));
member.setSno(rs.getString(2));
member.setSname(rs.getString(3));
member.setSclass(rs.getString(4));
member.setSdept(rs.getString(5));
member.setYu_score(Integer.valueOf(rs.getString(6)));
member.setJue_score(Integer.valueOf(rs.getString(7)));
member.setStatus(Integer.valueOf(rs.getString(8)));
member.setAward(rs.getString(9));
list.add(member);
}
}catch(SQLException ex){
}
return list;
}