3.使用annotation配置

dao接口+annotation配置
这种方式不适合sql语句较复杂的场景，语句过长也不便于代码维护和查看，如果要用到高级映射和动态sql也不好编写

创建maven工程，目录结构如下

maven配置

<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/xsd/maven-4.0.0.xsd">  <modelVersion>4.0.0</modelVersion>  <groupId>com.cjq</groupId>  <artifactId>cjq-mybatis1</artifactId>  <version>1.0-SNAPSHOT</version>  <packaging>jar</packaging>  <name>cjq-mybatis1</name>  <url>http://maven.apache.org</url>  <properties>    <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>  </properties>  <dependencies>    <dependency>      <groupId>junit</groupId>      <artifactId>junit</artifactId>      <version>4.12</version>      <scope>test</scope>    </dependency>    <!--MyBatis相关-->    <dependency>      <groupId>org.mybatis</groupId>      <artifactId>mybatis</artifactId>      <version>3.2.8</version>    </dependency>    <!--数据库相关-->    <dependency>      <groupId>mysql</groupId>      <artifactId>mysql-connector-java</artifactId>      <version>5.1.35</version>    </dependency>  </dependencies></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>    <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="admin"/>            </dataSource>        </environment>    </environments>    <mappers>        <!-- 映射DeptDao接口所在的包-->       <package name="com.cjq.dao" />    </mappers></configuration>

Dept类型

package com.cjq.vo;/** * Created by cjq on 2017/9/16. */public class Dept {    Integer deptno;    String  dname;    String  loc;    @Override    public String toString() {        return "Dept{" +                "deptno=" + deptno +                ", dname='" + dname + '\'' +                ", loc='" + loc + '\'' +                '}';    }    public Integer getDeptno() {        return deptno;    }    public void setDeptno(Integer deptno) {        this.deptno = deptno;    }    public String getDname() {        return dname;    }    public void setDname(String dname) {        this.dname = dname;    }    public String getLoc() {        return loc;    }    public void setLoc(String loc) {        this.loc = loc;    }}

SessionFactory类

package com.cjq.dao;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.InputStream;/** * Created by cjq on 2017/9/16. */public class SessionFactory {    static SqlSessionFactory factory=null;    static{        //测试查询        String resource="configuration.xml";        //获取资源的流        InputStream r= null;        try {            r = Resources.getResourceAsStream(resource);        } catch (IOException e) {            e.printStackTrace();        }        //获得session工厂         factory=new SqlSessionFactoryBuilder().build(r);    }    public static SqlSession getSession(){        //openSession默认事物是手动提交的         return factory.openSession();    }}

DeptDao类

package com.cjq.dao;import com.cjq.vo.Dept;import org.apache.ibatis.annotations.Insert;import org.apache.ibatis.annotations.Select;import java.util.List;/** * Created by cjq on 2017/9/16. */public interface DeptDao {    @Insert("insert into dept values(#{deptno},#{dname},#{loc})")    public void save(Dept dept);    //value可以是任意名称，因为此方法就一个参数，可以用任意名称代替    @Select("select * from dept where deptno>#{value} order by deptno")    public List<Dept> getAll(int deptno);}

测试

package com.cjq.vo;import com.cjq.dao.DeptDao;import com.cjq.dao.SessionFactory;import org.apache.ibatis.session.SqlSession;import java.io.IOException;import java.util.List;/** * Created by cjq on 2017/9/16. */public class DeptTest {    public static void main(String[] args) throws IOException {        //获取session        SqlSession session= SessionFactory.getSession();        //获得Dao        DeptDao dao=session.getMapper(DeptDao.class);        Dept dept=new Dept();        dept.setDeptno(10);        dept.setDname("test");        dept.setLoc("test");       // dao.save(dept);       // session.commit();        List<Dept> list=dao.getAll(5);        for(Dept d:list){            System.out.println(d);        }        session.close();    }}