简单的mybatis例子，用idea写的

用的是maven搭建

目录结构：

pom.xml

<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/maven-v4_0_0.xsd">
  <modelVersion>4.0.0</modelVersion>
  <groupId>com.wzl.mybatis</groupId>
  <artifactId>mybatis</artifactId>
  <packaging>war</packaging>
  <version>1.0-SNAPSHOT</version>
  <name>mybatis Maven Webapp</name>
  <url>http://maven.apache.org</url>
  <dependencies>
    <dependency>
      <groupId>junit</groupId>
      <artifactId>junit</artifactId>
      <version>3.8.1</version>
      <scope>test</scope>
    </dependency>
    <!-- https://mvnrepository.com/artifact/org.mybatis/mybatis -->
    <dependency>
      <groupId>org.mybatis</groupId>
      <artifactId>mybatis</artifactId>
      <version>3.0.3</version>
    </dependency>
    <!-- https://mvnrepository.com/artifact/mysql/mysql-connector-java -->
    <dependency>
      <groupId>mysql</groupId>
      <artifactId>mysql-connector-java</artifactId>
      <version>5.1.21</version>
    </dependency>

  </dependencies>
  <build>
    <finalName>mybatis</finalName>
  </build>
</project>

configuration.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>
    <typeAliases>
        <typeAlias alias="User" type="entity.User" />
    </typeAliases>
    <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/mybatis?useUnicode=true&characterEncoding=utf8" />
                <property name="username" value="root" />
                <property name="password" value="bobo" />
            </dataSource>
        </environment>
    </environments>
    <mappers>
        <mapper resource="mapper/User.xml" />
    </mappers>
</configuration>

User.java

package entity;
public class User {
    private int id;
    private String name;
    private String pass;
    private String sex;

    public String getSex() {
        return sex;
    }

    public void setSex(String sex) {
        this.sex = sex;
    }

    public String getPass() {
        return pass;
    }

    public void setPass(String pass) {
        this.pass = pass;
    }

    public User() {
    }
    public User(int id, String name) {
        this.id = id;
        this.name = name;
    }
    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;
    }
    @Override
    public String toString() {
        return "User [id=" + id + ", name=" + name + "]";
    }

}

User.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="entity.User">
    <select id="selectUser" parameterType="int" resultType="User">
        select * from `user` where id = #{id}
    </select>
    <delete id="deleteUser" parameterType="User">
        delete from `user` where id=#{id}
    </delete>
    <update id="updateUser" parameterType="User">
        UPDATE `user`
        <set>
            <if test="name != null">name=#{name},</if>
            <if test="pass != null">name=#{pass},</if>
            <if test="sex != null">name=#{sex}</if>
        </set>
        where id=#{id}
    </update>
    <!--useGeneratedKeys设置为"true"表明要MyBatis获取由数据库自动生成的主键；
       keyProperty="id"指定把获取到的主键值注入到User的id属性-->
    <insert id="insertUser" parameterType="User">
        insert into `user` (id,`name`,pass,sex) value(#{id},#{name},#{pass},#{sex})
    </insert>
</mapper>

Test.java

package dao;

import entity.User;
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 java.io.IOException;
import java.io.Reader;

/**
 * Created by Administrator on 2017/3/20.
 */
public class Test {
    public static void main(String[] args) throws IOException {
        String resource = "configuration.xml";
        Reader reader = Resources.getResourceAsReader(resource);
        SqlSessionFactory ssf = new SqlSessionFactoryBuilder().build(reader);
        SqlSession session = ssf.openSession();
        try {
            //查询
            /*User user = (User) session.selectOne("selectUser", 1);
            System.out.println(user);*/
            //更新
            /*User user=new User();
            user.setName("拉拉");
            user.setId(3);
            session.update("updateUser",user);*/
            //添加
            User user=new User();
            user.setId(5);
            user.setName("wawwa");
            user.setPass("qqqq");
            user.setSex("qewe");
            session.insert("insertUser",user);
            //删除
            /*User user=new User();
            user.setId(2);
            session.delete("deleteUser",user);*/

            session.commit();
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            session.close();
        }
    }
}