需要先导入jar包 jsch-0.1.51.jar
1.测试ssh连接mysql数据库
2.在项目中使用ssh连接mysql数据库
(1)配置properties:
driver=com.mysql.jdbc.Driver
url=jdbc\:mysql\://localhost\:5393/cm?useUnicode\=true&characterEncoding\=utf8
username=root
passwd=123456
lport=5393
rhost=192.16.101.122
rport=5393
sshusername=admin
sshpasswd=pwd12345
sshhost=192.16.101.111
sshport=22
(2)实现util:
package dao;
import java.io.IOException;
import java.io.InputStream;
import java.sql.CallableStatement;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Properties;
import com.jcraft.jsch.JSch;
import com.jcraft.jsch.Session;
import com.util.LogUtil;
public class SshmysqlUt