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

「爱情、让人受尽委屈。」 2021-09-28 00:50 204阅读 0赞

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.springframework.beans.factory.annotation.Autowired;  
import org.springframework.beans.factory.annotation.Qualifier;

import com.enation.app.javashop.framework.database.DaoSupport;  
import com.mysql.fabric.xmlrpc.base.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();  
        \}  
    \}  
\}