Win a copy of Learn Spring Security (video course) this week in the Spring forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

JDBC

 
Anubhav Singhal
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi, i got this code from my friend, making it more standardized. Previously i use simple code that is written in try catch block here, but after i got this code i didn't understand the use of if condition here. When the connection parameters are in try catch black then why this code
if(con!=null)
return con;

is used here................Please Help !! Thanks in advance ..

import java.sql.*;

public class ConnectionProvider
{
private static Connection con = null;

public static Connection getConnection() {
if (con != null)
return con;
else {
try {

String driver = "com.mysql.jdbc.Driver";
String url = "jdbc:mysql://localhost:3306/test";
String user = "root";
String password = "password";
Class.forName(driver);
con = DriverManager.getConnection(url, user, password);
} catch (Exception e) {
System.out.println(e); }
return con;
}

}
}
 
Ivan Jozsef Balazs
Rancher
Posts: 972
5
  • Likes 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
The variable "con" is used to store the reference to a Connection. Once it was set, the same value will be returned and not a connection will be built every time.

 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic