console
<script src="//cdn.bootcss.com/jquery/1.9.1/jquery.min.js">
</script>
<link href="//cdn.bootcss.com/bootstrap/3.3.4/css/bootstrap.min.css" rel="stylesheet">
<script src="//cdn.bootcss.com/bootstrap/3.3.4/js/bootstrap.min.js">
</script>
<link href="//cdn.bootcss.com/layer/3.0.1/skin/default/layer.min.css"
rel="stylesheet">
<div class="aw-container-wrap">
<div class="container">
<div class="row">
<div class="aw-content-wrap clearfix">
<div class=" aw-main-content" style="min-height:700px;max-height:2000px">
<div class="panel panel-default">
<div class="panel-heading">
<div class="media">
<div class="media-body">
<h4 class="media-heading">
SQL追加或去除双引号
</h4>
<div id="desc1">
SQL追加或去除双引号
</div>
</div>
</div>
</div>
<div class="panel-body">
<div class="box1">
<div class="info1">
<div style="color:#336699;">
请把要增加双引号的文字粘贴到下面表单:
</div>
<div align="center">
<textarea id="content" name="content" onfocus="if(jQuery(this).val()=='[要增加双引号的内容放上面,要去除双引号的内容放下面]'){jQuery(this).val('');}"
onblur="if(jQuery(this).val()==''){jQuery(this).val('[要增加双引号的内容放上面,要去除双引号的内容放下面]');}"
rows="15">
[要增加双引号的内容放上面,要去除双引号的内容放下面]
</textarea>
</div>
<div style="margin-left:2px;padding:10px 0px 0px 0px; text-align:center;">
<input class="but2" id="conv" type="button" value="追加双引号↓" style="width:100px">
<input class="but2" id="res" type="button" value="去除双引号↑" style="width:100px">
<input class="but2" id="Button3" type="button" value="清空" onclick="jQuery('#content').val('');">
</div>
<div style="color:#336699;">
追加双引号结果如下:
</div>
<div align="center">
<textarea id="result" name="result" rows="15">
</textarea>
</div>
<div style="margin-left:2px;padding:10px 0px 0px 0px; text-align:center;">
<input class="but2" id="Button2" type="button" value="清空" onclick="jQuery('#result').val('');">
</div>
</div>
</div>
<script type="text/javascript" src="http://tool.chinaz.com/template/default/js/jquery.min.js">
</script>
<script>
$(function() {
$("#conv").click(function() {
var cont = $("#content").val();
var text_array = cont.split("\n");
var res = "";
for (var i = 0; i < text_array.length; i++) {
var line = text_array[i];
line = line.replace(';', '');
if (line == "") {
continue;
}
res += '"' + line + '"';
if (text_array.length != 1 && i < text_array.length - 1) {
res += ' +';
}
res += '\n';
}
$("#result").val(res);
});
$("#res").click(function() {
var cont = $("#result").val();
var text_array = cont.split("\n");
var res = "";
for (var i = 0; i < text_array.length; i++) {
res += text_array[i].replace(/\"|\+/g, '') + '\n';
}
$("#content").val(res);
});
})
</script>
</div>
<input type="hidden" id="encode" value="1" />
<div class="panel-footer">
</div>
</div>
</div>
</div>
</div>
</div>
</div>
.a2016 {
color: white;
font-family: "Microsoft YaHei", 微软雅黑, "MicrosoftJhengHei", 华文细黑, STHeiti, MingLiu;
text-align: center;
background: red;
border-radius: 2px;
}
.touxiang {
height: 20px;
line-height: 45px;
}
* {
font-size: 13px;
}
textarea {
border: 1px solid #C5E2F2;
font-size: 14px;
line-height: 20px;
overflow: visible;
padding: 5px;
width: 850px;
}
.aesdiv {
color: #336699;
}
.aesdiv span {
margin-left: 10px;
}
.pwd {
border: 1px solid #C5E2F2;
width: 150px;
height: 18px;
}