java oracle sql±äÁ¿ ÈçºÎ°ó¶¨

SQL code:

String query = "select * from test where name =: na



ÈçÉÏsql Óï¾ä ÔÚjavaÖÐ ÓÃ
session.createSQLQuery(query);
query.setString("na", "Xionghong")
....
ÕâÑùдÊÇ¿ÉÒԵġ£
µ«Èç¹ûÎÒµÄqueryµÄ²éѯÌõ¼þÊÇ like ¶ø²»ÊÇ = ÈçºÎд¡£¿ÉÒÔÔÚjavaÖа󶨱äÁ¿

---

String query = "select * from test where name like ?

query.setString(1, "%Xionghong%")

---

¶÷¡£ÕâÑùд¿ÉÒԵġ£µ«ÎÒÏ£ÍûÊÇÉèÖð󶨱äÁ¿ ÒòΪÎÒÓкܶà¸ö ±äÁ¿°ó¶¨ ¶øÇÒ»¹ÓÐÌõ¼þÏÞÖÆ

---

Java code:

private String buildQuery(Map<String, Object> map) {
StringBuffer strBuff = new StringBuff();
if(map.contains("name")) {
map.append(" and t.name like '%").append(map.get("name")).append("%'");
}
if(map.contains("age")) {
map.append...
}
...
return strBuff.toString();
}
private int getCount(Map<String, Object> map) {
BigDecimal resultCount = null;
Session hibernateSession = getSession();
try {
String countSql = "select count(*) from Test t where 1 = 1 ".concat(this.buildQuery(map));
resultCount = (BigDecimal) hibernate.createSQLQuery(countSql);
i