Mybatis学习——实操

流程图

1.创建项目 

2.导入包

其中 mysql-connector-java-5.1.37-bin.jar 是与数据库连接jar包

mybatis-3.5.7.jar是mybatis jar包，其它的为mybatis的依赖包

 创建数据库

user表

 创建user实体类

mysql配置文件

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

 

log4j配置文件

#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

 从 XML 中构建 SqlSessionFactory

 mybatis-config.xml配置文件内容

<?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>
        <!--当domain中实体类多了，太麻烦-->
        <!--<typeAlias type="com.softeem.domain.User" alias="user"></typeAlias>-->

        <package name="com.softeem.domain" ></package>
    </typeAliases>
    <environments default="development">
        <environment id="development">
            <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"/>
    </mappers>
</configuration>

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="didi">

    <select id="selectUser" parameterType="int" resultType="user">
        select * from User where id = #{id}
    </select>

    <select id="selectUserlike" parameterType="String" resultType="user">
        select * from User where username like #{username}
    </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="insert" 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 UserDao {
    /*1)根据用户id查询一个用户
        2)实现根据用户名模糊查询用户
        3)添加用户
        4)修改用户
        5)删除用户*/

    User selectOne(Integer id);

    List<User> selectlike(String username);

    boolean add(User user);

    boolean update(User user);

    boolean delete(Integer id);
}

DaoImpl dao实现类内容：

package com.softeem.dao.impl;

import com.softeem.dao.UserDao;
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 java.io.IOException;
import java.io.InputStream;
import java.util.List;

public class UserDaoImpl implements UserDao {
    @Override
    public User selectOne(Integer id) {
        String resource = "mybatis-config.xml";
        try {
            InputStream inputStream = Resources.getResourceAsStream(resource);
            SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(inputStream);

            SqlSession sqlSession = factory.openSession();

            Object selectUser = sqlSession.selectOne("selectUser", id);
            System.out.println(selectUser);
            sqlSession.close();
        } catch (IOException e) {
            e.printStackTrace();
        }

        return null;
    }

    @Override
    public List<User> selectlike(String username) {
        String resource = "mybatis-config.xml";
        try {
            InputStream inputStream = Resources.getResourceAsStream(resource);
            SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(inputStream);

            SqlSession sqlSession = factory.openSession();

            List<User> selectUserlike = sqlSession.selectList("selectUserlike", username);
            sqlSession.close();
            return selectUserlike;


        } catch (IOException e) {
            e.printStackTrace();
        }

        return null;
    }

    @Override
    public boolean add(User user) {
        String resource = "mybatis-config.xml";
        try {
            InputStream inputStream = Resources.getResourceAsStream(resource);
            SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(inputStream);

            SqlSession sqlSession = factory.openSession();

            int insert = sqlSession.insert("insert", user);
            System.out.println(insert);
            //事务提交
            sqlSession.commit();
            sqlSession.close();//关闭资源
        } catch (IOException e) {
            e.printStackTrace();
        }
        return false;
    }

    @Override
    public boolean update(User user) {
        String resource = "mybatis-config.xml";
        try {
            InputStream inputStream = Resources.getResourceAsStream(resource);
            SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(inputStream);

            SqlSession sqlSession = factory.openSession();

            int update = sqlSession.update("update", user);
            sqlSession.commit();
            sqlSession.close();

            return update>0;
        } catch (IOException e) {
            e.printStackTrace();
        }
        return false;
    }

    @Override
    public boolean delete(Integer id) {
        String resource = "mybatis-config.xml";
        try {
            InputStream inputStream = Resources.getResourceAsStream(resource);
            SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(inputStream);

            SqlSession sqlSession = factory.openSession();

            int delete = sqlSession.delete("delete", id);
            //事务提交
            sqlSession.commit();
            //关闭资源
            sqlSession.close();
        } catch (IOException e) {
            e.printStackTrace();
        }
        return false;
    }
}