<html lang="zh-CN">
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1">
<link href="http://cdn.static.runoob.com/libs/bootstrap/3.3.7/css/bootstrap.min.css" rel="stylesheet">
<script src="http://cdn.static.runoob.com/libs/bootstrap/3.3.7/css/bootstrap-theme.min.css"></script>
<script src="https://cdn.bootcdn.net/ajax/libs/jquery/2.1.4/jquery.min.js"></script>
<!-- <script src="http://code.jquery.com/jquery-2.1.4.min.js"></script> -->
<script src="http://cdn.static.runoob.com/libs/bootstrap/3.3.7/js/bootstrap.min.js"></script>
<script src="https://cdn.bootcss.com/underscore.js/1.9.1/underscore-min.js"></script>
<script type="text/javascript">
function onReplaceCleanNullRows(){ //清空空行
var str = document.getElementById("certiNo").value;
if(str == '' || str == 'undefined'){
return null;
}
str = str.replace(/\n(\n)*( )*(\n)*\n/g,"\n");
document.getElementById("certiNo").value=str;
}
function selectTextarea(){
var textbox = document.getElementById('certiNo');
var startIndex = 0;
var stopIndex = textbox.value.length;
textbox.focus();
if(textbox.setSelectionRange){
textbox.setSelectionRange(startIndex,stopIndex);
}else if(textbox.createTextRange){
var range=textbox.createTextRange();
range.collapse(true);
range.moveStart('character',startIndex);
range.moveEnd('character',stopIndex-startIndex);
range.select();
}
textbox.focus();
}
$(document).keydown( //默认快捷键
function(e){
var evn = e||event;
var code = evn.keyCode||evn.which||evn.charCode;
if(code==9){
$("#format").click();
return false;//阻止默认TAB行为，为了能够选中TEXTAERA中的文本
}
if(code==46){
$("#onReplaceClean").click();
}
if(window.event.altKey && window.event.keyCode==81){
$("#onReplaceNextRows").click();
}
}
);
$(document).ready(function(){
$("#format").click(function(){//格式化
var str = document.getElementById("certiNo").value;
var fdStart = str.indexOf("(");
if(fdStart == -1){
if(str == '' || str == 'undefined'){
return null;
}
<!-- 去最后n个换行 -->
str = str.replace(/^\s+|\s+$/g,'');
<!-- 去空行 -->
onReplaceCleanNullRows();
<!-- 将回车符替换成引号 -->
str=str.replace(/[\n\r]/g,'\',\'');
<!-- 开头和结尾增加引号-->
str = '\''+str+'\'';
str = '\('+str+'\)';
<!-- 去空格 -->
str = str.replace(/\s/g,"");
$("#certiNo").val(str);
}
//选中文本
selectTextarea();
});
$("#onReplaceNextRows").click(function(){//换行
var str = document.getElementById("certiNo").value;
if(str == '' || str == 'undefined'){
return null;
}
str=str.replace(/[,\r]/g,'\,\n');
str = str + '\r';
document.getElementById("certiNo").value=str;
onReplaceCleanNullRows();
selectTextarea();
});
$("#onReplaceClean").click(function(){//清空
document.getElementById("certiNo").value='';
});
});
</script>
</head>
<body style="">
<form name="fm" action="" method="post">
<nav class="navbar navbar-inverse navbar-fixed-top" role="navigation">
<div class="container">
<div class="navbar-collapse collapse" id="navbar">
<ul class="nav navbar-nav">
<li class="active"><a href="https://www.sinosoft.com.cn">中科软科技股份有限公司</a></li>
<li class="active"><a href="https://www.cnblogs.com/springwater">Made by zqp</a></li>
</ul>
</div>
</div>
</nav>
<div class="container theme-showcase" role="main" >
<div class="jumbotron">
<div class="page-header"><i class="icon-book"></i>
<h2>SQL Tool</small>
<button type="button" class="btn btn-primary" id="format">格式化(TAB)</button>
<button type="button" class="btn btn-primary" id="onReplaceNextRows">换行(Alt+Q)</button>
<button type="button" class="btn btn-primary" id="onReplaceClean">清空(DEL)</button>
</h2>
</div>
<textarea class="form-control" rows="20" cols="60" name="certiNo" id="certiNo" placeholder="输入要处理的批量数据，生成where之后的字段对应的值的mysql格式"></textarea>
<br>
</div>
</div>
</form>
</body>
</html>