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

📄 urledit.jsp

📁 网络版办公管理系统,采用最新技术java开发,对学习java语语的朋友可以借鉴
💻 JSP
字号:
🔍 
<%@ page contentType="text/html;charset=gb2312" %><%@ include file="check.jsp" %>


<script language=javascript src="mouse.js"></script>

<%
String op = "9";
if(request.getParameter("op")!=null){
	op = request.getParameter("op");
}	
String urlname = "";		
String url = "";
String urlsn = "";
String id = request.getParameter("id");
String sql ;
String status =" readonly ";
int op2= 0;
String stitle ="添加网址";

if(op.compareTo("1")==0 || op.compareTo("4")==0 || op.compareTo("5")==0 ){ ////添加//编辑
	
		
		if( op.compareTo("4")==0 || op.compareTo("5")==0 ){
			sql = "select * from url where ID="+id;
			sqlbean.executeQuery(sql);
			
			if(sqlbean.next()){
				urlname = sqlbean.getString("urlname");
				url = sqlbean.getString("url");
				urlsn = sqlbean.getString("urlsn");
			}
			if(op.compareTo("4")==0){
				status = " readonly";
				op2 = 0;
				stitle ="查看网址！";
			}else{
				status = "";
				op2 = 7;
				stitle ="编辑网址！";
			}				
		}	
		if(op.compareTo("1")==0 ){
			op2 = 6;
			status = "";
		}	
	
%>
<HTML><HEAD><TITLE><%=stitle%></TITLE>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel="stylesheet" href="oa.css">
</HEAD>
<BODY>
<FORM action="urledit.jsp" method=post>
<input type=hidden name=op value="<%=op2%>">
<input type=hidden name=id value="<%=id%>">

        <TABLE bgColor=#666666 border=0 cellPadding=1 cellSpacing=1 
        width="100%">
          <TBODY> 
          <TR> 
            <TD bgColor=#000000 class=heading colSpan=2><FONT 
            color=#ffffff><b><%=stitle%></b></FONT></TD>
          </TR>
          <TR> 
            <TD bgColor=#efefef height=20 width=60>&nbsp;网站名称 </TD>
            <TD bgColor=#ffffff height=20> 
              <INPUT maxLength=100 name="urlname" size=30  value='<%=urlname%>' <%=status%>>
            </TD>
          </TR>
          <TR> 
            <TD bgColor=#efefef height=20 width=60 >&nbsp;网站地址</TD>
            <TD bgColor=#ffffff height=20><INPUT maxLength=60 name="url" size=23 value='<%=url%>' <%=status%>>
            </TD>
          </TR>
		  <TR> 
            <TD bgColor=#efefef height=20 width=60 >&nbsp;网站说明 </TD>
            <TD bgColor=#ffffff height=20> 
                <TEXTAREA NAME="urlsn" ROWS="8" COLS="29" <%=status%> ><%=urlsn%></TEXTAREA>
			</TD>
          </TR>
          
          <TR> 
            <TD bgColor=#efefef height=20 width=60> 
              &nbsp;
            </TD>
            <TD bgColor=#ffffff height=20>             
               <INPUT TYPE="image" SRC="images/sendarticle_on.gif">
            </TD>
          </TR>
        
          </TBODY> 
        </TABLE>
      </FORM>
<%	
}else if(op.compareTo("6")==0){
	sql = "INSERT INTO url(urlname,url,urlsn) values('"
		+ sqlbean.to_8859_1(request.getParameter("urlname"))+"','"
		+ sqlbean.to_8859_1(request.getParameter("url"))+"','"
		+ sqlbean.to_8859_1(request.getParameter("urlsn"))+"')";
		
	sqlbean.executeUpdate(sql);
	sqlbean.close();
	//out.println(sql);
	out.println("<script language=javascript>");
	out.println("window.close();");
	out.println("</script>");	
}else if(op.compareTo("7")==0){
	sql = "update url set urlname='"
		+sqlbean.to_8859_1(request.getParameter("urlname"))
		+"',url='"+sqlbean.to_8859_1(request.getParameter("url"))
		+"',urlsn='"+sqlbean.to_8859_1(request.getParameter("urlsn"))
		+"' where ID="+id;
	sqlbean.executeUpdate(sql);	
	//out.println(sql);
	sqlbean.close();
	out.println("<script language=javascript>");
	out.println("window.close();");
	out.println("</script>");	
}else if(op.compareTo("3")==0){
	sql = "delete from url where ID="+id;
	sqlbean.executeUpdate(sql);
	sqlbean.close();
	response.sendRedirect("url.jsp");
}	
%>
<script language=javascript>
opener.location=opener.location;
</script>
<a  href="javaScript:window.close()"><img   border="0" src="images/close_1.gif"></a>

⌨️ 快捷键说明

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