[spring boot+Lazy ORM+mysql] Develop a database management system to view and modify the corresponding database data
Demo project address : http://124.222.48.62:30193/wu -smart-acw-ui/index.html#/login (admin/admin)
function
-
User login registration -
Add and edit instances -
Add and edit database information -
New table structure -
***View core * * * table data
User login registration
Add and edit instances
Add and edit database information
New table structure
Single table query (just click it like navicat)
-
Select Database Instance -
Select Database -
Select Table -
Select the data field you want to query. By default, select all -
Field display is displayed by field name by default, and can be switched to display by field description -
Add search parameters Select the parameters, conditions and data you want to query (support= like、>、<、in) -
Click Execute to view the filtering results -
Click Add Data to add a new piece of data, enter the database and click Blank to save -
Export supports exporting upsert data and md data
Multi table query (and navicat, you need to write some sql)
-
Select the database instance and database you want to execute -
It's good to write SQL. You can support SQL prompts
Backend service source code : https://gitee.com/wujiawei1207537021/wu-framework-parent/tree/master/wu-smart-integration/wu-smart-acw
Front end source code : https://gitee.com/wujiawei1207537021/wu-vue-lazy-dmt
Docker Start
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