java ssh方式连接mysql数据库

    ssh方式连接mysql数据库Jsch这个包里面其实已经帮我们封装好了，关键代码就只有几行.

	
	/**
	 * 数据备份
	 * @param backup
	 * @return
	 */
	public Map
  
    doDataBackup(BackupDTO backup) {
		
		String schedule = backup.getSchedule();
		String config = backup.getConfig();
		BackupConfigDTO cfg = (BackupConfigDTO) JSONObject.toBean(JSONObject.fromObject(config),BackupConfigDTO.class);
		
		String target = cfg.getTarget();
		
		String[] tables = null;
		String database = null;
		String backupSource = backup.getBackupSource();
		if(StringUtils.contains(backupSource, ":")){
			String[] tempArr = backupSource.split(":");
			database = tempArr[0];
			tables = tempArr[1].split(",");
		}else{
			database = backupSource;
			try {
				List
   
     tnames = new ArrayList
    
     ();
				List
     
    
   
  

package com.app.backup;
import java.sql.Connection;
import java.sql.SQLException;
import java.util.List;
import java.util.Map;

import javax.sql.DataSource;

import org.junit.Test;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.jdbc.core.JdbcTemplate;

import com.app.BaseTestCase;
import com.app.backup.service.DatabaseBackupService;
import com.jcraft.jsch.JSchException;

public class DatabaseBackupTest extends BaseTestCase{
	
	@Autowired
	public DatabaseBackupService dbBackupService;

	@Test
	public void getDataSourceTest() throws SQLException{
		DataSource ds = dbBackupService.getDataSource("192.168.12.219","3308", "root", "root", "test");
		List

    对于SSH客户端的配置选项StrictHostKeyChecking有不明确的可以在这里找到答案。