SSM整合小程序之CURD

SSM整合小程序之CURD

这几天自己看视频学习了ssm整合 实现了一个简单的CRUD和搜索功能。下面对我做的东西进行一个总结。

环境：
idea
jdk 1.8
Windows

一.建立数据库

创建一个存放数据的表

CREATE TABLE `books`(
	`id` INT (4) NOT NULL AUTO_INCREMENT COMENT'书籍ID',
	`bookName` VARCHAR(50) NOT NULL COMENT'书籍名字' ,
	`bookCounts` INT（20） NOT NULL COMENT'书籍数量',
	`detail` VARCHAR(50) NOT NULL COMENT'书籍描述',
	PRIMARY KEY (`id`)
)

二，基本环境搭建

建立idea项目
导入pom文件相关依赖
常规依赖自行导入。
建立项目包结构
com.x.pojo
com.x.dao
com.x.service
com.x.controller
MyBatis-config.xml

applicationContext.xml

基本框架结构完成

二，底层代码编写
建立database.peroperties ， 连接数据库设置。

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configuration
       PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
       "http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
   
   <typeAliases>
       <package name="com.x.pojo"/>
   </typeAliases>
   <mappers>
       <mapper resource="com/x /dao/BookMapper.xml"/>
   </mappers>

</configuration>

编写对应实体类class books
注意数据库里的名字与实体类里的名字一一对应。

dao层接口编写：bookMapper

//增加一个Book
    int addBook(Books book);

    //根据id删除一个Book
    int deleteBookById(int id);

    //更新Book
    int updateBook(Books books);

    //根据id查询,返回一个Book
    Books queryBookById(int id);

    //查询全部Book,返回list集合
    List<Books> queryAllBook();

编写对应Mapper.xml文件，需要导入MyBatis的包。

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
        PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">

<mapper namespace="com.dao.BookMapper">

    <!--增加一个Book-->
    <insert id="addBook" parameterType="Books">
        insert into ssmbuild.books(bookName,bookCounts,detail)
        values (#{
   bookName}, #{
   bookCounts}, #{
   detail})
    </insert>

    <!--根据id删除一个Book-->
    <delete id="deleteBookById" parameterType="int">
        delete from ssmbuild.books where bookID=#{
   bookID}
    </delete>

    <!--更新Book-->
    <update id="updateBook" parameterType="Books">
        update ssmbuild.books
        set bookName = #{
   bookName},bookCounts = #{
   bookCounts},detail = #{
   detail}
        where bookID = #{
   bookID}
    </update>

    <!--根据id查询,返回一个Book-->
    <select id="queryBookById" resultType="Books">
        select * from ssmbuild.books
        where bookID = #{
   bookID}
    </select>

    <!--查询全部Book-->
    <select id="queryAllBook" resultType="Books">
        SELECT * from ssmbuild.books
    </select>
</mapper>

三.sercvice接口和实现类

service接口：bookService
参考bookMapper完成
service实现类：

public class BookServiceImpl implements BookService {
   

    //调用dao层的操作，设置一个set接口，方便Spring管理
    private BookMapper bookMapper;

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

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

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

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

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

    public List<Books> queryAllBook() {
   
        return bookMapper.queryAllBook();
    }
    public Books queryBookByName(String bookName){
   
        return bookMapper.queryBookByName(bookName);
    }
}

底层代码基本结束！！！

四.配置spring整合mybatis

首先写spring-dao.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: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/context
       https://www.springframework.org/schema/context/spring-context.xsd