Java实现对数据库的操作（全文以MySql为例）

1.测试数据库

       DataBaseInfor 为数据库信息，包括ip，账号，密码等

private static void testMySqlLink(DataBaseInfor dataBaseInfor) {
    // 数据库连接信息
    String url = "jdbc:mysql://"+dataBaseInfor.getLinkAddress();
    String user = dataBaseInfor.getUserName();
    String password = dataBaseInfor.getPassword();
    try {
        // 加载数据库驱动
        Class.forName("com.mysql.cj.jdbc.Driver");
        // 建立连接
        Connection connection = DriverManager.getConnection(url, user, password);
        // 测试连接是否成功
        if (!connection.isClosed()) {
            System.out.println("数据库连接成功！");
        }
        // 关闭连接
        connection.close();
    } catch (ClassNotFoundException e) {
        System.out.println("数据库驱动未找到！");
    } catch (SQLException e) {
        System.out.println("数据库连接失败！");
        e.printStackTrace();
    }
}

2.创建数据库

DataBaseInfor 为数据库信息，包括ip，账号，密码等

/**
 * 新建mysql数据库
 */
private static void createMySqlDataBase(DataBaseInfor dataBaseInfor){
    // 数据库URL，用户名和密码
    String url = "jdbc:mysql://"+dataBaseInfor.getLinkAddress()+"/?user="+dataBaseInfor.getUserName()+"&password="+dataBaseInfor.getPassword();
    String dbName = dataBaseInfor.getName();

    try {
        // 加载MySQL JDBC驱动
        Class.forName("com.mysql.cj.jdbc.Driver");

        // 建立连接
        Connection conn = DriverManager.getConnection(url);

        // 创建Statement
        Statement stmt = conn.createStatement();

        // 创建数据库SQL语句
        String createDbSQL = "CREATE DATABASE IF NOT EXISTS " + dbName;

        // 执行SQL语句
        stmt.executeUpdate(createDbSQL);

        System.out.println("Database " + dbName + " is created!");

        // 关闭连接和Statement
        stmt.close();
        conn.close();
    } catch (ClassNotFoundException e) {
        System.out.println("MySQL JDBC Driver not found.");
        System.out.println("Exception: " + e.getMessage());
    } catch (SQLException e) {
        System.out.println("Database connection failed.");
        System.out.println("Exception: " + e.getMessage());
    }
}

3.删除数据库

DataBaseInfor 为数据库信息，包括ip，账号，密码等

private static void  deleteMySqlDataBase(DataBaseInfor dataBaseInfor) {
    String url = "jdbc:mysql://"+dataBaseInfor.getLinkAddress()+"/";
    String dbName = dataBaseInfor.getName();
    String driver = "com.mysql.jdbc.Driver";
    String username = dataBaseInfor.getUserName();
    String password = dataBaseInfor.getPassword();

    try {
        Class.forName(driver);
        Connection connection = DriverManager.getConnection(url, username, password);
        Statement statement = connection.createStatement();

        // 执行DROP DATABASE语句
        statement.executeUpdate("DROP DATABASE " + dbName);

        statement.close();
        connection.close();
        System.out.println("数据库删除成功");
    } catch (ClassNotFoundException e) {
        e.printStackTrace();
        System.out.println("数据库删除失败");
    } catch (SQLException e) {
        e.printStackTrace();
        System.out.println("数据库删除失败");
    }
}