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();
}
}
}