SQL 语句，输入N，取出前N个数据方法

最新推荐文章于 2022-08-09 11:38:38 发布

huahuahailang

最新推荐文章于 2022-08-09 11:38:38 发布

阅读量822

点赞数

分类专栏： SQL 文章标签： sql list include integer stylesheet border

本文链接：https://blog.csdn.net/huahuahailang/article/details/7562265

版权

SQL 专栏收录该内容

2 篇文章 0 订阅

订阅专栏

///1.jsp

<%@ page contentType="text/html; charset=gb2312"%>
<%@page import="java.sql.*"%>
<%@page import="java.util.*"%>
<%@page import="com.hua.domain.StudentForm"%>

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;
   }

huahuahailang

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
SQL 语句，输入N，取出前N个数据方法

///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////1.jsp%@page import="java.sql.*"%>%@pa
复制链接

扫一扫

专栏目录