github.com/ismailbayram/bigpicture@v0.0.0-20231225173155-e4b21f5efcff/internal/browser/javaproject/src/main/com/shashi/utility/DBUtil.java (about)

     1  package com.shashi.utility;
     2  
     3  import java.sql.Connection;
     4  import java.sql.DriverManager;
     5  import java.sql.SQLException;
     6  import java.util.ResourceBundle;
     7  
     8  import com.shashi.beans.TrainException;
     9  import com.shashi.constant.ResponseCode;
    10  
    11  public class DBUtil {
    12  	private static Connection con;
    13  
    14  	static {
    15  
    16  		ResourceBundle rb = ResourceBundle.getBundle("application");
    17  
    18  		try {
    19  			Class.forName(rb.getString("driverName"));
    20  		} catch (ClassNotFoundException e) {
    21  			e.printStackTrace();
    22  		}
    23  
    24  		try {
    25  			System.out.println(rb.getString("connectionString"));
    26  			System.out.println(rb.getString("username"));
    27  			System.out.println(rb.getString("password"));
    28  			con = DriverManager.getConnection(rb.getString("connectionString"), rb.getString("username"),
    29  					rb.getString("password"));
    30  			System.out.println("Connection Success!!");
    31  		} catch (SQLException e) {
    32  
    33  			e.printStackTrace();
    34  		}
    35  	}
    36  
    37  	public static Connection getConnection() throws TrainException {
    38  		if (con == null)
    39  			throw new TrainException(ResponseCode.DATABASE_CONNECTION_FAILURE);
    40  		return con;
    41  	}
    42  }