PGR_Complaints/dbconnection/DBConnection.java

package in.gov.chennaicorporation.gccoffice.pgr.dbconnection;

import java.sql.Connection;

import java.sql.DriverManager;
import java.sql.SQLException;

import org.springframework.stereotype.Component;

@Component
public class DBConnection {
	
	private static Connection dbcon;
	
	private static final String l_sUrl = "jdbc:oracle:thin:@10.1.0.14:1521:chncorp";
	private static final String user="FAS";
	private static final String password="FAS";


	
	public static Connection getConnection() {
		try {

			
			Connection	pgr_Con = DriverManager.getConnection(l_sUrl,user,password);
			System.out.println("pgr_conn Con :"+ l_sUrl );
			
			dbcon=pgr_Con;
			return pgr_Con;

		} catch (SQLException e) {
			e.printStackTrace();
		}
		return dbcon;
	}

}