📄 archives_edit.jsp
字号:
<%@ page contentType="text/html;charset=gb2312" %>
<%@ include file="check.jsp" %>
<%@ page import="java.util.*" %>
<%
String strSql = "";
String op = "8";
if(request.getParameter("op")!=null){
op = request.getParameter("op");
}
String Uname ="";
String sex= "男性";
String duty ="";
String grade ="";
String birthday ="";
String polity ="";
String health ="";
String Nplace ="";
String weight ="";
String idcard ="";
String marriage ="未婚";
String Fschool ="";
String member ="";
String speciality ="";
String length ="";
String study ="";
String foreign1 ="";
String Elevel ="";
String Clevel ="";
String Hplace ="";
String QQ = "";
String call ="";
String place ="";
String love ="";
String award ="";
String experience ="";
String family ="";
String contact ="";
String remark = "";
String nation ="";
String height ="";
String Ltime ="";
String phone = "";
String email = "";
String mobile = "";
String havephoto = "0";
String check = "";
String status = " readonly ";
int kind = 0;
int id =0;
// ttitle ="用户提交数据！";
// errorstr ="数据成功被输入!"
//String ttitle ="出错了！";
//String errorstr ="您的请求没有被执行!";
boolean t = false;
if(op.compareTo("1")==0 || op.compareTo("5")==0){ //添加 //编辑
if(op.compareTo("5")==0){
strSql= "select * from userinfo where userid="+session.getAttribute("Uid");
sqlbean.executeQuery(strSql);
if(sqlbean.next()){
Uname = sqlbean.getString("Uname");
sex = sqlbean.getString("sex");
nation = sqlbean.getString("nation");
duty = sqlbean.getString("duty");
grade = sqlbean.getString("grade");
birthday= sqlbean.getString("birthday");
polity = sqlbean.getString("polity");
health = sqlbean.getString("health");
Nplace = sqlbean.getString("Nplace");
weight = sqlbean.getString("weight");
idcard = sqlbean.getString("idcard");
marriage= sqlbean.getString("marriage");
Fschool = sqlbean.getString("Fschool");
member = sqlbean.getString("member");
speciality= sqlbean.getString("speciality");
length = sqlbean.getString("length");
study = sqlbean.getString("study");
foreign1= sqlbean.getString("foreign1");
Elevel = sqlbean.getString("Clevel");
Clevel = sqlbean.getString("Clevel");
Hplace = sqlbean.getString("Hplace");
QQ = sqlbean.getString("QQ");
call = sqlbean.getString("call");
place = sqlbean.getString("place");
love = sqlbean.getString("love");
award = sqlbean.getString("award");
experience =sqlbean.getString("experience");
family = sqlbean.getString("family");
contact = sqlbean.getString("contact");
remark = sqlbean.getString("remark");
nation = sqlbean.getString("nation");
height = sqlbean.getString("height");
Ltime = sqlbean.getString("Ltime");
phone = sqlbean.getString("phone");
email = sqlbean.getString("email");
mobile = sqlbean.getString("mobile");
havephoto = sqlbean.getString("havephoto");
check = sqlbean.getString("ischeck");
id = sqlbean.getInt("ID");
op = "2";
t = true;
status ="";
}
}else{
op = "6";
t = true;
status = "";
}
if(t){
%>
<html><head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel="stylesheet" href="oa.css">
</head>
<title>个人档案</title>
<body bgcolor="#FFFFFF" topmargin="0" leftmargin="0">
<form method="post" action="archives_edit.jsp">
<input type=hidden name=op value="<%=op%>">
<input type=hidden name=id value="<%=id%>">
<table border="1" cellpadding="0" cellspacing="0" width="95%" bordercolorlight=#000000 bordercolordark=#ffffff align=right>
<tr>
<td align="center" width="15%"><b>真实姓名</b></td>
<td width="30%"> <%=session.getAttribute("Rname") %></td>
<td align="center" width="15%"><b>登陆姓名</b></td>
<td width="25%"> <%=Uname%></td>
</tr>
<tr>
<td align="center"><b>性 别</b></td>
<td><SELECT NAME="sex">
<%
out.println("<option value=1 "+((sex.indexOf('1')!=-1)?"selected":"")+">女性</option>");
out.println("<option value=0 "+((sex.indexOf('0')!=-1)?"selected":"")+">男性</option>");
%>
</SELECT>
</td>
<td align="center"><b>民 族</b></td>
<td>
<INPUT TYPE="text" value="<%=nation%>" name=nation size="10" <%=status%>>
</td>
</tr>
<tr>
<td align="center"><b>所属部门</b></td>
<td> <%=session.getAttribute("Upart") %></td>
<td align="center"><b>职 务</b></td>
<td>
<INPUT TYPE="text" value="<%=duty %>" name="duty" size="10" <%=status%>>
</td>
</tr>
<tr>
<td align="center"><b>职 称</b></td>
<td>
<INPUT TYPE="text" value="<%=grade %>" name="grade" size="10" <%=status%>>
</td>
<td align="center"><b>出生日期</b></td>
<td>
<INPUT TYPE="text" value="<%=birthday %>" name="birthday" size="10" <%=status%>>
</td>
</tr>
<tr>
<td align="center"><b>政治面貌</b></td>
<td>
<INPUT TYPE="text" value="<%=polity %>" name="polity" size="10" <%=status%>>
</td>
<td align="center"><b>健康状况</b></td>
<td>
<INPUT TYPE="text" value="<%=health %>" name="health" size="10" <%=status%>>
</td>
</tr>
<tr>
<td align="center" height="20"><b>籍 贯</b></td>
<td>
<INPUT TYPE="text" value="<%=Nplace %>" name="Nplace" size="10" <%=status%>>
</td>
<td align="center"><b>体 重</b></td>
<td>
<INPUT TYPE="text" value="<%=weight %>" name="weight" size="10" <%=status%>>
</td>
</tr>
<tr>
<td height="20" align="center"><b>身份证号</b></td>
<td>
<INPUT TYPE="text" value="<%=idcard %>" name="idcard" size="10" <%=status%>>
</td>
<td align="center"><b>身 高</b></td>
<td>
<INPUT TYPE="text" value="<%=height %>" name="height" size="10" <%=status%>>
</td>
</tr>
<tr>
<td align="center" height="20"><b>婚姻状况</b></td>
<td><SELECT NAME="marriage">
<%
out.println("<option value=1 "+((marriage.indexOf('1')!=-1)?"selected":"")+">已婚</option>");
out.println("<option value=0 "+((marriage.indexOf('0')!=-1)?"selected":"")+">未婚</option>");
%>
</td>
<td align="center"><b>毕业院校</b></td>
<td>
<INPUT TYPE="text" value="<%=Fschool %>" name="Fschool" size="10" <%=status%>>
</td>
</tr>
<tr>
<td align="center" height="20"><b>本人成分</b></td>
<td>
<INPUT TYPE="text" value="<%=member %>" name="member" size="10" <%=status%>>
</td>
<td align="center"><b>专 业</b></td>
<td>
<INPUT TYPE="text" value="<%=speciality %>" name="speciality" size="10" <%=status%>>
</td>
</tr>
<tr>
<td height="20" align="center"><b>工 龄</b></td>
<td>
<INPUT TYPE="text" value="<%=length %>" name="length" size="10" <%=status%>>
</td>
<td align="center"><b>学 历</b></td>
<td>
<INPUT TYPE="text" value="<%=study %>" name="study" size="10" <%=status%>>
</td>
</tr>
<tr>
<td height="20" align="center"><b>外语语种</b></td>
<td>
<INPUT TYPE="text" value="<%=foreign1 %>" name="foreign1" size="10" <%=status%>>
</td>
<td align="center"><b>外语水平</b></td>
<td>
<INPUT TYPE="text" value="<%=Elevel %>" name="Elevel" size="10" <%=status%>>
</td>
</tr>
<tr>
<td height="20" align="center"><b>计算机能力</b></td>
<td>
<INPUT TYPE="text" value="<%=Clevel %>" name="Clevel" size="10" <%=status%>>
</td>
<td align="center"><b>户口所在地</b></td>
<td>
<INPUT TYPE="text" value="<%=Hplace %>" name="Hplace" size="10" <%=status%>>
</td>
</tr>
<tr>
<td height="20" align="center"><b>QQ号码</b></td>
<td>
<INPUT TYPE="text" value="<%=QQ %>" name="QQ" size="10" <%=status%>>
</td>
<td align="center"><b>EMAIL</b></td>
<td><INPUT TYPE="text" value="<%=email %>" name=email size="10" <%=status%>></td>
</tr>
<tr>
<td height="20" align="center"><b>常用电话</b></td>
<td><INPUT TYPE="text" value="<%=phone %>" name=phone size="10" <%=status%>></td>
<td align="center"><b>手机号码</b></td>
<td><INPUT TYPE="text" value="<%=mobile %>" name=mobile size="10" <%=status%>></td>
</tr>
<tr>
<td height="20" align="center"> <b>传呼号码</b> </td>
<td>
<INPUT TYPE="text" value="<%=call %>" name="call1" size="10" <%=status%>>
</td>
<td align="center"> </td>
<td> </td>
</tr>
<tr>
<td height="20" align="center"><b>现 住 址</b></td>
<td colspan="3">
<INPUT size=45 TYPE="text" value="<%=place %>" name="place" <%=status%>>
</td></tr>
<tr>
<td height="20" align="center"><b>个人专长<br>
以及爱好</b></td>
<td colspan="3">
<TEXTAREA NAME="love" ROWS="2" COLS="44" <%=status%>><%=love %></TEXTAREA>
</td>
</tr>
<tr>
<td height="20" align="center"><b>本人曾受<br>
过何种奖<br>
励和处分</b></td>
<td colspan="3">
<TEXTAREA NAME="award" ROWS="3" COLS="44" <%=status%>><%=award %></TEXTAREA>
</td>
</tr>
<tr>
<td height="20" align="center"><b>工作经历</b></td>
<td colspan="3">
<TEXTAREA NAME="experience" ROWS="2" COLS="44" <%=status%>><%=experience %></TEXTAREA>
</td>
</tr>
<tr>
<td height="20" align="center"><b>家庭情况</b></td>
<td colspan="3">
<TEXTAREA NAME="family" ROWS="2" COLS="44" <%=status%>><%=family %></TEXTAREA>
</td>
</tr>
<tr>
<td height="20" align="center"><b>本 人<br>
联系方式</b></td>
<td colspan="3">
<TEXTAREA NAME="contact" ROWS="2" COLS="44" <%=status%>><%=contact %></TEXTAREA>
</td>
</tr>
<tr>
<td height="20" align="center"><b>备 注</b></td>
<td colspan="3">
<TEXTAREA NAME="remark" ROWS="2" COLS="44" <%=status%>><%=remark %></TEXTAREA>
</td>
</tr>
<tr>
<td height="20" align="center" colspan="4"><b><%=session.getAttribute("Rname") %>的个人基本档案</b>
<input type=submit value=' 提 交 ' name=submit>
</td>
</tr>
</table>
</form>
<% }
}else if(op.compareTo("3")==0){ //删除数据
}else if(op.compareTo("4")==0){
}else if(op.compareTo("2")==0){ //修改数据
String sql ="select * from userinfo where ID="+request.getParameter("id");
sqlbean.executeQuery(sql);
if(sqlbean.next()){
sqlbean.rs.updateString("sex",sqlbean.to_8859_1(request.getParameter("sex")));
sqlbean.rs.updateString("duty",sqlbean.to_8859_1(request.getParameter("duty")));
sqlbean.rs.updateString("grade",sqlbean.to_8859_1(request.getParameter("grade")));
sqlbean.rs.updateString("birthday",sqlbean.to_8859_1(request.getParameter("birthday")));
sqlbean.rs.updateString("polity",sqlbean.to_8859_1(request.getParameter("polity")));
sqlbean.rs.updateString("health",sqlbean.to_8859_1(request.getParameter("health")));
sqlbean.rs.updateString("Nplace",sqlbean.to_8859_1(request.getParameter("Nplace")));
sqlbean.rs.updateString("weight",sqlbean.to_8859_1(request.getParameter("weight")));
sqlbean.rs.updateString("idcard",sqlbean.to_8859_1(request.getParameter("idcard")));
sqlbean.rs.updateString("marriage",sqlbean.to_8859_1(request.getParameter("marriage")));
sqlbean.rs.updateString("Fschool",sqlbean.to_8859_1(request.getParameter("Fschool")));
sqlbean.rs.updateString("member",sqlbean.to_8859_1(request.getParameter("member")));
sqlbean.rs.updateString("speciality",sqlbean.to_8859_1(request.getParameter("speciality")));
sqlbean.rs.updateString("length",sqlbean.to_8859_1(request.getParameter("length")));
sqlbean.rs.updateString("study",sqlbean.to_8859_1(request.getParameter("study")));
sqlbean.rs.updateString("foreign1",sqlbean.to_8859_1(request.getParameter("foreign1")));
sqlbean.rs.updateString("Elevel",sqlbean.to_8859_1(request.getParameter("Elevel")));
sqlbean.rs.updateString("Clevel",sqlbean.to_8859_1(request.getParameter("Clevel")));
sqlbean.rs.updateString("Hplace",sqlbean.to_8859_1(request.getParameter("Hplace")));
sqlbean.rs.updateString("QQ",sqlbean.to_8859_1(request.getParameter("QQ")));
sqlbean.rs.updateString("call",sqlbean.to_8859_1(request.getParameter("call1")));
sqlbean.rs.updateString("place",sqlbean.to_8859_1(request.getParameter("place")));
sqlbean.rs.updateString("love",sqlbean.to_8859_1(request.getParameter("love")));
sqlbean.rs.updateString("award",sqlbean.to_8859_1(request.getParameter("award")));
sqlbean.rs.updateString("experience",sqlbean.to_8859_1(request.getParameter("experience")));
sqlbean.rs.updateString("family",sqlbean.to_8859_1(request.getParameter("family")));
sqlbean.rs.updateString("contact",sqlbean.to_8859_1(request.getParameter("contact")));
sqlbean.rs.updateString("remark",sqlbean.to_8859_1(request.getParameter("remark")));
sqlbean.rs.updateString("nation",sqlbean.to_8859_1(request.getParameter("nation")));
sqlbean.rs.updateString("height",sqlbean.to_8859_1(request.getParameter("height")));
sqlbean.rs.updateString("Ltime",sqlbean.to_8859_1(request.getParameter("Ltime")));
sqlbean.rs.updateString("phone",sqlbean.to_8859_1(request.getParameter("phone")));
sqlbean.rs.updateString("mobile",sqlbean.to_8859_1(request.getParameter("mobile")));
sqlbean.rs.updateString("email",sqlbean.to_8859_1(request.getParameter("email")));
Calendar now = Calendar.getInstance();
String sj = now.get(Calendar.YEAR)+"-"+(now.get(Calendar.MONTH)+1)+"-"+now.get(Calendar.DAY_OF_MONTH)+" "+now.get(Calendar.HOUR_OF_DAY)+":"+now.get(Calendar.MINUTE)+":"+now.get(Calendar.SECOND);
sqlbean.rs.updateString("Ltime",sqlbean.to_8859_1(sj));
sqlbean.rs.updateRow();
}
response.sendRedirect("archives.jsp");
}else if(op.compareTo("8")==0){ //错误的提交
}sqlbean.close();
%>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -