mybatis 学习

来源：互联网发布：android 崩溃数据丢失编辑：程序博客网时间：2024/06/14 09:30

简单的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);    }}

0 0