将application.yml文件中的数据库配置信息填进来来并运行即可检测是否正确
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class DatabaseConnectionTest {
public static void main(String[] args) {
String url = "jdbc:mysql://localhost:3306/数据库名";
String username = "root";
String password = "密码";
try (Connection connection = DriverManager.getConnection(url, username, password);
Statement statement = connection.createStatement()) {
// 简单的查询,例如检索一条记录
String query = "SELECT * FROM 表名 LIMIT 1";
ResultSet resultSet = statement.executeQuery(query);
// 输出结果
while (resultSet.next()) {
// 处理查询结果
// 例如:String result = resultSet.getString("column_name");
}
} catch (SQLException e) {
// 处理数据库连接异常
System.out.println("失败");
e.printStackTrace();
}
}
}