云服务器中tomcat连接数据库

// 示例代码：使用Apache Commons DBCP连接池
import org.apache.commons.dbcp2.BasicDataSource;

public class DatabaseConnector {
    private static BasicDataSource dataSource;

    static {
        dataSource = new BasicDataSource();
        dataSource.setUrl("jdbc:mysql://your_database_host:3306/your_database_name");
        dataSource.setUsername("your_username");
        dataSource.setPassword("your_password");
        dataSource.setInitialSize(5);
        dataSource.setMaxTotal(20);
    }

    public static Connection getConnection() throws SQLException {
        return dataSource.getConnection();
    }
}

// 示例代码：使用try-with-resources自动关闭连接
try (Connection conn = DatabaseConnector.getConnection();
     PreparedStatement ps = conn.prepareStatement("SELECT * FROM your_table")) {
    ResultSet rs = ps.executeQuery();
    while (rs.next()) {
        // 处理结果集
    }
} catch (SQLException e) {
    e.printStackTrace();
}

-- 示例SQL：授予权限
GRANT ALL PRIVILEGES ON your_database_name.* TO 'your_username'@'your_host';
FLUSH PRIVILEGES;