/p>
"-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
select * from employee where id=#{id}
三、Mybatis的接口编程,恰好是使用 interface_name + method_name 组成唯一的 sql 设定。
3.1 UserImp.java
package mybatis;
//运用OOP编程思想,给xml做过改进 --- 接口编程
public interface UserImp {
//定义方法,interface 只能定义方法,无法实现方法体。
public User getUserById(Integer id);
}
3.2 改进后的 User.xml
/p>
"-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
select * from employee where id=#{id}
3.3 configuration.xml
/p>
"-//mybatis.org//DTD Config 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-config.dtd">
3.4 testcase2.java
package mybatis;
import java.io.IOException;
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;
public class testcase2 {
public static void main(String [] args) throws IOException{
String resource = "mybatis/configuration.xml";
Reader reader = Resources.getResourceAsReader(resource);
SqlSessionFactory sessionFactory = new SqlSessionFactoryBuilder().build(reader);
SqlSession session = sessionFactory.openSession();
try{
//获得 接口对象
UserImp usermapper = session.getMapper(UserImp.class);
User user = usermapper.getUserById(1);
System.out.println(user);
}finally{
session.close();
}
}
}
测试结果:
log4j:WARN No appenders could be found for logger (org.apache.ibatis.logging.LogFactory).
log4j:WARN Please initialize the log4j system properly.Employee [id=1, lastName=mmb, email=144@qq.com, gender=0]
效果与此前一样。