SQL 编辑工具

最新推荐文章于 2024-08-02 07:00:00 发布

flyfx52

最新推荐文章于 2024-08-02 07:00:00 发布

阅读量279

点赞数

分类专栏： java 工具类文章标签： javascript ViewUI

本文链接：https://blog.csdn.net/flyfx52/article/details/84694774

版权

java 工具类专栏收录该内容

2 篇文章 0 订阅

订阅专栏

<HTML>
<HEAD>
<TITLE>SQLチェンジ</TITLE>
<style type="text/css">
body {
margin:0;
padding:0;
border:0;
text-align:left;
font: 12px ＭＳゴシック;
background:#CCCCCC;
}
textarea {
border: 1 dotted ;
font: 12px Arial, ＭＳゴシック;
margin: 0;
overflow: auto;
padding: 0 0 0 0px;
width: 100%;
}
textarea#sql {
height: 210px;
}
textarea#param {
height: 60px;
}
textarea#result {
border: 1 dashed;
height: 210px;
}
</style>
<script type="text/javascript">
String.prototype.trim = function() {return this.replace(/^\s+|\s+$/g,"");}
function doChange(){
var sql = $("sql").value;
var result = sql;
var params = $("param").value.replace(/[\[\]]+/gm,"").split(",");
if ("" != params){
for(var i in params) {
result = result.replace(/\?/,"'" + params[i].trim() + "'");
}
}
$("result").value = result;
}
function $(element){
return document.getElementById(element);
}
function doClean(){
$("sql").value="";
$("param").value="";
$("result").value="";
}
</script>
<HTA:APPLICATION ID="oHTA"
APPLICATIONNAME="sqlChange" BORDER="thin"
BORDERSTYLE="normal" CAPTION="yes"
ICON="filename.ico"
MAXIMIZEBUTTON="no"
MINIMIZEBUTTON="no"
SHOWINTASKBAR="no"
INGLEINSTANCE="no"
SYSMENU="yes"
VERSION="1.0"
WINDOWSTATE="normal"/>
</HEAD>
<BODY SCROLL="no">
<div>
<h3>SQL文</h3>
<textarea name="sql" id="sql"/></textarea>
</div>
<div>
<h3>パラメータ</h3>
<textarea name="param" id="param"></textarea>
</div>
<div align="right"><hr/>
<input type="button" value="チェンジ" οnclick="doChange();">

<input type="button" value="クリア" οnclick="doClean();">

</div>
<div>
<h3>結果</h3>
<textarea name="result" id="result" readonly="readonly"></textarea>
</div>
</BODY>
</HTML>