package testingdb;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

import com.jcraft.jsch.Session;
import com.jcraft.jsch.JSch;
import com.mysql.jdbc.Driver;


public class DatabaseTesting {



public static void main(String[] args) {
    String huser = "user";
    String hpass = "*********";
    String userName = "username_user";
    String password = "*********";
    String host = "<My web server>";
    String url = "jdbc:mysql://<My Web Server>:<port>/";
    Session session= null;
    try {

        java.util.Properties config = new java.util.Properties();
        config.put("StrictHostKeyChecking", "no");

        JSch jsch = new JSch();
        session = jsch.getSession(huser, host, <port>);
        session.setConfig(config);
        session.setPassword(hpass);
        session.connect();
        System.out.println("Connected through SSH");
        session.setPortForwardingL(3306, "127.0.0.1", <port>);


    Class.forName("com.mysql.jdbc.Driver").newInstance();
    System.out.println("Logging into Database: "+ userName);
    Connection con = DriverManager.getConnection(url, userName, password);
    System.out.println("Server connected successfully");
    //Statement st = con.createStatement();
    //ResultSet results = st.executeQuery("SELECT * FROM NPC_DATA");
    //System.out.println(results);

    }
    catch(Exception e) {
        System.out.println("connection failed . . .");
        System.out.println(e.getMessage());
    }
}
}