MyBatis 通过Mapper接口操作数据库
创建UserMapper接口
package com.mapper;
import com.po.User;
public interface UserMapper {
User getUserById(Integer id);
}
创建UserMapper.xml
<mapper namespace="com.mapper.UserMapper">
<select id="getUserById" resultType="user" parameterType="Integer">
select * from t_user where userId=#{userId}
</select>
</mapper>
创建UserDao
package com.dao;
import org.apache.ibatis.session.SqlSession;
import org.junit.Test;
import com.factory.SessionFactory;
import com.mapper.UserMapper;
import com.po.User;
public class UserDao {
private SqlSession session=SessionFactory.getSqlSession();
@Test
public void getUserById() {
UserMapper um=session.getMapper(UserMapper.class);
User user=um.getUserById(1);
session.close();
System.out.println(user);
}
}
执行getUserById()方法