Mybatis文件配置和入门程序

约定不等于承诺〃 2023-06-14 05:30 12阅读 0赞

## mybatis入门程序 ##

#### 导入jar包 ####

从mybatis管网下载（地址：https://github.com/mybatis/mybatis-3/releases）  
![所需jar包][jar]

#### 工程结构 ####

![在这里插入图片描述][20191118204652497.png]

#### log4j.properties（公用文件） ####

用于查看日志

#Global logging configuration，建议开发环境中要用debug
    log4j.rootLogger=DEBUG, stdout
    #Console output...
    log4j.appender.stdout=org.apache.log4j.ConsoleAppender
    log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
    log4j.appender.stdout.layout.ConversionPattern=%5p [%t] - %m%n

#### SqlMapConfig.xml(公用文件) ####

通过SqlMapConfig.xml加载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>
    
        
    
        <properties resource="jdbc.properties"></properties>
    
    
        <typeAliases>
            <package name="baidu.com.pojo" />
        </typeAliases>
    
        <environments default="development">
            <environment id="development">
                <transactionManager type="JDBC"/>
                <dataSource type="POOLED">
                    <property name="driver" value="${jdbc.driver}"/>
                    <property name="url" value="${jdbc.url}"/>
                    <property name="username" value="${jdbc.username}"/>
                    <property name="password" value="${jdbc.password}"/>
                </dataSource>
            </environment>
        </environments>
    
    
        <mappers>
         
                <mapper resource="sqlMap/THobby.xml"></mapper>
                
            <package name="baidu/com/mapper"/>
        </mappers>
        
    </configuration>

#### jdbc.properties ####

数据库连接配置  
（注）?characterEncoding=UTF-8 是为了防止数据库乱码

jdbc.driver=com.mysql.jdbc.Driver
    jdbc.url=jdbc\:mysql\://localhost\:3306/yuangong?characterEncoding=UTF-8
    jdbc.username=root
    jdbc.password=root

#### THobby.xml ####

包含了 增删改查 等方法 还有两种返回所添加数据的id

<?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="THobby">
        
        <select id="findAllThobby" resultType="baidu.com.pojo.THobby">
            select * from t_hobby
        </select>
    
        
        <select id="findByHid" parameterType="int" resultType="baidu.com.pojo.THobby">
            select * from t_hobby where hid = #{hid}
        </select>
    
        
        
            
        
        
        
        <insert id="save" parameterType="baidu.com.pojo.THobby" >
            <selectKey keyProperty="hid" resultType="int" order="AFTER">
                select LAST_INSERT_ID()
            </selectKey>
            insert into t_hobby set hobby=#{hobby}
        </insert>
    
        
        <delete id="del" parameterType="int">
            delete from t_hobby where hid =#{hid}
        </delete>
    
        
        <update id="upd" parameterType="baidu.com.pojo.THobby">
            update t_hobby set hobby=#{hobby} where hid = #{hid}
        </update>
    
        
        <select id="mohu" parameterType="String" resultType="baidu.com.pojo.THobby">
            select * from t_hobby where hobby like #{h}
        </select>
    
        
        <select id="count" resultType="int">
            select count(hid) from t_hobby
        </select>
    </mapper>

#### THobby 实体类 ####

package baidu.com.pojo;
    
    /**
     * @类名： THobby
     * @说明： TODO
     * @作者：
     * @时间： 2019/11/18 15:24
     * @版本：
     */
    public class THobby {
    
        private Integer hid;
        private String hobby;
    
        public Integer getHid() {
            return hid;
        }
    
        public void setHid(Integer hid) {
            this.hid = hid;
        }
    
        public String getHobby() {
            return hobby;
        }
    
        public void setHobby(String hobby) {
            this.hobby = hobby;
        }
    
        @Override
        public String toString() {
            return "THobby{" +
                    "hid=" + hid +
                    ", hobby='" + hobby + '\'' +
                    '}';
        }
    }

#### 测试增删改查等方法 ####

package baidu.com.test;
    
    import baidu.com.pojo.THobby;
    import org.apache.ibatis.io.Resources;
    import org.apache.ibatis.session.SqlSession;
    import org.apache.ibatis.session.SqlSessionFactory;
    import org.apache.ibatis.session.SqlSessionFactoryBuilder;
    import org.apache.log4j.lf5.util.Resource;
    import org.junit.Before;
    import org.junit.Test;
    
    import java.io.IOException;
    import java.io.InputStream;
    import java.util.List;
    
    /**
     * @类名： Test01
     * @说明： TODO
     * @作者：
     * @时间： 2019/11/18 15:29
     * @版本：
     */
    public class Test01 {
    
        SqlSessionFactory sqlSessionFactory;
    
        @Before
        public void befroe() throws IOException {
            InputStream inputStream = Resources.getResourceAsStream("SqlMapConfig.xml");
           sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
        }
    
    
        @Test
        public void findAll(){
            SqlSession sqlSession = sqlSessionFactory.openSession();
            List<THobby> list = sqlSession.selectList("THobby.findAllThobby");
            list.forEach(c-> System.out.println(c));
            sqlSession.close();
        }
        @Test
        public void findByhid(){
            SqlSession sqlSession = sqlSessionFactory.openSession();
            THobby hobby = sqlSession.selectOne("THobby.findByHid",1);
            System.out.println(hobby);
        }
    
        @Test
        public void save(){
            SqlSession sqlSession = sqlSessionFactory.openSession();
            THobby tHobby = new THobby();
            tHobby.setHobby("吃饭");
            sqlSession.insert("THobby.save", tHobby);
            sqlSession.commit();
            System.out.println(tHobby.getHid());
        }
    
        @Test
        public void del(){
            SqlSession sqlSession = sqlSessionFactory.openSession();
            sqlSession.delete("THobby.del",16);
            sqlSession.commit();
        }
    
        @Test
        public void upd(){
            SqlSession sqlSession = sqlSessionFactory.openSession();
            THobby tHobby = new THobby();
            tHobby.setHobby("游泳");
            tHobby.setHid(15);
            sqlSession.delete("THobby.upd",tHobby);
            sqlSession.commit();
        }
    
        @Test
        public void mohu(){
            SqlSession sqlSession = sqlSessionFactory.openSession();
            List<THobby> hobby = sqlSession.selectList("THobby.mohu", "%游%");
            sqlSession.commit();
            hobby.forEach(c-> System.out.println(c));
        }
    
        @Test
        public void count(){
            SqlSession sqlSession = sqlSessionFactory.openSession();
            Integer o = sqlSession.selectOne("THobby.count");
            System.out.println("总条数"+o);
        }
        
    }

[jar]: https://img-blog.csdnimg.cn/20191118204541130.png
[20191118204652497.png]: https://img-blog.csdnimg.cn/20191118204652497.png