<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8" />
<title>js实现SQL语句格式化</title>
<script src="sql-formatter.min.js"></script>
<style>
.demo { padding: 10px; }
.demo-btn { }
.demo-btn a { text-decoration: none; color: #696969; background-color: #dadada; padding: 10px 20px; display: inline-block; border-radius: 5px; transition: .5s; }
.demo-btn a:hover { box-shadow: 0 0 10px #15537b; background-color: #388dc5; color: #fff; }
.demo-sql { }
.demo-sql textarea { outline: none; font-family: 'Microsoft YaHei'; width: 100%; height: 500px; border: 1px solid #dadada; padding: 5px; border-radius: 5px; transition: .5s; }
.demo-sql textarea:hover { box-shadow: 0 0 10px #15537b; border-color: #388dc5; }
</style>
</head>
<body>
<div class="demo demo-btn">
<a href="javascript:;" id="lbtnFormat">格式化</a>
</div>
<div class="demo demo-sql">
<textarea id="txtSql">SELECT DicId,ParentDicId,DicType,DicName FROM BAS_DataDic WHERE DicName=='Quber' AND DicType=100 ORDER BY DicName DESC,DicType ASC;</textarea>
</div>
</body>
</html>
<script>
onload = function () {
document.getElementById('lbtnFormat').addEventListener('click', function () {
var formatSql = sqlFormatter.format(document.getElementById('txtSql').value, { language: 'sql', indent: ' ' });
document.getElementById('txtSql').value = formatSql;
});
};
</script>
评论2