MyBatis-Spring整合

目录结构:

  
    
    
      org.aspectj
      aspectjweaver
      1.9.4
    
    
      org.springframework
      spring-jdbc
      5.3.1
    
    
      org.springframework
      spring-tx
      5.3.1
    
    
      org.springframework
      spring-core
      5.3.1
    
    
      org.springframework
      spring-context
      5.3.1
    
    
      org.springframework
      spring-beans
      5.3.1
    
    
      org.springframework
      spring-aop
      5.3.1
    
    
      org.springframework
      spring-jdbc
      5.3.1
    
    
      org.springframework
      spring-orm
      5.3.1
    
    
      org.springframework
      spring-web
      5.3.1
    
    
      org.springframework
      spring-webmvc
      5.3.1
    
    
      org.aspectj
      aspectjweaver
      1.6.8
    
    
    
      com.alibaba
      druid
      1.1.18
    
    
    
      mysql
      mysql-connector-java
      5.1.6
    

    
      javax.servlet
      javax.servlet-api
      3.1.0
      provided
    
    
      cglib
      cglib
      2.2
    


    
    
    
      org.mybatis
      mybatis
      3.4.5
    

    
      org.mybatis
      mybatis-spring
      2.0.6
    

    
    
      log4j
      log4j
      1.2.17
    
    
      jstl
      jstl
      1.2
    
    
      com.alibaba
      fastjson
      1.2.58
    
    
      com.fasterxml.jackson.core
      jackson-core
      2.9.8
    
    
      com.fasterxml.jackson.core
      jackson-databind
      2.9.8
    
    
      com.fasterxml.jackson.core
      jackson-annotations
      2.9.8
    
  

  
    
      
        src/main/java
        
          **/*.xml
        
      
    
  

导入依赖后先把待会要配置的xml文件分别创建出来

    
        org.springframework.web.context.ContextLoaderListener
    

    
        contextConfigLocation
        classpath:applicationContext.xml
    

    
        dispatcher
        org.springframework.web.servlet.DispatcherServlet
        1
    
    
        dispatcher
        /
    

需注意,SpringMVC配置文件的文件名必须为web.xml中配置的servlet-name后面加-servlet.xml

 数据库配置文件db.properties

jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/book_db?allowMultiQueries=true
jdbc.username=root
jdbc.password=root

mybatis-config中其实已经可以删除了,但是我们留着它可以对mybatis进行一些设置

随便找了一张之前创建的表,用于测试

到配置文件中改一下数据库URL

创建Book类

编写BookMapper.xml

    
        id bookId,name bookName,author,`attribute`,introduce
    
    
        select  from t_book
    

编写BookMapper接口

@Mapper
public interface BookMapper {
    List selBook();
}

编写Service接口

public interface BookService {
    List selBook();
}

编写Service实现类

@Service
public class BookServiceImpl implements BookService{
    @Autowired
    private BookMapper bookMapper;
    @Override
    public List selBook() {
        return bookMapper.selBook();
    }
}

编写Controller

@Controller
public class BookController {
    @Autowired
    private BookService bookService;
    @RequestMapping("/getBooks")
    public String getBooks(Model model){
        List books = bookService.selBook();
        model.addAttribute("books",books);
        return "list";
    }
}

编辑请求页面

<%@ page contentType="text/html;charset=UTF-8" language="java" %>


    


    获取所有书籍信息

编辑响应成功页面

    
            

        

            
ID
            
名称
            
作者
            
属性
            
描述
        
        

                
${book.bookId}
                
${book.bookName}
                
${book.author}
                
${book.attribute}
                
${book.introduce}
            
        
    

然后配置完Tomcat就OK了