gz_dy_bm1.jsp

来自「JSP页面和oracle9i数据库的源代码」· JSP 代码 · 共 44 行

JSP
44
字号
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>输入部门</title>
</head>
<body>
<div align="center">
<jsp:useBean id="conn" scope="page" class="beans3.conn"/>
<%
String page_type=(String)session.getAttribute("page_type");
String page_name=(String)session.getAttribute("page_name");
if(page_type==null){page_type="";}
if(session.isNew()){response.sendRedirect("../index.jsp");}
else
{	if(!(page_type.equals("super")) && !page_type.equals("sgz"))
	{response.sendRedirect("../index.jsp");}	
}
%>
<%	
ResultSet rs=null;
String condition="select * from BM";
rs=conn.executeQuery(condition);
%>
</div>
<form name="form1" method="post" action="gz_dy_bm.jsp">
  <div align="center">请选择按那个部门查询:
  <select name="bm" id="select">
    <option value="0">部门</option>
    <%while(rs.next())
		  	   {%>
    <option value=<%=rs.getString("BM")%>><%=rs.getString("BM")%></option>
    <%}%>
  </select>
  <input type="submit" name="Submit" value="查询">
  <a href="../index/gz_index.jsp">返回主菜单</a></div>
</form>

</div>
			
              
</body>
</html>

⌨️ 快捷键说明

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