使用SSM框架完成后台管理项目开发——登录、注册(一)
使用SSM框架完成后台管理项目开发——登录、注册(一)
配置web.xml
<!--spring入口 加载spring配置文件-->
<listener>
<!--spring分发器-->
<listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
</listener>
<!--指定spring配置文件的位置和名字-->
<context-param>
<param-name>contextConfigLocation</param-name>
<param-value>classpath:applicationContext.xml</param-value>
</context-param>
<!--spring mvc入口-->
<servlet>
<servlet-name>springMVC</servlet-name>
<!--spring mvc 分发器 家在哪springmvc配置文件-->
<servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
<!--指定springmvc配置文件的路径 默认在web-inf下-->
<init-param>
<param-name>contextConfigLocation</param-name>
<param-value>classpath:springMVC-servlet.xml</param-value>
</init-param>
<!--在服务器启动时实例化springmvc中的对象-->
<load-on-startup>1</load-on-startup>
</servlet>
<servlet-mapping>
<servlet-name>springMVC</servlet-name>
<url-pattern>*.do</url-pattern>
</servlet-mapping>
创建maven项目,导入所需要的jar包
<dependency>
<groupId>com.fasterxml.jackson.core</groupId>
<artifactId>jackson-databind</artifactId>
<version>2.9.8</version>
</dependency>
<dependency>
<groupId>com.fasterxml.jackson.core</groupId>
<artifactId>jackson-annotations</artifactId>
<version>2.9.8</version>
</dependency>
<dependency>
<groupId>com.fasterxml.jackson.core</groupId>
<artifactId>jackson-core</artifactId>
<version>2.9.8</version>
</dependency>
<dependency>
<groupId>aopalliance</groupId>
<artifactId>aopalliance</artifactId>
<version>1.0</version>
</dependency>
<dependency>
<groupId>org.aspectj</groupId>
<artifactId>aspectjweaver</artifactId>
<version>1.9.5</version>
</dependency>
<dependency>
<groupId>commons-codec</groupId>
<artifactId>commons-codec</artifactId>
<version>1.11</version>
</dependency>
<dependency>
<groupId>commons-dbcp</groupId>
<artifactId>commons-dbcp</artifactId>
<version>1.4</version>
</dependency>
<dependency>
<groupId>commons-logging</groupId>
<artifactId>commons-logging</artifactId>
<version>1.1.1</version>
</dependency>
<!--commons-pool-1.6.jar-->
<dependency>
<groupId>commons-pool</groupId>
<artifactId>commons-pool</artifactId>
<version>1.6</version>
</dependency>
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>fastjson</artifactId>
<version>1.2.76</version>
</dependency>
<dependency>
<groupId>javax</groupId>
<artifactId>javaee-api</artifactId>
<version>7.0</version>
<scope>provided</scope>
</dependency>
<dependency>
<groupId>javax.servlet</groupId>
<artifactId>jstl</artifactId>
<version>1.2</version>
</dependency>
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>3.4.6</version>
</dependency>
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis-spring</artifactId>
<version>1.3.2</version>
</dependency>
<dependency>
<groupId>com.oracle.database.jdbc</groupId>
<artifactId>ojdbc6</artifactId>
<version>11.2.0.4</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-aop</artifactId>
<version>5.2.9.RELEASE</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-aspects</artifactId>
<version>5.2.9.RELEASE</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-beans</artifactId>
<version>5.2.9.RELEASE</version>
</dependency>
<!--spring-context-5.2.9.RELEASE.jar-->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-context</artifactId>
<version>5.2.9.RELEASE</version>
</dependency>
<!--spring-core-5.2.9.RELEASE.jar-->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-core</artifactId>
<version>5.2.9.RELEASE</version>
</dependency>
<!--spring-expression-5.2.9.RELEASE.jar-->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-expression</artifactId>
<version>5.2.9.RELEASE</version>
</dependency>
<!--spring-jdbc-5.2.9.RELEASE.jar-->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-jdbc</artifactId>
<version>5.2.9.RELEASE</version>
</dependency>
<!--spring-test-5.2.9.RELEASE.jar-->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-test</artifactId>
<version>5.2.9.RELEASE</version>
</dependency>
<!--spring-tx-5.2.9.RELEASE.jar-->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-tx</artifactId>
<version>5.2.9.RELEASE</version>
</dependency>
<!-- spring-web-5.2.9.RELEASE.jar-->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-web</artifactId>
<version>5.2.9.RELEASE</version>
</dependency>
<!-- spring-webmvc-5.2.9.RELEASE.jar-->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-webmvc</artifactId>
<version>5.2.9.RELEASE</version>
</dependency>
先创建数据库表,编写用户实体类
create table userLogin(
user_id number primary key,
user_name varchar2(200),
user_pwd varchar2(200),
u_salt varchar2(200)
);
编写用户实体类
封装用户属性,剩下的就是getter、setter方法,重写toString,无参,有参构造方法
private int userId;
private String userName;
private String userPwd;
private String uSalt;
在mapper.xml文件下编写结果集映射和sql语句
编写结果集映射
<resultMap id="UserMap" type="com.test.entity.User">
<id column="user_id" property="userId"></id>
<result column="user_name" property="userName"></result>
<result column="user_pwd" property="userPwd"></result>
<result column="u_salt" property="uSalt"></result>
</resultMap>
编写登录所用到的sql语句
<!--登录-->
<select id="login" resultMap="UserMap">
SELECT * FROM userLogin
<where>
<if test="userName != null and userName != ''">
user_name = #{userName}
</if>
<if test="userPwd != null and userPwd != ''">
AND user_pwd = #{userPwd}
</if>
</where>
</select>
<!--注册-->
<insert id="regist">
insert into userLogin values(seq_user.nextval,#{userName}, #{userPwd},#{uSalt})
</insert>
在注册时如果需要验证用户唯一性时,编写验证用户唯一性
<!--验证账号唯一性-->
<select id="unique" resultMap="UserMap">
SELECT user_name from userLogin where user_name = #{userName}
</select>
编写dao层、service层,serviceImpl层
dao层
因为有多个参数,所以需要用@param注解
//登录
public List<User> login(@Param("userName") String userName, @Param("userPwd") String userPwd);
//注册
public boolean regist(@Param("userName") String userName, @Param("userPwd") String userPwd, @Param("uSalt") String uSalt);
//验证账号唯一性
public List<User> unique(@Param("userName") String userName);
service层
//登录
public List<User> login(String userName, String userPwd);
//注册
public boolean regist(String userName, String userPwd, String uSalt);
//验证账号唯一性
public List<User> unique(String userName);
serviceImpl层
@Service
public class UserServiceImpl implements IUserService {
//service层对象赋值
@Autowired
public UserDao userDao;
/**
* 登录
* @param userName
* @param userPwd
* @return
*/
@Override
public List<User> login(String userName, String userPwd) {
List<User> list = userDao.login(userName, userPwd);
System.out.println("list = " + list);
return list;
}
/**
* 注册
* @param userName
* @param userPwd
* @param uSalt
* @return
*/
@Override
public boolean regist(String userName, String userPwd,String uSalt) {
boolean b = userDao.regist(userName, userPwd,uSalt);
return b;
}
/**
* 验证账号唯一性
* @param userName
* @return
*/
@Override
public List<User> unique(String userName) {
List<User> userList = userDao.unique(userName);
return userList;
}
}
在创建serviceImpl层时,要加@Service注解,是为了告诉Spring,要创建UserServiceImpl的实列时,bean的名字必须叫做“userService”
编写Controller层
@Controller
public class UserController {
//service层对象
@Autowired
public IUserService userService;
/**
* 登录
* @param user
* @param session
* @return
* @throws IOException
*/
@RequestMapping("/login")
@ResponseBody
public String login(User user, HttpSession session)throws IOException {
//获取用户名
String userName = user.getUserName();
//获取密码
String userPwd = user.getUserPwd();
//调用service层方法
List<User> list = userService.login(userName,null);
//存储到作用域中
session.setAttribute("userName",userName);
//定义字符串
String message = "false";
//判断是否登录成功
if(list.size()>0) {
//获取用户对象
User userFromDB = list.get(0);
//从数据库中获取盐值
String s = userFromDB.getuSalt();
//拼接
String newPwd = userPwd + s;
//获取加密后的密码
String md5Hex = DigestUtils.md5Hex(newPwd);
//获取数据库中该用户对应的密码
String uPwdFromDB = userFromDB.getUserPwd();
if(md5Hex.equals(uPwdFromDB)){
message = "true";
}
}
return message;
}
/**
* 注册
* @param user
* @return
* @throws IOException
*/
@RequestMapping("/regist")
@ResponseBody
public String regist(User user)throws IOException{
//获取用户名
String userName = user.getUserName();
//获取密码
String userPwd = user.getUserPwd();
//定义字符串
String message = "false";
//调用service层方法
List<User> unique = userService.unique(userName);
if(userName.equals("")){
message = "Please enter your username";
}else{
if(unique.size()>0){
message = "Please change your user name, it already exists";
}else{
//加盐 生成随机字符串
String randomString = RandomCharacters.getRandomString(4);
//拼接 盐值+密码
String newPwd = userPwd + randomString;
//加密
String md5Hex = DigestUtils.md5Hex(newPwd);
//调用service层方法
boolean b = userService.regist(userName,md5Hex,randomString);
if(b == true){
message = "true";
}
}
}
return message;
}
/**
* 检查用户名(验证账号唯一性)
* @param user
* @return
*/
@RequestMapping("/checkUserName")
@ResponseBody
public String checkUserName(User user){
//获取用户名
String userName = user.getUserName();
//调用service层方法
List<User> unique = userService.unique(userName);
//定义字符串
String message = "false";
//判断用户名是否为空
if(userName.equals("")){
message = "Please enter your username";
//判断用户名是否存在
}else if(unique.size()>0){
message = "Please change your user name, it already exists";
}else{
message = "true";
}
return message;
}
}
@Controller 用于标记在一个类上,使用它标记的类就是一个SpringMVC Controller 对象。分发处理器将会扫描使用了该注解的类的方法。通俗来说,被Controller标记的类就是一个控制器,这个类中的方法,就是相应的动作。
@RequestMapping是一个用来处理请求地址映射的注解,可用于类或方法上。用于类上,表示类中的所有响应请求的方法都是以该地址作为父路径。比如图一中,跳转到登录页面的路径就是
@responseBody注解的作用是将controller的方法返回的对象通过适当的转换器转换为指定的格式之后,写入到response对象的body区,通常用来返回JSON数据或者是XML数据。
编写Ajax与后台做交互
登录页面
function login() {
$.ajax({
url:"${pageContext.request.contextPath}/login.do",
type:"POST",
data:{
"userName":$("#login-username").val(),
"userPwd":$("#login-password").val()
},
success:function (result) {
if(result == "true"){
alert("Login Success");
window.location.href="${pageContext.request.contextPath}/index.jsp"
}else{
alert("Login failed");
}
},
error:function (xhr) {
console.log("响应失败信息" + xhr.responseText)
alert("Login failed");
},
dataType:"json"
});
}
注册页面
<script>
//检查用户名
function checkUserName() {
$.ajax({
url:"${pageContext.request.contextPath}/checkUserName.do",
type:"POST",
data:{
"userName":$("#register-username").val()
},
success:function (result) {
if(result != "true"){
$("#tip1").html(result);
return false;
}else{
$("#tip1").html("");
return true;
}
},
dataType:"json"
})
}
//检查密码
function checkUserPwd() {
var userPwd = $("#register-password").val()
if(userPwd == ""){
$("#tip2").html("Please enter your password");
return false;
}else{
$("#tip2").html("");
return true;
}
}
//注册
function checkRegister() {
$.ajax({
url:"${pageContext.request.contextPath}/regist.do",
type:"POST",
data:{
"userName":$("#register-username").val(),
"userPwd":$("#register-password").val()
},
success:function (result) {
if(result == "true"){
alert("Register successfully");
window.location.href="${pageContext.request.contextPath}/login.jsp"
return true;
}else if(checkUserName() == false){
$("#tip1").html(result)
return false;
}else if(checkUserPwd() == false){
$("#tip2").html(result)
return false;
}
},
error:function (xhr) {
console.log(xhr.responseText)
alert("Registration failed");
},
dataType:"json"
})
}
</script>