Sping5整合MyBatis3实战

短命女 2021-07-24 12:57 306阅读 0赞

**一 开发环境搭建**

1 安装JDK8

2 安装Eclipse，并配置JRE环境

3 安装Tomcat8，并在Eclipse中集成Tomcat8

4 安装MySQL 5以上数据库。

**二 准备所需的jar包**

1 Spring框架jar包

2 MyBatis框架jar包

3 MyBatis整合Spring中间件jar包

4 aspectj框架jar包

5 数据库驱动包

6 数据源C3P0所需jar包

7 JSTL标签库jar包

**三 数据库表**

1 tb\_user

CREATE TABLE tb_user(
    id INT PRIMARY KEY AUTO_INCREMENT,      #id
    loginname VARCHAR(50) UNIQUE,        #登录名 邮箱
    PASSWORD VARCHAR(18),            #密码
    username VARCHAR(18),            #用户名
    phone VARCHAR(18),            #电话
    address VARCHAR(255)            #地址
    );

2 tb\_book

CREATE TABLE tb_book (
        id INT (11) PRIMARY KEY AUTO_INCREMENT,
        name VARCHAR (54),
        author VARCHAR (54),
        publicationdate DATE ,
        publication VARCHAR (150),
        price DOUBLE ,
        image VARCHAR (54),
        remark VARCHAR (600)
    );

**四 配置文件**

1 db.properties

dataSource.driverClass=com.mysql.jdbc.Driver
    dataSource.jdbcUrl=jdbc:mysql://127.0.0.1:3306/mybatis
    dataSource.user=root
    dataSource.password=123456
    dataSource.maxPoolSize=20
    dataSource.maxIdleTime = 1000
    dataSource.minPoolSize=6
    dataSource.initialPoolSize=5

2 applicationContext.xml

<?xml version="1.0" encoding="UTF-8"?>
    <beans xmlns="http://www.springframework.org/schema/beans"
         xmlns:mybatis="http://mybatis.org/schema/mybatis-spring"
         xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xmlns:p="http://www.springframework.org/schema/p"
         xmlns:context="http://www.springframework.org/schema/context"
         xmlns:mvc="http://www.springframework.org/schema/mvc"
         xmlns:tx="http://www.springframework.org/schema/tx"
         xsi:schemaLocation="http://www.springframework.org/schema/beans
                                 http://www.springframework.org/schema/beans/spring-beans.xsd
                                 http://www.springframework.org/schema/context
                                 http://www.springframework.org/schema/context/spring-context.xsd
                                 http://www.springframework.org/schema/mvc
                                 http://www.springframework.org/schema/mvc/spring-mvc.xsd
                                 http://www.springframework.org/schema/tx
                                 http://www.springframework.org/schema/tx/spring-tx.xsd
                                 http://mybatis.org/schema/mybatis-spring
                                 http://mybatis.org/schema/mybatis-spring.xsd ">
                          
            
        <mybatis:scan base-package="org.fkit.mapper"/>   
           
          
        <context:component-scan base-package="org.fkit"/>
        
         
         <context:property-override  location="classpath:db.properties"/>
         
         <bean id="dataSource"  class="com.mchange.v2.c3p0.ComboPooledDataSource"/>
         
         
         <bean id="sqlSessionFactory"  class="org.mybatis.spring.SqlSessionFactoryBean"
             p:dataSource-ref="dataSource"/>
         
         
         <bean id="transactionManager"
         class="org.springframework.jdbc.datasource.DataSourceTransactionManager"
                p:dataSource-ref="dataSource"/>
         
         
         <tx:annotation-driven  transaction-manager="transactionManager"/>
         
    </beans>

3 springmvc-config.xml

<?xml version="1.0" encoding="UTF-8"?>
    <beans xmlns="http://www.springframework.org/schema/beans"
        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
        xmlns:mvc="http://www.springframework.org/schema/mvc"
        xmlns:p="http://www.springframework.org/schema/p"
         xmlns:context="http://www.springframework.org/schema/context"
        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">
            
        
        <context:component-scan base-package="org.fkit.controller"/>
        
        <mvc:annotation-driven/>
        
        <mvc:default-servlet-handler/>
       
         <bean id="viewResolver"
               class="org.springframework.web.servlet.view.InternalResourceViewResolver"
              p:prefix="/WEB-INF/content/" p:suffix=".jsp"/>
        
    </beans>

