02使用java脚本向Pxc集群写入数据

使用java脚本向Pxc集群写入数据

批量写入pxc集群程序

导入mysql驱动包

# 批量插入数据的java脚本

package pxc_demo;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;

import com.mysql.jdbc.Driver;


public class Test {

    public static void main(String[] args) throws Exception {
        // TODO Auto-generated method stub
        DriverManager.registerDriver(new Driver());
        String url="jdbc:mysql://10.11.0.210:3306/chinasoft";
        String username="root";
        String password="root";
        Connection con = DriverManager.getConnection(url, username, password);
        String sql = "INSERT INTO students(name) values(?)";
        PreparedStatement pst = con.prepareStatement(sql);
        while(true) {
            for(int i=1;i<=10;i++) {
                pst.setString(1, "Test");
                pst.execute();
            }
            Thread.sleep(1000);
        }
    }

}