栏目分类:
子分类:
返回
名师互学网用户登录
快速导航关闭
当前搜索
当前分类
子分类
实用工具
热门搜索
名师互学网 > IT > 软件开发 > 后端开发 > Java

ssm 框架整合

Java 更新时间: 发布时间: IT归档 最新发布 模块sitemap 名妆网 法律咨询 聚返吧 英语巴士网 伯小乐 网商动力

ssm 框架整合


title: ssm框架整合
date: 2019-07-10
tags:

  • ssm
  • spring
  • mybatis
    categories:
  • spring
  • ssm框架整合

ssm框架整合

一、搭建数据库

创建一个存放书籍数据的数据库表

CREATE DATABASE ssmbuild;
USE ssmbuild;
CREATE TABLE `books`(
`bookID` INT NOT NULL AUTO_INCREMENT COMMENT '书id',
`bookName` VARCHAr(100) NOT NULL COMMENT '书名',
`bookCounts` INT NOT NULL COMMENT '数量',
`detail` VARCHAr(200) NOT NULL COMMENT '描述',
KEY `bookID`(`bookID`)
)ENGINE=INNODB DEFAULT CHARSET=utf8;

INSERT INTO `books`(`bookID`,`bookName`,`bookCounts`,`detail`)VALUES
(1,'Java',1,'从入门到放弃'),
(2,'MySQL',10,'从删库到跑路'),
(3,'Linux',5,'从进门到进牢')
二、基本环境搭建 1. 创建一个Maven项目!ssmbuild,添加web的支持。 2. 导入相关的pom依赖

    
    
        junit
        junit
        4.13
        test
    

    
    
        mysql
        mysql-connector-java
        8.0.19
    

    
        log4j
        log4j
        1.2.17
    

    
    
        com.mchange
        c3p0
        0.9.5.2
    

    
    
        javax.servlet
        servlet-api
        2.5
    
    
        javax.servlet.jsp
        jsp-api
        2.2
    
    
        javax.servlet
        jstl
        1.2
    

    
    
        org.mybatis
        mybatis
        3.5.2
    
    
        org.mybatis
        mybatis-spring
        2.0.2
    

    
    
        org.springframework
        spring-webmvc
        5.1.9.RELEASE
    
    
        org.springframework
        spring-jdbc
        5.1.9.RELEASE
    

    
    
        org.projectlombok
        lombok
        1.18.12
    






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

3. 创建基本结构和配置框架 创建各层需要的包(pojo、dao、service、controller)

[外链图片转存失败,源站可能有防盗链机制,建议将图片保存下来直接上传(img-X7Utlug1-1655042160798)(ssm%E6%A1%86%E6%9E%B6%E6%95%B4%E5%90%88/image-20200715224247526.png)]

创建mybatis-config.xml





创建applicationContext.xml





三、Mybatis层编写 1. 编写数据库配置文件 database.properties
driver=com.mysql.cj.jdbc.Driver
#如果使用的Mysql8.0+,增加一个时区设置serverTimezone=Asia/Shanghai
url=jdbc:mysql://localhost:3306/ssmbuild?serverTimezone=Asia/Shanghai&useSSL=false&useUnicode=true&characterEncoding=utf8
jdbc.username=root
jdbc.password=root
2. 编写mybatis-config.xml文件



    
    
        

    


    
    
        
    

    
    
    
        
        

        

    

3. 编写数据库表对应的pojo包下的实体类Books.java
package com.zhy.pojo;

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

@Data
@AllArgsConstructor
@NoArgsConstructor
public class Books {
    private int bookID;
    private String bookName;
    private int bookCounts;
    private String detail;

}
4. 编写dao包下的BookMapper接口
package com.zhy.dao;

import com.zhy.pojo.Books;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Update;

import java.util.List;

public interface BookMapper {

    //增加一本书
    int addBook(Books books);
    @Update("alter table books auto_increment = 1;")
    void addBookPlus();

    //删除一本书
    int deleteBookById(@Param("bookId") int id);

    //更新一本书
    int updateBook(Books books);

    //查询一本书
    Books queryBookById(@Param("bookId") int id);

    //查询全部书
    List queryAllBook();

    //根据名称查询书籍
//    Books queryBookByName(@Param("bookName") String bookName);#{bookName}
//    @Select("select * from ssmbuild.books where bookName like concat('%',#{bookName},'%');")
    List queryBookByName(@Param("bookName") String bookName);

}
5. 编写BookMapper接口对应的BookMapper.xml



    
        insert into ssmbuild.books (bookName,bookCounts,detail)
        values (#{bookName},#{bookCounts},#{detail});
    

    
        delete from ssmbuild.books where bookID = #{bookId}
    

    
        update ssmbuild.books
        set bookName = #{bookName},bookCounts = #{bookCounts},detail = #{detail}
        where bookID = #{bookID};
    
    
    
        select * from ssmbuild.books;
    

    




    


四、 Spring层编写 1. 整合dao层,编写spring-dao.xml



    
    


    
    
        
        
        
        

        
        
        
        
        
        
        
        

    


    
    
        

        
        
    


    
    
        
        
        
        
    

2. 整合service层 编写service层的接口和实现类:
public interface BookService {
    //增加一本书
    int addBook(Books books);

    //删除一本书
    int deleteBookById(int id);

    //更新一本书
    int updateBook(Books books);

    //查询一本书
    Books queryBookById(int id);

    //查询全部书
    List queryAllBook();

    //Books queryBookByName(String bookName);

    List queryBookByName(String bookName);
}
public class BookServiceImpl implements BookService {

    //service调dao层:组合Dao
    private BookMapper bookMapper;

    public void setBookMapper(BookMapper bookMapper) {
        this.bookMapper = bookMapper;
    }

    public int addBook(Books books) {
        bookMapper.addBookPlus();
        return bookMapper.addBook(books);
    }

    public int deleteBookById(int id) {
        int flag = bookMapper.deleteBookById(id);
        bookMapper.addBookPlus();
        return flag;
    }

    public int updateBook(Books books) {
        return bookMapper.updateBook(books);
    }

    public Books queryBookById(int id) {
        return bookMapper.queryBookById(id);
    }

    public List queryAllBook() {
        return bookMapper.queryAllBook();
    }

//    public Books queryBookByName(String bookName) {
//        return bookMapper.queryBookByName(bookName);
//    }

    public List queryBookByName(String bookName) {
        return bookMapper.queryBookByName(bookName);
    }
}

编写spring-service.xml,将service层的实现类注入到spring







    
        
    


    
        
    

五、spring-MVC层编写 1. 编写web.xml

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

        1
    
    
        springmvc
        /
    



    
        encodingFilter
        org.springframework.web.filter.CharacterEncodingFilter
        
            encoding
            utf-8
        
    
    
        encodingFilter
        /*
    



    
        15
    
2. 编写controller层
@Controller
@RequestMapping("/book")
public class BookController {
    //controller 调 service层
    @Autowired
    @Qualifier("BookServiceImpl")
    private BookService bookService;
}
3.编写spring-mvc.xml,使controller层对象注入到spring中




    


    


    


    
        
        
    
    
    
    
        
            
                
            
            
                
                    
                        
                    
                
            
        
    

    

    
        
            
            
        
    


转载请注明:文章转载自 www.mshxw.com
本文地址:https://www.mshxw.com/it/969876.html
我们一直用心在做
关于我们 文章归档 网站地图 联系我们

版权所有 (c)2021-2022 MSHXW.COM

ICP备案号:晋ICP备2021003244-6号