4 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_3_1.xsd"
         id="WebApp_ID" version="3.1">
         
         
         <listener>
               <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
         </listener>
         
         <context-param>
               <param-name>contextConfigLocation</param-name>
               <param-value>/WEB-INF/applicationContext*.xml</param-value>
         </context-param>
         
         
      <servlet>
        <servlet-name>springmvc</servlet-name>
        <servlet-class>
            org.springframework.web.servlet.DispatcherServlet
        </servlet-class>
        <init-param>
          <param-name>contextConfigLocation</param-name>
          <param-value>/WEB-INF/springmvc-config.xml</param-value>
        </init-param>
        <load-on-startup>1</load-on-startup>
      </servlet>
      
      
      <servlet-mapping>
        <servlet-name>springmvc</servlet-name>
        <url-pattern>/</url-pattern>
      </servlet-mapping>
      
      
      <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>
         
    </web-app>

5 log4j.xml

<?xml version="1.0" encoding="UTF-8"?>
    <!DOCTYPE log4j:configuration SYSTEM "log4j.dtd">  
    <log4j:configuration  xmlns:log4j="http://jakarta.apache.org/log4j/">  
        <appender name="STDOUT"  class="org.apache.log4j.ConsoleAppender">  
            <layout class="org.apache.log4j.PatternLayout">  
                <param name="ConversionPattern" value="%5p [%t] %m%n"  />  
            </layout>  
        </appender>   
         <logger name="org.fkit.mapper">  
            <level value="DEBUG" />  
        </logger>
        <root>  
            <level value="ERROR" />  
            <appender-ref ref="STDOUT" />  
        </root>  
    </log4j:configuration>

**五 领域模型**

1 Book

package org.fkit.domain;
    
    import java.io.Serializable;
    import java.util.Date;
    
    /**
    * CREATE TABLE tb_book (
        id INT (11) PRIMARY KEY AUTO_INCREMENT,
        name VARCHAR (54),
        author VARCHAR (54),
        publicationdate DATE ,
        publication VARCHAR (150),
        price DOUBLE ,
        image VARCHAR (54),
        remark VARCHAR (600)
    );
    * */
    public class Book implements Serializable{
        
        private static final long serialVersionUID = 1L;
        
        private Integer id;                // id    
        private String name;            // 书名
        private String author;            // 作者
        private String publication;        // 出版社
        private Date publicationdate;    // 出版日期
        private Double price;            // 价格
        private String image;            // 封面图片
        private String remark;            // 详细描述
        
        public Book() {
            super();
            // TODO Auto-generated constructor stub
        }
        public Integer getId() {
            return id;
        }
        public void setId(Integer id) {
            this.id = id;
        }
        public String getName() {
            return name;
        }
        public void setName(String name) {
            this.name = name;
        }
        public String getAuthor() {
            return author;
        }
        public void setAuthor(String author) {
            this.author = author;
        }
        public String getPublication() {
            return publication;
        }
        public void setPublication(String publication) {
            this.publication = publication;
        }
        public Date getPublicationdate() {
            return publicationdate;
        }
        public void setPublicationdate(Date publicationdate) {
            this.publicationdate = publicationdate;
        }
        public Double getPrice() {
            return price;
        }
        public void setPrice(Double price) {
            this.price = price;
        }
        public String getImage() {
            return image;
        }
        public void setImage(String image) {
            this.image = image;
        }
        public String getRemark() {
            return remark;
        }
        public void setRemark(String remark) {
            this.remark = remark;
        }
        @Override
        public String toString() {
            return "Book [id=" + id + ", name=" + name + ", author=" + author
                    + ", publication=" + publication + ", publicationdate="
                    + publicationdate + ", price=" + price + ", image=" + image
                    + ", remark=" + remark + "]";
        }
        
    
    }

2 User

package org.fkit.domain;
    import java.io.Serializable;
    /**
    * CREATE TABLE tb_user(
    id INT PRIMARY KEY AUTO_INCREMENT,      #id
    loginname VARCHAR(50) UNIQUE,        #登录名 邮箱
    PASSWORD VARCHAR(18),           #密码
    username VARCHAR(18),           #用户名
    phone VARCHAR(18),              #电话
    address VARCHAR(255)            #地址
    );
    * */
    public class User implements Serializable{
         private static final long serialVersionUID = 1L;
         
         private Integer id;             // id
         private String loginname;  // 登录名
         private String password;   // 密码
         private String username;   // 用户名
         private String phone;      // 电话
         private String address;         // 地址
         
         public User() {
               super();
               // TODO Auto-generated constructor stub
         }
         public Integer getId() {
               return id;
         }
         public void setId(Integer id) {
               this.id = id;
         }
         public String getLoginname() {
               return loginname;
         }
         public void setLoginname(String loginname) {
               this.loginname = loginname;
         }
         public String getPassword() {
               return password;
         }
         public void setPassword(String password) {
               this.password = password;
         }
         public String getUsername() {
               return username;
         }
         public void setUsername(String username) {
               this.username = username;
         }
         public String getPhone() {
               return phone;
         }
         public void setPhone(String phone) {
               this.phone = phone;
         }
         public String getAddress() {
               return address;
         }
         public void setAddress(String address) {
               this.address = address;
         }
         @Override
         public String toString() {
               return "User [id=" + id + ", loginname=" + loginname  + ", password="
                         + password + ", username=" + username + ",  phone=" + phone
                         + ", address=" + address + "]";
         }
         
         
    }

