The Tutorial want to illustrate a code that explain you to understand JDBC Mysql Connection. The code include a class JdbcMysqlConnectionUrl.

JDBC Mysql Connection Url

     

The Tutorial want to illustrate a code that explain you to understand JDBC Mysql Connection. In this program, the code explain the JDBC url and string connection that helps you in connecting between url and database. For this we have a code that includes a java.sql package, this package enables you a network connectivity between url and database.

Loading a driver is done by  calling a Class.forName ( ) that accept driver class as argument.

 DriverManager.getConnection ( ) - The Driver Manager class call Connection ( ) method, which returns you a connection object. This method is responsible for built a connection between a url and database.

On execution of code, The println show you the value of connection and type of driver used in connecting url and database. In case there is an exception in try block, the catch block caught and handle the exception.

JdbcMysqlConnectionUrl.java

import java.sql.*; public class JdbcMysqlConnectionUrl {   static public final String driver = "com.mysql.jdbc.Driver";   static public final String connection =   "jdbc:mysql://localhost:3306/komal" +   "?user=root&password=root&database=komal";   public static void main(String args[]) {   try {   Class.forName(driver);   Connection con = DriverManager.getConnection(connection);      System.out.println("Jdbc Mysql Connection Url :");   System.out.println(connection);   if (!con.isClosed()) {   con.close();   }   } catch (Exception e) {   e.printStackTrace();   }   } }

Output

JdbcMysqlConnectionString : jdbc:mysql://localhost:3306/komal?user=root&password=root&database=komal

Download code

Related Tags for Jdbc Mysql Connection Url:
sql,  mysql,  c,  url,  class,  ant,  jdbc,  io,  include,  connection,  tutorial,  ria,  ai,  connect,  sqlconnection,  to,  e,  il,  in,  as,  sta,  m,  nt,  tr,  wan,  j,  dbc,  db,  cl,  jdb,  rate,  explain,  tor,  s,  at,  my,  inc,  ha,  ll,  and,  cod,  code,  str,  xp,  want,  tutor,  s,  s,  ri,  th,  cm,  bc,  st,  hat,  pl,  plai,  nd,  ode,  on,  o

More Tutorials from this section

• JDBC, JDBC Tutorial, JDBC Tutorials
• Accessing Databases Using Java and JDBC
• Common SQL Commands
• Delete row and column from table through java code
• JDBC Connectivity Code In Java
• Servlet Example To Delete Mysql Blob Data
• Servlet Example To Delete Mysql Clob Data
• Difference between JDBC 3.0 & JDBC 4.0
• Servlet Example To Display Mysql Blob Data
• Servlet Example To Display Mysql Clob Data
• Display Data from Database in JSP
• Enhanced SQL Exception Handling
• Create table and insert data by sql query
• Features of JDBC 3.0 API
• Features of JDBC 4.0
• Get Column Count using ResultSet in SQL
• GET DATE in JDBC
• Important JDBC Concepts
• JDBC - Java Database Connectivity Tutorial
• Servlet Example To Insert Mysql Clob Data