Mybatis——进阶

Dao开发方式

1.映射文件Mapper.xml文件

<?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.softeem.dao.UserMapper"><!--内容与接口地址一致-->
                    
<!--id与接口方法一致，parameterType与形参类型一致，，resultType与返回值一致-->
    <select id="selectOne" parameterType="int" resultType="User">
 select * from User where id = #{id}
 </select>
    <select id="selectlike" parameterType="String" resultType="user">
        select * from User where username like #{username}
    </select>

    <select id="selectlikewhere" parameterType="User" resultType="user">
        select * from User
        <where>
            <if test="username!=null and username != ''">
                and username like "%"#{username}"%"
            </if>
        </where>
    </select>

    <update id="update" parameterType="user">
        update User set username = #{username},address= #{address} where id = #{id}
    </update>

    <delete id="delete" parameterType="int">
        delete from User where id = #{id}
    </delete>

    <insert id="add" parameterType="user" useGeneratedKeys="true" keyProperty="id">
      insert into User (username,birthday,sex,address)value (#{username},#{birthday},#{sex},#{address})
    </insert>
</mapper>

Dao接口：

package com.softeem.dao;

import com.softeem.domain.User;

import java.util.List;

public interface UserMapper {
    /*1)根据用户id查询一个用户
        2)实现根据用户名模糊查询用户
        3)添加用户
        4)修改用户
        5)删除用户*/

    User selectOne(Integer id);

    List<User> selectlike(String username);


    List<User> selectlikewhere(User user);

    boolean add(User user);

    boolean update(User user);

    boolean delete(Integer id);
}

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>
<!--引入连接书记库-->
<!-- 是用resource属性加载外部配置文件 -->
    <properties resource="jdbc.properties"></properties>
<!-- 在properties内部用property定义属性 -->
		<!-- 如果外部配置文件有该属性，则内部定义属性被外部属性覆盖 -->

    <!--配置别名-->
    <typeAliases>
        <!--当domain中实体类多了，太麻烦-->
        <!--<typeAlias type="com.softeem.domain.User" alias="user"></typeAlias>--><!-- 单个别名定义 -->

		<!-- 批量别名定义，扫描整个包下的类，别名为类名（大小写不敏感） -->
        <package name="com.softeem.domain" ></package>
    </typeAliases>
    <environments default="development">
        <environment id="development">
<!-- 使用jdbc事务管理 -->
            <transactionManager type="JDBC"/>
<!-- 数据库连接池 -->
            <dataSource type="POOLED">
<!--配置四大金刚-->
                <property name="driver" value="${driver}"/>
                <property name="url" value="${url}"/>
                <property name="username" value="${username}"/>
                <property name="password" value="${password}"/>
            </dataSource>
        </environment>
    </environments>

<!-- 加载映射文件 -->

    <mappers>
        <!--<mapper resource="UserMapper.xml"></mapper>-->
<!--扫描整个包下的配置文件-->
        <package name="com/softeem/dao"></package>
    </mappers>

</configuration>

测试Test：

package com.softeem.test;


import com.softeem.dao.UserMapper;
import com.softeem.domain.User;
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.junit.Before;
import org.junit.Test;

import java.io.InputStream;
import java.util.List;

public class UserDaoTest {
    private SqlSessionFactory factory;
    @Before
    public void init() throws Exception {
        String resource = "SqlMapConfig.xml";
        InputStream inputStream = Resources.getResourceAsStream(resource);
        factory = new SqlSessionFactoryBuilder().build(inputStream);

    }

    @Test
    public void  selectlike(){
        SqlSession sqlSession = factory.openSession();
        UserMapper dao = sqlSession.getMapper(UserMapper.class);
        String username = "悟";
        username = "%"+username+"%";
        List<User> list = dao.selectlike(username);
        System.out.println(list);
        sqlSession.close();
    }
    @Test
    public void  selectOne(){
        SqlSession sqlSession = factory.openSession();
        UserMapper dao = sqlSession.getMapper(UserMapper.class);
        User user = dao.selectOne(2);
        System.out.println(user);
        sqlSession.close();
    }

    @Test
    public void  selectlikewhere(){
        SqlSession sqlSession = factory.openSession();
        UserMapper dao = sqlSession.getMapper(UserMapper.class);
        String username = "悟";
        User user = new User();
        user.setUsername(username);
        List<User> list = dao.selectlikewhere(user);
        System.out.println(list);
        sqlSession.close();
    }
}

代码文件位置图片：

 需要导入的jar包：

测试test需要导入的jar包：

 

jdbc.properties 连接数据库的配置文件：

driver=com.mysql.jdbc.Driver
url=jdbc:mysql://localhost:3305/user?useUnicode=true&characterEncoding=utf-8
username=root
password=root

log4j.properties（控制台输出+自定义布局） 配置文件内容：

#5.控制台输出+自定义布局
log4j.rootLogger=DEBUG,my
#指定输出器
log4j.appender.my=org.apache.log4j.ConsoleAppender
#指定布局器(自定义布局)
#指定布局为自定义布局
log4j.appender.my.layout=org.apache.log4j.PatternLayout
#指定在自定义布局的格式，%d -- 表示当前系统时间，%t -- 执行该业务的线程名称，%p -- 日记器的级别，-5 -- 5表示输出字符的个数，符号表示右对齐
#%c -- 表示指定业务所在的类的完全限定名(包名.类名)，%m -- 输出额外信息，%n -- 表示换行
log4j.appender.my.layout.ConversionPattern=%d [%t] %-5p [%c] - %m%n
#设置package（可以是自定义的包也可以是api的包）输出级别
log4j.logger.org.springframework=info
log4j.logger.com.softeem =debug

测试结果：