Mybatis接口注解

1.创建一个接口：并在其中声明对应的操作方法
内容如下：
public interface User {
@Select(“select * from user where id= #{id}”)
public User getUserByID(int id);
}`
注意，这里面代码有一个方法名 getUserByID 必须与 User.xml 里面配置的 select 的 id 对应(<``select id=“getUserByID”>)同名
2.创建对应映射接口 SQL 语句
首先配置 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 alias="User" type="com.yiibai.mybatis.models.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://127.0.0.1:3306/testdb" />
                <property name="username" value="root" />
                <property name="password" value="123456" />
            </dataSource>
        </environment>
    </environments>
    <mappers>
        <mapper resource="com/yiibai/mybatis/models/User.xml" />-->
    </mappers>
</configuration>
3、测试接口映射
src 这个目录下创建一个类，用来测试整个配置和程序运行结果

public class Main {
private static SqlSessionFactory sqlSessionFactory;
private static Reader reader;
static {
try {
reader = Resources.getResourceAsReader(“config/Configure.xml”);
sqlSessionFactory = new SqlSessionFactoryBuilder().build(reader);
sqlSessionFactory.getConfiguration().addMapper(IUser.class);
} catch (Exception e) {
e.printStackTrace();
}
}

public static SqlSessionFactory getSession() {
    return sqlSessionFactory;
}

public static void main(String[] args) {
    SqlSession session = sqlSessionFactory.openSession();
    try {
        IUser iuser = session.getMapper(IUser.class);
        User user = iuser.getUserByID(1);
        System.out.println("名字："+user.getName());
        System.out.println("所属部门："+user.getDept());
        System.out.println("主页："+user.getWebsite());
    } finally {
        session.close();
    }
}

}