📄 teledit.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 telname = "";
String telephone = "";
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 tel where ID="+id;
sqlbean.executeQuery(sql);
if(sqlbean.next()){
telname = sqlbean.getString("telname");
telephone = sqlbean.getString("telephone");
}
if(op.compareTo("4")==0){
status = " readonly";
op2 = 0;
stitle ="查看电话！";
}else{
status = "";
op2 = 7;
stitle ="编辑电话！";
}
}
if(op.compareTo("1")==0 ){
op2 = 6;
status = "";
}
sqlbean.close();
%>
<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="teledit.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="telname" size=30 value='<%=telname%>' <%=status%>>
</TD>
</TR>
<TR>
<TD bgColor=#efefef height=20 width=60 > 电话号码</TD>
<TD bgColor=#ffffff height=20><INPUT maxLength=60 name="telephone" size=30 value='<%=telephone%>' <%=status%>>
</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 tel(telname,telephone) values('"+ sqlbean.to_8859_1(request.getParameter("telname"))+"','"+ sqlbean.to_8859_1(request.getParameter("telephone"))+"')";
sqlbean.executeUpdate(sql);
sqlbean.close();
out.println("<script language=javascript>");
out.println("window.close();");
out.println("</script>");
//out.println(sql);
}else if(op.compareTo("7")==0){
sql = "update tel set telname='"
+sqlbean.to_8859_1(request.getParameter("telname"))
+"',telephone='"+sqlbean.to_8859_1(request.getParameter("telephone"))
+"' where ID="+id;
sqlbean.executeUpdate(sql);
sqlbean.close();
out.println("<script language=javascript>");
out.println("window.close();");
out.println("</script>");
//out.println(sql);
}else if(op.compareTo("3")==0){
sql = "delete from tel where ID="+id;
sqlbean.executeUpdate(sql);
sqlbean.close();
response.sendRedirect("tel.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 + -