mybatis模糊查询

最新推荐文章于 2025-12-02 21:20:38 发布

最新推荐文章于 2025-12-02 21:20:38 发布 · 72 阅读

文章标签：

本文介绍如何使用MyBatis实现对学生信息的增删查操作，包括通过名字模糊查询和插入新学生记录。

<resultMap type="Student" id="studentMap">
<id property="id" column="id" /> <result property="sname" column="name" /> <result property="spwd" column="pwd" /> <result property="sbirth" column="birth" /> </resultMap>  <select id="getModelByName" parameterType="String" resultMap="studentMap"> select id,name,pwd,birth from tbl_student where name like "%"#{name}"%"; </select> <insert id="insertStu" parameterType="Student"> insert into tbl_student(name,pwd,birth) values(#{sname},#{spwd},#{sbirth}); </insert> // 根据名字模糊查询 public List<Student> getModelByName(String name) { SqlSession sqlSession = BasicDaoImpl.getSqlSessionFactory().openSession(); List<Student> students = null; try { students=(List<Student>)sqlSession.selectList("mybatis.mapper.getModelByName", name); } finally { sqlSession.close(); } return students; }