jdbc中的查询语句会经常用到:
String sql2 = "select u.USERID from USER_PREF u " + "where u.USERID like ?||'%' and ( u.key like 'SEARCH_TEMPLATE:%')"; uidList = (List<String>) qr.query(sql2, new ColumnListHandler("USERID"), uid);
jdbc中的查询语句会经常用到:
String sql2 = "select u.USERID from USER_PREF u " + "where u.USERID like ?||'%' and ( u.key like 'SEARCH_TEMPLATE:%')"; uidList = (List<String>) qr.query(sql2, new ColumnListHandler("USERID"), uid);