import com.datastax.driver.core.Cluster;
import com.datastax.driver.core.ResultSet;
import com.datastax.driver.core.Row;
import com.datastax.driver.core.Session;
public class beginning {
public static void main(String[] args){
Cluster cluster;
Session session;
// Connect to the cluster and keyspace "demo"
cluster = Cluster.builder().addContactPoint("127.0.0.1").build();
session = cluster.connect("cass");
//this part is for insertion
for (int i=0;i<1000;i++)
{
session.execute("INSERT INTO cass.users (id,name) Values (" + i + " , 'Username' )");
}
/*
for (int i=0;i<1000;i++)
{
ResultSet results = session.execute("SELECT * from users where id = " + i);
for (Row row : results) {
System.out.format("%s %d\n", row.getString("name"), row.getInt("id"));
}
}
*/
// Insert one record into the users table
// Use select to get the user we just entered
/*
// Update the same user with a new age
//session.execute("update users set age = 36 where lastname = 'Jones'");
// Select and show the change
results = session.execute("select * from users ");
for (Row row : results) {
System.out.format("%s %d\n", row.getString("firstname"), row.getInt("age"));
}
// Delete the user from the users table
//session.execute("DELETE FROM users WHERE lastname = 'Jones'");
// Show that the user is gone
results = session.execute("SELECT * FROM users");
for (Row row : results) {
System.out.format("%s %d %s %s %s\n", row.getString("lastname"), row.getInt("age"), row.getString("city"), row.getString("email"), row.getString("firstname"));
}
*/
// Clean up the connection by closing it
cluster.close();
}
}