在MySQL中添加数据库

2019-11-18 16:06:50

字体：大中小

来源：转载

供稿：网友

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

public class MainClass {
  public static void main(String[] args) {
    Connection connection = null;
    Statement statement = null;
    try {
      Class.forName("org.gjt.mm.MySQL.Driver").newInstance();
      String url = "jdbc:mysql://localhost/mysql";
      connection = DriverManager.getConnection(url, "username", "passWord");
      statement = connection.createStatement();
      String hrappSQL = "CREATE DATABASE hrapp";
      statement.executeUpdate(hrappSQL);
    } catch (Exception e) {
      e.PRintStackTrace();
    } finally {
      if (statement != null) {
        try {
          statement.close();
        } catch (SQLException e) {
        }
      }
      if (connection != null) {
        try {
          connection.close();
        } catch (SQLException e) {
        }
      }
    }
  }

}

（出处：http://www.VeVb.com）

上一篇：测试MySQL驱动的安装

下一篇：执行SQL Batch