import java.sql.*; //import all the JDBC classes

public class JoltItInsert {

	static String[] SQL = {
			"insert into JoltData values ('Gilbert', 'Mon', 1);",
			"insert into JoltData values ('Wally', 'Mon', 2);",
			"insert into JoltData values ('Edgar', 'Tue', 8);",
			"insert into JoltData values ('Wally', 'Tue', 2);",
			"insert into JoltData values ('Eugene', 'Tue', 3);",
			"insert into JoltData values ('Josephine', 'Wed', 2);",
			"insert into JoltData values ('Eugene', 'Thu', 3);",
			"insert into JoltData values ('Gilbert', 'Thu', 1);",
			"insert into JoltData values ('Clarence', 'Fri', 9);",
			"insert into JoltData values ('Edgar', 'Fri', 3);",
			"insert into JoltData values ('Josephine', 'Fri', 4);", };

	public void insert() {
		String dataSource = "jdbc:mysql://localhost/test?"
				+ "user=root&password=root";
		Statement stmt = null;
		Connection con = null;
		try {
			con = DriverManager.getConnection(dataSource);
			stmt = con.createStatement();
		} catch (Exception e) {
			System.err.println("problems connecting to " + dataSource);
		}

		try {
			// execute SQL commands to create table, insert data
			for (int i = 0; i < SQL.length; i++) {
				stmt.execute(SQL[i]);
			}
			con.close();
		} catch (Exception e) {
			System.err.println("problems with SQL sent to " + dataSource + ": "
					+ e.getMessage());
		}

	}
}