mybatis select 查询标签

model

public class User implements Serializable {
    private Integer userId;
    private String userName;
    private String userAddress;
}

interface

public interface IUserDao {
    User findById(Integer userId);
}

mybatis.xml

<select id="findById" resultType="com.User" parameterType="int"> 
  select * from user where id = #{uid} 
</select> 

resultType 属性：指定结果集的类型
parameterType 属性：指定传入参数的类型
sql 语句中使用#{}字符：占位符，相当于原来 jdbc 部分所学的?

测试

  @Test 
  public void testFindOne()  {   
    //6.执行操作 
    User user = userDao.findById(41); 
    System.out.println(user); 
  }