?? getdba.jsp
字號:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="errorpage.jsp" %>
<%@ page import="myBeans.SQLBean"%>
<html>
<head>
<link href="Inc/student_com.css" type="text/css" rel="stylesheet">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>管理員</title>
</head>
<jsp:useBean id="dba" class="myBean.DBA" scope="page"/>
<body>
<p>
<%String admin_id = (String)session.getAttribute("id");
if(admin_id==null){response.sendRedirect("login.jsp");}
String name="",id="",password="",dep="",sex="",enrol="",info="",dep_id="";
dep = (String)session.getAttribute("dep");;
%>
</p>
<p align="center"><font color="#00FF00" size="+3" face="華文行楷">管理員</font></p>
<p><a href="addDBA.jsp">新加管理員</a></p>
<div align="center">
<table cellpadding="2" cellspacing="1" bgcolor="#DEDFDE">
<tr>
<td align="center" bgcolor="#EEEEEE">管理員帳號</td>
<td align="center" bgcolor="#EEEEEE">姓名</td>
<td align="center" bgcolor="#EEEEEE">密碼</td>
<td align="center" bgcolor="#EEEEEE">系別</td>
<td align="center" bgcolor="#EEEEEE">性別</td>
<td align="center" bgcolor="#EEEEEE">注冊日期</td>
<td align="center" bgcolor="#EEEEEE">備注</td>
<td align="center" bgcolor="#EEEEEE">刪除</td>
<td align="center" bgcolor="#EEEEEE">更新</td>
</tr>
<%
ResultSet rs = dba.getDBA(dep);
while(rs.next())
{
id=rs.getString(1);
name=rs.getString(3);
password=rs.getString(2);
dep_id=rs.getString(6);
sex=rs.getString(4);
enrol=rs.getString(5);
info=rs.getString(7);
if(dep_id.equals("0000"))
dep="全局";
else{
String sql = "select NAME from department where ID='"+dep_id+"'";
SQLBean db = new SQLBean();
ResultSet rs1 = null;
try{
rs1 = db.executeQuery(sql);
if(rs1!=null&&rs1.next()) dep = rs1.getString("NAME");
}catch(SQLException e){e.getMessage();}
finally{ rs1.close();}
}
%>
<tr>
<td align="center" bgcolor="#FFFFFF"><%=id%></td>
<td align="center" bgcolor="#FFFFFF"><%=name%></td>
<td align="center" bgcolor="#FFFFFF"><%=password%></td>
<td align="center" bgcolor="#FFFFFF"><%=dep%></td>
<td align="center" bgcolor="#FFFFFF"><%=sex%></td>
<td align="center" bgcolor="#FFFFFF"><%=enrol%></td>
<td align="center" bgcolor="#FFFFFF"><%=info%></td>
<td align="center" bgcolor="#FFFFFF"><a href="DBASvlt?action=delete&id=<%=id%>">刪除</a></td>
<td align="center" bgcolor="#FFFFFF"><a href="updateDBA.jsp?id=<%=id%>&name=<%=name%>&password=<%=password%>&dep=<%=dep_id%>&sex=<%=sex%>&enrol=<%=enrol%>&info=<%=info%>">更新</a> </td>
</tr>
<%
}
%>
</table>
</div>
<p align="center"> </p>
<div align="center"><a href="admin.jsp" target="_parent">返回</a>
</div>
</body>
</html>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -