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:
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, 2538🔥, 0💬
Popular Posts:
What Is javax.websocket-api-1.1. jar?javax.websocket-api-1.1. jaris the JAR file for Java API for We...
JDK 11 java.xml.crypto.jmod is the JMOD file for JDK 11 XML (eXtensible Markup Language) Crypto modu...
JDK 11 jdk.jlink.jmod is the JMOD file for JDK 11 JLink tool, which can be invoked by the "jlink" co...
Where to find answers to frequently asked questions on Download and Installing of Older Versions? He...
JDK 11 java.xml.crypto.jmod is the JMOD file for JDK 11 XML (eXtensible Markup Language) Crypto modu...