package conn;

import java.sql.Connection;
import java.sql.Date;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.Statement;
import java.text.SimpleDateFormat;


public class DBConnection {
	private static Connection conn = null;
	public static Connection getConn(){		
		
//		String driver = "com.mysql.jdbc.Driver";
//        String url ="jdbc:mysql://localhost:3306";
        try {
        	conn = DriverManager.getConnection("proxool.proxoolPool");
            
        }catch(Exception e){
              e.printStackTrace();
        } 
		
		return conn;
	}
	public static void closeConn(){
		Statement stmt = null;
		PreparedStatement pstmt = null;
		ResultSet rs = null;
		if(rs != null){
			try{
				rs.close();
			}catch(Exception e){
				e.printStackTrace();
			}
		}
		if(stmt != null){
			try{
				stmt.close();
			}catch(Exception e){
				e.printStackTrace();
			}
		}
		if(pstmt != null){
			try{
				pstmt.close();
			}catch(Exception e){
				e.printStackTrace();
			}
		}
		if(conn != null){
			try{
				conn.close();
			}catch(Exception e){
				e.printStackTrace();
			}
		}
	}
	
	public static Date stringToDate(String date){
		SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd"); 
		Date dat = null;
		try {
			dat  = new Date(sdf.parse(date).getTime());
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return dat;
	}
}