Categories:
Audio (13)
Biotech (29)
Bytecode (36)
Database (77)
Framework (7)
Game (7)
General (507)
Graphics (53)
I/O (35)
IDE (2)
JAR Tools (101)
JavaBeans (21)
JDBC (121)
JDK (426)
JSP (20)
Logging (108)
Mail (58)
Messaging (8)
Network (84)
PDF (97)
Report (7)
Scripting (84)
Security (32)
Server (121)
Servlet (26)
SOAP (24)
Testing (54)
Web (15)
XML (309)
Collections:
Other Resources:
MySqlCreateDatabase.java - Connector/J JDBC Create Database
How to create a new database in MySQL using the Connector/J JDBC driver? I want to see a Java program example.
✍: FYIcenter.com
Here is a Java example that shows you how to create a new database in MySQL using the Connector/J JDBC driver:
// Copyright (c) FYIcenter.com import java.sql.DriverManager; import java.sql.Connection; import java.sql.Statement; // Example of sqljdbc JDBC driver to create a new database public class MySqlCreateDatabase { public static void main(String [] args) throws Exception { // Connector/J JDBC connection URL with required elements String url = "jdbc:mysql://localhost?user=root&password=fyicenter&useSSL=false"; Connection con = DriverManager.getConnection(url); System.out.println("JDBC connection URL: "+url); System.out.println(" Connected to: "+con.getCatalog()); Statement st = con.createStatement(); // Create a new database "FyiCenter" and connect to it String db = "FyiCenter"; st.execute("CREATE DATABASE "+db); con.setCatalog(db); System.out.println(" Connected to: "+con.getCatalog()); // Can not drop any database, with the old "st", // since it was created with the old "con", // which has no database selected // st.execute("DROP DATABASE "+db); // Get a new Statement object in "st" // from the new "con", // which has "FyiCenter" database selected st = con.createStatement(); st.execute("DROP DATABASE "+db); con.close(); } }
You can compile and run the above example in a command window as shown below:
fyicenter> javac MySqlCreateDatabase.java fyicenter> java -cp .;mysql-connector-java-5.1.40-bin.j MySqlCreateDatabase JDBC connection URL: jdbc:mysql://localhost?user=root&password=fyicenter&useSSL=false Connected to: Connected to: FyiCenter
Note that:
⇒ MySqlCreateTable.java - Connector/J JDBC Create Table
⇐ MySqlJdbcUrl.java - Connector/J JDBC Connection URL
2016-12-02, 1959🔥, 0💬
Popular Posts:
ZooKeeper is a centralized service for maintaining configuration information, naming, providing dist...
How to download and install Apache XMLBeans-2.6.0.zip? If you want to try the XMLBeans Java library,...
JDK 11 jdk.internal.vm.ci.jmod is the JMOD file for JDK 11 Internal VM CI module. JDK 11 Internal VM...
JSP(tm) Standard Tag Library 1.1 implementation - Jakarta Taglibs hosts the Standard Taglib 1.1, an ...
How to download and install ojdbc6.jar for Oracle 11g R2? ojdbc6.jar for Oracle 11g R2 is a Java 6, ...