欢迎来到SpringWater的博客

人生三从境界：昨夜西风凋碧树，独上高楼，望尽天涯路。衣带渐宽终不悔，为伊消得人憔悴。众里寻他千百度，蓦然回首，那人却在灯火阑珊处。

sql字段对应批量数据处理工具

<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://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;
}

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>

posted @ 2024-06-12 14:53 骑ZHU看夕阳``` 阅读(6) 评论(0) 编辑收藏举报

刷新页面返回顶部