格式化日志中SQL（从Eclipse控制台中提取数据库查询语句）网页工具

最新推荐文章于 2020-09-16 14:10:05 发布

Capricorncd

最新推荐文章于 2020-09-16 14:10:05 发布

阅读量629

点赞数

文章标签： sql SQL格式化

本文链接：https://blog.youkuaiyun.com/Yagizacd/article/details/100155362

版权

本文介绍了一款实用工具，能够从Eclipse控制台中方便地提取和格式化SQL查询语句，帮助开发者更高效地管理和理解数据库操作。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

<!DOCTYPE html>
<html>
	<head>
		<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
		<meta name="viewport" content="width=device-width, initial-scale=1.0">
		<title>Getting SQL from Eclipse log</title>
		<link rel="stylesheet" href="https://unpkg.com/element-ui/lib/theme-chalk/index.css">
		<link rel="stylesheet" href="./css/common.css">
		<style>
			.result-form-data-wrapper {
     line-height: 20px; }
			.result-form-data-wrapper dl {
     margin: 0; padding: 0; }
			/*.result-form-data-wrapper dl *:hover { background: #f1f1f1; }*/
			.result-form-data-wrapper b {
     color: #00f; }
			.result-form-data-wrapper ._green {
     color: #67C23A; }
			.result-form-data-wrapper ._gray {
     color: #999; }
			.result-form-data-wrapper i {
     color: #f00;font-style: normal; }
			.result-form-data-wrapper ._warning {
     color: #E6A23C; }
			.result-list-table-wrapper {
     overflow-x:auto; padding-bottom: 30px; }
			.result-list-table-wrapper table {
     background: #999; }
			.result-list-table-wrapper table th {
     font-size: 1em; background: rgb(135, 231, 173); }
			.result-list-table-wrapper table td {
     background: #fff; font-size: 1em; }
		</style>
	</head>
	<body>

		<div id="app" class="wp">
			<zx-header></zx-header>

			<el-form>
				<el-form-item label="SQL string from Eclipse, Executing Statement:から、Parameters: [...]まで">
					<el-input
					 type="textarea"
					 :rows="5"
					 placeholder="SQL string from Eclipse, Executing Statement:から、Parameters: [...]まで"
					 v-model="inputSql"
					 @change="handleInputSqlChange"></el-input>
				</el-form-item>

				<el-form-item label="ResultSet string from Eclipse, Executing Header:から、Result: [...]まで">
					<el-input
					 type="textarea"
					 :rows="2"
					 placeholder="ResultSet string from Eclipse, Executing Header:から、Result: [...]まで"
					 v-model="inputResult"></el-input>
				</el-form-item>

				<!-- <el-form-item style="text-align:right;"> -->
					<!-- <el-button type="primary" @click="handleSubmit">Submit</el-button> -->
				<!-- </el-form-item> -->

				<el-form-item label="SQL">
					<el-input ref="result" type="textarea" :rows="5" placeholder="SQL" v-model="result" readonly></el-input>
				</el-form-item>

				<el-form-item style="text-align:right;">
					<el-button type=success plain @click="handleTest(0)">Test1 SQL</el-button>
					<el-button type="success" plain @click="handleTest(1)">Test2 SQL</el-button>
					<el-button @click="handleClear">Clear SQL</el-button>
					<el-button type="primary" @click="copyCode">Copy Code</el-button>
				</el-form-item>
				<!--
				<el-form-item>
					<div class="result-form-data-wrapper" v-html="resultFormatData"></div>
				</el-form-item>
 				-->
			</el-form>

最低0.47元/天解锁文章