SSM整合01---Spring-Mybatis层

川长思鸟来 2022-11-25 11:42 119阅读 0赞

### Mybatis层 ###

*  一、建库建表增加记录
 *  二、pom.xml 以及资源导出问题
 *  三、pojo实体类
 *  四、Mybatis核心配置文件
 *  五、mapper接口
 *  六、mapper映射文件
 *  七、mapper实现类
 *  八、spring-dao.xml
 *  九、service层
 *  十、spring-service.xml
 *  十一、注册mapper

# 一、建库建表增加记录 #

**database：ssmbuild**

CREATE DATABASE ssmbuild;

**table：books**

CREATE TABLE `books`(
    	`bookID` INT(10) NOT NULL COMMENT '书id',
    	`bookName` VARCHAR(100) NOT NULL COMMENT '书名',
    	`bookCounts` INT(11) NOT NULL COMMENT '数量',
    	`detail` VARCHAR(200) NOT NULL COMMENT '描述',
    	PRIMARY KEY(`bookID`)
    ) ENGINE=INNODB DEFAULT CHARSET=utf8

**增加记录**

INSERT INTO books
    VALUES (1,'Java',1,'从入门到放弃'),
    (2,'Mysql',1,'从删库到跑路'),
    (3,'Linux',1,'从进门到进狱');

# 二、pom.xml 以及资源导出问题 #

<dependencies>
            <dependency>
                <groupId>junit</groupId>
                <artifactId>junit</artifactId>
                <version>4.13</version>
            </dependency>
    
            <dependency>
                <groupId>mysql</groupId>
                <artifactId>mysql-connector-java</artifactId>
                <version>8.0.21</version>
            </dependency>
    
            <dependency>
                <groupId>com.mchange</groupId>
                <artifactId>c3p0</artifactId>
                <version>0.9.5.2</version>
            </dependency>
    
    
            <dependency>
                <groupId>org.mybatis</groupId>
                <artifactId>mybatis</artifactId>
                <version>3.5.5</version>
            </dependency>
    
            <dependency>
                <groupId>org.mybatis</groupId>
                <artifactId>mybatis-spring</artifactId>
                <version>2.0.5</version>
            </dependency>
    
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-webmvc</artifactId>
                <version>5.2.8.RELEASE</version>
            </dependency>
    
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-jdbc</artifactId>
                <version>5.2.7.RELEASE</version>
            </dependency>
    
            <dependency>
                <groupId>javax.servlet</groupId>
                <artifactId>servlet-api</artifactId>
                <version>2.5</version>
            </dependency>
    
            <dependency>
                <groupId>javax.servlet.jsp</groupId>
                <artifactId>jsp-api</artifactId>
                <version>2.2</version>
            </dependency>
            
            
            <dependency>
                <groupId>javax.servlet</groupId>
                <artifactId>jstl</artifactId>
                <version>1.2</version>
            </dependency>
    
            
            <dependency>
                <groupId>org.apache.taglibs</groupId>
                <artifactId>taglibs-standard-impl</artifactId>
                <version>1.2.5</version>
            </dependency>
        </dependencies>

<build>
            <resources>
                <resource>
                    <directory>src/main/resources</directory>
                    <includes>
                        <include>**/*.properties</include> <include>**/*.xml</include>
                    </includes>
                    <filtering>true</filtering>
                </resource>
                <resource>
                    <directory>src/main/java</directory>
                    <includes>
                        <include>**/*.properties</include> <include>**/*.xml</include>
                    </includes>
                    <filtering>true</filtering>
                </resource>
            </resources>
    
    	<properties>
            <java.version>13</java.version>
            <maven.compiler.source>${ java.version}</maven.compiler.source>
            <maven.compiler.target>${ java.version}</maven.compiler.target>
        </properties>
        </build>

# 三、pojo实体类 #