**六 mapper**

1 BookMapper

package org.fkit.mapper;
    
    import java.util.List;
    import org.apache.ibatis.annotations.Select;
    import org.fkit.domain.Book;
    
    /**
    * BookMapper接口
    * */
    public interface BookMapper {
    
        /**
         * 查询所有图书
         * @return 图书对象集合
         * */
        @Select(" select * from tb_book ")
        List<Book> findAll();
        
    }

2 UserMapper

package org.fkit.mapper;
    
    import org.apache.ibatis.annotations.Param;
    import org.apache.ibatis.annotations.Select;
    import org.fkit.domain.User;
    
    /**
    * UserMapper接口
    * */
    public interface UserMapper {
        
        /**
         * 根据登录名和密码查询用户
         * @param String loginname
         * @param String password
         * @return 找到返回User对象，没有找到返回null
         * */
        @Select("select * from tb_user where loginname = #{loginname} and password = #{password}")
        User findWithLoginnameAndPassword(@Param("loginname")String loginname,
                @Param("password") String password);
    
    }

**七 业务层接口**

1 BookService

package org.fkit.service;
    
    import java.util.List;
    import org.fkit.domain.Book;
    
    /**
    * Book服务层接口
    * */
    public interface BookService {
        
        /**
         * 查找所有图书
         * @return Book对象集合
         * */
        List<Book> getAll();
    
    }

2 UserService

package org.fkit.service;
    import org.fkit.domain.User;
    /**
    * User服务层接口
    * */
    public interface UserService {
         
         /**
          * 判断用户登录
          * @param String loginname
          * @param String password
          * @return 找到返回User对象，没有找到返回null
          * */
         User login(String loginname,String password);
    }

**八 业务层接口实现类**

1 BookServiceImpl

package org.fkit.service.impl;
    
    import java.util.List;
    import org.fkit.domain.Book;
    import org.fkit.mapper.BookMapper;
    import org.fkit.service.BookService;
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.stereotype.Service;
    import org.springframework.transaction.annotation.Isolation;
    import org.springframework.transaction.annotation.Propagation;
    import org.springframework.transaction.annotation.Transactional;
    
    /**
    * Book服务层接口实现类
    * @Service("bookService")用于将当前类注释为一个Spring的bean，名为bookService
    * */
    @Transactional(propagation=Propagation.REQUIRED,isolation=Isolation.DEFAULT)
    @Service("bookService")
    public class BookServiceImpl implements BookService {
        
        /**
         * 自动注入BookMapper
         * */
        @Autowired
        private BookMapper bookMapper;
    
        /**
         * BookService接口getAll方法实现
         * @see { BookService }
         * */
        @Transactional(readOnly=true)
        @Override
        public List<Book> getAll() {
            
            return bookMapper.findAll();
        }
    
    }

2 UserServiceImpl

package org.fkit.service.impl;
    
    import org.fkit.domain.User;
    import org.fkit.mapper.UserMapper;
    import org.fkit.service.UserService;
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.stereotype.Service;
    import org.springframework.transaction.annotation.Isolation;
    import org.springframework.transaction.annotation.Propagation;
    import org.springframework.transaction.annotation.Transactional;
    
    /**
    * User服务层接口实现类
    * @Service("userService")用于将当前类注释为一个Spring的bean，名为userService
    * */
    @Transactional(propagation=Propagation.REQUIRED,isolation=Isolation.DEFAULT)
    @Service("userService")
    public class UserServiceImpl implements UserService {
        
        /**
         * 自动注入UserMapper
         * */
        @Autowired
        private UserMapper userMapper;
    
        /**
         * UserService接口login方法实现
         * @see { UserService }
         * */
        @Transactional(readOnly=true)
        @Override
        public User login(String loginname, String password) {
            return userMapper.findWithLoginnameAndPassword(loginname, password);
        }
    
    }

**九 控制器**

1 BookController

