Categories:
Audio (13)
Biotech (29)
Bytecode (36)
Database (77)
Framework (7)
Game (7)
General (507)
Graphics (53)
I/O (35)
IDE (2)
JAR Tools (102)
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 (322)
Collections:
Other Resources:
MySqlJdbcUrl.java - Connector/J JDBC Connection URL
How to use port number and database name in the connection URL string for MySQL database 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 specify
port number, database name, and instance name
in the connection URL string for MySQL database using the Connector/J JDBC driver:
// Copyright (c) FYIcenter.com import java.sql.DriverManager; import java.sql.Connection; // Example of Connector/J JDBC connection URL for MySQL server public class MySqlJdbcUrl { 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()); con.close(); // Connector/J JDBC connection URL with port number url = "jdbc:mysql://localhost:3306?user=root&password=fyicenter&useSSL=false"; con = DriverManager.getConnection(url); System.out.println("JDBC connection URL: "+url); System.out.println(" Connected to: "+con.getCatalog()); con.close(); // Connector/J JDBC connection URL with database (catalog) name url = "jdbc:mysql://localhost/mysql?user=root&password=fyicenter&useSSL=false"; con = DriverManager.getConnection(url); System.out.println("JDBC connection URL: "+url); System.out.println(" Connected to: "+con.getCatalog()); con.close(); } }
You can compile and run the above example in a command window as shown below:
fyicenter> javac MySqlJdbcUrl.java fyicenter> java -cp .;mysql-connector-java-5.1.40-bin.jar MySqlJdbcUrl JDBC connection URL: jdbc:mysql://localhost?user=root&password=fyicenter&useSSL=false Connected to: JDBC connection URL: jdbc:mysql://localhost:3306?user=root&password=fyicenter&useSSL=false Connected to: JDBC connection URL: jdbc:mysql://localhost/mysql?user=root&password=fyicenter&useSSL=false Connected to: mysql
Note that MySQL server does not provide a default database. You need to specify the database name as the path name in the connection URL.
⇒ MySqlCreateDatabase.java - Connector/J JDBC Create Database
⇐ MySqlJdbcConnection.java - Connector/J JDBC Connection
2016-12-02, ∼2875🔥, 0💬
Popular Posts:
HttpComponents Core Source Code Files are provided in the source package file, httpcomponents-core-5...
Rhino JavaScript Java Library is an open-source implementation of JavaScript written entirely in Jav...
What Is log4j-1.2.13.jar? I got the JAR file from logging-log4j-1.2.13.zip .log4j-1.2.13.jar is the ...
Java Cryptography Extension 1.2.2 JAR File Size and Download Location: File name: jce.jar, jce-1.2.2...
MXP1 is a stable XmlPull parsing engine that is based on ideas from XPP and in particular XPP2 but c...