package cn.kexing.pojo;
    
    public class Books { 
        private int bookID;
        private String bookName;
        private int bookCounts;
        private String detail;
    
        public Books() { 
        }
    
        public Books(int bookID, String bookName, int bookCounts, String detail) { 
            this.bookID = bookID;
            this.bookName = bookName;
            this.bookCounts = bookCounts;
            this.detail = detail;
        }
    
        public int getBookID() { 
            return bookID;
        }
    
        public void setBookID(int bookID) { 
            this.bookID = bookID;
        }
    
        public String getBookName() { 
            return bookName;
        }
    
        public void setBookName(String bookName) { 
            this.bookName = bookName;
        }
    
        public int getBookCounts() { 
            return bookCounts;
        }
    
        public void setBookCounts(int bookCounts) { 
            this.bookCounts = bookCounts;
        }
    
        public String getDetail() { 
            return detail;
        }
    
        public void setDetail(String detail) { 
            this.detail = detail;
        }
    
        @Override
        public String toString() { 
            return "Books{" +
                    "bookID=" + bookID +
                    ", bookName='" + bookName + '\'' +
                    ", bookCounts=" + bookCounts +
                    ", detail='" + detail + '\'' +
                    '}';
        }
    }

# 四、Mybatis核心配置文件 #

<?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="cn.kexing.pojo"/>
        </typeAliases>
    </configuration>

**核心文件因为后期整合spring，所有只在这里取别名和配置一些settings**

# 五、mapper接口 #

package cn.kexing.dao;
    
    import cn.kexing.pojo.Books;
    import org.apache.ibatis.annotations.Param;
    
    import java.util.List;
    
    public interface BookMapper { 
        //增加一本书
        int addBook(Books book);
    
        //删除一本书
        int deleteBookForID(@Param("bookID") int id);
    
        //修改一本书
        int updateBook(Books book);
    
        //根据书名查找书
        List<Books> selectBookForName(@Param("bookName") String name);
    
        //查找所有书
        List<Books> selectAllBooks();
    
        //根据ID查找书
        Books selectBookForID(@Param("bookID") int id);
    }

# 六、mapper映射文件 #

