/** @param args */ private static void registerStudents() throws Exception { Scanner keyboard = new Scanner(System.in); Class.forName("com.mysql.jdbc.Driver"); Properties config = DBUtil.getConfigProperties(); Connection conn = DBUtil.connectToDatabase(config, "cloudcoder.db"); List<Course> courses = DBUtil.getAllModelObjects( conn, Course.SCHEMA, new IFactory<Course>() { @Override public Course create() { return new Course(); } }); Course c = ConfigurationUtil.choose( keyboard, "For which course would you like to register students?", courses); // TODO: look up the term for each course String filename = ConfigurationUtil.ask( keyboard, "Enter the name of the file containing a tab-separated list student registration entries in this format: \n" + "username\tfirstname\tlastname\temail\tpassword\tsection\n" + "Usernames in the datbase will be re-used, but the names/email/password will not be updated," + "and users will not be registered for a course if they are already registered"); int num = ConfigurationUtil.registerStudentsForCourseId( new FileInputStream(filename), c.getId(), conn); System.out.println("Registered " + num + " students for " + c.getName()); }