java连接mysql数据库降序

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

String url = "jdbc:mysql://localhost:3306/database_name";
String user = "username";
String password = "password";
Connection connection = null;
try {
    connection = DriverManager.getConnection(url, user, password);
} catch (SQLException e) {
    e.printStackTrace();
}

Statement statement = null;
try {
    statement = connection.createStatement();
} catch (SQLException e) {
    e.printStackTrace();
}

String query = "SELECT * FROM table_name ORDER BY column_name DESC";
ResultSet resultSet = null;
try {
    resultSet = statement.executeQuery(query);
} catch (SQLException e) {
    e.printStackTrace();
}

try {
    while (resultSet.next()) {
        // 处理每一行数据
        // 例如，可以使用resultSet.getString("column_name")获取某一列的值
    }
} catch (SQLException e) {
    e.printStackTrace();
}

try {
    resultSet.close();
    statement.close();
    connection.close();
} catch (SQLException e) {
    e.printStackTrace();
}