MyBatis 通过Mapper接口操作数据库

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()方法