mybatis

一、在网上下载mybatis 3.2.7

二、搭建mybatis环境

创建mybatis项目

 

 

 

 mybatis需要的jar

 

 

 在src 下创建 com.school.mybatis.pojo      com.school.mybatis.junit  格式如下

 

 

 在com.school.mybatis.pojo创建实体类 sysUser.class

package com.school.mybatis.pojo;

import java.io.Serializable;

public class sysUser implements Serializable{
    private static final long serialVersionUID = 1L;
    private Integer id;
    private String sysUsername;//管理员名字
    private String password;//管理员密码
    public Integer getId() {
        return id;
    }
    public void setId(Integer id) {
        this.id = id;
    }
    public String getSysUsername() {
        return sysUsername;
    }
    public void setSysUsername(String sysUsername) {
        this.sysUsername = sysUsername;
    }
    public String getPassword() {
        return password;
    }
    public void setPassword(String password) {
        this.password = password;
    }
    public static long getSerialversionuid() {
        return serialVersionUID;
    }
    @Override
    public String toString() {
        return "sysUser [id=" + id + ", sysUsername=" + sysUsername + ", password=" + password + "]";
    }
}

创建核心配置文件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>
    <!-- 和spring整合后 environments配置将废除 -->
    <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/schoolpro?characterEncoding=utf-8" />
                <property name="username" value="root" />
                <property name="password" value="123456" />
            </dataSource>
        </environment>
    </environments>
    <!--Mapper的位置  -->
    <mappers>
        <mapper resource="sqlmap/User.xml"/>
    </mappers>
</configuration>

创建log4j.properties

# Global logging configuration
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

 

在src下创建sqlmap包之下创建SysUser.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">
<!-- 写sql语句 -->
<!-- namespace为命名空间 -->
<mapper namespace="test">
    <!-- 通过ID查询一个用户  -->
    <select id="findUserById" parameterType="Integer" resultType="com.school.mybatis.pojo.sysUser">
        select * from sysUser where id = #{v}
    </select>
</mapper>

在com.school.mybatis.junit下创建测试类mybatisTest.java

package com.school.mybatis.junit;

import java.io.InputStream;

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.Test;

import com.school.mybatis.pojo.sysUser;

public class mybatisTest {
    @Test
    public void testmybatis() throws Exception{
        //加载核心配置文件
        String resource = "sqlMapConfig.xml";
        InputStream in = Resources.getResourceAsStream(resource);
        //创建SqlSessionFactory
        SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(in);
        SqlSession sqlSessino = sqlSessionFactory.openSession();
        //执行sql语句
        sysUser user = sqlSessino.selectOne("test.findUserById", 1);
        System.out.println(user);
    }
    
}

 

最后格式为