jsp登录注册完整实现代码(增删改查+网页+数据库)
register.jsp:注册
%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"% !DOCTYPE html html head meta charset="UTF-8" title 注册 /title style #a { width:50%; height:200px; border: 1px dashed ; background-color:lightyellow; text-align:center;}body{background-color:lightblue;} /style /head body form action="doregister.jsp" method="post" 用户名: input type="text" name="uname" br 密码: input type="password" name="upwd" br 备注: textarea rows="" cols="" name="uinfo" /textarea br input type="submit" value="注册" input type="reset" value="重置" /form /body /html
%@page import="java.sql.ResultSet"% %@page import="java.sql.PreparedStatement"% %@page import="java.sql.Connection"% %@page import="java.sql.DriverManager"% %@page import="oracle.jdbc.driver.OracleDriver"% %@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"% %//设置编码-设置请求对象的编号request.setCharacterEncoding("utf-8");//接收注册页面传递的数据String uname = request.getParameter("uname");String upwd = request.getParameter("upwd");String uinfo = request.getParameter("uinfo");//连接数据库Class.forName("oracle.jdbc.driver.OracleDriver");String url = "jdbc:oracle:thin:@localhost:1521:orcl";Connection con = DriverManager.getConnection(url, "scott", "tiger");/*查询到用户的最大编号最大编号+1，做为新添加的用户的编号*///这里的代码是用来 得到最新编号的int nextId=1;//做为新用户的编号PreparedStatement ps = con.prepareStatement("select max(uuid) from T277");//执行sql语句ResultSet rs= ps.executeQuery();if(rs.next()){//查询到最大的编号，加1，就是新数据的编号nextId = rs.getInt(1)+1;}//这里的代码 开始执行添加用户操作ps = con.prepareStatement("insert into T277 values(?,?,?,?)");ps.setInt(1, nextId);ps.setString(2, uname);ps.setString(3, upwd);ps.setString(4, uinfo);//执行sql语句int i = ps.executeUpdate();if(i 0){out.print(" script alert('注册成功');location.href='login.jsp' /script ");}else{out.print(" script alert('注册失败');location.href='register.jsp' /script ");}%
%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"% !DOCTYPE html html head meta charset="UTF-8" title 登录 /title style #a { width:50%; height:200px; border: 1px dashed ; background-color:lightyellow; text-align:center;}body{background-color:lightblue;} /style /head body form action="dologin.jsp" 用户名： input type="text" name="uname" br 密码: input type="password" name="upwd" br input type="submit" value="登录" input type="button" value="注册" onclick="javascript:location.href='register.jsp'" /form /body /html
%@page import="java.sql.ResultSet"% %@page import="java.sql.PreparedStatement"% %@page import="java.sql.DriverManager"% %@page import="java.sql.Connection"% %@page import="oracle.jdbc.driver.OracleDriver"% %@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"% %//接收login页面传递的数据String uname = request.getParameter("uname");String upwd = request.getParameter("upwd");//连接数据库//注册驱动类//OracleDriverClass.forName("oracle.jdbc.driver.OracleDriver");//连接数据库String url = "jdbc:oracle:thin:@localhost:1521:orcl";Connection con = DriverManager.getConnection(url, "scott", "tiger");//创建对象PreparedStatement ps = con.prepareStatement("select * from T277 where uname=? and upwd=?");//给占位符赋值ps.setString(1, uname);ps.setString(2, upwd);//执行sql语句ResultSet rs = ps.executeQuery();//处理结果if(rs.next()){//转发request.getRequestDispatcher("index.jsp").forward(request, response);}else{//失败out.print(" script alert('用户名或密码错误，请重新登录');location.href='login.jsp' /script ");}//关闭连接%
%@page import="java.sql.ResultSet"% %@page import="java.sql.PreparedStatement"% %@page import="java.sql.DriverManager"% %@page import="java.sql.Connection"% %@page import="oracle.jdbc.driver.OracleDriver"% %@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"% !DOCTYPE html html head meta charset="UTF-8" title 主页面 /title style #a { width:50%; height:200px; border: 1px dashed ; background-color:lightyellow; text-align:center;}body{background-color:lightblue;} /style /head body table border="1" align="center" width="80%" tr td 编号 /td td 用户名 /td td 密码 /td td 备注 /td td 操作 /td /tr %//连接数据库 进行查询所有数据//注册驱动类Class.forName("oracle.jdbc.driver.OracleDriver");//连接数据库String url = "jdbc:oracle:thin:@localhost:1521:orcl";Connection con = DriverManager.getConnection(url, "scott", "tiger");//创建Pre对象PreparedStatement ps = con.prepareStatement("select * from T277 order by uuid");//执行sql语句ResultSet rs = ps.executeQuery();//处理结果-遍历结果集while(rs.next()){% tr align="center" td %=rs.getInt(1) % /td td %=rs.getString("uname") % /td td %=rs.getString("upwd") % /td td %=rs.getString(4) % /td td a href="doup.jsp?uuid= %=rs.getInt(1)% " rel="external nofollow" 修改 /a a href="info.jsp?uuid= %=rs.getInt(1)% " rel="external nofollow" 详情 /a a href="dodel.jsp?uuid= %=rs.getInt(1)% " rel="external nofollow" 删除 /a /td /tr %} % /table /body /html
%@page import="java.sql.PreparedStatement"% %@page import="java.sql.DriverManager"% %@page import="java.sql.Connection"% %@page import="oracle.jdbc.driver.OracleDriver"% %@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"% %//设置编码-设置请求对象的编号request.setCharacterEncoding("utf-8");//接收修改页面传递的数据String uname = request.getParameter("uname");String upwd = request.getParameter("upwd");String uinfo = request.getParameter("uinfo");//获取要修改的用户编号String id = request.getParameter("uuid");//把字符串转换为整数编号int uuid = Integer.valueOf(id);//JDBC 删除 Class.forName("oracle.jdbc.driver.OracleDriver");String url = "jdbc:oracle:thin:@localhost:1521:orcl";Connection con = DriverManager.getConnection(url, "scott", "tiger");PreparedStatement ps = con.prepareStatement("update T277 set uname=?,upwd=?, uinfo=? where uuid="+uuid);ps.setString(1, uname);ps.setString(2, upwd);ps.setString(3, uinfo);int i = ps.executeUpdate();if(i 0){out.print(" script alert('修改成功');location.href='index.jsp' /script ");}else{out.print(" script alert('修改失败');location.href='index.jsp' /script ");}%
%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"% !DOCTYPE html html head meta charset="UTF-8" title Insert title here /title /head body %//获取要修改的用户编号String id = request.getParameter("uuid");//把字符串转换为整数编号int uuid = Integer.valueOf(id);% form action="update.jsp?uuid= %=uuid % " method="post" 用户名: input type="text" name="uname" br 密码: input type="password" name="upwd" br 备注: textarea rows="" cols="" name="uinfo" /textarea br input type="submit" value="修改" input type="reset" value="重置" /form /body /html
%@page import="java.sql.ResultSet"% %@page import="java.sql.PreparedStatement"% %@page import="java.sql.DriverManager"% %@page import="java.sql.Connection"% %@page import="oracle.jdbc.driver.OracleDriver"% %@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"% %//获取要修改的用户编号String id = request.getParameter("uuid");//把字符串转换为整数编号int uuid = Integer.valueOf(id);//JDBC 删除Class.forName("oracle.jdbc.driver.OracleDriver");String url = "jdbc:oracle:thin:@localhost:1521:orcl";Connection con = DriverManager.getConnection(url, "scott", "tiger");PreparedStatement ps = con.prepareStatement("select * from T277 where uuid="+uuid);ResultSet rs= ps.executeQuery();if(rs.next()){% form 用户名: input type="text" name="uname" value=" %=rs.getString("uname") % " br 密码: input type="password" name="upwd" value=" %=rs.getString("upwd") % " br 备注: textarea rows="" cols="" name="uinfo" %=rs.getString(4) % /textarea br a href="index.jsp" rel="external nofollow" 返回 /a /form %} %
%@page import="java.sql.PreparedStatement"% %@page import="java.sql.DriverManager"% %@page import="java.sql.Connection"% %@page import="oracle.jdbc.driver.OracleDriver"% %@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"% %//获取要删除的用户编号String id = request.getParameter("uuid");//把字符串转换为整数编号int uuid = Integer.valueOf(id);//JDBC 删除Class.forName("oracle.jdbc.driver.OracleDriver");String url = "jdbc:oracle:thin:@localhost:1521:orcl";Connection con = DriverManager.getConnection(url, "scott", "tiger");PreparedStatement ps = con.prepareStatement("delete T277 where uuid="+uuid);int i = ps.executeUpdate();if(i 0){out.print(" script alert('删除成功');location.href='index.jsp' /script ");}else{out.print(" script alert('删除失败');location.href='index.jsp' /script ");}%
//假设法：假设我的用户名为admin 密码为123 if("admin".equals(name) "123".equals(pwd)){ //说明登录成功 跳转到success.jsp//1.重定向 将页面跳转 地址栏发生了改变 //不能将值传递到下一个界面 可以跳转到任意资源 在客户端发挥作用 response.sendRedirect("http://www.baidu.com");//2.转发 将页面跳转 可以将值传递到下一个界面 //但是地址栏不发生改变 而是停留在了之前的页面 只能转发到当前项目内资源 在服务器端发挥作用 //request.getRequestDispatcher("http://www.baidu.com").forward(request, response); } else{ //说明登录失败 提示用户并返回登录界面login.jsp js的跳转属于重定向 地址栏发生了改变 login-- dologin-- login out.print(" script alert('用户名或者密码有误');location.href='login.jsp'; /script "); }
重定向：地址栏发生改变 不能传值 可以跳转到任意资源 在客户端发挥作用
转发：地址栏不发生改变 能传值 只能跳转到当前项目内资源 在服务器端发挥作用语法：
重定向：response.sendR()转发：request.getreq .for(request,response)
URL:jdbc:oracle:thin:@localhost:1521:orcl
request.setCharacterEncoding("utf-8");
//这里的代码是用来 得到最新编号的 int nextId=1;//做为新用户的编号 PreparedStatement ps = con.prepareStatement("select max(uuid) from T277"); //执行sql语句 ResultSet rs= ps.executeQuery(); if(rs.next()){ //查询到最大的编号，加1，就是新数据的编号 nextId = rs.getInt(1)+1; }
jsp登录注册完整实现代码(增删改查+网页+数据库)
