java数据接口编写简单例子,（6）MyBatis小总结：一个简单的例子--接口编程改进...

/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]

效果与此前一样。