<div id="readability-page-1" class="page"><div id="article_content">
<h2><a name="t0"></a><a id="spring_bootLazy_ORMmysql_0"></a>【spring boot+Lazy ORM+mysql】開發(fā)一個(gè)數(shù)據(jù)庫管理系統(tǒng)實(shí)現(xiàn)對應(yīng)數(shù)據(jù)庫數(shù)據(jù)查看和修改</h2>
<h3><a name="t1"></a><a id="http124222486230193wusmartacwuiindexhtmlloginhttp124222486230193wusmartacwuiindexhtmllogin_adminadmin_2"></a><a href="http://124.222.48.62:30193/wu-smart-acw-ui/index.html#/login" rel="nofollow">演示項(xiàng)目地址</a>：http://124.222.48.62:30193/wu-smart-acw-ui/index.html#/login （admin/admin）</h3>
<h3><a name="t2"></a><a id="_3"></a>功能</h3>
<ul><li>用戶登錄注冊</li><li>新增、編輯數(shù)實(shí)例</li><li>新增、編輯數(shù)據(jù)庫信息</li><li>新增表結(jié)構(gòu)</li><li><em><strong>核心</strong></em>表數(shù)據(jù)查看</li></ul>
<h4><a name="t3"></a><a id="_11"></a>用戶登錄注冊</h4>
<p><img src="https://upload-images.jianshu.io/upload_images/29237356-5927449763167399.png" alt="在這里插入圖片描述"></p>
<h4><a name="t4"></a><a id="_14"></a>新增、編輯數(shù)實(shí)例</h4>
<p><img src="https://upload-images.jianshu.io/upload_images/29237356-c1acec4302b21821.png" alt="在這里插入圖片描述"></p>
<h4><a name="t5"></a><a id="_17"></a>新增、編輯數(shù)據(jù)庫信息</h4>
<p><img src="https://upload-images.jianshu.io/upload_images/29237356-0728bb5f876850eb.png" alt="在這里插入圖片描述"></p>
<h4><a name="t6"></a><a id="_20"></a>新增表結(jié)構(gòu)</h4>
<p><img src="https://upload-images.jianshu.io/upload_images/29237356-60abaeb2b6c79d0d.png" alt="在這里插入圖片描述"></p>
<h4><a name="t7"></a><a id="_23"></a>表數(shù)據(jù)查看</h4>
<h5><a id="navicat_24"></a>單表查詢（和navicat一樣點(diǎn)點(diǎn)點(diǎn)就好了）</h5>
<ul><li>選擇數(shù)據(jù)庫實(shí)例</li><li>選擇數(shù)據(jù)庫</li><li>選擇表</li><li>選擇你要查詢的數(shù)據(jù)字段默認(rèn)是全選</li><li>字段展示默認(rèn)是按照字段名稱進(jìn)行展示、可以切換到通過字段描述展示</li><li>添加搜索參數(shù)選擇你要查詢的參數(shù)，條件，數(shù)據(jù)（支持=、like、>、<、in）</li><li>點(diǎn)擊執(zhí)行查看篩選結(jié)果</li><li>添加數(shù)據(jù)按鈕新增一條數(shù)據(jù)，輸入數(shù)據(jù)庫點(diǎn)擊空白保存</li><li>導(dǎo)出支持導(dǎo)出upsert數(shù)據(jù)、md數(shù)據(jù)
<img src="https://upload-images.jianshu.io/upload_images/29237356-7d7bde7625d79796.png" alt="在這里插入圖片描述"></li></ul>
<h5><a id="navicat_sql_35"></a>多表查詢（和navicat 你要寫點(diǎn)sql了）</h5>
<ul><li>選擇你要執(zhí)行的數(shù)據(jù)庫實(shí)例、數(shù)據(jù)庫</li><li>寫sql就好了哦，可以支持sql提示的哦
<img src="https://upload-images.jianshu.io/upload_images/29237356-b096608f70f44f10.png" alt="在這里插入圖片描述"></li></ul>
<h4><a name="t8"></a><a id="httpsgiteecomwujiawei1207537021wuframeworkparenttreemasterwusmartintegrationwusmartacwhttpsgiteecomwujiawei1207537021wuframeworkparenttreemasterwusmartintegrationwusmartacw_42"></a><a href="https://gitee.com/wujiawei1207537021/wu-framework-parent/tree/master/wu-smart-integration/wu-smart-acw" rel="nofollow">后端服務(wù)源碼</a>：https://gitee.com/wujiawei1207537021/wu-framework-parent/tree/master/wu-smart-integration/wu-smart-acw</h4>
<h4><a name="t9"></a><a id="httpsgiteecomwujiawei1207537021wuvuelazydmthttpsgiteecomwujiawei1207537021wuvuelazydmt_43"></a><a href="https://gitee.com/wujiawei1207537021/wu-vue-lazy-dmt" rel="nofollow">前端源碼</a>：https://gitee.com/wujiawei1207537021/wu-vue-lazy-dmt</h4>
<h4><a name="t10"></a><a id="docker_46"></a>docker啟動(dòng)</h4>
<pre data-index="0"><code onclick="mdcp.copyCode(event)">docker run -d -it -p 18080:18080 -e MAIN_DB_HOST=cloud-mysql:3306 -e MAIN_DB_USERNAME=root -e MAIN_PASSWORD=mysql --name wu-smart-acw-server registry.cn-hangzhou.aliyuncs.com/wu-lazy/wu-smart-acw-server:1.2.6-JDK17-SNAPSHOT
http://127.0.0.1:18080/swagger-ui/index.html
http://127.0.0.1:18080/wu-smart-acw-ui/index.html
</code><ul><li>1</li><li>2</li><li>3</li><li>4</li><li>5</li><li>6</li><li>7</li><li>8</li></ul></pre>
</div></div><blockquote><p>本文使用 <a href="http://www.itdecent.cn/p/5709df6fb58d" class="internal">文章同步助手</a> 同步</p></blockquote>
