本例以上一讲中的老师表为基础,演示ibatis的动态sql。
sqlMap中这样写:
java中这样调用:
查询结果:
老师信息如下:
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 : 英语