druid mysql超时

import com.alibaba.druid.pool.DruidDataSource;

public class DruidConfig {
    public DataSource dataSource() {
        DruidDataSource dataSource = new DruidDataSource();
        dataSource.setUrl("jdbc:mysql://localhost:3306/mydb");
        dataSource.setUsername("user");
        dataSource.setPassword("password");
        dataSource.setInitialSize(5);
        dataSource.setMinIdle(5);
        dataSource.setMaxActive(20);
        dataSource.setMaxWait(60000);
        dataSource.setTimeBetweenEvictionRunsMillis(60000);
        dataSource.setMinEvictableIdleTimeMillis(300000);
        dataSource.setValidationQuery("SELECT 1");
        dataSource.setTestWhileIdle(true);
        dataSource.setTestOnBorrow(false);
        dataSource.setTestOnReturn(false);
        return dataSource;
    }
}

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

public class QueryExample {
    public void executeQuery(Connection conn) throws SQLException {
        String sql = "SELECT * FROM mytable WHERE condition = ?";
        try (PreparedStatement ps = conn.prepareStatement(sql)) {
            ps.setString(1, "value");
            ps.setQueryTimeout(30); // 设置查询超时时间为30秒
            try (ResultSet rs = ps.executeQuery()) {
                while (rs.next()) {
                    // 处理结果集
                }
            }
        }
    }
}