从Java关闭MySQL服务器可以通过以下步骤:
import java.sql.*;
String url = "jdbc:mysql://localhost:3306/mydatabase";
String username = "root";
String password = "password";
Connection connection = DriverManager.getConnection(url, username, password);
Statement statement = connection.createStatement();
String sql = "SHUTDOWN";
statement.execute(sql);
statement.close();
connection.close();
完整的Java代码示例:
import java.sql.*;
public class CloseMySQLServer {
public static void main(String[] args) {
String url = "jdbc:mysql://localhost:3306/mydatabase";
String username = "root";
String password = "password";
try {
Connection connection = DriverManager.getConnection(url, username, password);
Statement statement = connection.createStatement();
String sql = "SHUTDOWN";
statement.execute(sql);
statement.close();
connection.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
这样,通过Java代码执行关闭MySQL服务器的SQL语句,即可实现从Java关闭MySQL服务器。
注意:以上代码示例仅适用于MySQL数据库,如果使用其他数据库,需要根据具体数据库的关闭服务器语法进行修改。
领取专属 10元无门槛券
手把手带您无忧上云