TERSUS笔记103-本地开发测试mysql数据库连接
Configuration.xml 文件官网下载(文件夹中没有此文件就要下载)
1.外部数据库地址账号密码等连接配置信息需放入项目文件夹下的“Configuration.xml”配置文件中
127.0.0.1
<?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
<?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>