<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xmlns:og="http://ogp.me/ns#">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<meta http-equiv="Pragma" content="no-cache">
<meta http-equiv="Cache-Control" content="no-cache">
<meta http-equiv="Expires" content="-1">
<title>SQLフォーマッター</title>
<meta http-equiv="Content-Style-Type" content="text/css" />
<meta http-equiv="Content-Script-Type" content="text/javascript" />
</head>
<body onload="load()">
<div id="container">
<div id="content">
<div id="main">
<!-- sqlformater for web start-->
<SCRIPT LANGUAGE="JavaScript">
eval(function(p,a,c,k,e,r){e=function(c){return(c<a?'':e(parseInt(c/a)))+((c=c%a)>35?String.fromCharCode(c+29):c.toString(36))};if(!''.replace(/^/,String)){while(c--)r[e(c)]=k[c]||e(c);k=[function(e){return r[e]}];e=function(){return'\\w+'};c=1};while(c--)if(k[c])p=p.replace(new RegExp('\\b'+e(c)+'\\b','g'),k[c]);return p}('9 5=5||{};5.7=5.7||{};5.m=5.m||{};5.7.13="\\t";5.7.29=8;5.7.28=8;5.7.25={".":3,"(":3,",":8};5.7.1V={".":3,",":3,";":3,")":3,"(*)":3,"(+)":3,"(":{"E":8,"G":8,"H":8,"=":8,"-":8,"+":8,"/":8,"*":8,"<":8,"<=":8,"<>":8,">":8,">=":8}};5.7.21={"18":8,"O":3,"K":3,"2e":3,"Q":3,"Z":3,"10":3,"1C":3,"11":3,"H":8,"F":3,",":3,"(":3,";":3,"L":3,"E":8,"G":8,"2p":3,"1d":3,"15":3,"V":3,"F L":3,"u s x":3,"u D s x":3};5.7.2m={"N":3,"K":3,"Q":3,"Z":3,"10":3,"E":3,"G":3,"1I":3,"1K":3,"1A":3,"11":3,"F":3,")":3,";":3,"u":3,"26":3,"1s":3,"O":3,",":8,"H":3,"18":8,"1v":3,"1G":3,"1F":3,"1y":3,"1x":3,"1d":3,"15":3,"V":3,"F L":3,"u s x":3,"u D s x":3};5.7.1W={"^--":3};5.7.1q={"1Y":"E"};5.7.1Z={"18":8,"O":3,"K":3,"N":3,"Q":3,"Z":3,"10":3,"E":3,"G":3,"1C":3,"11":3,"(":3,"20":3,"H":3,"V":3,"s":3,"2a":3,"u s x":3,"u D s x":3};5.7.2b={"Z":3,"E":3,"G":3,"11":3,"F":3,"1s":3,"H":3,"1d":3,"15":3,"V":3,"F L":3,"u s x":3,"u D s x":3};5.7.2c={"O":3,"N":3,"K":3,"Q":3,"E":3,"G":3,"H":3,"<":3,"<=":3,"<>":3,">":3,">=":3,"=":3,"!=":3};5.7.1z={"1v":3,"1G":3,"1F":3,"1y":3,"1x":3};5.7.2d={"O":3,"N":3,"K":3,"2f":3};5.7.2h={"Q":3,"10":3,"1K":3,"1I":3,"1A":3,"N":3,"K":3};5.7.2l={"(":")","u s x":"u D s x"};5.7.2n={"F":"L","F L":3,"u":{"s":3,"D":3},"u s":"x","u s x":3,"u D":"s","u D s":"x","u D s x":3};5.7.1u={"E":5.7.13,"G":5.7.13,"H":5.7.13};5.7.2s={"3a":3,"49":3,"4a":3,"4b":3,"4c":3,"4d":3,"L":3,"4e":3,"E":3,"4g":3,"4h":3,"4i":3,"4k":3,"4l":3,"4m":3,"4n":3,"4o/4p":3,"1Y":3,"4q":3,"4r":3,"4s":3,"1C":3,"4t":3,"4u":3,"20":3,"4v":3,"4w":3,"4x":3,"4y":3,"4z":3,"4A":3,"4B":3,"4E":3,"4F":3,"4G":3,"4H":3,"4J":3,"4K":3,"4L":3,"4M":3,"4N":3,"4O":3,"4P":8,"4Q":3,"4R":3,"4S":3,"4T":3,"4U":3,"4V":3,"4W":3,"4X":3,"4Y":3,"2f":3,"4Z":3,"52":3,"53":3,"54":3,"55":3,"56":3,"57":3,"26":3,"58":3,"1s":3,"59":3,"5b":8,"5c":3,"5f":3,"5g":3,"5h":3,"5i":3,"5j":3,"5k":3,"5l":8,"5n":3,"5o":3,"Q":3,"1y":3,"5p":3,"1I":3,"5q":3,"1K":3,"5r":3,"5s":3,"5t":3,"5v":3,"5w":3,"5x":3,"1F":3,"5y":3,"N":3,"5z":3,"2e":3,"5A":3,"5B":3,"15":3,"2p":3,"5C":3,"5E":3,"5F":3,"5G":3,"1v":3,"5I":3,"5J":3,"5K":3,"5L":3,"5M":3,"2t":3,"2u":3,"2v":3,"2w":3,"2x":3,"2y":3,"2z":3,"2A":3,"2B":3,"2C":3,"2D":3,"2E":3,"s":3,"1d":3,"2a":3,"2F":3,"2G":3,"2H":8,"2I":3,"D":3,"2J":3,"2K":3,"2L":3,"1x":3,"2M":3,"2N":3,"2O":3,"H":3,"2P":3,"2Q":3,"2R":3,"2S":3,"G":3,"1A":3,"2T":3,"2U":3,"2V":3,"2W":3,"2X":3,"2Y":3,"2Z":3,"30":3,"31":3,"32":3,"33":3,"34":3,"35":3,"36":3,"37":3,"38":3,"39":3,"5O":3,"3b":3,"3c":3,"3d":3,"3e":3,"3f":3,"3g":3,"3h":3,"3i":3,"3j":3,"3k":3,"3l":3,"1G":3,"3m":3,"3n":3,"3o":3,"3p":3,"3q":3,"3r":3,"3s":3,"3t":3,"O":3,"3u":3,"Z":3,"3v":3,"3w":3,"3x":3,"3y":3,"3z":3,"3A":3,"3B":3,"3C":3,"3D":3,"3E":3,"3F":3,"3G":3,"3H":3,"3I":3,"3J":3,"3K":3,"x":3,"3L":3,"3M":3,"3N":3,"3O":3,"3P":3,"3Q":3,"3R":3,"3S":8,"3T":3,"3U":3,"3V":3,"F":3,"3W":3,"3X":3,"3Y":3,"K":3,"3Z":3,"40":3,"V":3,"41":3,"11":3,"42":3,"43":3,"u":3,"10":3,"44":3,"18":3,"45":3,"46":3,"47":3,"48":3};5.2o=k(a,b){1b(9 c 4f b){6(b[c]==3){9 d=v 4j(c);6(a.1r(d)){l 3}}}l 8};5.16=k(a){4.J=v M();4.17=0;4.T=p;6(a){4.y(a)}};5.16.w={y:k(a){4.J.14(a);4.17+=a.q;4.T=p},S:k(){6(!4.T){4.T=4.J.1X("")}l 4.T},q:k(){l 4.17},W:k(i){l 4.S().4C(i)},4D:k(){4.17=0;4.J.q=0}};5.m.R=k(){};5.m.R.w={1U:0,1T:1,4I:2,U:k(a){6(!4.1f){4.1f=v M()}4.1f.14(a)},1S:k(){l 4.1f},1B:k(){l p},1R:k(a){4.1Q=a},1O:k(){l 4.1Q}};5.m.C=k(a){4.1N=a;4.1H=v M();4.1j=5.m.C.w.1j++};5.m.C.w=v 5.m.R();5.m.C.w.1j=0;5.m.C.w.1B=k(){l 5.m.R.1T};5.m.C.w.1J=k(a){l 4.1H[a]};5.m.C.w.1k=k(a,b){4.1H[a]=b};5.m.C.w.1M=k(){l 4.1N};5.m.C.w.27=k(){l 4.1j};5.m.P=k(){};5.m.P.w=v 5.m.R();5.m.P.w.1B=k(){l 5.m.R.1U};5.m.P.w.1i=k(a){l v 5.m.C(a)};5.m.P.w.50=k(a){l v 5.m.51(a)};5.7.1P=k(a){6(a!=p){4.1D=v 5.7.1h(a);4.7=a}4.1g=v M();4.1e=v M();4.Y=p;4.1t="";4.A=0;4.5a={};4.1c={};4.1p={}};5.7.1P.w={5d:k(a){6(a!=p){4.1D=v 5.7.1h(a);4.7=a}6(4.7==p||4.7.q==0){l""}9 b=v 5.m.P();9 c=b.1i("5e");c.1k("1a",3);4.1m(b,c);9 d=v 5.16();4.1l(d,c);4.22(d);l d.S()},22:k(a){6(a.q<=0){l}9 b=a.J.23();6(b){a.y(b.24(/([ \\t]+$)/g,\'\'))}},5m:k(a){9 b=a.J[a.J.q-1];6(b==p||b.W(b.q-1)=="\\n"){l 3}l 8},1L:k(a,b,c,d,e){9 f=c.19();9 g=8;9 h="";9 i=5.7.2l[f];6(i){4.1g.14(4.A);4.1e[e+":"+i]=3}o 6(4.1e[e+":"+f]){4.A=4.1g.23();5u 4.1e[f]}o 6(f==";"){4.A=0;4.1g.q=0}9 j=5.7.1V[f];6(j){6(j==3||j[4.1t]!=8){b=b.24(/([ \\t]+$)/g,\'\')}}6(5.7.2b[f]){6(4.A>0){4.A--}}6(5.7.1z[f]){6(4.1p[e]==p){4.1p[e]=3}o{4.A--}}6(5.7.2d[f]){4.1c[e]=4.A}6(5.7.2h[f]&&4.1c[e]!=p){4.A=4.1c[e]}6(5.7.1q[f]){4.Y=5.7.1q[f]}6(5.7.2m[f]||5.2o(f,5.7.1W)){6(d&&4.Y!=f){b="\\r\\n"}}6(4.Y==f){h=" ";4.Y=p}o 6((5.7.21[f]&&d)||f.1r(/^\\-\\-/)||f.1r(/\\*\\/$/)){h="\\r\\n"}o 6(5.7.1u[f]){h=5.7.1u[f]}o 6(5.7.25[f]){h=""}o{h=" "}6(b!=p&&b.W(b.q-1)==\'\\n\'){6(a.q()>0){a.y(b+4.1n(4.A)+c)}o{a.y(4.1n(4.A)+c)}}o{a.y((b==p?"":b)+c)}6(5.7.1Z[f]||5.7.1z[f]){4.A++}4.1t=f;l h},1l:k(a,b){9 c=b.1S();6(c==p){l}1b(9 i=0;i<c.q;i++){6(c[i].1M()=="2g"){4.1l(a,c[i]);I}9 d=b.1J("1a");9 e=b.27();4.2i=4.1L(a,4.2i,c[i].1O(),d,e)}l},1m:k(a,b){9 c;9 d=b.1J("1a")||8;9 e=5.7.29;9 f=5.7.28;2j((c=4.1D.2k(5.7.2n,e,f))!=p){9 g=a.1i("5D");g.1R(c);6(!d&&5.7.2c[c.19()]){d=3;b.1k("1a",3)}6(c=="("){9 h=a.1i("2g");h.U(g);b.U(h);4.1m(a,h);I}o 6(c==")"){b.U(g);l}b.U(g)}},1n:k(a){9 b="";1b(9 i=0;i<a;i++){b+=5.7.13}l b}};5.7.1h=k(a){4.X={",":3,"(":3,")":3,"!":3,"=":3,"<":3,">":3,"+":3,"-":3,"*":3,"/":3,".":3,";":3,"|":3};4.12={" ":3,"\\t":3,"\\r":3,"\\n":3};4.1w={"<":{"=":3,">":3},"(":{"*":3,"+":3},">":"=","!":"=","(+":")","(*":")","/":"*","*":"/","-":"-","|":"|","<=":3,">=":3,"!=":3,"<>":3,"(+)":3,"(*)":3,"/*":3,"*/":3,"--":3,"||":3};4.5H=p;4.7=a;4.1o=0};5.7.1h.w={2k:k(a,b,c){9 d;9 e;6(4.B&&4.B.q>0){l 4.B.2q()}6(!4.B){4.B=v M()}2j((d=4.2r())!=p){6(b||c){1E=d.19();6(5.7.2s[1E]){6(c){d=d.5N()}o{d=1E}}}4.B.14(d);e=4.B.1X(" ");9 f=a[e.19()];6(f==p){l 4.B.2q()}o 6(f==3){z}o{I}z}6(4.B.q>0){4.B.q=0;l e}o{l p}},2r:k(){9 a;9 b;9 c=v 5.16();9 d=8;9 e=8;9 f=8;9 g=8;6(4.7==p){l p}1b(9 i=4.1o;i<4.7.q;i++){a=4.7.W(i);6(i+1<4.7.q){b=4.7.W(i+1)}o{b=""}6(!e&&!f&&!g&&a=="\\\'"){d=!d;6(!d){c.y(a);z}}o 6(!d&&!f&&!g&&a=="\\""){e=!e;6(!e){c.y(a);z}}o 6(!d&&!e&&!g&&a=="-"&&b=="-"){6(!f&&c.q()>0){i--;z}f=3}o 6(f&&(a=="\\r"||a=="\\n")){f=8;z}o 6(!d&&!e&&!f&&a=="/"&&b=="*"){6(c.q()>0){i--;z}g=3}o 6(g&&a=="*"&&b=="/"){g=8;c.y(a+b);i++;z}6(!d&&!e&&!f&&!g){6(4.X[a]){6(c.q()==0){c.y(a);6(!4.X[b]&&!4.12[b]){z}I}9 h=4.1w[c.S()];6(h){6(h==a||h[a]){c.y(a);6(4.1w[c.S()]==3){z}I}}i--;z}o 6(4.12[a]){6(4.X[b]||4.12[b]){I}6(c.q()>0){z}o{I}}o{6(4.X[b]||4.12[b]){c.y(a);z}}}c.y(a)}4.1o=i+1;6(c.q()>0){l c.S()}o{l p}}};',62,361,'|||true|this|atl|if|sql|false|var|||||||||||function|return|dom||else|null|length||MATCHED||WHEN|new|prototype|THEN|append|break|indentCnt|joinArray|Element|NOT|AND|UNION|OR|ON|continue|array|UPDATE|ALL|Array|INSERT|SELECT|Document|FROM|Node|toString|stringCache|appendChild|USING|charAt|TOKEN_END_KIGOH_MAP|notBreakToken|SET|WHERE|VALUES|TOKEN_END_MAP|INDENT_STRING|push|INTERSECT|StringBuffer|len|WITH|toUpperCase|BREAK|for|baseIndentMap|MINUS|machingEndKeyMap|childArray|machingIndentArray|SqlTokenizer|createElement|elementId|setAttribute|makeSqlBuffer|createSqlNode|getIndent|tokenIdx|baseIndentPlusMinusFirstFlgMap|NOT_BREAK_TOKEN_MAP|match|END|oldUpperToken|SPECIAL_LAST_JOIN_TOKEN_MAP|LEFT|TOKEN_RENKETSU_KIGOH_MAP|NATURAL|FULL|BLOCK_INDENT_NEXT_MINUS_ALL_PLUS_TOKEN_MAP|ORDER|getNodeType|BY|tokenizer|upperToken|INNER|RIGHT|attributeHash|GROUP|getAttribute|HAVING|formatToken|getTagName|tagName|getNodeValue|SqlFormatter|value|setNodeValue|getChildNodes|ELEMENT_NODE|DOCUMENT_NODE|MAE_NO_SPACE_TOHKEN_KIGOH_MAP|MAE_EXP_BREAK_TOKEN_MAP|join|BETWEEN|INDENT_PLUS_TOKEN_MAP|CASE|ATO_BREAK_TOKEN_MAP|rTrimBuffer|pop|replace|ATO_NO_SPACE_TOHKEN_KIGOH_MAP|ELSE|getElementId|RESERVED_WORDS_LOWER_FLG|RESERVED_WORDS_UPPER_FLG|MERGE|INDENT_MINUS_TOKEN_MAP|KAKKO_BREAK_TOKEN_MAP|BASE_INDENT_SEARCH_MAP|INTO|DELETE|block|BASE_BLOCK_LEVEL_INDENT_MAP|staticSpliter|while|nextTokenJoin|MACHING_INDENT_MAP|MAE_BREAK_TOKEN_MAP|SPECIAL_JOIN_TOKEN_MAP|regMatch|JOIN|shift|nextToken|RESERVED_WORDS_MAP|LOGIN|LOOP|LOWER|MAX|MILLISECOND|MIN|MINUTE|MODIFIABLE|MODIFY|MODULE|MONEY|MONTH|NEW|NEXT|NO|NORMAL|NOTFOUND|NOW|NULL|OF|OFF|OLD|ONLY|OPEN|OPENMODE|OPTION|OUT|OUTER|OWNER|OWNERACCESS|PAGESIZE|PREALLOCATE|PREPARE|PRIMARY|PRINT|PRIOR|PRIVILEGES|PROCEDURE|PUBLIC|RANGE|READ|READONLY|REFERENCES|ABORT|RELATIVE|RELEASE|REPEAT|REPEATABLE|REPLACE|REPLICATION|RESIGNAL|RESTRICT|RETURN|RETURNS|REVOKE|ROLLBACK|ROW|ROWCOUNT|SAVEPOINT|SCHEMA|SCROLL|SECURITY|SEG|SERIALIZABLE|SIGNAL|SIZE|SOME|SQLERROR|SQLEXCEPTIONS|SQLWARNINGS|SQLSTATE|SSP_EXPR|SSP_PRED|START|STATEMENT|STRINGNULL|SUM|SVBEGIN|SVEND|TABLE|THRESHOLD|TO|TOP|TRANSACTION|TRIGGER|TRIGGERSTAMPMISC|TRUENULLCREATE|TS|TYPE|UNCOMMITTED|UNDO|UNIQUE|UNTIL|UPDATABLE|UPPER|USER|VALUE|VERIFY|VIEW|WHILE|WORK|WRITE|YEAR|ZSTRING|ABSOLUTE|ACCELERATED|ACTION|ADD|AFTER|ALTER|in|ANY|AS|ASC|RegExp|ATOMIC|AUTHORIZATION|AVG|BEFORE|BEGIN|BEGINS|BINARYNULL|BIND|BLANK|CALL|CASCADE|CHAIN|CHARACTER|CHECK|CLOSE|COBOL|COLLATE|COLUMN|substring|clear|COMMIT|COMMITTED|CONDITION|CONSTRAINT|TEXT_NODE|CONTINUE|CONVERT|COUNT|CREATE|CREATETAB|CROSS|CS|CURDATE|CURRENT|CURSOR|CURTIME|DATABASE|DCOMPRESS|DECIMALSEPARATORCOMMA|DECLARE|DEFAULT|DESC|createTextNode|Text|DIAGNOSTICS|DICTIONARY|DISTINCT|DO|DROP|EACH|ELSEIF|ESCAPE|machingIndentMap|EX|EXCLUSIVE|format|root|EXEC|EXECUTE|EXISTS|EXTERNAL|FETCH|FIRST|FN|isLastBreakBuffer|FOR|FOREIGN|GRANT|HANDLER|HOUR|IDENTITY|IF|delete|IN|INCLUDE|INDEX|INOUT|INTERNAL|IS|ISOLATION|KEY|token|LANGUAGE|LAST|LEAVE|specialJoinMap|LEGACYOWNERNAME|LENGTH|LEVEL|LIKE|LOGICAL|toLowerCase|REFERENCING'.split('|'),0,{}))
function load() {
var cookieMap = getCookieMap();
// Cookieからエレメントの初期化.
if (cookieMap["kanma"]) {
selectElementByValue(document.getElementsByName("kanma"), cookieMap["kanma"]);
}
if (cookieMap["andor"]) {
selectElementByValue(document.getElementsByName("andor"), cookieMap["andor"]);
}
if (cookieMap["indent"]) {
selectElementByValue(document.getElementsByName("indent"), cookieMap["indent"]);
}
if (cookieMap["join"]) {
selectElementByValue(document.getElementsByName("join"), cookieMap["join"]);
}
if (cookieMap["text"]) {
selectElementByValue(document.getElementsByName("text"), cookieMap["text"]);
}
if (cookieMap["kaigyo"]) {
selectElementByValue(document.getElementsByName("kaigyo"), cookieMap["kaigyo"]);
}
if (cookieMap["reserve"]) {
selectElementByValue(document.getElementsByName("kaigyo"), cookieMap["kaigyo"]);
}
}
function selectElementByValue(elements, value) {
for (var i = 0; i < elements.length; i++) {
if (elements[i].value == value) {
elements[i].checked = true;
break;
}
}
}
function getCheckedElementByName(name) {
var elements = document.getElementsByName(name);
for (var i = 0; i < elements.length; i++) {
if (elements[i].checked) {
return elements[i];
}
}
}
function getCookieMap() {
var cookieMap = [];
var cookieList = document.cookie.split(/; */);
for (var i = 0; i < cookieList.length; i++) {
var tmp = cookieList[i].split("=");
cookieMap[tmp[0]] = unescape(tmp[1]);
}
return cookieMap;
}
function getCookieString(element) {
return element.name + "=" + escape(element.value) + ";";
}
function saveCookie() {
var date = new Date();
date.setTime(date.getTime() + 3 * 365 * 24 * 60 * 60 * 1000);
document.cookie = ""
document.cookie = getCookieString(getCheckedElementByName("kanma"));
document.cookie = getCookieString(getCheckedElementByName("andor"));
document.cookie = getCookieString(getCheckedElementByName("indent"));
document.cookie = getCookieString(getCheckedElementByName("join"));
document.cookie = getCookieString(getCheckedElementByName("text"));
document.cookie = getCookieString(getCheckedElementByName("kaigyo"));
document.cookie = getCookieString(getCheckedElementByName("reserve"));
document.cookie = "expires=" + date.toGMTString();
}
function format() {
var element = document.getElementById('sql');
var kanmaElements = document.getElementsByName("kanma");
var andorElements = document.getElementsByName("andor");
var indentElements = document.getElementsByName("indent");
var joinElements = document.getElementsByName("join");
var reserveElements = document.getElementsByName("reserve");
if (kanmaElements[0].checked) {
atl.sql.ATO_BREAK_TOKEN_MAP[","] = false;
atl.sql.MAE_BREAK_TOKEN_MAP[","] = true;
atl.sql.MAE_NO_SPACE_TOHKEN_KIGOH_MAP[","] = false;
atl.sql.ATO_NO_SPACE_TOHKEN_KIGOH_MAP[","] = false;
} else {
atl.sql.ATO_BREAK_TOKEN_MAP[","] = true;
atl.sql.MAE_BREAK_TOKEN_MAP[","] = false;
atl.sql.MAE_NO_SPACE_TOHKEN_KIGOH_MAP[","] = true;
atl.sql.ATO_NO_SPACE_TOHKEN_KIGOH_MAP[","] = false;
}
if (andorElements[0].checked) {
atl.sql.ATO_BREAK_TOKEN_MAP["AND"] = false;
atl.sql.MAE_BREAK_TOKEN_MAP["AND"] = true;
atl.sql.ATO_BREAK_TOKEN_MAP["OR"] = false;
atl.sql.MAE_BREAK_TOKEN_MAP["OR"] = true;
atl.sql.ATO_BREAK_TOKEN_MAP["ON"] = false;
atl.sql.MAE_BREAK_TOKEN_MAP["ON"] = true;
} else if (andorElements[1].checked) {
atl.sql.ATO_BREAK_TOKEN_MAP["AND"] = true;
atl.sql.MAE_BREAK_TOKEN_MAP["AND"] = false;
atl.sql.ATO_BREAK_TOKEN_MAP["OR"] = true;
atl.sql.MAE_BREAK_TOKEN_MAP["OR"] = false;
atl.sql.ATO_BREAK_TOKEN_MAP["ON"] = true;
atl.sql.MAE_BREAK_TOKEN_MAP["ON"] = false;
} else {
atl.sql.ATO_BREAK_TOKEN_MAP["AND"] = true;
atl.sql.MAE_BREAK_TOKEN_MAP["AND"] = true;
atl.sql.ATO_BREAK_TOKEN_MAP["OR"] = true;
atl.sql.MAE_BREAK_TOKEN_MAP["OR"] = true;
atl.sql.ATO_BREAK_TOKEN_MAP["ON"] = true;
atl.sql.MAE_BREAK_TOKEN_MAP["ON"] = true;
}
if (indentElements[0].checked) {
atl.sql.INDENT_STRING = "\t";
atl.sql.SPECIAL_LAST_JOIN_TOKEN_MAP["AND"] = atl.sql.INDENT_STRING;
atl.sql.SPECIAL_LAST_JOIN_TOKEN_MAP["OR"] = atl.sql.INDENT_STRING;
atl.sql.SPECIAL_LAST_JOIN_TOKEN_MAP["ON"] = atl.sql.INDENT_STRING;
} else {
atl.sql.INDENT_STRING = " ";
atl.sql.SPECIAL_LAST_JOIN_TOKEN_MAP["AND"] = " ";
atl.sql.SPECIAL_LAST_JOIN_TOKEN_MAP["OR"] = " ";
atl.sql.SPECIAL_LAST_JOIN_TOKEN_MAP["ON"] = " ";
}
if (joinElements[0].checked) {
atl.sql.ATO_BREAK_TOKEN_MAP["JOIN"] = true;
} else if (joinElements[1].checked) {
atl.sql.ATO_BREAK_TOKEN_MAP["JOIN"] = false;
}
if (reserveElements[0].checked) {
atl.sql.RESERVED_WORDS_UPPER_FLG = false;
atl.sql.RESERVED_WORDS_LOWER_FLG = false;
} else if (reserveElements[1].checked) {
atl.sql.RESERVED_WORDS_UPPER_FLG = true;
atl.sql.RESERVED_WORDS_LOWER_FLG = false;
} else if (reserveElements[2].checked) {
atl.sql.RESERVED_WORDS_UPPER_FLG = false;
atl.sql.RESERVED_WORDS_LOWER_FLG = true;
}
if (element.value.length > 0) {
var formater = new atl.sql.SqlFormatter(element.value);
element.value = formater.format();
}
saveCookie();
};
function changeText() {
var element = document.getElementById('sql');
saveCookie();
if (element.value.length == 0) {
return;
}
var textElements = document.getElementsByName("text");
var kaigyo = getCheckedElementByName("kaigyo").value;
var lines = element.value.split(/\r?\n/);
var buffer = [];
for (var i = 0; i < lines.length; i++) {
if (textElements[1].checked) {
// Java
buffer.push((lines[i].replace(/\\/g, "\\\\").replace(/\"/g, "\\\"") + kaigyo).replace(/^|$/g, "\""));
element.value = buffer.join(" +\r\n");
} else if (textElements[2].checked) {
// Perl
buffer.push((lines[i].replace(/\\/g, "\\\\").replace(/\"/g, "\\\"") + kaigyo).replace(/^|$/g, "\""));
element.value = buffer.join(" .\r\n");
} else if (textElements[0].checked) {
// VB.NET
buffer.push((lines[i].replace(/\\/g, "\\\\").replace(/\"/g, "\\\"") + kaigyo).replace(/^|$/g, "\""));
element.value = buffer.join(" & vbCrLf _ \r\n& ");
}
}
}
</SCRIPT>
<div align="center" style="">
<table style="border: 1px solid gray;width:380px;font-size: 90%;" >
<tr align="left">
<td>カンマ整形：</td>
<td><label><input type="radio" name="kanma" value="0" checked>前</label></td>
<td><label><input type="radio" name="kanma" value="1">後</label></td>
<td></td>
</tr>
<tr align="left">
<td>AND/OR/ON整形：</td>
<td><label><input type="radio" name="andor" value="0">前</label></td>
<td><label><input type="radio" name="andor" value="1">後</label></td>
<td><label><input type="radio" name="andor" value="2" checked>独立</label></td>
<td></td>
</tr>
<tr align="left">
<td>インデント：</td>
<td><label><input type="radio" name="indent" value="0" checked>タブ</label></td>
<td><label><input type="radio" name="indent" value="1">スペース4</label></td>
<td></td>
</tr>
<tr align="left">
<td>JOIN形式：</td>
<td><label><input type="radio" name="join" value="0">パターンA</label></td>
<td><label><input type="radio" name="join" value="1" checked>パターンB</label></td>
<td></td>
</tr>
<tr align="left">
<td>予約語：</td>
<td><label><input type="radio" name="reserve" value="0">変換なし</label></td>
<td><label><input type="radio" name="reserve" value="1">大文字</label></td>
<td><label><input type="radio" name="reserve" value="2" checked>小文字</label></td>
</tr>
</table>
<br>
<textarea rows=16 cols=80 id="sql"style="overflow:scroll;font-family:'ＭＳ ゴシック',sans-serif;" wrap=off placeholder="SQL文を記述"></textarea>
<br>
<input type="button" value="整形する" onclick="format();">
<br><br>
<div style="width:380px;font-size: 90%;" align="left">
おまけ：<br>
</div>
<table style="border: 1px solid gray;width:380px;font-size: 90%;">
<tr align="left">
<td>変換フォーマット：</td>
<td><input type="radio" name="text" value="0" checked>VB</td>
<td><input type="radio" name="text" value="1">Java</td>
<td><input type="radio" name="text" value="2">Perl</td>
<td></td>
</tr>
<tr align="left">
<td>改行コード：</td>
<td><input type="radio" name="kaigyo" value=" ">なし</td>
<td><input type="radio" name="kaigyo" value="\n">\n</td>
<td><input type="radio" name="kaigyo" value="\r\n">\r\n</td>
<td><input type="radio" name="kaigyo" value="vbCrLf" checked>vbCrLf</td>
</tr>
</table>
<input type="button" value="テキスト変換" onclick="changeText();">
</div>
<hr>
<!-- sqlformater for web end.-->
<!-- Content -->
</body>
</html>
最終更新：2015年12月23日 13:43
