mybatis 学习

简单的mybatis Demo 采用xml文件形式

实体类

package org.lanqiao.mybatis.pojo;

public class User {
    private int userid;
    private String username;
    private String userpassword;

    public String getUsername() {
        return username;
    }
    public void setUsername(String username) {
        this.username = username;
    }
    public String getUserpassword() {
        return userpassword;
    }
    public void setUserpassword(String userpassword) {
        this.userpassword = userpassword;
    }
    public int getUserid() {
        return userid;
    }
    public void setUserid(int userid) {
        this.userid = userid;
    }

}

数据访问层

package org.lanqiao.mybatis.Inte;

import org.lanqiao.mybatis.pojo.User;

public interface SelectUser {
    User selectUser(User u);
}

sql语句，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="org.lanqiao.mybatis.Inte.SelectUser">
    <select id="selectUser" parameterType="User" resultType="User">
        select * from User where userid=#{userid}
    </select>
</mapper>

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>
<typeAliases>
<typeAlias type="org.lanqiao.mybatis.pojo.User" alias="User"/>
</typeAliases>
<environments default="sd">
    <environment id="sd">
    <transactionManager type="jdbc"/>
        <dataSource type="POOLED">
            <property name="driver" value="com.mysql.jdbc.Driver"/>
            <property name="url" value="jdbc:mysql://localhost:3306/shiro"/>
            <property name="username" value="root"/>
            <property name="password" value="HUI1212"/>
        </dataSource>
    </environment>
</environments>
<mappers>
    <mapper resource="org/lanqiao/mybatis/mapper/SelectUser.xml"/>
</mappers>
</configuration>

JUNIT 测试

package org.lanqiao.mybatis.test;

import java.io.Reader;

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.Assert;
import org.junit.Before;
import org.junit.Test;
import org.lanqiao.mybatis.Inte.SelectUser;
import org.lanqiao.mybatis.pojo.User;

public class testuser {
    SqlSession session=null;
    @Before
    public void setUp() throws Exception {
        Reader reader = Resources.getResourceAsReader("org/lanqiao/mybatis/config/mapper-config-1.xml");
        SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(reader);
        session =factory.openSession();
    }

    @Test
    public void test() {
        System.out.println(23);
        SelectUser mapper = session.getMapper(SelectUser.class);
        User u = new User();
        u.setUserid(1);
        String s = mapper.selectUser(u).getUsername();

        Assert.assertNotNull(s);
    }

}