java ssh jsch_Java程序使用JSch和JDBC通过SSH连接到MySQL

旧城等待， 2023-02-28 06:08 4阅读 0赞

java ssh jsch

Recently in one of my projects, I had to connect to a remote database that was set up on the SSH-enabled server. Since it was on the SSH-enabled server, we can’t connect it directly using JDBC connection API. To achieve this, we first have to create an SSH session, and then using Port Forwarding we can forward the request to the server and connect to the database.

最近，在我的一个项目中，我不得不连接到在启用SSH的服务器上设置的远程数据库。 由于它位于启用SSH的服务器上，因此我们无法使用JDBC连接API直接将其连接。 为此，我们首先必须创建一个SSH会话，然后使用端口转发将请求转发到服务器并连接到数据库。

I achieved this using [JSch][] Port Forwarding and then connecting to database.

我使用[JSch][]端口转发并连接到数据库来实现此目的。

## 使用JSch连接到远程SSH MySQL数据库的Java程序 **(**Java Program to Connect to Remote SSH MySQL Database using JSch**)** ##

Here is the program I wrote for port forwarding and connecting to a remote database.

这是我编写的用于端口转发和连接到远程数据库的程序。

package com.journaldev.java.ssh
    
    import java.sql.DriverManager;
    import java.sql.PreparedStatement;
    import java.sql.ResultSet;
    import java.sql.SQLException;
    
    import com.jcraft.jsch.JSch;
    import com.jcraft.jsch.Session;
    import java.sql.Connection;
    
    
    public class MySqlConnOverSSH {
    
    	/**
    	 * Java Program to connect to the remote database through SSH using port forwarding
    	 * @author Pankaj@JournalDev
    	 * @throws SQLException 
    	 */
    	public static void main(String[] args) throws SQLException {
    
    		int lport=5656;
    	    String rhost="secure.journaldev.com";
    	    String host="secure.journaldev.com";
    	    int rport=3306;
    	    String user="sshuser";
    	    String password="sshpassword";
    	    String dbuserName = "mysql";
            String dbpassword = "mysql123";
            String url = "jdbc:mysql://localhost:"+lport+"/mydb";
            String driverName="com.mysql.jdbc.Driver";
            Connection conn = null;
            Session session= null;
    	    try{
    	    	//Set StrictHostKeyChecking property to no to avoid UnknownHostKey issue
    	    	java.util.Properties config = new java.util.Properties(); 
    	    	config.put("StrictHostKeyChecking", "no");
    	    	JSch jsch = new JSch();
    	    	session=jsch.getSession(user, host, 22);
    	    	session.setPassword(password);
    	    	session.setConfig(config);
    	    	session.connect();
    	    	System.out.println("Connected");
    	    	int assinged_port=session.setPortForwardingL(lport, rhost, rport);
    	        System.out.println("localhost:"+assinged_port+" -> "+rhost+":"+rport);
    	    	System.out.println("Port Forwarded");
    	    	
    	    	//mysql database connectivity
                Class.forName(driverName).newInstance();
                conn = DriverManager.getConnection (url, dbuserName, dbpassword);
                System.out.println ("Database connection established");
                System.out.println("DONE");
    	    }catch(Exception e){
    	    	e.printStackTrace();
    	    }finally{
    	    	if(conn != null && !conn.isClosed()){
    	    		System.out.println("Closing Database Connection");
    	    		conn.close();
    	    	}
    	    	if(session !=null && session.isConnected()){
    	    		System.out.println("Closing SSH Connection");
    	    		session.disconnect();
    	    	}
    	    }
    	}
    
    }

The output of the above program is:

上面程序的输出是：

Connected
    localhost:5656 -> secure.journaldev.com:3306
    Port Forwarded
    Database connection established
    DONE
    Closing Database Connection
    Closing SSH Connection

Here I am connecting to the MySql database but you can connect to any other database or Enterprise Information Systems using this approach.

在这里，我正在连接到MySql数据库，但是您可以使用此方法连接到任何其他数据库或企业信息系统。

> 翻译自: [https://www.journaldev.com/235/java-mysql-ssh-jsch-jdbc][https_www.journaldev.com_235_java-mysql-ssh-jsch-jdbc]

java ssh jsch

[JSch]: https://www.jcraft.com/jsch/
[https_www.journaldev.com_235_java-mysql-ssh-jsch-jdbc]: https://www.journaldev.com/235/java-mysql-ssh-jsch-jdbc