`
webcode
  • 浏览: 5911584 次
  • 性别: Icon_minigender_1
  • 来自: 上海
文章分类
社区版块
存档分类
最新评论

mybatis模糊查询

 
阅读更多
<resultMap type="Student" id="studentMap">
<wbr><wbr>&lt;id property="id" column="id" /&gt;<br><wbr><wbr>&lt;result property="sname" column="name" /&gt;<br><wbr><wbr>&lt;result property="spwd" column="pwd" /&gt;<br><wbr><wbr>&lt;result property="sbirth" column="birth" /&gt;<br><wbr>&lt;/resultMap&gt; <p><wbr></wbr></p> <p><strong>&lt;!-- sql语句是针对表的操作,而resultMap说明了表和pojo的映射关系 --&gt;</strong></p> <p>&lt;select id="getModelByName" parameterType="String" resultMap="studentMap"&gt;<br><wbr><wbr>select<br><wbr><wbr>id,name,pwd,birth from<br><wbr><wbr><strong>tbl_student <span style="color:#ed1c24">where name like "%"#{name}"%";</span></strong></wbr></wbr></wbr></wbr></wbr></wbr></p> <p><wbr>&lt;/select&gt;</wbr></p> <p><wbr></wbr></p> <p>&lt;insert id="insertStu" parameterType="Student"&gt;<br><wbr><wbr>insert into<br><wbr><wbr><strong>tbl_student</strong>(name,pwd,birth)<br><wbr><wbr>values(#{sname},#{spwd},#{sbirth});<br><wbr>&lt;/insert&gt;</wbr></wbr></wbr></wbr></wbr></wbr></wbr></p> <p><wbr></wbr></p> <p><wbr></wbr></p> <p><wbr>// 根据名字模糊查询<br><wbr>public List&lt;Student&gt; getModelByName(String name)<br><wbr>{<br><wbr><wbr>SqlSession sqlSession = BasicDaoImpl.getSqlSessionFactory().openSession();<br><wbr><wbr>List&lt;Student&gt; students = null;<br><wbr><wbr>try<br><wbr><wbr>{<br><wbr><wbr><wbr>students=(List&lt;Student&gt;)sqlSession.selectList("mybatis.mapper.getModelByName", name);<br><wbr><wbr>}<br><wbr><wbr>finally<br><wbr><wbr>{<br><wbr><wbr><wbr>sqlSession.close();<br><wbr><wbr>}<br><wbr><wbr>return students;<br><wbr>}</wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></p> <p></p> <p></p> </wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
分享到:
评论

相关推荐

Global site tag (gtag.js) - Google Analytics