02--MyBatis入门相关配置-详细版

一，下载相关jar包

mybatis-3.3.0jar包-Java工具类资源-CSDN下载

二，引入数据库驱动包

 

三，编写mybatis的核心配置文件mybatis.cfg.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>

        <!-- 配置当前数据库环境（信息），default用来指定当前默认的数据库环境 -->
    <environments default="development">
                <!-- 具体的数据库执行环境 -->
        <environment id="development">
            <!-- 使用jdbc控制操作数据的事务 -->
            <transactionManager type="JDBC" />
            <!-- 配置数据库连接池 -->
            <dataSource type="POOLED">

                <property name="driver" value="com.mysql.jdbc.Driver" />
                <property name="url" value="jdbc:mysql://localhost:3306/dbuser"/>

                <property name="username" value="root" />

                <property name="password" value="123456" />

            </dataSource>
        </environment>

    </environments>

        <!-- 加载mybait数据库操作的映射文件 -->
        <mappers>
            <mapper resource="com/sxt/mapper/User.xml"/>

        </mappers>
</configuration>

四，创建数据库

 五，创建实体类User

package com.qf.pojo;

public class User {

    private int uid;

    private String uname;

    private int uage;

    private String upsw;

    public User() {

        // TODO Auto-generated constructor stub


    }

    @Override

    public String toString() {

        return "User [uid=" + uid + ", uname=" + uname + ", uage=" + uage

                + ", upsw=" + upsw + "]";

    }

    public User(int uid, String uname, int uage, String upsw) {

        super();

        this.uid = uid;

        this.uname = uname;

        this.uage = uage;

        this.upsw = upsw;


    }

    //get seter方法

}

六，创建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">

<mapper namespace="com.sxt.mapper.UserMapper">

    <select id="addUser" parameterType="com.sxt.pojo.User">

        insert into user values(null,#{uname},#{uage},#{upsw})

    </select>

</mapper>

七，创建UserDAO

public interface ProductDao {


    /***
     * 添加用户信息
     * 
     **/

    public void addUser(User user);


}

八，建立UserDaoImpl实现类

public class UserDAOImpl implements UserDao {

    @Override

    public void addUser(User user) {

        //1 创建SqlSessionFactoryBuilder对象

        SqlSessionFactoryBuilder ssfb = new SqlSessionFactoryBuilder();

        //2 通过ssfb对象，构造SqlSessionFactory对象


        SqlSessionFactory ssf = ssfb.build(this.getClass().getClassLoader()

                .getResourceAsStream("mybatis.cfg.xml"));

        //3 通过ssf创建SqlSession对象

        SqlSession sqlSession = ssf.openSession();

        //4 数据库crud操作

        /***
         * arg0: namespace.id ,获得mapper.xml中的sql语句
         * arg1:
         *
		 **/

        sqlSession.insert("com.sxt.mapper.UserMapper.addUser", user);

        //5 提交事务

        sqlSession.commit();

    }

}

九，测试

  @Test
    public void testMybatis(){

        UserDAO dao=new UserDAOImpl();

        User user = new User("张三",22,"123456");

        dao.addUser(user);
    }

十，Log4j的配置log4j.properties

# Global logging configuration
log4j.rootLogger=DEBUG, stdout

# MyBatis logging configuration...
log4j.logger.org.mybatis.example.BlogMapper=TRACE

# 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

配置日志的输出方式


    <settings>

        <setting name="logImpl" value="LOG4J" />
    </settings>