原始Dao开发

具体配置看Mybities入门
https://blog.csdn.net/qq_39205129/article/details/97278242
Mybaties框架入门

原始Dao开发Mybaties

dao

package com.baidu.dao;

import com.baidu.pojo.User;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;

//原始Dao 开发
public class UserDao {


    private SqlSessionFactory sqlSessionFactory;
    public  UserDao(SqlSessionFactory sqlSessionFactory){
        this.sqlSessionFactory=sqlSessionFactory;


    }


    public  void add(){
        SqlSession session = sqlSessionFactory.openSession();

        User user = new User();
        user.setName("slisisisqqq");

        session.insert("test.insertUser4", user);
        System.out.println(user.getId());
        session.commit();

        session.close();

    }

}

pojo

package com.baidu.pojo;

public class User {
    public Integer getId() {
        return id;
    }

    public void setId(Integer id) {
        this.id = id;
    }

    public String getName() {
        return name;
    }

    @Override
    public String toString() {
        return "User{" +
                "id=" + id +
                ", name='" + name + '\'' +
                '}';
    }

    public void setName(String name) {
        this.name = name;
    }

    private Integer id;
    private  String name;
}

SqlMapConfig.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>

    <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/UserMapper.xml"/>
        <!--<mapper resource="com/baidu/dao/UserMapper.xml"/>-->
    </mappers>
</configuration>

UserMapper.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">

    <insert id="insertUser4" parameterType="com.baidu.pojo.User" keyProperty="id">
<!--<selectKey keyProperty="id" resultType="int" order="AFTER">

    select  LAST_INSERT_ID()
</selectKey>-->
        insert  into  t_user set  name =#{name };
    </insert>

</mapper>

test

package com.baidu.test;

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

public class TesyMybaties {

    public static void main(String[] args) throws IOException {

        String resource = "SqlMapConfig.xml";
        InputStream inputStream = Resources.getResourceAsStream(resource);
        SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
        SqlSession session = sqlSessionFactory.openSession();
        List<Object> list = session.selectList("test.selectUser");
        System.out.println(list.size());
        session.close();
    }
    SqlSessionFactory sqlSessionFactory;

    @Before//执行之前干这事
    public void before() throws IOException {

        String resource = "SqlMapConfig.xml";

        InputStream inputStream = Resources.getResourceAsStream(resource);
        this.sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
    }
    @Test
    public  void  test(){
        UserDao userDao = new UserDao(sqlSessionFactory);
        userDao.add();
    }
}

结果

DEBUG [main] - Logging initialized using 'class org.apache.ibatis.logging.slf4j.Slf4jImpl' adapter.
DEBUG [main] - PooledDataSource forcefully closed/removed all connections.
DEBUG [main] - PooledDataSource forcefully closed/removed all connections.
DEBUG [main] - PooledDataSource forcefully closed/removed all connections.
DEBUG [main] - PooledDataSource forcefully closed/removed all connections.
DEBUG [main] - Opening JDBC Connection
DEBUG [main] - Created connection 2042495840.
DEBUG [main] - Setting autocommit to false on JDBC Connection [com.mysql.jdbc.JDBC4Connection@79be0360]
DEBUG [main] - ==>  Preparing: insert into t_user set name =?; 
DEBUG [main] - ==> Parameters: slisisisqqq(String)
DEBUG [main] - <==    Updates: 1
null
DEBUG [main] - Committing JDBC Connection [com.mysql.jdbc.JDBC4Connection@79be0360]
DEBUG [main] - Resetting autocommit to true on JDBC Connection [com.mysql.jdbc.JDBC4Connection@79be0360]
DEBUG [main] - Closing JDBC Connection [com.mysql.jdbc.JDBC4Connection@79be0360]
DEBUG [main] - Returned connection 2042495840 to pool.

Process finished with exit code 0