ibatis动态sql入门

本例以上一讲中的老师表为基础，演示ibatis的动态sql。

sqlMap中这样写：

<statement id="getTeachersByDynamicSql" parameterClass="java.util.HashMap" resultClass="Teacher"> select * from teacher <dynamic prepend="where"> <isNotEmpty prepend="and" property="name"> name like '%$name$%' </isNotEmpty> <isNotEmpty prepend="and" property="subject"> subject = #subject# </isNotEmpty> </dynamic> order by name </statement>

 

java中这样调用：

//省略一些初始化代码 public List getTeacherInfo(String name, String subject) { List tlist = null; try { System.out.println("老师信息如下："); HashMap hmParam = new HashMap(); hmParam.put("subject", subject); hmParam.put("name", name); tlist = sqlMapClient.queryForList("getTeachersByDynamicSql", hmParam); } catch (SQLException e) { e.printStackTrace(); } finally { try { sqlMapClient.endTransaction(); } catch (SQLException e) { e.printStackTrace(); } } return tlist; } /** * @param args */ public static void main(String[] args) { DynamicSql ds = new DynamicSql(); List list = ds.getTeacherInfo("E", ""); for (int i = 0; i < list.size(); i++) { Teacher t = new Teacher(); t = (Teacher) list.get(i); System.out.println("name : " + t.getName() + "/t" + "subj : " + t.getSubject()); } }

查询结果：

老师信息如下：
2009-06-29 13:04:57,440 DEBUG [java.sql.PreparedStatement] - {pstm-100001} Executing Statement:     select * from teacher    where           name like '%E%'                        order by name  
2009-06-29 13:04:57,440 DEBUG [java.sql.PreparedStatement] - {pstm-100001} Parameters: []
2009-06-29 13:04:57,440 DEBUG [java.sql.PreparedStatement] - {pstm-100001} Types: []
name : Jerry subj : 语文
name : Steven subj : 英语