📄 teacher_addexe.jsp
字号:
<%
/*
程序员:苏楠
用途:添加老师确认
时间:2003-8-19 10:30
*/
%>
<%@ page contentType="text/html;charset=gb2312" %>
<%@ page language="java" %>
<%
//////////////////////////////////////////////////////////////
// Privilege Guarding
String PrivXP="添加教师信息";
String PrivME="00201";
String PrivOUT="HTML"; // HTML | XSL | NONE
%>
<%@ include file="../pub/privGuarding.jsp" %>
<%
// Privilege Guarding
//////////////////////////////////////////////////////////////
%>
<link href="../css/style.css" rel="stylesheet" type="text/css">
<jsp:useBean id="work" scope="application" class="com.dbConnection.dbpool" />
<%
String id=request.getParameter("id");
String name=request.getParameter("name");
String password=request.getParameter("password");
String email=request.getParameter("email");
String phone=request.getParameter("phone");
String address=request.getParameter("address");
String zip_code=request.getParameter("zip_code");
String work_place=request.getParameter("work_place");
String position=request.getParameter("position");
String title=request.getParameter("title");
String gender=request.getParameter("gender");
String teach_level=request.getParameter("teach_level");
// String site = request.getParameter("site");
String status=request.getParameter("status");
String work_kind=request.getParameter("work_kind");
String teach_time=request.getParameter("teach_time");
//String reg_time=request.getParameter("reg_time");
String note=request.getParameter("note");
String screenpass=request.getParameter("password");
// for mail
String TID,TPASSWORD,EMAIL;
TID="T"+id;
TPASSWORD=password;
EMAIL=email;
if(email.equals(""))
email="无";
if(phone.equals(""))
phone="不详";
if(address.equals(""))
address="不详";
if(zip_code.equals(""))
zip_code="不详";
if(work_place.equals(""))
work_place="不详";
if(position.equals(""))
position="不详";
if(title.equals(""))
title="不详";
if(work_kind.equals(""))
work_kind="略";
if(teach_time.equals(""))
teach_time="略";
if(note.equals(""))
note="略";
//id="T"+id;
//输入的教师编号是否已经存在
String sql="SELECT ID FROM LRN_TEACHER_INFO WHERE ID='"+id+"'";
//out.print(sql);
com.dbConnection.MyResultSet RS = work.executeQuery(sql);
if(RS != null && RS.next())
{
work.close(RS);
out.print("<p>本教师ID已经存在请<a href='teacher_add.jsp'>返回</a>");
return;
}
work.close(RS);
//password=md5(password);
String query="insert into lrn_teacher_info(id,name,password,email,phone,address,zip_code,gender,work_place,position,title,status,login_num,note,teach_level,work_kind,teach_time) values ('"+id+"','"+name+"','"+password+"','"+email+"','"+phone+"','"+com.whaty.encode.SQLEncoder.encode(address)+"','"+zip_code+"','"+gender+"','"+com.whaty.encode.SQLEncoder.encode(work_place)+"','"+com.whaty.encode.SQLEncoder.encode(position)+"','"+com.whaty.encode.SQLEncoder.encode(title)+"','"+status+"',0,'"+com.whaty.encode.SQLEncoder.encode(note)+"','"+com.whaty.encode.SQLEncoder.encode(teach_level)+"','"+ work_kind + "','" + teach_time + "')";
//out.print(query);
int ret = work.executeUpdate(query);
//out.print("key:"+ret);
if(ret >0)
{
%>
<html>
<head><title>添加教师</title></head>
<body topmargin=0 leftmargin=0 bgcolor=FFFFFF>
<table width="80%" border="0" align=center cellpadding="2" cellspacing="1" bgcolor="3F6C61">
<tr class="t08_bgwhite_p2">
<td colspan="9" align="center">已经添加教师信息如下</td>
<tr>
<tr>
<td class="t12_14_bgE3EAE9">教师编号*</td>
<td class="t08_bgwhite_p2"><%=id%></td>
<td class="t08_bgwhite_p2"></td>
</tr>
<tr>
<td class="t12_14_bgE3EAE9">教师名称*</td>
<td class="t08_bgwhite_p2"><%=name%></td>
<td class="t08_bgwhite_p2"></td>
</tr>
<tr>
<td class="t12_14_bgE3EAE9">登录密码*</td>
<td class="t08_bgwhite_p2"><%=screenpass%></td>
<td class="t08_bgwhite_p2"></td>
</tr>
<tr>
<td class="t12_14_bgE3EAE9">电子邮件</td>
<td class="t08_bgwhite_p2"><%=email%></td>
<td class="t08_bgwhite_p2"></td>
</tr>
<tr>
<td class="t12_14_bgE3EAE9">联系电话</td>
<td class="t08_bgwhite_p2"><%=phone%></td>
<td class="t08_bgwhite_p2"></td>
</tr>
<tr><td class="t12_14_bgE3EAE9">通信地址</td>
<td class="t08_bgwhite_p2"><%=address%></td>
<td class="t08_bgwhite_p2"></td>
</tr>
<tr><td class="t12_14_bgE3EAE9">邮政编码</td>
<td class="t08_bgwhite_p2"><%=zip_code%></td>
<td class="t08_bgwhite_p2"></td>
</tr>
<tr><td class="t12_14_bgE3EAE9">工作单位</td>
<td class="t08_bgwhite_p2"><%=work_place%></td>
<td class="t08_bgwhite_p2"></td>
</tr>
<tr><td class="t12_14_bgE3EAE9">职务</td>
<td class="t08_bgwhite_p2"><%=position%></td>
<td class="t08_bgwhite_p2"></td>
</tr>
<tr><td class="t12_14_bgE3EAE9">职称</td>
<td class="t08_bgwhite_p2"><%=title%></td>
<td class="t08_bgwhite_p2"></td>
</tr>
<tr><td class="t12_14_bgE3EAE9">性别</td>
<td class="t08_bgwhite_p2"><%=gender%></td>
<td class="t08_bgwhite_p2"></td>
</tr>
<tr><td class="t12_14_bgE3EAE9">教师类型</td>
<td class="t08_bgwhite_p2"><%=teach_level%></td>
<td class="t08_bgwhite_p2"></td>
</tr>
<tr><td class="t12_14_bgE3EAE9">状态</td>
<td class="t08_bgwhite_p2"><%if (status.equals("0000")) out.print("有效");
else out.print("停用");%></td>
<td class="t08_bgwhite_p2"></td>
</tr>
<tr><td class="t12_14_bgE3EAE9">工作性质</td>
<td class="t08_bgwhite_p2"><%=note%></td>
<td class="t08_bgwhite_p2"></td>
</tr>
<tr><td class="t12_14_bgE3EAE9">教师</td>
<td class="t08_bgwhite_p2"><%=name%></td>
<td class="t08_bgwhite_p2">添加成功</td>
</tr>
</table>
<%
}
else
{
%>
<tr><td class="t12_14_bgE3EAE9">教师</td>
<td class="t08_bgwhite_p2"><%=name%></td>
<td class="t08_bgwhite_p2">添加不成功</td>
</tr>
</table>
<%
}
%>
<a href="teacher_add.jsp">返回继续添加</a>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -