注册与登录(springmvc+mybatis+spring)

一、实验结果

1、项目目录
在这里插入图片描述
在这里插入图片描述
2、运行项目后
在这里插入图片描述

3、注册
在这里插入图片描述

在这里插入图片描述

3、点击按钮“注册成功,返回主页面”
在这里插入图片描述

4、返回主界面
在这里插入图片描述

5、选择“登录”
(1)用户名、密码错误
在这里插入图片描述
在这里插入图片描述

(2)用户名、密码正确
在这里插入图片描述
在这里插入图片描述
6、数据库
在这里插入图片描述

二、实验环境 Windows 10 ,JavaEE

三、jar包下载

https://mvnrepository.com/

四、实验步骤

1.新建web工程ch10T1,导入jar包(aspectjweaver-1.8.13、c3p0-0.9.1.2、hamcrest-core-1.3、jstl-1.2、junit-4.12、log4j-1.2.12、mybatis-3.4.5、mybatis-spring-1.3.1、mysql-connector-java-5.1.6、mysql-connector-java-8.0.11、protobuf-java-2.6.0、slf4j-api-1.6.6、spring-aop-5.0.2.RELEASE、spring-beans-5.0.2.RELEASE、spring-context-5.0.2.RELEASE、spring-core-5.0.2.RELEASE、
spring-expression-5.0.2.RELEASE、spring-jcl-5.0.2.RELEASE、spring-jdbc-5.0.2.RELEASE、spring-test-5.0.2.RELEASE、
spring-tx-5.0.2.RELEASE、spring-web-5.0.2.RELEASE、spring-webmvc-5.0.2.RELEASE)

2.打开MySQL Workbench,输入sql语句,在student数据库下建表

create table db3(
    id int  primary key auto_increment,
    uname varchar(30) not null,
    upwd varchar(20) not null,
    uage int not null
)character set utf8 collate utf8_general_ci; 

3.在WebContent/WEB-INF下新建web.xml