package org.fkit.controller;
    
    import java.util.List;
    import org.fkit.domain.Book;
    import org.fkit.service.BookService;
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.beans.factory.annotation.Qualifier;
    import org.springframework.stereotype.Controller;
    import org.springframework.ui.Model;
    import org.springframework.web.bind.annotation.RequestMapping;
    
    /**
    * 处理图书请求控制器
    * */
    @Controller
    public class BookController {
        
        /**
         * 自动注入BookService
         * */
        @Autowired
        @Qualifier("bookService")
        private BookService bookService;
    
        /**
         * 处理/main请求
         * */
        @RequestMapping(value="/main")
         public String main(Model model){
            // 获得所有图书集合
            List<Book> book_list = bookService.getAll();
            // 将图书集合添加到model当中
            model.addAttribute("book_list", book_list);
            // 跳转到main页面
            return "main";
        }
        
    }

2 UserController

package org.fkit.controller;
    
    import javax.servlet.http.HttpSession;
    import org.fkit.domain.User;
    import org.fkit.service.UserService;
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.beans.factory.annotation.Qualifier;
    import org.springframework.stereotype.Controller;
    import org.springframework.web.bind.annotation.PostMapping;
    import org.springframework.web.servlet.ModelAndView;
    import org.springframework.web.servlet.view.RedirectView;
    
    /**
    * 处理用户请求控制器
    * */
    @Controller
    public class UserController {
        
        /**
         * 自动注入UserService
         * */
        @Autowired
        @Qualifier("userService")
        private UserService userService;
    
        /**
         * 处理/login请求
         * */
        @PostMapping(value="/login")
         public ModelAndView login(
                 String loginname,String password,
                 ModelAndView mv,
                 HttpSession session){
            // 根据登录名和密码查找用户，判断用户登录
            User user = userService.login(loginname, password);
            if(user != null){
                // 登录成功，将user对象设置到HttpSession作用范围域
                session.setAttribute("user", user);
                // 转发到main请求
                mv.setView(new RedirectView("/fkbookapp/main"));
            }else{
                // 登录失败，设置失败提示信息，并跳转到登录页面
                mv.addObject("message", "登录名或密码错误，请重新输入!");
                mv.setViewName("loginForm");
            }
            return mv;
        }
        
        
    }

3 FormController

package org.fkit.controller;
    
    import org.springframework.stereotype.Controller;
    import org.springframework.web.bind.annotation.RequestMapping;
    
    
    /**
    * 页面跳转控制器
    * */
    @Controller
    public class FormController{
    
        @RequestMapping(value="/loginForm")
         public String loginForm(){
            // 跳转页面
            return "loginForm";
        }
    
    }

**十 视图**

1 loginForm.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>
    <h3>登录页面</h3>
    <form action="login" method="post">
         <font color="red">${requestScope.message }</font>
         <table>
             <tr>
                <td><label>登录名: </label></td>
                 <td><input type="text" id="loginname"  name="loginname" ></td>
             </tr>
             <tr>
                <td><label>密码: </label></td>
                 <td><input type="password" id="password"  name="password" ></td>
             </tr>
             <tr>
                 <td><input type="submit" value="登录"></td>
             </tr>
         </table>
    </form>
    </body>
    </html>

2 main.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"
        pageEncoding="UTF-8"%>
    <%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %>
    <!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>
    <style type="text/css">
         table{border-collapse:collapse;border-spacing:0;border-left:1px  solid #888;border-top:1px solid #888;background:#efefef;}
         th,td{border-right:1px solid #888;border-bottom:1px solid  #888;padding:5px 15px;}
         th{font-weight:bold;background:#ccc;}
    </style>
    </head>
    <body>
    欢迎[${sessionScope.user.username }]访问
    
    <table border="1">
         <tr>
               <th>封面</th><th>书名</th><th>作者</th><th>价格</th>
         </tr>
         <c:forEach items="${requestScope.book_list }" var="book">
               <tr>
                    <td><img src="images/${book.image }"  height="60"></td>
                    <td>${book.name }</td>
                    <td>${book.author }</td>
                    <td>${book.price }</td>
               </tr>
         </c:forEach>
    </table>
    </body>
    </html>

**十一 测试**

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2NoZW5ncWl1bWluZw_size_16_color_FFFFFF_t_70][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2NoZW5ncWl1bWluZw_size_16_color_FFFFFF_t_70 1][]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2NoZW5ncWl1bWluZw_size_16_color_FFFFFF_t_70]: /images/20210724/9699d570c55d42759c1c8dd673260ec8.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2NoZW5ncWl1bWluZw_size_16_color_FFFFFF_t_70 1]: /images/20210724/5cb9b35dbe6b44a78a7ab04270dd164b.png