?? adddba.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>
<p>
<%String admin_id = (String)session.getAttribute("id");
if(admin_id==null){response.sendRedirect("login.jsp");}
SQLBean db = new SQLBean();
String sql = "select * from studba";
ResultSet rs = db.executeQuery(sql);
String dep = (String)session.getAttribute("dep");;
%>
</p>
<script language="javascript">
var onecount;
onecount=0;
subcat = new Array();
<%
int count = 0;
while(rs.next()){
%>
subcat[<%=count%>] = new Array("<%=rs.getString("DEPARTMENT")%>","<%=rs.getString("ENROLLDAY").substring(0,4)%>","<%=rs.getString("ID")%>");
<%
count++;
}
rs.close();%>
onecount=<%=count%>;
function changeValue()
{
var year = form1.enrol.value.substring(0,4);
var depid = form1.dep.value;
var i,j;j=1;
for(i=0;i<onecount;i++){
if(subcat[i][0]==depid && subcat[i][1]==year){
j++;
}
}
if(j<9){id = year+depid+0+j;}
else id = year+depid+j;
for(i=0;i<onecount;i++){
if(id==subcat[i][2]){
j++;
if(j<9){id = year+depid+0+j;}
else id = year+depid+j;
}
}
form1.id.value=id;
}
</script>
<body>
<p align="center"><font color="#00FF00" size="+3" face="華文行楷">新增管理員</font></p>
<form name="form1" method="post" action="DBASvlt">
<input type="hidden" name="action" value="new">
<p> </p>
<div align="center">
<table width="49%" height="50" cellpadding="2" cellspacing="1" bgcolor="#DEDFDE">
<tr>
<td width="33%" bgcolor="#FFFFFF"><div align="right">姓名 </div></td>
<td width="67%" bgcolor="#FFFFFF"><input name="name" type="text" id="name" ></td>
</tr>
<tr>
<td bgcolor="#FFFFFF"><div align="right">密碼 </div></td>
<td bgcolor="#FFFFFF"><input name="password" type="password" id="password" maxlength="10" value="8888"></td>
</tr>
<tr>
<td bgcolor="#FFFFFF"><div align="right">性別</div></td>
<td bgcolor="#FFFFFF"><input type="radio" name="sex" value="男" checked>
<font color="#FFFFFF" size="+2" face="華文行楷">男</font>
<input name="sex" type="radio" value="女">
<font color="#FFFFFF" size="+2" face="華文行楷">女</font> </td>
</tr>
<tr>
<td bgcolor="#FFFFFF"><div align="right">注冊時間</div></td>
<td bgcolor="#FFFFFF">
<%java.util.Date date = new java.util.Date();
java.text.SimpleDateFormat dformat=new java.text.SimpleDateFormat("yyyy-MM-dd");
String dateandtime=dformat.format(date);%>
<input type="text" value="<%=dateandtime%>" name="enrol" id="enrol"> </td>
</tr>
<tr>
<td bgcolor="#FFFFFF"><div align="right">所在系 </div></td>
<td bgcolor="#FFFFFF"><select name="dep" size="1" id="dep" onChange="changeValue()">
<option selected >請選擇院系 </option>
<%
if(dep.equals("0000")){
sql = "select ID,NAME from department ";%>
<option value="0000">全局</option>
<% }else{
sql = "select ID, NAME from department where ID='"+dep+"'";
}
rs = db.executeQuery(sql);
while(rs.next()){
String dep_id=rs.getString("ID");%>
<option value="<%=dep_id%>"><%=rs.getString("NAME")%></option>
<%}rs.close();%>
</select></td>
</tr>
<tr>
<td bgcolor="#FFFFFF"><div align="right">帳號</div></td>
<td bgcolor="#FFFFFF"><input name="id" id="id" type="text"></td>
</tr>
<tr><td bgcolor="#FFFFFF"><div align="right">備注</div></td>
<td bgcolor="#FFFFFF"><input name="info" id="info" type="Textarea"></td>
</tr>
</table>
</div>
<p> </p>
<div align="center" class="warnFont"> 提 示: 初 始 密 碼 為 8888!! </div>
<p align="center">
<input type="submit" name="Submit" value="確定">
</p>
</form>
<p> </p>
<div align="center"><a href="getDBA.jsp">返回</a>
</div>
</body>
</html>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -