SpringBoot 通过 SSH 通道连接远程 MySQL 数据库

、添加 Maven 依赖

1. <dependency>
2. <groupId>com.jcraft</groupId>
3. <artifactId>jsch</artifactId>
4. <version>0.1.55</version>
5. </dependency>

2、创建 SSH 连接工具类

1. import com.jcraft.jsch.JSch;
2. import com.jcraft.jsch.Session;
4. public class SshConnection {
6. //跳板机
7. String username = "username";
8. String password = "password";
9. String host = "host";
10. int port = 22;
12. //本地端口
13. int local_port = 3307;
14. String remote_host = "192.168.5.56";
15. int remote_port = 3306;
16. Session session;
18. /**
19. * 建立SSH连接
20. */
21. public void init() {
22. try {
23. JSch jsch = new JSch();
24. session = jsch.getSession(username, host, port);
25. session.setPassword(password);
26. session.setConfig("StrictHostKeyChecking", "no");
27. session.connect();
28. session.setPortForwardingL(local_port, remote_host, remote_port);
29. } catch (Exception e) {
30. e.printStackTrace();
31. }
32. }
34. /**
35. * 断开SSH连接
36. */
37. public void destroy() {
38. this.session.disconnect();
39. }
40. }

3、管理 SSH 连接

1. import org.springframework.stereotype.Component;
3. import javax.servlet.ServletContextEvent;
4. import javax.servlet.ServletContextListener;
5. import javax.servlet.annotation.WebListener;
7. @WebListener
8. @Component
9. public class SshContextListener implements ServletContextListener {
10. private SshConnection sshConnection;
12. @Override
13. public void contextInitialized(ServletContextEvent arg0) {
14. System.out.println("==========>Context initialized...");
15. try {
16. sshConnection = new SshConnection();
17. sshConnection.init();
18. } catch (Exception e) {
19. e.printStackTrace();
20. }
21. }
23. @Override
24. public void contextDestroyed(ServletContextEvent arg0) {
25. System.out.println("==========>Context destroyed...");
26. try {
27. sshConnection.destroy();
28. } catch (Exception e) {
29. e.printStackTrace();
30. }
31. }
32. }

4、配置 application.properties

1. spring.datasource.url=jdbc:mysql://127.0.0.1:3307/test?characterEncoding=utf8
2. spring.datasource.username=root
3. spring.datasource.password=root
4. spring.datasource.driver-class-name=com.mysql.jdbc.Driver

注意：

数据库连接地址由 192.168.5.56:3306 改为 127.0.0.1:3307 ，SSH 连接会把 127.0.0.1:3307 上的操作转发到 192.168.5.56:3306