<?xml version="1.0" encoding="UTF-8"?>
<web-app
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns="http://java.sun.com/xml/ns/javaee"
xsi:schemaLocation="http://java.sun.com/xml/ns/javaee 
http://java.sun.com/xml/ns/javaee/web-app_3_1.xsd"
>

  <!--配置监听器spring,默认只加载WEB-INF目录的applicationContext.xml的配置文件 -->
  <listener>  <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
  </listener>
  <!--设置配置文件的路径 -->
  <context-param>
    <param-name>contextConfigLocation</param-name>   <param-value>classpath:applicationContext.xml</param-value>
  </context-param>

  <!--中文乱码 过滤器 -->
  <filter>
    <filter-name>characterEncodingFilter</filter-name>    <filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class>

    <init-param><!-- 编码集-->
      <param-name>encoding</param-name>
      <param-value>utf-8</param-value>
    </init-param>
  </filter>

  <filter-mapping>
    <filter-name>characterEncodingFilter</filter-name>
    <url-pattern>/*</url-pattern>
  </filter-mapping>

  <!-- 前端控制器-->
  <servlet>
    <servlet-name>dispatcherServlet</servlet-name> <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
    <init-param>
      <param-name>contextConfigLocation</param-name>
      <param-value>classpath:springmvc.xml</param-value>
    </init-param>
    <load-on-startup>1</load-on-startup><!--启动服务器·,创建该Servlet -->
  </servlet>
  <servlet-mapping>
    <servlet-name>dispatcherServlet</servlet-name>
    <url-pattern>/</url-pattern><!-- /发任何请求都会通过servlet-->
  </servlet-mapping>
</web-app>

4.在src下新建applicationContext.xml及springmvc.xml
(1)applicationContext.xml

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
       xmlns:mvc="http://www.springframework.org/schema/mvc"
       xmlns:context="http://www.springframework.org/schema/context"
       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
       xsi:schemaLocation="http://www.springframework.org/schema/beans
        http://www.springframework.org/schema/beans/spring-beans.xsd
        http://www.springframework.org/schema/mvc
        http://www.springframework.org/schema/mvc/spring-mvc.xsd
        http://www.springframework.org/schema/context
        http://www.springframework.org/schema/context/spring-context.xsd">
    
    <!-- 配置Controller注解,其他的不配置-->
    <context:component-scan base-package="com.itc">
        <context:exclude-filter type="annotation" expression="org.springframework.stereotype.Controller"/>
    </context:component-scan>
    
    
    <!--配置连接池 -->
    <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
        <property name="driverClass" value="com.mysql.cj.jdbc.Driver"/>
        <property name="jdbcUrl" value="jdbc:mysql://localhost:3306/student?serverTimezone=GMT&amp;useUnicode=true&amp;characterEncoding=utf8&amp;useSSL=false"/>
        <property name="user" value="root"/>
        <property name="password" value="123456"/>
    </bean>
    <!--配置sqlsessionFactory工程 -->
    <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
        <property name="dataSource" ref="dataSource"/>
    </bean>
    <!--配置AccountDao接口所在位置 -->
    <bean  id="mapperScannerConfigurer" class="org.mybatis.spring.mapper.MapperScannerConfigurer">
        <property name="basePackage" value="com.itc.dao"></property>
    </bean>
</beans>

(2)springmvc.xml

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
       xmlns:mvc="http://www.springframework.org/schema/mvc"
       xmlns:context="http://www.springframework.org/schema/context"
       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
       xsi:schemaLocation="http://www.springframework.org/schema/beans
        http://www.springframework.org/schema/beans/spring-beans.xsd
        http://www.springframework.org/schema/mvc
        http://www.springframework.org/schema/mvc/spring-mvc.xsd
        http://www.springframework.org/schema/context
        http://www.springframework.org/schema/context/spring-context.xsd">
    
    <!-- 配置Controller注解,其他的不配置-->
    <context:component-scan base-package="com.itc">
        <context:include-filter type="annotation" expression="org.springframework.stereotype.Controller"/>
    </context:component-scan>

    <!-- 视图解析器-->
    <bean id="viewResolver" class="org.springframework.web.servlet.view.InternalResourceViewResolver">
<!--JSP所在目录 -->
        <property name="prefix" value="/WEB-INF/views/"></property>
        <property name="suffix" value=".jsp"></property>
    </bean>
    <!-- 开启SpringMVC注解支持-->
    <mvc:annotation-driven/>
</beans>

5.在src下新建包com.itc.controller,并建立UserController类

package com.itc.controller;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpSession;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;

import com.itc.service.UserService;
import com.itc.enty.User;

@Controller
public class UserController {
	@Autowired
	private UserService userService;
	@RequestMapping("/log2")
	public String t1(){
		return "login";
	}
	@RequestMapping("/reg2")
	public String t2(){
        return "register";}
	
	@RequestMapping("/login1")
	public String test1(User user,HttpServletRequest request){
		User u1=userService.log(user);
	//	System.out.print(u1.getUname());
		System.out.print(u1);
	    if(u1==null){
			request.setAttribute("errorMsg", "用户名或密码错误!");

		return "login";}//登录失败,提示信息,并返回“登录页面”
		else {
			HttpSession session=request.getSession();
			session.setAttribute("currentUser", u1.getUname());
			
			return "success";}//登陆成功
	}
	@RequestMapping("/register1")
	public String test2(User user){
		userService.reg(user);
		System.out.print("注册成功");
		return "reback";//注册成功,返回登录页面
	}
}

6.在WebContent/WEB-INF下新建目录views,并在目录下新建login.jsp、register.jsp、reback.jsp、success.jsp
(1)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>
</head>
<body>
<h2>登录</h2>
<form action="login1" method="get">
  姓名: <input type="text" name="uname"/><br/>
 密码:     <input type="text" name="upwd"/><br/>
    <input type="submit" value="登录"/><br/>
    <font color="red">${requestScope.errorMsg}</font>
   
</form>
</body>
</html>

(2)register.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>
</head>
<body>
<h2>注册</h2>
<form action="register1" method="post">
  姓名: <input type="text" name="uname"/><br/>
 密码:     <input type="text" name="upwd"/><br/>
  年龄:     <input type="text" name="uage"/><br/>
    <input type="submit" value="注册"/><br/>
   
</form>
</body>
</html>

(3)reback.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>
<script>
	function fun(){
		alert("确认返回主页面");	
 		window.history.go(-2);
	}
	
</script>
</head>
<body>
<input type="button" value="注册成功,返回主页面" onclick="fun()"/>

</body>
</html>

(4)success.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>
</head>
<body>
<h1>${currentUser }登陆成功!</h1>
</body>
</html>

7.在WebContent下新建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>
</head>
<body>
<h2><a href="log2">登录</a></h2><br/>
<h2><a href="reg2">注册</a></h2><br/>
</body>
</html>

8、在src下新建com.itc.dao包,UserDao接口

package com.itc.dao;

import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;

import com.itc.enty.User;
@Repository
public interface UserDao {
	@Select("select * from db3 where uname=#{uname} and upwd=#{upwd}")
	public User log(User user);
    @Insert("insert into db3(uname,upwd,uage) values(#{uname},#{upwd},#{uage})")
	public void reg(User user);
}

9、在src下新建com.itc.service包,UserServiceImpl类及接口UserService
(1)UserService

package com.itc.service;

import com.itc.enty.User;

public interface UserService {
	public User log(User user);
	public void reg(User user);
}

(2)UserServiceImpl

package com.itc.service;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import com.itc.dao.UserDao;
import com.itc.enty.User;
@Service("UserSe1")
public class UserServiceImpl implements UserService{
    @Autowired
	private UserDao userDao;
	public User log(User user){
		return userDao.log(user);
	}

	public void reg(User user) {
	     userDao.reg(user);
	}

}

10、在src下新建com.itc.enty包,User类

package com.itc.enty;

public class User {
	private int id;
	private String uname;
	private String upwd;
	private int uage;
	public int getId() {
		return id;
	}
	public void setId(int id) {
		this.id = id;
	}
	public String getUname() {
		return uname;
	}
	public void setUname(String uname) {
		this.uname = uname;
	}
	public String getUpwd() {
		return upwd;
	}
	public void setUpwd(String upwd) {
		this.upwd = upwd;
	}
	public int getUage() {
		return uage;
	}
	public void setUage(int uage) {
		this.uage = uage;
	}
	@Override
	public String toString() {
		return "User [id=" + id + ", uname=" + uname + ", upwd=" + upwd + ", uage=" + uage + "]";
	}
	public User(){
		super();
	}

	public User(int id, String uname, String upwd, int uage) {
		super();
		this.id = id;
		this.uname = uname;
		this.upwd = upwd;
		this.uage = uage;
	}
}
  • 0
    点赞
  • 4
    收藏
    觉得还不错? 一键收藏
  • 1
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论 1
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值