//获取sqlSession对象,本对象可以编译和执行sql代码
SqlSession sqlSession = factory.openSession();
//注意,这里使用的方法与 getAll 的方法不一样哦,因为这个需要传入参数。
Student student = sqlSession.selectOne("ll.getById",1);
System.out.println(student);
//关闭sqlSession对象
sqlSession.close();
}
}
> 测试结果,这样表示正确哦!
![在这里插入图片描述](https://img-blog.csdnimg.cn/3c494b53cdaf4aedacba06d2de2a2ecc.png)
[]( )按学生名称模糊查询
-------------------------------------------------------------------------
> 按照学生名称模糊查询这个功能也是很常见的哦!
> 接下来我们就来完成它吧!
> 首先我们依旧修改StudentMapper.xml文件。
<select id="getByName" parameterType="string" resultType="com.longlong.pojo.Student">
select id,name,email,age
from student
where name like '%${name}%'
</select>
> 接下来就可以编写测试类了。加入以下代码。本次操作和第一个比较像,详解看第一个代码注释哦!!
@Test
public void testGetByName() throws IOException {
InputStream in = Resources.getResourceAsStream("SqlMapConfig.xml");
SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(in);
SqlSession sqlSession = factory.openSession();
List<Student> list = sqlSession.selectList("ll.getByName","李");
// list.forEach(student -> System.out.println(student));
for (Student student : list){
System.out.println(student);
}
sqlSession.close();
}
> **注意:这里的接收的结果是列表,因为模糊查询可能有很多个结果,所以要列表来存起来哦!**
> 看结果咯
![在这里插入图片描述](https://img-blog.csdnimg.cn/29151876063d43909a2cbd65aeff1796.png)
[]( )增加学生
--------------------------------------------------------------------
> 增加功能也还是个常见的功能。以下的步骤和之前的一样哦,下面只写细节。
> 修改StudentMapper.xml文件。
<insert id="insert" parameterType="com.longlong.pojo.Student">
insert into student (name,email ,age) values(#{name},#{email},#{age})
</insert>
> 测试类,**注意这里一定要手动提交哦**
@Test
public void testInsert() throws IOException {
InputStream in = Resources.getResourceAsStream("SqlMapConfig.xml");
SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(in);
SqlSession sqlSession = factory.openSession();
int num = sqlSession.insert("ll.insert",new Student("张三","208970239@qq.com",20));
SqlSession.commit();
System.out.println(num);
sqlSession.close();
}
> 结果展示如下
![在这里插入图片描述](https://img-blog.csdnimg.cn/93208b9bb8cb46a496d47cdade2a40ff.png)
[]( )按主键删除学生
-----------------------------------------------------------------------
> 修改StudentMapper.xml文件
<delete id="delete" parameterType="int" >
delete from student where id=#{id}
</delete>
> 添加测试类,**注意,这里一定要手动提交哦**
@Test
public void testDelete() throws IOException {
InputStream in = Resources.getResourceAsStream("SqlMapConfig.xml");
SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(in);
SqlSession sqlSession = factory.openSession();
int num = sqlSession.delete("ll.delete", 2 );
sqlSession.commit();
System.out.println(num);
sqlSession.close();
}
> 结果展示如下
![在这里插入图片描述](https://img-blog.csdnimg.cn/6eba06ec68434b089230a0cf05be1cb0.png)
![在这里插入图片描述](https://img-blog.csdnimg.cn/bfac86c148fc482bbbb489d4d91c9a6f.png)
[]( )更新学生
--------------------------------------------------------------------
> 修改StudentMapper.xml文件
<update id="update" parameterType="com.longlong.pojo.Student">
update student set name=#{name},email=#{email},age=#{age}
where id=#{id}
</update>
> 修改测试类,**注意手动提交**
@Test
public void testUpdate() throws IOException {
InputStream in = Resources.getResourceAsStream("SqlMapConfig.xml");
SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(in);
最后
金三银四到了,送上一个小福利!
date() throws IOException {
InputStream in = Resources.getResourceAsStream("SqlMapConfig.xml");
SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(in);
最后
金三银四到了,送上一个小福利!
[外链图片转存中…(img-WWVeJsHu-1720084407025)]
[外链图片转存中…(img-AJE3dfnr-1720084407025)]
[外链图片转存中…(img-wbw2VeLm-1720084407026)]