通過主鍵查詢 1.UserMapper.java ~~~ //通過主鍵查詢 User findById(int id); ~~~ 2.UserMapper.xml ~~~ <select id="findById" resultType="com.nobb.domain.User" parameterType="int"> select * from t_user where id = #{id} </select> ~~~ 3.測試代碼（Test.java） ~~~ package com.test; import com.nobb.domain.User; import com.nobb.mapper.UserMapper; 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; import java.util.List; public class Test { @org.junit.Test public void testFindAll() { //定義配置文件路徑 String resource = "mybatis-config.xml";//不能加 根目錄 / InputStream inputStream = null; try {//加載配置文件 inputStream = Resources.getResourceAsStream(resource); } catch (IOException e) { e.printStackTrace(); }//根據配置文件創建SessionFactory對象 SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream); //獲得SqlSession SqlSession session = sqlSessionFactory.openSession(); //獲得UserMapper接口的實現類 UserMapper mapper = session.getMapper(UserMapper.class); //調用UserMapper方法,執行xml中定義的SQL語句 // List<User> list = mapper.findAll(); //打印list // System.out.println(list); User u = mapper.findById(15); System.out.println(u); } } ~~~