注册与登录(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&useUnicode=true&characterEncoding=utf8&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;
}
}