Mybatis根据用户ID查询数据

tech2022-08-06  1

根据用户ID查询数据 1,修改映射配置文件UsersMapper.xml

<?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> <mapper namespace="com.lying.mapper.UserMapper"> <!--根据用户ID查询用户--> <select id="selectUsersById" parameterType="int" resultType="com.lying.pojo.Users" > select * from users where userid=#{suibian} </select> </mapper>

2,修改UserDao接口 UserDao.java

package com.lying.dao; import com.lying.pojo.Users; import java.io.IOException; import java.util.List; /** * @Author:Lying * @Date:2020/8/30 * @Description:com.lying.dao * @version:1.0 */ public interface UsersDao { Users selectUsersById(int userid) throws IOException; }

3,修改UserDao接口实现类 UserDaoImpl.java

package com.lying.dao.com.lying.dao.impl; import com.lying.dao.UsersDao; import com.lying.pojo.Users; 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; /** * @Author:Lying * @Date:2020/8/30 * @Description:com.lying.dao.com.lying.dao.impl * @version:1.0 */ public class UsersDaoImpl implements UsersDao { /** * 根据用户ID查询用户 * @param userid * @return * @throws IOException */ @Override public Users selectUsersById(int userid) throws IOException { //创建SqlSessionFactory对象 InputStream inputStream=Resources.getResourceAsStream("mybatis-cfg.xml"); SqlSessionFactory sqlSessionFactory= new SqlSessionFactoryBuilder().build(inputStream); //获取SqlSession对象 SqlSession sqlSession =sqlSessionFactory.openSession(); Users users=sqlSession.selectOne("com.lying.mapper.UserMapper.selectUsersById",userid); sqlSession.close(); return users; } }

4,修改测试类 Test.java

package com.lying.test; import com.lying.dao.UsersDao; import com.lying.dao.com.lying.dao.impl.UsersDaoImpl; import com.lying.pojo.Users; import java.io.IOException; import java.util.List; /** * @Author:Lying * @Date:2020/9/1 * @Description:com.lying.test * @version:1.0 */ public class Test { public static void main(String[] args) throws IOException { UsersDao usersDao=new UsersDaoImpl(); Users users=usersDao.selectUsersById(1); System.out.println(users.getUserid()+"\t"+users.getUsername()+"\t"+users.getUsersex()); } }