public User(Integer userID) throws Exception { this.Connect(); Connection c = this.getConn(); ResultSet resultset; PreparedStatement preparedset = null; String sqlOption = "SELECT * FROM users WHERE id=? LIMIT 1"; preparedset = c.prepareStatement(sqlOption); preparedset.setInt(1, userID); resultset = preparedset.executeQuery(); if (resultset.next()) { this.setLogin(resultset.getString("login")); this.setRole(resultset.getInt("role_id")); this.setUserID(resultset.getInt("id")); } }
void profedit(String cid) throws Exception { try { Connection conn = DBConnection.ConnectDB(); while (true) { // System.out.println(cid); // list all exercises in this course PreparedStatement stmt0 = conn.prepareStatement("SELECT eid, hwname FROM exercise WHERE cid = ?"); stmt0.setString(1, cid); ResultSet rs0 = stmt0.executeQuery(); int i = 1; String[] profselect = new String[20]; int[] alleid = new int[20]; while (rs0.next()) { String hwname = rs0.getString("hwname"); alleid[i] = rs0.getInt("eid"); profselect[i] = hwname; // professor's selection is stored System.out.printf(" %d. %s\n", i, hwname); i++; } System.out.println(" 0. Back"); Scanner scan = new Scanner(System.in); int Choice = -1; // get user choice of which Exercise System.out.println("Please enter the corresponding number:"); while (true) { Choice = scan.nextInt(); if (checkint(Choice, 0, i - 1)) break; } if (Choice == 0) { System.out.print('\u000C'); break; // go back } else { // display chosen Exercise System.out.print('\u000C'); String chosename = profselect[Choice]; System.out.println("You chose to update " + chosename); int eid = alleid[Choice]; PreparedStatement stmt1 = conn.prepareStatement("SELECT * FROM Exercise WHERE eid=?"); stmt1.setInt(1, eid); ResultSet rs1 = stmt1.executeQuery(); rs1.next(); String startdate = rs1.getString("startdate"); String enddate = rs1.getString("enddate"); int newallowattempt = rs1.getInt("allowattempt"); int newscorescheme = rs1.getInt("scorescheme"); int newnumofquestion = rs1.getInt("numofquestion"); int newcorrectpoint = rs1.getInt("correctpoint"); int newincorrectpoint = rs1.getInt("incorrectpoint"); int newbasedon = rs1.getInt("basedon"); while (true) { // display options the professor can modify System.out.println( "Choose what to update:\n 1. Start date\n 2. End date\n 3. Number of attempts\n " + "4. Score selection\n 5. Question numbers\n 6. Correct answer points\n 7. Incorrect answer points\n 8. Based on\n 0. Back"); Choice = -1; while (true) { Choice = scan.nextInt(); if (checkint(Choice, 0, 8)) break; } /* 1. Start date 2. End date 3. Number of attempts 4. Score selection 5. Question numbers 6. Correct answer points 7. Incorrect answer points 8. Based on */ Scanner scan1 = new Scanner(System.in); if (Choice == 0) { System.out.print('\u000C'); break; } else if (Choice == 1) { System.out.printf( "Origionally Start Date:%s\nPlease enter new Start Date(yyyy-mm-dd):", startdate); while (true) { startdate = scan1.nextLine(); if (checkdate(startdate)) break; } startdate = startdate + " 00:00:00.0"; } else if (Choice == 2) { System.out.printf( "Origionally End Date:%s\nPlease enter new End Date(yyyy-mm-dd):", enddate); while (true) { enddate = scan1.nextLine(); if (checkdate(enddate)) break; } enddate = enddate + " 00:00:00.0"; } else if (Choice == 3) { System.out.printf( "Origionally Number of attempts:%d\nPlease enter new Number of attempts:", newallowattempt); newallowattempt = scan1.nextInt(); } else if (Choice == 4) { String[] sele = new String[5]; sele[1] = "first attempt"; sele[2] = "last attempt"; sele[3] = "average"; sele[4] = "max"; System.out.printf( "Origionally Score selection:%s\nPlease enter new Score selection(1.first attempt 2.last attempt 3.average 4.max):", sele[newscorescheme]); while (true) { newscorescheme = scan.nextInt(); if (checkint(newscorescheme, 1, 4)) { // give professor choice whether to update all the scores of students System.out.println( "Do you want to update all the students' scores? 1. Yes 2. No"); int updatechoice = scan.nextInt(); if (checkint(updatechoice, 1, 2)) { if (updatechoice == 1) { ProfUpdateScore pupdate = new ProfUpdateScore(); pupdate.profupdate(eid, newscorescheme); break; } } break; } } } else if (Choice == 5) { System.out.printf( "Origionally Question numbers:%d\nPlease enter new Question numbers:", newnumofquestion); newnumofquestion = scan1.nextInt(); } else if (Choice == 6) { System.out.printf( "Origionally Correct answer points:%d\nPlease enter new Correct answer points:", newcorrectpoint); newcorrectpoint = scan1.nextInt(); } else if (Choice == 7) { System.out.printf( "Origionally Incorrect answer points:%d\nPlease enter new Incorrect answer points:", newincorrectpoint); newincorrectpoint = scan1.nextInt(); } else if (Choice == 8) { String[] basedt = new String[4]; if (cid.equals("CSC440")) { basedt[1] = "Database Fundamentals"; basedt[2] = "ER Design"; basedt[3] = "Security and Authorization"; System.out.printf( "Origionally Based on: %s\nPlease enter new Base on:\n 1. Database Fundamentals\n 2. ER Design\n 3. Security and Authorization\n", basedt[newbasedon]); } else { basedt[1] = "Binary search trees and Btrees"; basedt[2] = "Hashing"; basedt[3] = "Files and indexing and other topics"; System.out.printf( "Origionally Based on: %s\nPlease enter new Base on:\n 1. Binary search trees and Btrees\n 2.Hashing 3.Files and indexing and other topics\n", basedt[newbasedon]); } while (true) { newbasedon = scan.nextInt(); if (checkint(newbasedon, 1, 3)) break; } } // System.out.println(enddate); String query = "UPDATE Exercise SET startdate = timestamp'" + startdate + "', enddate = timestamp'" + enddate + "'," + " correctpoint = " + newcorrectpoint + ",incorrectpoint = " + newincorrectpoint + ", scorescheme = " + newscorescheme + ", " + "allowattempt = " + newallowattempt + ", numofquestion = " + newnumofquestion + ", basedon = " + newbasedon + " WHERE eid = " + eid + " "; // edit homework Statement stmt3 = conn.createStatement(); // debug // System.out.println("query:"+query); if (stmt3.executeUpdate(query) == 1) { // System.out.print('\u000C'); System.out.println("Update Successful!"); } else { // System.out.print('\u000C'); System.out.println("Update Failure!Please try again."); } } } } conn.close(); } catch (Exception e) { System.out.println("" + e.getMessage()); } }