Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- package edu.missouriwestern.cpozo.csc254.sqlwork;
- import java.sql.*;
- import java.util.ArrayList;
- import java.util.Collections;
- import java.util.Scanner;
- public class App {
- private static String server = "turing.cs.missouriwestern.edu";
- private static String database = "schedule2";
- private static String user = "csc254";
- public static void main(String[] args) {
- String password;
- String Instructor;
- System.out.println("Please enter the password: ");
- Scanner input = new Scanner(System.in);
- password = input.nextLine();
- //Section[] classes = new Section[100];
- ArrayList<Section> list = new ArrayList<>();
- System.out.println("Which Teacher are you searching for?");
- Scanner teacher = new Scanner(System.in);
- Instructor = teacher.nextLine();
- try {
- String connectionString = String.format("jdbc:mysql://%s/%s?user=%s&password=%s", server, database, user, password);
- Connection conn = DriverManager.getConnection(connectionString);
- String queryString = String.format("SELECT * FROM sections WHERE instructor LIKE '%s' LIMIT 100", wildCheck(Instructor));
- Statement st = conn.createStatement();
- ResultSet rs = st.executeQuery(queryString);
- while (rs.next()) {
- String discipline = rs.getString("discipline");
- String number = rs.getString("courseNumber");
- String crn = rs.getString("crn");
- String title = rs.getString("title");
- String instructor = rs.getString("Instructor");
- int maxenrollment = rs.getInt("maximumEnrollment");
- int seatsavailable = rs.getInt("seatsAvailable");
- Section course = new Section(crn, discipline, number, title, instructor, maxenrollment, seatsavailable);
- SectionList.add(course);
- }
- //selectionSort(classes, n);
- Collections.sort(list);
- print(list);
- } catch (SQLException e) {
- e.printStackTrace();
- }
- }
- public static String wildCheck(String Instructor) {
- String wildInstructor;
- if (Instructor.contains("%") == false) {
- wildInstructor = Instructor.concat("%");
- return wildInstructor;
- } else
- return Instructor;
- }
- public static <E> void print(ArrayList<E> list) {
- System.out.println(list.size() + " items ----------------------------");
- for (E e : list) {
- System.out.println(e);
- }
- /*
- public static void print(Section[] classes, int n) {
- if (classes != null) {
- for (int i = 0; i < n; i++) {
- System.out.println(classes[i]);
- }
- } else
- System.out.println("No Classes found");
- }*/
- /* public static void selectionSort(Section[] classes, int n) {
- for (int i = 0; i < n-1; i++) {
- Section currentMin = classes[i];
- int currentMinIndex = i;
- for (int j = i + 1; j < n; j++) {
- if (currentMin.compareTo(classes[j]) > 0) {
- currentMin = classes[j];
- currentMinIndex = j;
- }
- }
- if (currentMinIndex != i) {
- classes[currentMinIndex] = classes[i];
- classes[i] = currentMin;
- }
- }
- }*/
- }
- }
Add Comment
Please, Sign In to add comment