SSM框架整合案例【可直接在此基础上开发】

案例项目下载：https://download.csdn.net/download/qq_45021180/84967718

案例项目配置：https://blog.csdn.net/qq_45021180/article/details/123501818

准备一、Mybatis层二、Spring层三、SpringMVC层四、编写增删改查

1. 查询2. 添加3. 修改4. 删除5. 搜索

1.创建一个Maven项目
2.导入依赖（pom.xml）：

 
 
     
     
         junit
         junit
         4.12
     
     
     
         mysql
         mysql-connector-java
         8.0.25
     
     
     
         com.mchange
         c3p0
         0.9.5.2
     
     
     
         javax.servlet
         servlet-api
         2.5
     
     
         javax.servlet
         jstl
         1.2
     
     
         javax.servlet.jsp
         jsp-api
         2.2
     
     
     
         org.mybatis
         mybatis
         3.5.6
     
     
         org.mybatis
         mybatis-spring
         2.0.6
     
     
     
         org.springframework
         spring-webmvc
         5.1.9.RELEASE
     
     
         org.springframework
         spring-jdbc
         5.3.8
     
     
	  
	      org.projectlombok
	      lombok
	      1.16.10
	  
 

3.Maven资源过滤设置(pom.xml)：静态资源导出问题

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

4.applicationContext.xml

1. database.properties

jdbc.driver=com.mysql.jdbc.Driver
#在和mysql传递数据的过程中，使用unicode编码格式，并且字符集设置为utf-8
#如果使用的是MySQL8.0+,需要添加一个时区的配置
jdbc.url=jdbc:mysql://127.0.0.1:3306/smbms?useUnicode=true&characterEncoding=utf-8&zeroDateTimeBehavior=convertToNull
jdbc.user=root
jdbc.password=123456

2. mybatis-config

3. pojo.Books

@Data
@AllArgsConstructor
@NoArgsConstructor
public class Books {
    private int id;
    private String name;
    private int count;
}

4. dao下 BookMapper.java

public interface BookMapper {
    //添加一本书
    public int addBook(Books books);
    //删除一本书
    public int deleteBookById(int id);
    //更新一本书
    public int updateBook(Books books);
    //查询一本书
    public Books queryBookById(int id);
    //查询所有书
    public List queryAllBook();
}

5. dao下： BookMapper.xml

    
        insert into user_db.books (id,name,count)
        values (#{id},#{name},#{count});
    

    
        delete from user_db.books
        where id=#{id}
    

    
        update user_db.books
        set name=#{name},count=#{count}
        where id=#{id}
    

    
        select * from user_db.books
        where id=#{id}
    

    
        select * from user_db.books
    

6. BookService.java

public interface BookService {
    //添加一本书
    int addBook(Books books);
    //删除一本书
    int deleteBookById(int id);
    //更新一本书
    int updateBook(Books books);
    //查询一本书
    Books queryBookById(int id);
    //查询所有书
    List queryAllBook();
}

7. BookServiceImpl.java

public class BookServiceImpl implements BookService {
    // Service层要调用dao层，所有将dao层组合进来
    private BookMapper bookMapper;  // 自动注入，添加set方法
    public void setBookMapper(BookMapper bookMapper) {
        this.bookMapper = bookMapper;
    }
    @Override
    public int addBook(Books books) {
        return bookMapper.addBook(books);
    }
    @Override
    public int deleteBookById(int id) {
        return bookMapper.deleteBookById(id);
    }
    @Override
    public int updateBook(Books books) {
        return bookMapper.updateBook(books);
    }
    @Override
    public Books queryBookById(int id) {
        return bookMapper.queryBookById(id);
    }
    @Override
    public List queryAllBook() {
        return bookMapper.queryAllBook();
    }
}

1. spring-dao.xml

2. spring-service.xml

1. 添加web框架支持
2. web.xml

    
    
        springmvc
        org.springframework.web.servlet.DispatcherServlet
        
            contextConfigLocation
            classpath:applicationContext.xml
        
        1
    
    
        springmvc
        /
    

    
    
        encodingFilter
        
            org.springframework.web.filter.CharacterEncodingFilter
        
        
            encoding
            UTF-8
        
        
            forceEncoding
            true
        
    
    
        encodingFilter
        /*
    


    
    
        15
    

3. spring-mvc.xml

BookController.java

@Controller
@RequestMapping("/book")
public class BookController {

    @Autowired
    @Qualifier("bookServiceImpl")
    private BookService bookService;

    //查询所有书籍
    @RequestMapping("/allBook")
    public String getAllBook(Model model){
        List books = bookService.queryAllBook();
        model.addAttribute("bookList",books);
        return "allBook";
    }
}

2. index.jsp

查看所有书籍

3. allBook.jsp

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


    
    


	添加书籍
	
	            

	    

	        

	            
书籍编号
	            
书籍名称
	            
书籍数量
	            
操作
	        
	    
	    

	        

	                
${book.id}
	                
${book.name}
	                
${book.count}
	                

	                    修改  | 
	                    删除
                	
	            
	        
	    
	

结果：

1. addBook.jsp

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


    
    


    
添加书籍
    

        

            书籍名称：
            
        
        

            书籍数量：
            
        
        

            
        
    

2. BookController

 //2.添加书籍
 //2.1 跳转到添加书籍界面
 @RequestMapping("/toAddBook")
 public String toAddBook(Model model){
     return "addBook";
 }
 //2.2添加书籍
 @PostMapping("/addBook")
 public String addBook(Books books){
     System.out.println("添加书籍：" + books);
     bookService.addBook(books);
     return "redirect:/book/allBook";
 }

结果：

updateBook.jsp

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


    
    



    
修改书籍
    

        
        

            书籍名称：
            
        
        

            书籍数量：
            
        
        

            
        
    

BookController.java

//3.修改书籍
//3.1 跳转到修改书籍界面
@RequestMapping("/toUpdateBook")
public String toUpdateBook(int id,Model model){
    System.out.println("修改的ID："+id);
    Books book = bookService.queryBookById(id);
    model.addAttribute("book",book);
    return "updateBook";
}
//3.2修改书籍
@PostMapping("/updateBook")
public String updateBook(Books books){
    System.out.println("修改书籍：" + books);
    bookService.updateBook(books);
    return "redirect:/book/allBook";
}

BookController.java

//4.删除
@RequestMapping("/deleteBook/{id}")
public String updateBook(@PathVariable("id") int t_id){
    System.out.println("删除书籍id ：" + t_id);
    bookService.deleteBookById(t_id);
    return "redirect:/book/allBook";
}

allBook.jsp

BookController.java

 //5.搜索一本书
 @PostMapping("/queryBook")
 public String queryBookByName(String queryBookName,Model model){
     System.out.println("搜索书籍名字 ： "+queryBookName);
     if(queryBookName=="") return "redirect:/book/allBook";
     List books = bookService.queryBookByName(queryBookName);
     model.addAttribute("bookList",books);
     return "allBook";
 }

模糊查询：

 
     select * from user_db.books
     where name like  "%"#{name,jdbcType=VARCHAR}"%"