?? afileadd.jsp
字號:
<%@ page contentType="text/html;charset=gb2312" %>
<%@ include file="check.jsp" %>
<%
String rule = String.valueOf(session.getAttribute("Urule"));
if(rule.compareTo("a")!=0 && rule.compareTo("b")!=0){
response.sendRedirect("login.jsp?id=admin");
}
%>
<%
String op = "100";
if(request.getParameter("op")!=null){
op= request.getParameter("op");
}
String sql="";
boolean column = true;
if(op.compareTo("1")==0){
int count=0;
%>
<link rel="stylesheet" type="text/css" href="oa.css">
<script language="javascript" src="mouse.js"></script>
<script language="javascript" src="ShowProcessBar.js"></script>
<script language="javascript" src="MM_script.js"></script>
<script Language="javaScript" src="afileadd.js"></script></head>
<body bgcolor="#d6d3ce" oncontextmenu=self.event.returnValue=false;showmenu() >
<%@ include file="rightmenu.jsp" %>
<form method="POST" action="afilesave.jsp" enctype="MULTIPART/FORM-DATA" name=myform onsubmit="return validate()">
<div align="center"><center>
<table width="480" border="1" cellspacing="0" cellpadding="0" bordercolorlight="#666666" bordercolordark="#ffffff" >
<tr>
<td width="100%" bgcolor="#999999" height="20"><font color="#FFFFFF"><center><p><b>添加</b></font></td>
</tr>
<tr align="center">
<td width="100%">
<TABLE bgColor=#666666 border=0 cellPadding=1 cellSpacing=1 width='100%' >
<tr>
<td width="15%" bgColor=#efefef><b>類型:</b></td>
<td bgColor=#ffffff>
<%
sql = "select * from type order by ID asc";
sqlbean.executeQuery(sql);
if(! sqlbean.next()){
out.println ("<font color=red size=4>請先添加欄目。</font>");
column = false;
//response.end
}else{
out.println("<select name=typeid size=1>");
// out.println("<option selected value='0'>==請選欄目==</option>");
do{
out.println("<option value=\""+sqlbean.getInt("ID")+"\">"+sqlbean.getString("type")+"</option>");
}while(sqlbean.next());
out.println("</select> ");
}
%>
</td></tr>
<tr><td width="15%" bgColor=#efefef><b>附件</b></font>
<td bgColor=#ffffff align="left">
<input type=file name=fname>
</td>
</tr>
<tr>
<td width="15%" bgColor=#efefef><b>標題:</b></td>
<td bgColor=#ffffff><input type="text" name="title" size="50"
class="smallinput" maxlength="100"></td>
</tr>
<tr>
<td width="15%" bgColor=#efefef><b>內容:</b></td>
<td bgColor=#ffffff><textarea rows="13" name="content" cols="50" class="smallarea"></textarea></td>
</tr>
<tr><td width="15%" bgColor=#efefef></td><td align=center bgcolor="#ffffff">
<% if(column){%>
<input type="submit" value=" 添 加 " name="cmdok" class="buttonface" IsShowProcessBar="True">
<input type="reset" value=" 清 除 " name="cmdcancel" class="buttonface">
<% } %>
</td></tr>
</table>
</td>
</tr>
</table>
</center></div>
</form>
<%}else if(op.compareTo("2")==0){%>
<html><head>
<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="Cache-Control" content="no-cache, must-revalidate">
<meta http-equiv="expires" content="wed, 26 Feb 1997 08:21:57 GMT">
<title>增加欄目</title>
<link rel="stylesheet" href="oa.css">
<script language="JavaScript" src="afileadd.js"></script>
</head>
<body bgcolor="#FFFFFF" topmargin='0' leftmargin='0'
style="background-image: url('images/main_bg.gif'); background-attachment: scroll; background-repeat: no-repeat; background-position: left bottom">
<table width="100%" border='0' cellspacing='0' cellpadding='0'>
<tr>
<td class="heading" bgcolor="#4e5960" height=20> <font color="#FFFFFF"><b>欄目管理</font></b></td>
<td class="heading" bgcolor="#4e5960">
<p align="right">
</td>
</tr>
<tr>
<td width="110" valign="top">
</td>
<td valign="top" >
<table width="100%" border='0' cellspacing='0' cellpadding='0'>
<tr >
<td align="right" width="100%">
<%
String key1 ="";
if(request.getParameter("key1")!=null){
key1 = request.getParameter("key1");
}
String tb1 ="";
if(request.getParameter("tb1")!=null){
tb1 = request.getParameter("tb1");
}
int curpage =1;
if(request.getParameter("curpage")!=null){
curpage= Integer.parseInt(request.getParameter("curpage"));
}
sql ="SELECT * FROM type";
sqlbean.executeQuery(sql);
int totalnum = sqlbean.getTotalNum();
int pagesize = 10;
mypage.Init(curpage,totalnum,pagesize);
int pagecount=mypage.getTotalpage();
int first = mypage.getFirst();
int last = mypage.getLast();
if(curpage<1) curpage=1;
if(curpage > pagecount) curpage=pagecount;
int count = 0;
String tmp = "";
if(totalnum>0){
//sqlbean.absolute(first);
out.println(mypage.printTable("afileadd.jsp",tb1,key1));
out.println("</td></tr><tr><td>");
out.println("<TABLE width=100% border='0' cellspacing='1' cellpadding='1' bgcolor=#636563>");
out.println("<tr><td bgcolor=#F6F6F6 align=center>單 位 名 稱 </td>");
out.println("<td bgcolor=#F6F6F6 align=center colspan=2>管 理</td>");
out.println("</tr></form>");
count=1;
while(sqlbean.next()){
out.println("<FORM METHOD=POST ACTION='afileadd.jsp'>");
out.println("<INPUT TYPE=hidden name=op value=0>");
out.println("<tr><td bgcolor=#F6F6F6 width='80%' >");
out.println("<INPUT TYPE=text value="+sqlbean.getString("type")+" name=type style='border:1pt solid #636563;font-size:9pt' size=30 onclick='this.form.op.value=4'>");
out.println("<INPUT TYPE=hidden name=id value="+sqlbean.getString("ID")+">");
out.println("</td><td bgcolor=#F6F6F6 align=center>");
out.println("<INPUT TYPE=submit name='edit' value='修改' style='border:1pt solid #636563;font-size:9pt; LINE-HEIGHT: normal;HEIGHT: 18px;' onclick='this.form.op.value=4'>");
out.println("</td> <td bgcolor=#F6F6F6 align=center>");
out.println("<INPUT TYPE=submit value='刪除' name='del' style='border:1pt solid #636563;font-size:9pt; LINE-HEIGHT: normal;HEIGHT: 18px;' onclick='this.form.op.value=3'>");
out.println("</td></tr></FORM>");
count++;
if(count>pagesize) break;
}
}
sqlbean.close();
%>
<FORM METHOD=POST ACTION="afileadd.jsp" name="myform">
<input type=hidden name=op value="6">
<tr>
<td colspan=3 bgcolor="#F6F6F6">新增加欄目:<INPUT TYPE="text" size=30 NAME="type" style="border:1pt solid #636563;font-size:9pt"> <INPUT TYPE="submit" name="add" value="增加" style="border:1pt solid #636563;font-size:9pt; LINE-HEIGHT: normal;HEIGHT: 18px;" onclick="return validate()">
</td>
</tr>
</TABLE>
</FORM>
</td></tr></table> </td></tr>
</table></td></tr></table>
<%}else if(op.compareTo("3")==0){//刪除
sql="DELETE from type where ID="+request.getParameter("id");
sqlbean.executeUpdate(sql);
sqlbean.close();
response.sendRedirect("afileadd.jsp?op=2");
}else if( op.compareTo("5")==0){//修改
sql = "update type set type='"+sqlbean.to_8859_1(request.getParameter("type"))+"' where ID="+request.getParameter("id");
sqlbean.executeUpdate(sql);
sqlbean.close();
response.sendRedirect("afileadd.jsp?op=2");
}else if( op.compareTo("6")==0){ //加入
sql="insert into type (type) values(\""+sqlbean.to_8859_1(request.getParameter("type"))+"\")";
sqlbean.executeUpdate(sql);
sqlbean.close();
//out.println(sql);
response.sendRedirect("afileadd.jsp?op=2");
}
%>
</body>
</html>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -