TERSUS无代码开发(笔记20)-本地开发测试mysql数据库连接
Configuration.xml 文件官网下载(文件夹中没有此文件就要下载)
1.外部数据库地址账号密码等连接配置信息需放入项目文件夹下的“Configuration.xml”配置文件中
127.0.0.1
![](https://images.cnblogs.com/OutliningIndicators/ContractedBlock.gif)
<?xml version="1.0" encoding="UTF-8"?> <Application name="CABJ" rootSystem="CABJ/CABJ" authenticationMethod="None"> <Resource name="jdbc/Main" driverClassName="com.mysql.jdbc.Driver" maxActive="100" maxIdle="30" maxWait="10000" auth="Container" type="javax.sql.DataSource" username="root" password="123456" testOnBorrow="true" testWhileIdle="true" url="jdbc:mysql://127.0.0.1:3306/cabj?useUnicode=true&characterEncoding=utf-8&autoReconnect=true&failOverReadOnly=false&autoReconnectForPools=true"/> </Application>
localhost
![](https://images.cnblogs.com/OutliningIndicators/ContractedBlock.gif)
<?xml version="1.0" encoding="UTF-8"?> <Application name="CABJ" rootSystem="CABJ/CABJ" authenticationMethod="None"> <Resource name="jdbc/Main" driverClassName="com.mysql.jdbc.Driver" maxActive="100" maxIdle="30" maxWait="10000" auth="Container" type="javax.sql.DataSource" username="root" password="123456" testOnBorrow="true" testWhileIdle="true" url="jdbc:mysql://localhost:3306/cabj?useUnicode=true&characterEncoding=utf-8&autoReconnect=true&failOverReadOnly=false&autoReconnectForPools=true"/> </Application>
Mysql数据库用户名和密码
MySQL5.7.29 和 Navicat的按装使用链接 https://www.cnblogs.com/djtang/p/13301482.html
新建的cabj数据库名
2.在开发软件Tersus安装目录文件夹下放入数据库连接驱动文件 mysql-connector-java-5.-bin.jar (我按装的目录:D:\program files\Tersus\jre\lib\ext)
mysql-connector-java-5.-bin.jar下载方法链接地址:https://www.cnblogs.com/djtang/p/14768928.html
3.回到当前项目停止运行项目
4.关闭软件重启,完成连接,打开数据库可以看到一些数据库表.