⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 main.jsp

📁 “JSP数据库项目案例导航”一书从第一章到第十一章各章实例的源程序文件以及数据库文件。 注意： 1. 本书中的案例提供的数据库环境不同
💻 JSP
字号:
🔍 
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<jsp:useBean id='db' scope='request' class='Base.DataBean.DefaultDataBean' />
<html>
<head>
<link rel=stylesheet href="../../index.css" type="text/css">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>无标题文档</title>
</head>

<body>
<form name="form1" method="post" action="">
  <table width="100%"  border="0" cellpadding="0" cellspacing="0">
    <tr>
      <td width="40">&nbsp;</td>
      <td width="910"><table width="100%" height="20"  border="0" cellpadding="0" cellspacing="0">
          <tr>
            <td height="20" class="title_s"><img src="../pics/login.gif" width=50>&nbsp;欢迎您>><%=(String)session.getAttribute("NAME")%> </td>
          </tr>
          <tr>
            <td height="5" bgcolor="#C8F8BA"></td>
          </tr>
          <tr>
            <td height="1" bgcolor="#2E990F"></td>
          </tr>
      </table></td>
      <td width="50">&nbsp;</td>
    </tr>
  </table>
  <table width="100%"  border="0" cellpadding="0" cellspacing="0">
    <tr>
      <td width="40">&nbsp;</td>
      <td width="910">
        <table class="main_w" width="100%"  border="1" cellpadding="4" cellspacing="0" bordercolor="FFFFFF" bgcolor="E8FCE2">
        <tr bgcolor="#FFFFFF" class="title_s">
          <td height="20" colspan="4"><div align="center">系所配置界面 </div></td>
        </tr>
		  <tr class="title_s">
		    <td height="20" colspan="4"><div align="center"><a href="newdepartment.cgi">添加新部门</a></div></td>
	      </tr>
		  <tr class="title_s">
            <td height="20"><div align="center">部门名称</div></td>
            <td height="20"><div align="center">上级单位</div></td>
            <td><div align="center">修改</div></td>
            <td height="20"><div align="center">删除</div></td>
          </tr>
		  <%
		  for(int i=0;i<db.getCount("department");i++){
		  %>
          
          <tr>
            <td height="20"><div align="center"><%= db.getAttributeStr("department.name",i)%></div></td>
            <td height="20"><div align="center">
			<%
			for(int j=0;j<db.getCount("college");j++){
			if(db.getAttributeStr("college.id",j).equals(db.getAttributeStr("department.college",i))){
			%>
			<%= db.getAttributeStr("college.name",j)%>
			<%
			}
			}
			%>
			</div></td>
            <td><div align="center"><a href="modify.cgi?id=<%= db.getAttributeStr("department.id",i)%>">修改</a></div></td>
            <td height="20"><div align="center"><a href="deletedepartment.cgi?id=<%= db.getAttributeStr("department.id",i)%>">删除</a></div></td>
          </tr>
		  <%
		  }
		  %>
      </table></td>
      <td width="50">&nbsp;</td>
    </tr>
  </table>
  <p>&nbsp;</p>
</form>
</body>
</html>

⌨️ 快捷键说明

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