package creditfair_website_config;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.logging.Logger;

import com.jcraft.jsch.JSch;


public class DbConnection {
	String appid = null;
	String otp = null;
	private final static Logger LOGGER = Logger.getLogger(DbConnection.class.getName());
	
	public DbConnection() throws Exception {
		super();
		// TODO Auto-generated constructor stub

	}

	public String pullOtp()
	{
		try {
			 JSch jsch = new JSch(); 
			Class.forName("com.mysql.jdbc.Driver");

			System.out.println("Driver loaded");


			
			Connection con = DriverManager.getConnection(
					"jdbc:mysql://cfwebbetanew1.cyc1x9kcl7ju.ap-south-1.rds.amazonaws.com:3306/cfwebbeta", "pratik",
					"m77UXldW5zZ_d");
			System.out.println("Connected to prod DB");

			Statement smt = con.createStatement();
			ResultSet rsotp = smt.executeQuery(
					"select otp from otp_manager where mobile_number = 9969800145 Order BY id DESC LIMIT 1");
			while (rsotp.next()) {

				otp = rsotp.getString("otp");
			}
			System.out.println(otp);

		}
		catch (Exception e) {
			e.printStackTrace();
		}

		return otp;
		
	}
	
	
}