?? urledit.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> 網站名稱 </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 > 網站地址</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 > 網站說明 </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>
</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 + -