62,614
社区成员
发帖
与我相关
我的任务
分享
select /*+ index(event event_pk) */
count(1)
from event
where evtcode = 'some_game'
and evtno = #evtno#
and userid = #memberid#
and giftcode = #giftcode#
SELECT /*+ INDEX(EVENTMAST EVENTMAST_PK) */
COUNT(1)
FROM EVENTMAST
WHERE EVTCODE = #evtcode#
AND EVTNO = #evtno#
AND USERID = #memberid#
AND GIFTCODE = #giftcode#
String sql = "select /*+ index(event event_pk) */\n"+
" count(1)\n" +
" from event\n" +
" where evtcode = 'some_game'\n" +
" and evtno = #evtno#\n" +
" and userid = #memberid#\n" +
" and giftcode = #giftcode#";
StringBuffer sb = new StringBuffer();
Pattern p = Pattern.compile("(?s)(.*?\\s*)(=.*?(\n|$))");
Matcher m = p.matcher(sql);
while (m.find()) {
m.appendReplacement(sb, m.group(1).toUpperCase() + m.group(2));
}
m.appendTail(sb);
System.out.println(sb);
String sql = "select /*+ index(event event_pk) */\n"+
" count(1)\n" +
" from event\n" +
" where evtcode = 'some_game'\n" +
" and evtno = #evtno#\n" +
" and userid = #memberid#\n" +
" and giftcode = #giftcode#";
StringBuffer sb = new StringBuffer();
Pattern p = Pattern.compile("(?s)(.*?\\s*)=(.*?(\n|$))");
Matcher m = p.matcher(sql);
while (m.find()) {
m.appendReplacement(sb, m.group(1).toUpperCase() + "=" + m.group(2));
}
m.appendTail(sb);
System.out.println(sb);
static String convert(String command){
Pattern pattern = Pattern.compile("(['#]\\S+)?");
Matcher matcher = pattern.matcher(command.toUpperCase());
StringBuffer buffer = new StringBuffer(256);
while (matcher.find()) {
matcher.appendReplacement(buffer, matcher.group().toLowerCase());
}
matcher.appendTail(buffer);
return buffer.toString();
}
String SQL = "select /*+ index(event event_pk) */\n"+
" count(1)\n" +
" from event\n" +
" where evtcode = 'some_game'\n" +
" and evtno = #evtno#\n" +
" and userid = #memberid#\n" +
" and giftcode = #giftcode#";
System.out.println(convert(SQL));
SELECT /*+ INDEX(EVENT EVENT_PK) */
COUNT(1)
FROM EVENT
WHERE EVTCODE = 'some_game'
AND EVTNO = #evtno#
AND USERID = #memberid#
AND GIFTCODE = #giftcode#
SELECT /*+ INDEX(EVENT EVENT_PK) */
COUNT(1)
FROM EVENT
WHERE EVTCODE = 'some_game'
AND EVTNO = #evtno#
AND USERID = #memberid#
AND GIFTCODE = #giftcode#