jdbc+mysql+ssh隧道

package com.woqu.supplier.util.ImportUtil;

import com.jcraft.jsch.JSch;
import com.jcraft.jsch.Session;
import com.woqu.supplier.dto.SelfItemDto;

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


public class JdbcConnect {
    public static final String url = "jdbc:mysql://localhost:33102/table";
    public static final String name = "com.mysql.jdbc.Driver";
    public static final String user = "username";
    public static final String password = "password";

    public static int lport = 33102;//本地端口（随便取）
    public static String rhost = "localhost";//远程MySQL服务器
    public static int rport = 3306;//远程MySQL服务端口

    public static Connection getConnect() {
        connectSession();
        Connection conn = null;
        try {
            Class.forName(name);
            conn = DriverManager.getConnection(url,user, password);
        } catch (Exception e) {
            e.printStackTrace();
        }
        return conn;
    }

    public static void connectSession() {
        String user = "ssh_name";//SSH连接用户名
        String password = "ssh_password#";//SSH连接密码
        String host = "103.121.121.12";//SSH服务器
        int port = 125421;//SSH访问端口
        try {
            JSch jsch = new JSch();
            Session session = jsch.getSession(user, host, port);
            session.setPassword(password);
            session.setConfig("StrictHostKeyChecking", "no");
            session.connect();
            System.out.println(session.getServerVersion());//这里打印SSH服务器版本信息
            int assinged_port = session.setPortForwardingL(lport, rhost, rport);
            System.out.println("localhost:" + assinged_port + " -> " + rhost + ":" + rport);
        } catch (Exception e) {
            e.printStackTrace();
        }
    }

    public static void main(String arg[]) throws Exception{
        Connection conn= getConnect();
        Statement statement = conn.createStatement();//准备执行语句
        ResultSet rs= statement.executeQuery("select * from table where ");
        int i=0;
        int insertNum=0;
        while (rs.next()) {
            SelfItemDto dto=new SelfItemDto();
            int activitycode= rs.getInt("activitycode");
            String activityname=rs.getString("activityname");
            String activityname_en=rs.getString("activityname_en");
            String desc_en=rs.getString("desc_en");
            String desc_cn=rs.getString("desc_cn");
            String adminnote=rs.getString("adminnote");
            int local_pay=rs.getInt("local_pay");
            System.out.println("insert into " + activitycode+"  inserTotal="+insertNum+" total="+i);
        }
    }


}