线下配置方式:
修改容器下conf\custom\ace4j-private.properties #jdbc连接 database.demo.url = jdbc:mysql://sp5052d5230e8b4.mysql.rds.aliyuncs.com:3306/huamin_dev #用户名 database.demo.username = huamin_dev #密码 database.demo.password = huamin_dev |
spring配置方式:
<bean id="datasource" class="com.alibaba.appengine.api.ds.DataSourceFactory" factory-method = "getDataSource" /> |
Java代码:
DataSource ds = DataSourceFactory.getDataSource(); Connection con = null; Statement statement = null; try { con = ds.getConnection(); statement = con.createStatement(); if (statement.execute("select * from developer limit 0,20 ")) { ResultSet result = statement.getResultSet(); while (result.next()) { out.println("查询数据库获得结果 name:" + result.getString("name")); } } } finally { if (statement != null) { statement.close(); } if (con != null) { con.close(); } } |
注:线上环境不需要配置数据链接,直接获取数据源即可