?? txledit.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 cname = "";
String company = "";
String address = "";
String postcode = "";
String duty ="";
String phone="";
String fax = "";
String handset ="";
String email = "";
String remark ="";
String id = request.getParameter("id");
String sql ;
String status ="";
int op2= 0;
String title ="增加卡片";
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 card where ID="+id;
sqlbean.executeQuery(sql);
if(sqlbean.next()){
cname = sqlbean.getString("cname");
company = sqlbean.getString("company");
address = sqlbean.getString("address");
postcode = sqlbean.getString("postcode");
duty = sqlbean.getString("duty");
phone = sqlbean.getString("phone");
fax = sqlbean.getString("fax");
handset = sqlbean.getString("handset");
email = sqlbean.getString("email");
remark = sqlbean.getString("remark");
}
if(op.compareTo("4")==0){
status = " readonly";
op2 = 0;
title ="查看卡片！";
}else{
status = "";
op2 = 7;
title ="編輯卡片！";
}
}else{
op2 = 6;
}
sqlbean.close();
%>
<script language="JavaScript" src="MM_script.js"></script>
<title><%=title%></title>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel="stylesheet" href="oa.css">
</head>
<body bgcolor="#efefef" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<form action="txledit.jsp" method="post" name="AddCard" onsubmit="return ChkCard();">
<input type=hidden name=op value=<%=op2%>>
<input type=hidden name=id value=<%=id%>>
<table width="100%" border="0" cellspacing="1" cellpadding="2">
<tr bgcolor="#4E5960">
<td class="heading" height="20"><font color="#FFFFFF"><b><%=title%></b></font></td>
</tr>
</table>
<table width="100%" border="1" cellspacing="0" cellpadding="1" bordercolordark="#FFFFFF" bordercolor="#000000">
<tr>
<td width="15%" bgcolor="#bfbfbf">
<div align="center">姓名：</div>
</td>
<td width="35%" bgcolor="#efefef">
<input type="text" name="cname" size=15 maxlength="20" value='<%=cname%>' <%=status%>>
</td>
<td width="15%" bgcolor="#bfbfbf">
<div align="center">單位：</div>
</td>
<td width="35%" bgcolor="#efefef">
<input type="text" name="company" size=15 value='<%=company%>' <%=status%>>
</td>
</tr>
<tr>
<td width="15%" bgcolor="#bfbfbf">
<div align="center">通訊地址：</div>
</td>
<td width="35%" bgcolor="#efefef">
<input type="text" name="address" size=15 value='<%=address%>' <%=status%>>
</td>
<td width="15%" bgcolor="#bfbfbf">
<div align="center">郵編：</div>
</td>
<td width="35%" bgcolor="#efefef">
<input type="text" name="postcode" size=15 maxlength="6" value='<%=postcode%>' <%=status%>>
</td>
</tr>
<tr>
<td width="15%" bgcolor="#bfbfbf">
<div align="center">職務(wù)：</div>
</td>
<td width="35%" bgcolor="#efefef">
<input type="text" name="duty" size=15 value='<%=duty%>' <%=status%>>
</td>
<td width="15%" bgcolor="#bfbfbf">
<div align="center">電話：</div>
</td>
<td width="35%" bgcolor="#efefef">
<input type="text" name="phone" size=15 value='<%=phone%>' <%=status%>>
</td>
</tr>
<tr>
<td width="15%" bgcolor="#bfbfbf">
<div align="center">傳真：</div>
</td>
<td width="35%" bgcolor="#efefef">
<input type="text" name="fax" size=15 value='<%=fax%>' <%=status%>>
</td>
<td width="15%" bgcolor="#bfbfbf">
<div align="center">手機(jī)：</div>
</td>
<td width="35%" bgcolor="#efefef">
<input type="text" name="handset" size=15 value='<%=handset%>' <%=status%>>
</td>
</tr>
<tr>
<td width="15%" bgcolor="#bfbfbf">
<div align="center">信箱：</div>
</td>
<td width="35%" bgcolor="#efefef" colspan=3>
<input type="text" name="email" size=40 value='<%=email%>' <%=status%>>
</td>
</tr>
<tr>
<td width="15%" bgcolor="#bfbfbf">
<div align="center">備注：</div>
</td>
<td width="35%" bgcolor="#efefef" colspan=3>
<textarea name="remark" cols="40" rows="4" <%=status%>><%=remark%></textarea>
</td>
<tr><td colspan=4>
<a href="Javascript:window.close();" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image3','','images/close_2.gif',1)">
<img name="Image3" border="0" src="images/close_1.gif" width="85" height="19" hspace="5"></a>
<% if(op.compareTo("1")==0){ %>
<input type="image" src="images/add_off_2.gif" WIDTH="60" HEIGHT="19">
<a href="javascript:document.AddCard.reset();" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image2','','images/rewrite_on.gif',1)">
<% }else if(op.compareTo("5")==0){ %>
<input type="image" src="images/sendarticle_off.gif" WIDTH="60" HEIGHT="19">
<a href="javascript:document.AddCard.reset();" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image2','','images/rewrite_on.gif',1)">
<img name="Image2" border="0" src="images/rewrite_off.gif" width="60" height="19" hspace="5"></a>
<% } %>
</td>
</tr>
</table>
</form>
</body>
</html>
<%
}else if(op.compareTo("2")==0){
}else if(op.compareTo("3")==0){ //刪除
sql = "delete from card where ID="+id;
sqlbean.executeUpdate(sql);
//out.println("修改數(shù)據(jù)成功！"+sql);
sqlbean.close();
response.sendRedirect("txl.jsp");
}else if(op.compareTo("7")==0){ //修改
sql = "update card set "
+"cname ='" + sqlbean.to_8859_1(request.getParameter("cname"))
+"',company='"+ sqlbean.to_8859_1(request.getParameter("company"))
+"',comaddress='"+ sqlbean.to_8859_1(request.getParameter("address"))
+"',postcode='"+ sqlbean.to_8859_1(request.getParameter("postcode"))
+"',duty='"+ sqlbean.to_8859_1(request.getParameter("duty"))
+"',phone='"+ sqlbean.to_8859_1(request.getParameter("phone"))
+"',fax='"+ sqlbean.to_8859_1(request.getParameter("fax"))
+"',handset='"+ sqlbean.to_8859_1(request.getParameter("handset"))
+"',email='"+ sqlbean.to_8859_1(request.getParameter("email"))
+"',remark='"+ sqlbean.to_8859_1(request.getParameter("remark"))
+"' where ID="+ id;
sqlbean.executeUpdate(sql);
sqlbean.close();
out.println("修改數(shù)據(jù)成功！");
out.println("<script language=javascript>");
out.println("window.close();");
out.println("</script>");
}else if(op.compareTo("6")==0){ //插入
/*
sql = "select * from card";
sqlbean.executeQuery(sql);
sqlbean.rs.moveToInsertRow(); sqlbean.rs.updateString("cname", sqlbean.to_8859_1(request.getParameter("cname"))); sqlbean.rs.updateString("company", sqlbean.to_8859_1(request.getParameter("company"))); sqlbean.rs.updateString("address", sqlbean.to_8859_1(request.getParameter("address"))); sqlbean.rs.updateString("postcode", sqlbean.to_8859_1(request.getParameter("postcode"))); sqlbean.rs.updateString("duty", sqlbean.to_8859_1(request.getParameter("duty"))); sqlbean.rs.updateString("phone", sqlbean.to_8859_1(request.getParameter("phone"))); sqlbean.rs.updateString("fax", sqlbean.to_8859_1(request.getParameter("fax"))); sqlbean.rs.updateString("handset", sqlbean.to_8859_1(request.getParameter("handset"))); sqlbean.rs.updateString("email", sqlbean.to_8859_1(request.getParameter("email"))); sqlbean.rs.updateString("remark", sqlbean.to_8859_1(request.getParameter("remark"))); sqlbean.rs.insertRow();*/
sql = "INSERT INTO card(cname,company,address,postcode,duty,phone,fax,handset,email,remark,userid) values('"
+ sqlbean.to_8859_1(request.getParameter("cname"))
+"','"+ sqlbean.to_8859_1(request.getParameter("company"))
+"','"+ sqlbean.to_8859_1(request.getParameter("address"))
+"','"+ sqlbean.to_8859_1(request.getParameter("postcode"))
+"','"+ sqlbean.to_8859_1(request.getParameter("duty"))
+"','"+ sqlbean.to_8859_1(request.getParameter("phone"))
+"','"+ sqlbean.to_8859_1(request.getParameter("fax"))
+"','"+ sqlbean.to_8859_1(request.getParameter("handset"))
+"','"+ sqlbean.to_8859_1(request.getParameter("email"))
+"','"+ sqlbean.to_8859_1(request.getParameter("remark"))
+"',"+ session.getAttribute("Uid")+")";
sqlbean.executeUpdate(sql);
sqlbean.close();
out.println(sqlbean.showMsg("javascript:window.close()","插入數(shù)據(jù)成功！","系統(tǒng)提示"));
//out.println("<script language=javascript>");
//out.println("window.close();");
//out.println("</script>");
}
%>
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -