update_deal.jsp
来自「JSP+oracle开发实例精粹》随书光盘」· JSP 代码 · 共 55 行
JSP
55 行
<%@ page language="java" contentType="text/html; charset=gb2312" import="java.sql.*"%>
<html>
<jsp:useBean id="db" class="yhgl.connectDB" />
<%
try
{
String id = request.getParameter("id");
if(id == null || id.equals(""))
{
session.setAttribute("error","3");
response.sendRedirect("error.jsp");
}
else
{
String prepsw = request.getParameter("prepsw");
String name = request.getParameter("name");
String sql = "select * from YHGL_TABLE where user_id='"+id+"' and user_name='"+name+"' and user_psw='"+prepsw+"'";
ResultSet rs = db.executeQuery(sql);
if(rs.next())
{
String psw = request.getParameter("psw");
if(psw.equals(request.getParameter("conpsw")))
{
sql = "update YHGL_TABLE set user_psw = '"+psw+"' where user_id = '"+id+"'";
db.executeUpdate(sql);
%>
<script language="javascipt">
alert("操作成功");
self.location.href = "list.jsp";
</script>
<%
}
else
{
%>
<script language="javascipt">
alert("密码确认不一致");
history.back();
</script>
<%
}
}
else
{
session.setAttribute("error","4");
response.sendRedirect("error.jsp");
}
}
}
catch(Exception e)
{
e.printStackTrace();
}
%>
</html>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?