简单的链接数据库访问数据，在本地进行储存

package com.enation.app.javashop.manager.api.wotai;

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

import org.junit.Test;
import org.spring work.beans.factory.annotation.Autowired;
import org.spring work.beans.factory.annotation.Qualifier;

import com.enation.app.javashop. work.data .DaoSupport;
import com.mysql.fabric. rpc. .Member;

public class WoTaiTest {

    @Autowired
    @Qualifier(\"memberDaoSupport\")
    DaoSupport memberDaoSupport;
    
    @Test
    public void test(){
        try {
            
            String url=\"jdbc:mysql://47.104.107.100:3306/jxp_health\";
            String user=\"jxp_health\";
            String password=\"rTfktdpRLT\";
            Connection cn=DriverManager.getConnection(url, user, password);
            Statement st=cn.createStatement();
            String sql=\"select * from es_member where is_on_game=1\";
            ResultSet rs=st.executeQuery(sql);
             while (rs.next()) {
              String name =   System.out.println(\"1:\" + rs.getInt(1));
              String name =    System.out.println(\"2:\" + rs.getString(2));
              String name =     System.out.println(\"3:\" + rs.getString(3));
              String name =    System.out.println(\"4:\" + rs.getString(4));
              String name =    System.out.println(\"5:\" + rs.getString(4));
              String name =     System.out.println(\"6:\" + rs.getString(4));
              Member member = new member();
              member.setName(name);
              `
              `
              `
              memberDaoSupport.insert(member);
               }
             
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
}