<?xml version="1.0" encoding="UTF-8" ?>
    <!DOCTYPE mapper
            PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
            "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
    
    <mapper namespace="cn.kexing.dao.BookMapper">
        <insert id="addBook" parameterType="books">
            insert into books (bookName,bookCounts,detail)
            values (#{ bookName},#{ bookCounts},#{ detail});
        </insert>
    
        <delete id="deleteBookForID" parameterType="int">
            delete from books where bookID=#{ bookID};
        </delete>
    
        <update id="updateBook" parameterType="books">
            update books set bookName=#{ bookName},bookCounts=#{ bookCounts},detail=#{ detail} where bookID=#{ bookID};
        </update>
    
        <select id="selectBookForName" parameterType="String" resultType="books">
            select * from books
            <where>
                <if test="bookName != null and bookName !=''">
                    AND bookName like "%"#{ bookName}"%"
                </if>
            </where>
        </select>
    
        <select id="selectAllBooks" resultType="books">
            select * from books;
        </select>
    
        <select id="selectBookForID" resultType="books" parameterType="int">
            select * from books where bookID=#{ bookID};
        </select>
    </mapper>

# 七、mapper实现类 #

**用SqlSessionTemplate获取mapper 实现方法**

package cn.kexing.dao;
    
    import cn.kexing.pojo.Books;
    import org.mybatis.spring.SqlSessionTemplate;
    
    import java.util.List;
    
    public class BookMapperImpl implements BookMapper { 
        private SqlSessionTemplate sqlSession;
    
        public void setSqlSession(SqlSessionTemplate sqlSession) { 
            this.sqlSession = sqlSession;
        }
    
    
        public int addBook(Books book) { 
            BookMapper mapper = sqlSession.getMapper(BookMapper.class);
            return mapper.addBook(book);
        }
    
        public int deleteBookForID(int id) { 
            BookMapper mapper = sqlSession.getMapper(BookMapper.class);
            return mapper.deleteBookForID(id);
        }
    
        public int updateBook(Books book) { 
            BookMapper mapper = sqlSession.getMapper(BookMapper.class);
            return mapper.updateBook(book);
        }
    
        public List<Books> selectBookForName(String name) { 
            BookMapper mapper = sqlSession.getMapper(BookMapper.class);
            return mapper.selectBookForName(name);
        }
    
        public List<Books> selectAllBooks() { 
            BookMapper mapper = sqlSession.getMapper(BookMapper.class);
            return mapper.selectAllBooks();
        }
    
        @Override
        public Books selectBookForID(int id) { 
            BookMapper mapper = sqlSession.getMapper(BookMapper.class);
            return mapper.selectBookForID(id);
        }
    }

# 八、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"
           xmlns:mvc="http://www.springframework.org/schema/mvc"
           xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd
                               http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context.xsd
                               http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc.xsd">
    
    
        <context:property-placeholder location="classpath:db.properties"></context:property-placeholder>
    
    
        <bean class="com.mchange.v2.c3p0.ComboPooledDataSource" id="dataSource">
            <property name="driverClass" value="${driver}"></property>
            <property name="jdbcUrl" value="${url}}"></property>
            <property name="user" value="${username}}"></property>
            <property name="password" value="${password}}"></property>
        </bean>
    
    
        <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
            <property name="dataSource" ref="dataSource" />
            <property name="configLocation" value="classpath:mybatis-config.xml"></property>
            <property name="mapperLocations" value="classpath:cn/kexing/dao/*.xml"></property>
        </bean>
    
    
        <bean id="sqlSession" class="org.mybatis.spring.SqlSessionTemplate">
            <constructor-arg name="sqlSessionFactory" ref="sqlSessionFactory"/>
        </bean>
    
        <bean class="cn.kexing.dao.BookMapperImpl" id="bookMapper">
            <property name="sqlSession" ref="sqlSession"></property>
        </bean>
    </beans>

**db.properties：**

driver=com.mysql.cj.jdbc.Driver
    url=jdbc:mysql://localhost://3306/ssmbuild?useUnicode=true&characterEncoding=utf8&serverTimezone=UTC&useSSL=true
    username=root
    password=123

# 九、service层 #

**interface：**

package cn.kexing.service;
    import cn.kexing.pojo.Books;
    
    import java.util.List;
    
    public interface BookService { 
        //增加一本书
        int addBook(Books book);
    
        //删除一本书
        int deleteBookForID(int id);
    
        //修改一本书
        int updateBook(Books book);
    
        //根据书名查找一本书
        List<Books> selectBookForName(String name);
    
        //查找所有书
        List<Books> selectAllBooks();
    
        //根据书籍ID查找一本书
        Books selectBookForID(int id);
    }

**impl：**

package cn.kexing.service;
    
    import cn.kexing.dao.BookMapperImpl;
    import cn.kexing.pojo.Books;
    
    import java.util.List;
    
    public class BookServiceImpl implements BookService{ 
        private BookMapperImpl bookMapper;
    
        public void setBookMapper(BookMapperImpl bookMapper) { 
            this.bookMapper = bookMapper;
        }
    
        public int addBook(Books book) { 
            return bookMapper.addBook(book);
        }
    
        public int deleteBookForID(int id) { 
            return bookMapper.deleteBookForID(id);
        }
    
        public int updateBook(Books book) { 
            return bookMapper.updateBook(book);
        }
    
        public List<Books> selectBookForName(String name) { 
            return bookMapper.selectBookForName(name);
        }
    
        public List<Books> selectAllBooks() { 
            return bookMapper.selectAllBooks();
        }
    
        @Override
        public Books selectBookForID(int id) { 
            return bookMapper.selectBookForID(id);
        }
    }

# 十、spring-service.xml #

**配置BookServiceImpl的bean**

# 十一、注册mapper #