📄 afileadd.jsp

📁 网络版办公管理系统,采用最新技术java开发,对学习java语语的朋友可以借鉴
💻 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">&nbsp; 
        <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"> &nbsp;
    </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">&nbsp;&nbsp;&nbsp;<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>
💿 文件大小 1527 K
👤 上传用户 nihao464667180
📂 所属分类 Java编程
🏷️ 相关标签

#java #网络 #管理系统 #最新技术
⌨️ 快捷键说明

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