SSM整合

    4.0.0

    com.yuan
    SSM
    1.0-SNAPSHOT

    
        17
        17
    

    

    
    
        junit
        junit
        4.13.2
        test
    
    
    
        org.mybatis
        mybatis
        3.5.6
    
    
    
        org.mybatis
        mybatis-spring
        2.0.6
    
    
    
        mysql
        mysql-connector-java
        8.0.28
    
    
    
        org.springframework
        spring-webmvc
        5.3.19
    
    
    
        org.projectlombok
        lombok
        1.18.22
        provided
    
        
        
            org.springframework
            spring-jdbc
            5.3.19
        

    
    

    
        
            
                
                src/main/resources
                
                    ***.xml
                
            
            
                src/main/java
                
                    ***.xml
                
                true
            
        
    

package com.yuan.pojo;

import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;
import lombok.ToString;

@Data
@ToString
@NoArgsConstructor
@AllArgsConstructor
public class Books {
    private long bookID;
    private String bookName;
    private long bookCounts;
    private String detail;
}

public interface BookMapper {
    //查询所有书籍
    List queryAllBooks();

    Books queryBooksById(@Param("id") long id);
    int deleteBooksById(@Param("id") long id);
    int updateBooksById(@Param("id") long id);
    int insertBooks(Books books);
}

    
        select * from books;
    
    
        insert into books(bookID, bookName, bookCounts, detail) values(#{bookID},#{bookName},#{bookCounts},#{detail}) 
    
    
        update books set bookID = #{bookID},bookName = #{bookName},bookCounts = #{bookCounts},detail = #{detail} where bookID = #{id}; 
    
    
        delete from books where bookID = #{id};
    

 
driver=com.mysql.cj.jdbc.Driver
url=jdbc:mysql://localhost:3306/ssmbuild?autoReconnect=true&useUnicode=true&createDatabaseIfNotExist=true&characterEncoding=utf8&useSSL=true&serverTimezone=UTC
user=root
password=yuanxipeng6
 
5.测试运行 
public class UserMapper_Test {
    @Test
    public void queryAllBooks() throws  java.io.IOException
    {
        //获取SqlSession
        String resource = "Mybatis-Config.xml";
        InputStream inputStream = Resources.getResourceAsStream(resource);
        SqlSessionFactory sqlsessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
        SqlSession sqlSession = sqlsessionFactory.openSession();

        //查询所有的书籍
        BooksMapper booksMapper = sqlSession.getMapper(BooksMapper.class);
        List list = booksMapper.queryAllBooks();

        //展示结果
        for (Books book : list)
        {
            System.out.println(book);
        }
    }
}
 
三、spring层 
1.spring整合mybatis层 
1.1创建sqlsession 


        

        

        
            
            
            
            
        

        
            
            
        

        

            
        

 
1.2 修改简化mybatis配置文件 



    
        
        
    
    
        
    
    
        
    

 
这里我们只保留mapper，setting和typealias
 
1.3 注入sqlSession实现类 
 
 
因为我们不能将mapper接口交给spring托管，也就是说接口不能创建实例，现在我们想要使用接口的方法，我们之好编写一个接口的实现类，然后重写它的方法，将sqlsession注入，完成具体的业务。同时这样也方便后面aop织入
 
 
@Repository//将这个类注册为bean
public class BooksMapperImpl implements BooksMapper{
    @Autowired//实现自动装配
    @Qualifier("sqlSessionTemplate")
    private SqlSessionTemplate template;

    @Override
    public List queryAllBooks() {
        BooksMapper booksMapper = template.getMapper(BooksMapper.class);

        return booksMapper.queryAllBooks();
    }

    @Override
    public Books queryBooksById(long id) {
        return null;
    }

    @Override
    public int deleteBooksById(long id) {
        return 0;
    }

    @Override
    public int updateBooksById(long id, Books books) {
        return 0;
    }

    @Override
    public int insertBooks(Books books) {
        return 0;
    }


}
 
1.4 测试 
public class UserMapper_Test {
    @Test
    public void queryAllBooks()
    {
        //获取SqlSession
        ApplicationContext context = new ClassPathXmlApplicationContext("ApplicationContext.xml");
        BooksMapper booksMapper = (BooksMapper) context.getBean("booksMapperImpl");
        for (Books book : booksMapper.queryAllBooks()) {
            System.out.println(book);
        }
    }

}
 
2.spring整合service层 
2.1 Spring-Service.xml配置文件 


    


 
2.2 编写Service层的业务类 
package com.yuan.service;


import com.yuan.mapper.BooksMapperImpl;
import com.yuan.pojo.Books;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.beans.factory.annotation.Qualifier;
import org.springframework.stereotype.Service;

import java.util.List;

@Service
public class BooksServiceImpl implements BooksService{
    @Autowired
    @Qualifier("booksMapperImpl")
    private BooksMapperImpl booksMapperImpl;

    @Override
    public List queryAllBooks() {
        List list = booksMapperImpl.queryAllBooks();
        return list;
    }

    @Override
    public Books queryBooksById(long id) {
        return null;
    }

    @Override
    public int deleteBooksById(long id) {
        return 0;
    }

    @Override
    public int updateBooksById(long id, Books books) {
        return 0;
    }

    @Override
    public int insertBooks(Books books) {
        return 0;
    }
}
 
3.spring整合SpringMVC层 
3.1 将项目类型改为WEB类型 
 
 
因为我创建项目的时候是个普通的maven项目，所以需要改一下project struct(这里注意需要将需要的jar包导入到和class同一目录下面的lib目录里面)
 
 
3.2 注册DispatcherServlet 


    
        springmvc
        org.springframework.web.servlet.DispatcherServlet
        
            contextConfigLocation
             
             
             
            
            classpath:ApplicationContext.xml
        
        1
    
    
        springmvc
        /
    
    
        encodingFilter
        org.springframework.web.filter.CharacterEncodingFilter
        
            encoding
            utf-8
        
    
    
        encodingFilter
        /*
    

 
3.3 spring-MVC.xml文件 


    
    
    
    
    
    
    
    
        
        
    

 
四、业务实现 
 
 
现在框架搭好了我们该实现具体的业务了
 
 
这里我总共实现了五个功能分别是：
 
显示所有用户
添加一个用户
删除一个用户
更新一个用户
按照名字的模糊查询
 
4.1 Mybatis层sql语句 



    
        select * from books;
    
    
        insert into books(bookName, bookCounts, detail) values(#{bookName},#{bookCounts},#{detail})
    
    
        update books set bookName = #{bookName},bookCounts = #{bookCounts},detail = #{detail} where bookID = #{bookID};
    
    
        delete from books where bookID = #{id};
    
    
        select * from books where bookID = #{id};
    
    
    
        select * from books where bookName like concat('%',#{bookName},'%');
    
	

public interface BooksMapper {
    //查询所有书籍
    List queryAllBooks();
    Books queryBooksById(@Param("id") long id);
    int deleteBooksById(@Param("id") long id);
    int updateBooksById(Books books);
    int insertBooks(Books books);
    List queryBooksByName(String bookName);
}

@Repository
public class BooksMapperImpl implements BooksMapper{
    @Autowired
    @Qualifier("sqlSessionTemplate")
    private SqlSessionTemplate template;

    @Override
    public List queryAllBooks() {
        BooksMapper booksMapper = template.getMapper(BooksMapper.class);
        return booksMapper.queryAllBooks();
    }

    @Override
    public Books queryBooksById(long id) {
        BooksMapper booksMapper= template.getMapper(BooksMapper.class);
        Books rs = booksMapper.queryBooksById(id);
        return rs;
    }

    @Override
    public int deleteBooksById(long id) {
        BooksMapper booksMapper = template.getMapper(BooksMapper.class);
        int rs = booksMapper.deleteBooksById(id);
        return rs;
    }

    @Override
    public int updateBooksById( Books books) {
        BooksMapper booksMapper = template.getMapper(BooksMapper.class);
        int rs = booksMapper.updateBooksById(books);
        return rs;
    }

    @Override
    public int insertBooks(Books books) {
        BooksMapper booksMapper = template.getMapper(BooksMapper.class);
        int rs = booksMapper.insertBooks(books);
        return rs;
    }

    @Override
    public List queryBooksByName(String bookName) {
        BooksMapper booksMapper = template.getMapper(BooksMapper.class);
        List rs = booksMapper.queryBooksByName(bookName);
        return rs;
    }


}

这里我们也可以直接BooksServiceImpl 去继承DaoSoupport，从而避免了注入SqlSession

public interface BooksService {
    List queryAllBooks();
    Books queryBooksById( long id);
    int deleteBooksById( long id);
    int updateBooksById(Books books);
    int insertBooks(Books books);
    List queryBooksByName(String bookName);
}

@Service
public class BooksServiceImpl implements BooksService{
    @Autowired
    @Qualifier("booksMapperImpl")
    private BooksMapperImpl booksMapperImpl;

    @Override
    public List queryAllBooks() {
        List list = booksMapperImpl.queryAllBooks();
        return list;
    }

    @Override
    public Books queryBooksById(long id) {
        Books rs = booksMapperImpl.queryBooksById(id);
        return rs;
    }

    @Override
    public int deleteBooksById(long id) {
        int rs = booksMapperImpl.deleteBooksById(id);
        return rs;
    }

    @Override
    public int updateBooksById( Books books) {
        int rs = booksMapperImpl.updateBooksById(books);
        return rs;
    }

    @Override
    public int insertBooks(Books books) {
        int rs = booksMapperImpl.insertBooks(books);
        return rs;
    }

    @Override
    public List queryBooksByName(String bookName) {
        List rs = booksMapperImpl.queryBooksByName(bookName);
        return rs;
    }
}

@Controller
@RequestMapping("/books")
public class MyController {

    @Autowired
    @Qualifier("booksServiceImpl")
    private BooksServiceImpl booksServiceImpl;

    @RequestMapping("/queryAllBooks")
    public String queryAllBooks(Model model)
    {
        List list = booksServiceImpl.queryAllBooks();
        model.addAttribute("list",list);
        return "queryAllBooks";
    }
    @RequestMapping("/gotoInsertBook")
    public String gotoInsertBook()
    {
        return "insertBook";
    }
    @RequestMapping("insertBook")
    public String insertBook(Books book)
    {
        booksServiceImpl.insertBooks(book);
        return "redirect:/books/queryAllBooks";
    }
    @RequestMapping("deleteBook")
    public String deleteBook(long id)
    {
        booksServiceImpl.deleteBooksById(id);
        return "redirect:/books/queryAllBooks";
    }
    @RequestMapping("gotoUpdateBook")
    public String gotoUpdateBook(long id,Model model)
    {
        Books books = booksServiceImpl.queryBooksById(id);
        model.addAttribute("book",books);
        return "updateBook";
    }
    @RequestMapping("updateBook")
    public String updateBook(Books book)
    {
        booksServiceImpl.updateBooksById(book);
        return "redirect:/books/queryAllBooks";
    }
    @RequestMapping("queryBooksByName")
    public String queryBooksByName(String bookName,Model model)
    {
        List list = null;
        //这里我们不能直接bookName==null，这里传过来的对象始终不是null，只是内容始终是空！！！
        if(bookName.equals(""))
        {
            model.addAttribute("msg","输入结果为空！");
        }else
        {
            list = booksServiceImpl.queryBooksByName(bookName);
            model.addAttribute("list",list);
        }
        return "queryAllBooks";
    }
}

主页面：

<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>



    
    



    
        
            
                
                    书籍列表 —— 显示所有书籍
                
            
        
    
    
        
            新增书籍
        
        
            

<%--                --%>
                ${requestScope.get("msg")}
                
                
            
        
    
    
        
            
                    

                

                

                    
书籍编号
                    
书籍名字
                    
书籍数量
                    
书籍详情
                    
操作
                
                
                

                

                        
${book.getBookID()}
                        
${book.getBookName()}
                        
${book.getBookCounts()}
                        
${book.getDetail()}
                        

                            更新
                                    |
                            删除
                        
                    
                
                
            
        
    

添加书籍页面

<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>


    
    
    
    



    
        
            
                
                    新增书籍
                
            
        
    
    

        书籍名称：



        书籍数量：



        书籍详情：



        
    

更新书籍页面

<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>


    
    
    
    



    
        
            
                
                    更新书籍
                
            
        
    
    

        
        书籍名称：



        书籍数量：



        书籍详情：