package com.jcg.spring.mvc.file.download;
import java.io.File;
import java.io.FileWriter;
import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;
import java.util.Properties;
import org.apache.log4j.Logger;
public class GenerateCsvData {
static ResultSet res;
static Statement stmt;
static Connection conn;
private static Logger logger = Logger.getLogger(GenerateCsvData.class);
/**** This Method Is Used To Create A Database Connection Object ****/
public static Connection getDatabaseConnection() {
try {
Class.forName(IConstants.DB_DRIVER);
conn = DriverManager.getConnection(IConstants.DB_URL, IConstants.DB_USERNAME,IConstants.DB_PASSWORD);
//Properties info = new Properties();
//info.setProperty("user", IConstants.DB_USERNAME);
//info.setProperty("password", IConstants.DB_PASSWORD);
//info.setProperty("useSSL", "false");
//info.setProperty("autoReconnect", "true");
//conn = DriverManager.getConnection(IConstants.DB_URL, info);
} catch(Exception exObj) {
logger.error("Exception While Creating The Db Connection Object?= " + exObj);
}
return conn;
}
