import java.sql.*;
import simpledb.remote.SimpleDriver;

public class CreateGradepointTable {
    public static void main(String[] args) {
		Connection conn = null;
		try {
			Driver d = new SimpleDriver();
			conn = d.connect("jdbc:simpledb://localhost", null);
			Statement stmt = conn.createStatement();

			String s = "create table GRADEPOINTS(LetterGrade varchar(2), Points int)";
			stmt.executeUpdate(s);
			System.out.println("Table GRDEPOINTS created.");

			s = "insert into GRADEPOINTS(LetterGrade, Points) values ";
			String[] grades =   {"('A', 40)",
								 "('A-', 37)",
								 "('B+', 33)",
								 "('B', 30)",
								 "('B-', 27)",
								 "('C+', 23)",
								 "('C', 20)",
								 "('C-', 17)",
								 "('D+', 13)",
								 "('D', 10)",
								 "('D-', 7)",
								 "('F', 0)"};


			for (int i=0; i<grades.length; i++)
				stmt.executeUpdate(s + grades[i]);
			System.out.println("GRADEPOINTS records inserted.");
		}
		catch(SQLException e) {
			e.printStackTrace();
		}
		finally {
			try {
				if (conn != null)
					conn.close();
			}
			catch (SQLException e) {
				e.printStackTrace();
			}
		}
	}
}