adminq1.jsp

来自「用JSP+SQL开发的在线考试系统..希望可以帮到一些人」· JSP 代码 · 共 43 行

JSP
43
字号
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<%@ page contentType="text/html; charset=gb2312"%>
<%@ page language="java" import="java.sql.*"%>
<jsp:useBean id="dep1" scope="page" class="exam.exam"/>
<%
String sql1="select * from departmen";
ResultSet rs1=dep1.executeQuery(sql1);
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>查询学生</title>
</head>

<body BGCOLOR=#0D85A6 BACKGROUND="images/bg.gif" text="#000000">
<table width="102%" border="0" cellspacing="0" cellpadding="0" >
  <tr>
              <td align="center"> 
                  <form action="adminq2.jsp" method="post" name="form1" target="mainFrame" >
                    <div align="center"> 
                      <p>学号<input type="text" size="15" name="id">
						 姓名<input type="text" size="10" name="sname">
						 系别
						<select name="dep"> 
                          <option value="">请选择..</option>
                          <%
							while(rs1.next())
							{
							int num=rs1.getInt("dep");
							String depname=rs1.getString("depname");
							%>
                          <option value="<%=num%>"><%=depname%></option>
                          <%}%>
                        </select>
						<input type="submit" name="Submit" value="查  询">
                            </p>
                    </div>
                  </form>
             </td>
  </tr>
</table>
</body>
</html>

⌨️ 快捷键说明

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