| | |
|---|
| | | public MysqlConnPool(String server_ip, int port, int conncount_max)
|
|---|
| | | {
|
|---|
| | | try {
|
|---|
| | | init(server_ip, port, conncount_max);
|
|---|
| | | initMySQL8(server_ip, port, conncount_max);
|
|---|
| | | } catch (PropertyVetoException e) {
|
|---|
| | | e.printStackTrace();
|
|---|
| | | }
|
|---|
| | |
|---|
| | | mysql_ds.setMinPoolSize(2);
|
|---|
| | | mysql_ds.setIdleConnectionTestPeriod(60);
|
|---|
| | | }
|
|---|
| | | public void initMySQL8(String server_ip, int port, int conncount_max) throws PropertyVetoException
|
|---|
| | | {
|
|---|
| | | mSqlPort = port;
|
|---|
| | | mysql_ds.setDriverClass("com.mysql.cj.jdbc.Driver");
|
|---|
| | | mysql_ds.setJdbcUrl("jdbc:mysql://" + server_ip + ":" + mSqlPort + "?useSSL=false&serverTimezone=UTC");
|
|---|
| | | mysql_ds.setUser("root");
|
|---|
| | | mysql_ds.setPassword("lmx8688139");
|
|---|
| | | //mysql_ds.setPassword("Dongli&12345678"); //清远电信数据库密码修改
|
|---|
| | | mysql_ds.setMaxPoolSize(conncount_max);
|
|---|
| | | mysql_ds.setMinPoolSize(2);
|
|---|
| | | mysql_ds.setIdleConnectionTestPeriod(60);
|
|---|
| | | }
|
|---|
| | | public Connection getConn()
|
|---|
| | | {
|
|---|
| | | Connection con = null;
|
|---|
