一、题目:用户管理与登录
二、要求:
1、建立用户表(表结构自定义)
2、实现用户注册、用户登录功能
3、用户登录后可以修改用户信息功能
三、首页代码
<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
四、用户注册代码
<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
function check() {
if(https://www.doczj.com/doc/9c18417950.html,erId.value==""){
alert("用户名不能为空");
return false;
}
if(https://www.doczj.com/doc/9c18417950.html,erPWD.value==""){
alert("密码不能为空");
return false;
}
if(document.regForm.reUserPWD.value==""){
alert("确认码不能为空");
return false;
}
if(document.regForm.reUserPWD.value!=https://www.doczj.com/doc/9c18417950.html,erPW D.value){
alert("确认码不正确");
return false;
}
return true;
}
<%@ page language="java" pageEncoding="utf-8"%>
<%@ page import="java.sql.*,javax.sql.*,javax.naming.*"%>
<%
String username=request.getParameter("UserId");
String userPWD=request.getParameter("UserPWD"); Context initCtx = new InitialContext();
Context envCtx = (Context)
initCtx.lookup("java:comp/env");
DataSource ds = (DataSource)
envCtx.lookup("jdbc/oracle");
Connection conn = ds.getConnection();
Statement sta = conn.createStatement();
int iback= sta.executeUpdate("insert into user1 values('"+username+"','"+userPWD+"')");
if(iback!=0){
response.sendRedirect("login.jsp");
}
else{
response.sendRedirect("reg.jsp");
}
conn.close();
%>
五、用户登录代码
<%@ page language="java" import="java.util.*"
pageEncoding="GBK"%>
function check() {
if(https://www.doczj.com/doc/9c18417950.html,erId.value==""){
alert("用户名不能为空");
https://www.doczj.com/doc/9c18417950.html,erId.focus();
return false;
}
if(https://www.doczj.com/doc/9c18417950.html,erPWD.value==""){
alert("密码不能为空");
https://www.doczj.com/doc/9c18417950.html,erPWD.focus();
return false;
}
document.loginForm.submit();
return true;
}
<%@ page language="java" import="java.util.*"
import="java.sql.*" pageEncoding="utf-8"%>
<%
String username=request.getParameter("UserId");
String userPWD=request.getParameter("UserPWD");
try{
Class.forName("oracle.jdbc.driver.OracleDriver");
String url = "jdbc:oracle:thin:@192.168.1.101:1521:orcl"; Connection conn = DriverManager.getConnection(url, "webdb", "webdb");
Statement sm=conn.createStatement();
ResultSet rs =sm.executeQuery("select * from user1 where userName='"+username+"'");
if(rs.next()){
out.println(rs.getString(1));
out.println("登录成功!");
%>
点击这里修改密码
<%
}
else
response.sendRedirect("login.jsp");
}catch(Exception e){
out.println(e);
}
%>
六、修改密码代码
<%@ page language="java" import="java.util.*"
pageEncoding="utf-8"%>
Function1check() {
if(https://www.doczj.com/doc/9c18417950.html,erId.value==""){
alert("用户名不能为空");
return false;
}
if(https://www.doczj.com/doc/9c18417950.html,erPWD.value==""){
alert("新密码不能为空");
return false;
}
if(document.passForm.reUserPWD.value==""){
alert("确认码不能为空");
return false;
}
if(document.passForm.reUserPWD.value!=https://www.doczj.com/doc/9c18417950.html,erP WD.value){
alert("确认码不正确");
return false;
}
return true;
}
<%@ page language="java" pageEncoding="utf-8"%>
<%@ page import="java.sql.*,javax.sql.*,javax.naming.*"%>
<%
String username=request.getParameter("UserId");
String userPWD=request.getParameter("UserPWD"); Context initCtx = new InitialContext();
Context envCtx = (Context)
initCtx.lookup("java:comp/env");
DataSource ds = (DataSource)
envCtx.lookup("jdbc/oracle");
Connection conn = ds.getConnection();
Statement sta = conn.createStatement();
int back= sta.executeUpdate("update user1 set password='"+userPWD+"'where userName='"+userPWD+"'");
if(back!=0){
out.print("密码修改成功!");
}
else{
out.print("密码修改失败!");
}
conn.close();
%>
JSP JavaBean Servlet实现用户登录和注册 1 数据库: create database student; use student; create table user( id int primary key auto_increment, user varchar(50) not null, pwd varchar(50) not null, name varchar(50) not null, *** varchar(50) not null, age int(50) not null ); 2 index.jsp <%@ page language="java" import="java.util.*" pageEncoding="utf-8"%> <% String path = request.getContextPath(); String basePath = request.getScheme() "://" request.getServerName() ":" request.getServerPort() path "/"; %>