JDBC Tutorial

When you use MySQL JDBC driver to connect to MySQL database server. You may encounter bellow error messages. try { Connection connection = DriverManager.getConnection(“jdbc:mysql://localhost:3306/dev2qa?useSSL=false”,”test”,”666888″); } catch (SQLException ex) { ex.printStackTrace(); System.out.println(“SQL State : ” + ex.getSQLState()); } Below are the error messages. INFO: Pre-instantiating singletons in org.springframework.beans.factory.support.DefaultListableBeanFactory@36d64342: defining beans [org.springframework.beans.factory.config.PropertyPlaceholderConfigurer#0,dataSource,userAccountDao]; root of factory hierarchy com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: […]

If you need to switch between different databases using JDBC, you can store different database JDBC connection-related information in a properties file. And then you can load the JDBC properties data in java source code to use them. This example will show you how to do it, and how you can utilize its benefits.

This article will show you how to use java.sql.Statement to execute insert, update, delete and select SQL DML commands with examples.

This article will show you examples of how to use JDBC to connect to a MySQL database server.