此处我就只贴出java代码和jsp代码,数据库表自己根据Regist.java去创建
1、首先,我先把前端代码贴出来,这个比较简单,没什么
注册(regist.jsp)
<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>注册界面</title>
<link rel="icon" type="image/x-icon" href="images/logo01.jpg">
<link rel="stylesheet" type="text/css" href="css/regist.css">
<script type="text/javascript" src="/js/regist.js"></script>
</head>
<body style="background:url(images/p02.jpg); background-size: cover;">
<form action="sign" method="post" onsubmit="return check(this)">
<img src="images/logo01.jpg">
<p>新用户请注册</p>
<hr size="3px" color="#666666">
<div id="div01">
<table id="tab">
<tr>
<td><input type="text" name="username" id="username" placeholder="请输入用户名(字母)"></td>
</tr>
<tr>
<td><input type="password" name="password" id="password1" placeholder="请输入密码"></td>
</tr>
<tr>
<td><input type="password" name="password" id="password2" placeholder="请再次输入密码"></td>
</tr>
<tr>
<td><input type="radio" name="gender" value="man"/>男
<input type="radio" name="gender" value="woman"/>女</td>
</tr>
<tr>
<td><input type="email" name="email" id="email" placeholder="请输入email"></td>
</tr>
<tr>
<td><input type="radio" name="type" value="user"/>用户
<input type="radio" name="type" value="admin"/>管理员</td>
</tr>
<tr>
<td><input type="text" name="phone" id="phone" placeholder="请输入电话"></td>
</tr>
</table>
<input type="submit" name="submit" id="submit" value="注册">
<a href="login.jsp">已有账号></a>
</div>
</form>
</body>
</html>
登录(login.jsp)
<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>登录界面</title>
<link rel="icon" type="image/x-icon" href="images/logo01.jpg">
<link rel="stylesheet" href="css/login.css">
<script type="text/javascript" src="/js/login.js"></script>
</head>
<body style="background:url(images/p02.jpg); background-size: cover;">
<form action="login" method="post" onsubmit="return check(this)">
<img src="images/logo01.jpg">
<p>欢迎登录</p>
<hr size="3px" color="#666666">
<div id="div02">
<table id="tab">
<tr>
<td><input type="text" name="username" id="username" placeholder="用户名" value=""
onfocus="if(this.value=='Your name') this.value='';"></td>
</tr>
<tr>
<td><input type="password" name="password" id="password" placeholder="密码" value=""
onfocus="if(this.value=='Your Password') this.value='';"></td>
</tr>
</table>
<input type="checkbox" name="checkbox" value="checkbox"/>记住用户密码
<input type="checkbox" name="checkbox" value="checkbox"/>自动登录 <br/>
<input type="submit" name="submit" id="submit" value="登录"><br>
<input type="button" name="but" id="but" value="返回" onclick="javascript:window.location.href='index.jsp'">
<br><a id="aa" href="regist.jsp">请注册</a>
</div>
</form>
</body>
</html>
主意:登录功能中的记住密码功能尚未投入使用
2、接下来的就是java代码
首先来个Regist.java
public class Regist {
private String username;
private String password;
private String gender;
private String email;
private String type;
private String phone;
public String getUsername() {
return username;
}
public void setUsername(String username) {
this.username = username;
}
public String getPassword() {
return password;
}
public void setPassword(String password) {
this.password = password;
}
public String getGender() {
return gender;
}
public void setGender(String gender) {
this.gender = gender;
}
public String getEmail() {
return email;
}
public void setEmail(String email) {
this.email = email;
}
public String getType() {
return type;
}
public void setType(String type) {
this.type = type;
}
public String getPhone() {
return phone;
}
public void setPhone(String phone) {
this.phone = phone;
}
}
接下来就是登录和注册的Servlet代码
RegistServlet.java
package com.hsx.servlet;
import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
public class RegistServlet extends HttpServlet {
private static final long serialVersionUID = 1L;
public RegistServlet() {
super();
}
protected void doGet(HttpServletRequest req, HttpServletResponse resp)
throws ServletException, IOException {
doPost(req, resp);
}
protected void doPost(HttpServletRequest req, HttpServletResponse resp)
throws ServletException, IOException {
req.setCharacterEncoding("UTF-8");
resp.setContentType("text/html;charset=UTF-8");
// req.getRequestDispatcher("regist_insert.jsp").forward(req, resp);
String username = req.getParameter("username");
String password = req.getParameter("password");
String gender = req.getParameter("gender");
String email = req.getParameter("email");
String type = req.getParameter("type");
String phone = req.getParameter("phone");
Connection connection = null;
PreparedStatement ps = null;
try{
Class.forName("com.mysql.jdbc.Driver").newInstance();
connection = DriverManager.getConnection("jdbc:mysql://localhost/(改为自己的数据库名)?user=(自己的数据库用户名)&password=(自己数据库密码)");
String sql = "insert into user(username,password,gender,email,type,phone) values(?,?,?,?,?,?)";
ps = connection.prepareStatement(sql);
ps.setString(1, username);
ps.setString(2, password);
ps.setString(3,gender);
ps.setString(4,email);
ps.setString(5,type);
ps.setString(6, phone);
int count = ps.executeUpdate();
if(count != 0){
req.getRequestDispatcher("login.jsp").forward(req, resp);
}else{
req.getRequestDispatcher("regist_fail.jsp").forward(req, resp);
}
}catch(Exception e){
e.printStackTrace();
}finally{
if(connection != null){
try {
connection.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
if(ps != null){
try {
ps.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
}
}
LoginServlet.java
package com.hsx.servlet;
import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
public class LoginServlet extends HttpServlet {
private static final long serialVersionUID = 1L;
public LoginServlet() {
super();
}
protected void doGet(HttpServletRequest req, HttpServletResponse resp)
throws ServletException, IOException {
doPost(req, resp);
}
protected void doPost(HttpServletRequest req, HttpServletResponse resp)
throws ServletException, IOException {
req.setCharacterEncoding("UTF-8");
resp.setContentType("text/html;charset=UTF-8");
// String result = "";
//从前端页面获取用户名和密码
String username = req.getParameter("username");
String password = req.getParameter("password");
/*
* //判断用户名是否为空 if (username == "" || username == null) { try { result =
* "请输入用户名"; req.setAttribute("message", result);
* resp.sendRedirect("login.jsp"); return;
*
* }catch (Exception e) { e.printStackTrace(); } }
*
* //判断密码是否为空 if(password == "" || password == null) { try { result = "请输入密码";
* req.setAttribute("message", result); resp.sendRedirect("login.jsp"); return;
* }catch (Exception e) { e.printStackTrace(); } }
*/
//登记jdbc驱动
try {
Class.forName("com.mysql.jdbc.Driver");
} catch (ClassNotFoundException e) {
System.out.println("驱动启动失败");
e.printStackTrace();
}
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
//连接数据库
try {
conn = DriverManager.getConnection("jdbc:mysql://localhost/xxxx?user=root&password=12xxxx");
stmt = conn.createStatement();
String sql = "select * from user where username = '"+username+"' and password = '"+password+"'";
rs = stmt.executeQuery(sql);
} catch (SQLException e) {
e.printStackTrace();
}
HttpSession session = req.getSession();
session.setAttribute("username", username);
try {
if (rs.next()) {
session.setAttribute("gender", rs.getString("gender"));
session.setAttribute("email", rs.getObject("email"));
session.setAttribute("type", rs.getObject("type"));
session.setAttribute("phone", rs.getObject("phone"));
resp.sendRedirect("index.jsp");
return;
}else {
session.setAttribute("message", "用户名和密码不匹配");
resp.sendRedirect("login_fail.jsp");
return;
}
} catch (SQLException e) {
e.printStackTrace();
}
}
}
最后在贴出web.xml
<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns="http://xmlns.jcp.org/xml/ns/javaee"
xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee
http://xmlns.jcp.org/xml/ns/javaee/web-app_4_0.xsd"
id="WebApp_ID"
version="4.0">
<display-name>HsxWorkSystem</display-name>
<welcome-file-list>
<welcome-file>login.jsp</welcome-file>
</welcome-file-list>
<servlet>
<servlet-name>sign</servlet-name>
<servlet-class>com.hsx.servlet.RegistServlet</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>sign</servlet-name>
<url-pattern>/sign</url-pattern>
</servlet-mapping>
<servlet>
<servlet-name>login</servlet-name>
<servlet-class>com.hsx.servlet.LoginServlet</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>login</servlet-name>
<url-pattern>/login</url-pattern>
</servlet-mapping>
</web-app>
基本的代码就是这样,不是很完美,前端的修饰根据你自己的喜好去弄,这里我就不贴出来了
3、看看成品展示
运行进来就是要求你登录,你可以选择登录,没有注册过选择注册
如若注册成功跳到登录界面,失败就跳到另一注册失败界面
下边我把主页面代码贴出来(index.jsp)
<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>商城主页</title>
<link rel="icon" type="image/x-icon" href="images/logo01.jpg">
<!-- 这个是商城进去的主页面,你可以在这个页面看到商品,搜索,登录注册,查看订单信息 -->
<link rel="stylesheet" href="css/main_type.css">
<link rel="stylesheet" href="css/main_head.css">
<link rel="stylesheet" href="css/show.css">
<script type="text/javascript" src="js/main_type.js"></script>
<script type="text/javascript" src="js/show.js"></script>
</head>
<body style="background:url(images/p02.jpg); background-size: cover;">
<%@ include file="main_head.jsp" %>
<%@ include file="main_type.jsp" %>
<%@ include file="show.jsp" %>
</body>
</html>
<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
<div id="main_head">
<div id="main_head_02"><marquee drection="left"><b>欢迎光临hexionly网上书城</b></marquee></div>
<!-- 点击分别跳转到相应的页面 -->
<a href="order.jsp">查看订单</a>
<a href="user.jsp">管理员操作</a>
<a id="type01">查看书类型</a>
<a>你好,<font color="red">${username }</font></a>
</div>
这个是main_head.jsp
不喜勿喷,新手上路,同时学习阶段,有什么新的东西可以互相交流