xuefen.jsp

来自「该源码为JSP的开发案例集锦」· JSP 代码 · 共 42 行

JSP
42
字号
<%@ page contentType="text/html;charset=GB2312" %>
<%@ include file="share/connection.jsp" %>
<HTML>
<BODY>
<% //获取提交的学分的最大、最小值:
    String xuefenmax=request.getParameter("xuefenmax");
    if(xuefenmax==null){
        xuefenmax="100";
    }
    String xuefenmin=request.getParameter("xuefenmin");
    if(xuefenmin==null){
        xuefenmin="0";
    }
    String Condi="学分 <= "+xuefenmax+" AND "+"学分 >= "+xuefenmin;
    String condition="SELECT * FROM ADMINISTRATOR.student AS STUDENT WHERE "+Condi;
    ResultSet rs=stm.executeQuery(condition);
%>
	<CENTER>
	输出<%=Condi%>的学生信息:<BR>
	<TABLE border="" bgcolor="#74bbc0">
		<TBODY>
			<TR>
				<TH width="100">学号</TH>
				<TH width="100">姓名</TH>
				<TH width="50">学分</TH>
			</TR>
<%  while(rs.next()){%>
 			<TR align="center">
				<TD><%=rs.getString(1)%></TD>
				<TD><%=rs.getString(2)%></TD>
				<TD><%=rs.getInt(3)%></TD>
			</TR>
<%  }%>
		</TBODY>
	</TABLE>
	</CENTER>
<%
     Conn.close();
 %>
</BODY>
</HTML>

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?