Luninariel

ArrayLists Main

Nov 27th, 2018
177
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.49 KB | None | 0 0
  1. package edu.missouriwestern.cpozo.csc254.sqlwork;
  2.  
  3. import java.sql.*;
  4. import java.util.ArrayList;
  5. import java.util.Collections;
  6. import java.util.Scanner;
  7.  
  8. public class App {
  9. private static String server = "turing.cs.missouriwestern.edu";
  10. private static String database = "schedule2";
  11. private static String user = "csc254";
  12.  
  13. public static void main(String[] args) {
  14. String password;
  15. String Instructor;
  16. System.out.println("Please enter the password: ");
  17. Scanner input = new Scanner(System.in);
  18. password = input.nextLine();
  19. //Section[] classes = new Section[100];
  20. ArrayList<Section> list = new ArrayList<>();
  21. System.out.println("Which Teacher are you searching for?");
  22. Scanner teacher = new Scanner(System.in);
  23. Instructor = teacher.nextLine();
  24.  
  25. try {
  26. String connectionString = String.format("jdbc:mysql://%s/%s?user=%s&password=%s", server, database, user, password);
  27. Connection conn = DriverManager.getConnection(connectionString);
  28. String queryString = String.format("SELECT * FROM sections WHERE instructor LIKE '%s' LIMIT 100", wildCheck(Instructor));
  29.  
  30. Statement st = conn.createStatement();
  31. ResultSet rs = st.executeQuery(queryString);
  32.  
  33. while (rs.next()) {
  34. String discipline = rs.getString("discipline");
  35. String number = rs.getString("courseNumber");
  36. String crn = rs.getString("crn");
  37. String title = rs.getString("title");
  38. String instructor = rs.getString("Instructor");
  39. int maxenrollment = rs.getInt("maximumEnrollment");
  40. int seatsavailable = rs.getInt("seatsAvailable");
  41. Section course = new Section(crn, discipline, number, title, instructor, maxenrollment, seatsavailable);
  42. SectionList.add(course);
  43.  
  44.  
  45. }
  46.  
  47. //selectionSort(classes, n);
  48. Collections.sort(list);
  49.  
  50. print(list);
  51.  
  52. } catch (SQLException e) {
  53. e.printStackTrace();
  54. }
  55. }
  56.  
  57. public static String wildCheck(String Instructor) {
  58. String wildInstructor;
  59. if (Instructor.contains("%") == false) {
  60. wildInstructor = Instructor.concat("%");
  61. return wildInstructor;
  62. } else
  63. return Instructor;
  64. }
  65.  
  66. public static <E> void print(ArrayList<E> list) {
  67. System.out.println(list.size() + " items ----------------------------");
  68. for (E e : list) {
  69. System.out.println(e);
  70. }
  71.  
  72. /*
  73. public static void print(Section[] classes, int n) {
  74. if (classes != null) {
  75. for (int i = 0; i < n; i++) {
  76. System.out.println(classes[i]);
  77. }
  78. } else
  79. System.out.println("No Classes found");
  80. }*/
  81. /* public static void selectionSort(Section[] classes, int n) {
  82. for (int i = 0; i < n-1; i++) {
  83. Section currentMin = classes[i];
  84. int currentMinIndex = i;
  85.  
  86. for (int j = i + 1; j < n; j++) {
  87. if (currentMin.compareTo(classes[j]) > 0) {
  88. currentMin = classes[j];
  89. currentMinIndex = j;
  90. }
  91. }
  92.  
  93. if (currentMinIndex != i) {
  94. classes[currentMinIndex] = classes[i];
  95. classes[i] = currentMin;
  96.  
  97. }
  98. }
  99. }*/
  100. }
  101. }
Add Comment
Please, Sign In to add comment