📄 update_action.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*"%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>修改事件处理</title>
</head>
<body>
<%
request.setCharacterEncoding("GB2312");
String 姓名=request.getParameter("姓名");
String 出生年月=request.getParameter("出生年月");
String 部门=request.getParameter("部门");
String 性别=request.getParameter("性别");
String 住址=request.getParameter("住址");
String 职称=request.getParameter("职称");
String 文化程度=request.getParameter("文化程度");
String 联系电话=request.getParameter("联系电话");
String Email=request.getParameter("Email");
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); //建立连接
Connection conn=DriverManager.getConnection("jdbc:odbc:mydb","",""); //发送SQL语句
Statement stmt=conn.createStatement();
String sql;
ResultSet rs;
rs=stmt.executeQuery("select * from employee_info where 姓名='"+姓名+"'");
if(rs.next()){
%>
<script language="javascript">alert("修改成功!");
window.history.go(-1);
</script>
<%
sql="update employee_info set 姓名='"+姓名+"',出生年月='"+出生年月+"',部门='"+部门+"',性别='"+性别+"',住址='"+住址+"',职称='"+职称+"',文化程度='"+文化程度+"',联系电话='"+联系电话+"',Email='"+Email
+"' where 姓名='"+(String)session.getAttribute("姓名")+"'";
try{ stmt.executeUpdate(sql);
}
catch(Exception e){
out.println(e.getMessage());
}
finally{
stmt.close();
conn.close();
}}else{%>
<script language="javascript">alert("不存在该姓名的员工!");
window.history.go(-1);
</script>
<%}%>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -