📄 update_deal.jsp

📁 JSP+oracle开发实例精粹》随书光盘

💻 JSP

字号:

<%@ 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 + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -