- 创建User类:
import lombok.Data;
@Data
public class User {
private Integer id;
private String username;
private String jobs;
private String phone;
}
- 配置UserMapper.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="UserMapper">
<!--根据用户编号,获取用户信息-->
<select id="findUserById" parameterType="Integer" resultType="com.mason.User">
select * from t_user where id = #{id}
</select>
<select id="findUserByName" parameterType="String" resultType="com.mason.User">
select * from t_user where username like '%${value}%'
</select>
</mapper>
2. 配置mabatis-config.xml MyBatis的核心配置文件
<?xml version="1.0" encoding="utf-8" ?>
<!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-config.dtd" >
<configuration>
<!--配置环境-->
<environments default="mysql">
<environment id="mysql">
<transactionManager type="JDBC"/>
<dataSource type="POOLED">
<property name="driver" value="com.mysql.cj.jdbc.Driver"/>
<property name="url" value="jdbc:mysql:///db_mybatis?serverTimezone=CTT"/>
<property name="username" value="xxxxxxxx"/>
<property name="password" value="xxxxxxxxxx"/>
</dataSource>
</environment>
</environments>
<!--配置mapper位置-->
<mappers>
<mapper resource="UserMapper.xml"/>
</mappers>
</configuration>
- 测试:
@Test
public void findUserByNameTest() throws Exception{
InputStream inputStream = Resources.getResourceAsStream("mabatis-config.xml");
SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
SqlSession sqlSession = sqlSessionFactory.openSession();
List<User> users = sqlSession.selectList("UserMapper.findUserByName", "g");
for (User user : users) {
System.out.println(user.toString());
}
sqlSession.close();
}
- 结果:
找到这两条信息,因为名字里面都有“g”