edithd1.jsp
来自「--- --^_^-------------- 广师公寓中心 1.请装上」· JSP 代码 · 共 298 行
JSP
298 行
<%@ page contentType="text/html; charset=gb2312" %>
<%@ page language="java" import="java.sql.*" %>
<%
int counter=0;
Cookie cookies[]=request.getCookies();
if(cookies!=null){
for(int i=0;i<cookies.length;i++){
if(cookies[i].getName().equals("counter"))
counter=Integer.parseInt(cookies[i].getValue());
}
}
%>
<%
if(session.getAttribute("login")== null)
{%>
<jsp:forward page="login.jsp"/>
<%}
%>
<html>
<head>
<title>后台管理>编辑工作人员</title>
<style type="text/css">
<!--
table {
font-family: "宋体";
font-size: 14px;
color: #000000;
}
.unnamed1 {
border-right-width: thin;
border-right-style: dashed;
border-right-color: #000000;
}
.unnamed2 {
border-bottom-width: thin;
border-bottom-style: dashed;
border-bottom-color: #000000;
}
.unnamed3 {
border-left-width: thin;
border-left-style: dashed;
border-left-color: #000000;
}
-->
</style>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body leftmargin="0" topmargin="0" marginwidth="0" marginheight="0" background="images/background.gif">
<%
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException e)
{
out.print(e);
}
try{
String strDirPath=application.getRealPath(request.getRequestURI());
strDirPath=strDirPath.substring(0,strDirPath.lastIndexOf('\\'))+"\\";
strDirPath=application.getRealPath("ODBC/gongyu.mdb");
String url = "jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ="+strDirPath;
Connection conn = DriverManager.getConnection(url);
Statement stmt = conn.createStatement();
request.setCharacterEncoding("gb2312");
String sql="SELECT * FROM manage where id="+request.getParameter("edit");
ResultSet rs = stmt.executeQuery(sql);
int id=1;
String name="";
int age=0;
String sex="";
String zhiwu="";
String xueli="";
int phone=0;
String email="";
while(rs.next()){
id=rs.getInt("id");
name=rs.getString("name");
age=rs.getInt("age");
sex=rs.getString("sex");
zhiwu=rs.getString("zhiwu");
xueli=rs.getString("xueli");
phone=rs.getInt("phone");
email=rs.getString("email");
%>
<!-- ImageReady Slices (glry) -->
<table id="__01" width="680" height="338" border="0" cellpadding="0" cellspacing="0" align="center" background="images/glry_11.gif">
<!--DWLayoutTable-->
<tr>
<td height="55" colspan="6">
<img src="images/glry_01.gif" width="680" height="55" alt=""></td>
</tr>
<tr>
<td height="46" colspan="6">
<img src="images/glry_02.gif" width="680" height="46" alt=""></td>
</tr>
<tr>
<td height="41" colspan="6">
<img src="images/glry_03.gif" width="680" height="41" alt=""></td>
</tr>
<tr>
<td colspan="6" background="images/glry_04.gif" height="20" alt="">
<font color="#FF0000" size="2"><jsp:include page="time.htm"/>
<%
if(counter==0){
//if(session.getAttribute("counter1") == null){
out.print("欢迎首次光临！");
}
else{
out.print("今天您已经光临了"+counter+"次！");
//out.print("您已经光临了"+session.getAttribute("counter1")+"次！");
}
%></font></td>
</tr>
<tr>
<td width="115" height="19">
<a href="gongyu.jsp"><img src="images/glry_05.gif" alt="" width="115" height="19" border="0"></a></td>
<td width="113">
<a href="ry.jsp"><img src="images/glry_06.gif" alt="" width="113" height="19" border="0"></a></td>
<td width="112">
<a href="xszs.jsp"><img src="images/glry_07.gif" alt="" width="112" height="19" border="0"></a></td>
<td width="113">
<a href="wh.jsp"><img src="images/glry_08.gif" alt="" width="113" height="19" border="0"></a></td>
<td width="113">
<a href="lx.jsp"><img src="images/glry_09.gif" alt="" width="113" height="19" border="0"></a></td>
<td width="114">
<a href="hd.jsp"><img src="images/glry_10.gif" alt="" width="114" height="19" border="0"></a></td>
</tr>
<tr>
<td colspan="6" background="images/glry_04.gif" height="20" alt="" bordercolorlight="#009999" class="unnamed2"><a href="gongyu.jsp">首页</a>>>后台管理>编辑工作人员 <a href="zhexiao.jsp">注销<%=session.getAttribute("username")%></a></td>
</tr>
<tr>
<td height="149" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0">
<!--DWLayoutTable-->
<tr>
<td width="113" height="3"></td>
</tr>
<tr>
<td height="22" valign="top"><a href="hd1.jsp"><img src="images/glry_06.gif" alt="" width="113" height="19" border="0"></a></td>
</tr>
<tr>
<td height="7"></td>
</tr>
<tr>
<td height="20" valign="top"><a href="zs.jsp"><img src="images/glry_07.gif" alt="" width="112" height="19" border="0"></a></td>
</tr>
<tr>
<td height="7"></td>
</tr>
<tr>
<td height="23" valign="top"><a href="hd3.jsp"><img src="images/glry_08.gif" alt="" width="113" height="19" border="0"></a></td>
</tr>
<tr>
<td height="7"></td>
</tr>
<tr>
<td height="23" valign="top"><a href="hd4.jsp"><img src="images/glry_09.gif" alt="" width="113" height="19" border="0"></a></td>
</tr>
<tr>
<td height="7"></td>
</tr>
<tr>
<td height="23" valign="top"><a href="hd6.jsp"><img src="images/glry_13.gif" alt="" width="113" height="19" border="0"></a></td>
</tr>
<tr>
<td height="7"></td>
</tr>
</table></td>
<td colspan="5" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0" class="unnamed3">
<!--DWLayoutTable-->
<tr>
<td width="565" height="149">
<script language="JavaScript">
function MyCheck()
{
var textfield1 = form1.textfield1.value;
var textfield2 = form1.textfield2.value;
var select1 = form1.select1.value;
var textfield4 = form1.textfield4.value;
var textfield5 = form1.textfield5.value;
var textfield6 = form1.textfield6.value;
var textfield7 = form1.textfield7.value;
var email1 = textfield6.indexOf("@");
var email2 = textfield6.indexOf(".");
if(textfield1=="")
{
alert("用户名不能为空！");
return false;
}
if( textfield1.indexOf("<") >=0 || textfield1.indexOf(">") >=0 )
{
alert("用户名含有非法字符！");
return false;
}
if(textfield2=="")
{
alert("年龄不能为空！");
return false;
}
if(isNaN(textfield2))return (textfield2=''),alert('年龄只能输入数字！'),false;
if(select1 == "")
{
alert("性别不能为空！");
return false;
}
if(textfield4=="")
{
alert("学历不能为空！");
return false;
}
if(textfield5=="")
{
alert("电话号码不能为空！");
return false;
}
if(isNaN(textfield5))return (textfield5=''),alert('电话号码只能输入数字！'),false;
if(textfield6=="")
{
alert("电子邮箱不能为空！");
return false;
}
if(textfield7=="")
{
alert("职务不能为空！");
return false;
}
if(email1==-1)
{
alert("不合法的Email地址！");
return false;
}
if(email2==-1)
{
alert("不合法的Email地址！");
return false;
}
return true;
}
</script>
<form name="form1" method="post" action="edit1.jsp" onSubmit="return MyCheck();" id="form1">
<input value=<%=id%> type="hidden" name="id">
<br>
<p align="left">
<font size="+1">正在编辑 <font color="#FF0000"><%=name%></font> 工作人员</font>
<br>
姓名：
<input name="textfield1" type="text" size="10" value=<%=name%>>
<br>
年龄：
<input name="textfield2" type="text" size="6" value=<%=age%>>
<br>
性别：
<input name="select1" type="text" size="5" value=<%=sex%>>
<br>
职务：
<input name="textfield7" type="text" size="8" value=<%=zhiwu%>><br>
学历：
<input name="textfield4" type="text" size="8" value=<%=xueli%>>
<br>
电话号码：
<input name="textfield5" type="text" size="10" value=<%=phone%>>
<br>
电子邮箱：
<input name="textfield6" type="text" size="15" value=<%=email%>>
<br>
<input name="Submit1" type="submit" id="Submit1" value="编辑">
<input type="reset" name="Submit2" value="重置">
<input type="button" name="Submit" value="返回" onClick="javascript:history.back();">
</p>
</form>
</td>
</tr>
</table></td>
</tr>
<tr>
<td height="48" colspan="6">
<img src="images/glry_12.gif" width="680" height="48" alt=""></td>
</tr>
</table>
<!-- End ImageReady Slices -->
<%}
rs.close();
stmt.close();
conn.close();
}
catch(Exception ex)
{
out.print(ex);
}
%>
</body>
</html>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?