Create database for MySql : MySQL : Database SQL JDBC : Java examples (example source code) Organized by topic

Java
C++
PHP
Java Home »  Database SQL JDBC   » [  MySQL  ]  Screenshots 
 



Create database for MySql

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) {
        }
      }
    }
  }

}

           
       
Related examples in the same category
1.  Use Oracle DataSource To Store MySql ConnectionHas Download File
2.  Create Database for MySQL
3.  Test MySQL JDBC Driver Installation
4.  Create table for mysql database
5.  Setup mysql datasource
6.  Access MySQL Database: open connection, create table, insert and retrieve
7.  Count rows in MySQL
8.  Demo ResultSet for MySQL
9.  Create Table With All Data Types In MySQL
10.  Insert text file into MySQL
11.  Read a Clob object from MySQL
12.  How to serialize/de-serialize a Java object to the MySQL database.
13.  Check JDBC Installation for MySQL
14.  Demo MySql Transaction
























Home| Contact Us
Copyright 2003 - 04 Demo Source and Support. All rights reserved.
All other trademarks are property of their respective owners.