add.jsp

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

<%@ page language="java" contentType="text/html; charset=gb2312" import="java.sql.*"%>
<%@ page import="yhgl.connectDB" %>
<%
	yhgl.connectDB db = new yhgl.connectDB();
	String psw = request.getParameter("psw");
	String name = request.getParameter("name");
	if(psw.equals(request.getParameter("conpsw")))
	{
		try
		{
			String sql = "select MAX(USER_ID) from YHGL_TABLE";
			ResultSet rs = db.executeQuery(sql);
			int id = 0;
			if(rs.next())
			{
				id = rs.getInt(1);
			}
			id = id + 1;
			System.out.print("haha");
			sql = "insert into YHGL_TABLE(USER_ID,USER_NAME,USER_PSW,USER_PRIORITY) values('"+id+"','"+name+"','"+psw+"','0')";
			db.executeUpdate(sql);
				%>
				<script language="javascript">
					alert("操作成功");
					self.location.href = "index.jsp";
				</script>
				<%
		}
		catch(Exception e)
		{
			session.setAttribute("error","3");
			response.sendRedirect("error.jsp");
			e.printStackTrace();
		}
		
	}
	else
	{
		%>

		<script language="javascript">
			alert("密码确认不一致");
			history.back();
		</script>

		<%
	}
%>