mybaties的简单使用

需要下载的jar包：
链接：https://pan.baidu.com/s/1FUtXK_v-oTiV6paTaVcr0A
提取码：r2e9

---

mybaties-config.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>
    <environments default="development">
        <environment id="development">
            <transactionManager type="JDBC" />
            <!-- 配置数据库连接信息 -->
            <dataSource type="POOLED">
                <property name="driver" value="com.mysql.jdbc.Driver" />
                <property name="url" value="jdbc:mysql://localhost:3306/test" />
                <property name="username" value="root" />
                <property name="password" value="123456" />
            </dataSource>
        </environment>
    </environments>

    <!-- 注册映射文件 -->
    <mappers>
        <mapper class="dao.UserMapper"/>
    </mappers>

</configuration>

---

UserMapper.java（dao层接口定义）：

public interface UserMapper {
      User getUserByID(String id);
      int addUser(User user);
}

UserMapper.xml（dao层接口实现）：

<?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="dao.UserMapper">
<resultMap id="Usermap" type="model.User">
    <id property="id" column="ID" />
    <result property="name" column="NAME"></result>
    <result property="age" column="AGE"></result>
</resultMap>
    <select id="getUserByID" resultMap="Usermap">
        select * from user where id = #{id}
    </select>
    <insert id="addUser" parameterType="model.User">
        insert into user values (#{id},#{name},#{age})
    </insert>

</mapper>

---

User.java（实体类）：

public class User{
    private int id;
    private String name;
    private  int  age;

    public int getId() {
        return id;
    }

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

    public String getName() {
        return name;
    }

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

    public int getAge() {
        return age;
    }

    public void setAge(int age) {
        this.age = age;
    }
    public  void  Output(){
        System.out.println("姓名："+getName()+", 年龄："+getAge());
    }
}

---

Main方法测试：

public static void test() throws IOException{
        String resource = "mybatis-config.xml";
        Reader reader = Resources.getResourceAsReader(resource);
        SqlSessionFactory factory=new SqlSessionFactoryBuilder().build(reader);
        //加载配置文件
        SqlSession session=factory.openSession();
        String statement="dao.UserMapper.getUserByID";
        //找到对应的接口
        User user=session.selectOne(statement, 123);
        //执行查询
        user.Output();
        User user2 = new User();
        user2.setId(1);
        user2.setName("zhang");
        user2.setAge(22);
        statement = "dao.UserMapper.addUser";
        user2.Output();
        System.out.println(session.insert(statement,user2));
        session.commit();
        //执行完事物操作后要提交才能保存到数据库

    }