Assignment2.java:44: error: cannot find symbol
        connection = DriverManager.getconnection(URL, username, password);
                                  ^
  symbol:   method getconnection(String,String,String)
  location: class DriverManager
Assignment2.java:50: error: cannot find symbol
        queryString = "SET search_path TO uber";
        ^
  symbol:   variable queryString
  location: class Assignment2
Assignment2.java:51: error: cannot find symbol
        pStatement = connection.prepareStatement(queryString);
        ^
  symbol:   variable pStatement
  location: class Assignment2
Assignment2.java:51: error: cannot find symbol
        pStatement = connection.prepareStatement(queryString);
                                                 ^
  symbol:   variable queryString
  location: class Assignment2
Assignment2.java:52: error: cannot find symbol
        pStatement.execute();
        ^
  symbol:   variable pStatement
  location: class Assignment2
Assignment2.java:88: error: cannot find symbol
          PreparedStatement ps = connection.preparedStatement(UpdateString);
                                           ^
  symbol:   method preparedStatement(String)
  location: variable connection of type Connection
Assignment2.java:92: error: incompatible types: int cannot be converted to boolean
          if (ps.executeUpdate()) {
                              ^
Assignment2.java:121: error: cannot find symbol
          PrepareStatement ps=connection.preparedStatement(QueryString);
          ^
  symbol:   class PrepareStatement
  location: class Assignment2
Assignment2.java:121: error: cannot find symbol
          PrepareStatement ps=connection.preparedStatement(QueryString);
                                        ^
  symbol:   method preparedStatement(String)
  location: variable connection of type Connection
Assignment2.java:124: error: cannot find symbol
          rs=ps.executeQuery();
          ^
  symbol:   variable rs
  location: class Assignment2
Assignment2.java:125: error: cannot find symbol
          while(rs.next()) {
                ^
  symbol:   variable rs
  location: class Assignment2
Assignment2.java:129: error: cannot find symbol
                  r_id=rs.getInt("request_id");
                  ^
  symbol:   variable r_id
  location: class Assignment2
Assignment2.java:129: error: cannot find symbol
                  r_id=rs.getInt("request_id");
                       ^
  symbol:   variable rs
  location: class Assignment2
Assignment2.java:130: error: cannot find symbol
                  time=rs.getTimestamp("timestamp");
                  ^
  symbol:   variable time
  location: class Assignment2
Assignment2.java:130: error: cannot find symbol
                  time=rs.getTimestamp("timestamp");
                       ^
  symbol:   variable rs
  location: class Assignment2
Assignment2.java:131: error: cannot find symbol
                  if (time == null) {
                      ^
  symbol:   variable time
  location: class Assignment2
Assignment2.java:135: error: cannot find symbol
                          PrepareStatement ps = connection.preparedStatement(UpdateString);
                          ^
  symbol:   class PrepareStatement
  location: class Assignment2
Assignment2.java:135: error: cannot find symbol
                          PrepareStatement ps = connection.preparedStatement(UpdateString);
                                                          ^
  symbol:   method preparedStatement(String)
  location: variable connection of type Connection
Assignment2.java:136: error: cannot find symbol
                      ps.setInt(1,r_id);
                                  ^
  symbol:   variable r_id
  location: class Assignment2
Assignment2.java:140: error: cannot find symbol
                   else if(time == when) {
                           ^
  symbol:   variable time
  location: class Assignment2
Assignment2.java:211: error: cannot find symbol
          PreparedStatement ps = connection.preparedStatement(QueryString);
                                                              ^
  symbol:   variable QueryString
  location: class Assignment2
Assignment2.java:216: error: cannot find symbol
          c_ID=ps.executeQuery();
          ^
  symbol:   variable c_ID
  location: class Assignment2
Assignment2.java:218: error: variable Querystring is already defined in method dispatch(PGpoint,PGpoint,Timestamp)
          String Querystring = "(SELECT x.driver_id, x.location, x.datetime " + //Finds most recent available time for all drivers
                 ^
Assignment2.java:235: error: variable ps is already defined in method dispatch(PGpoint,PGpoint,Timestamp)
          PreparedStatement ps = connection.preparedStatement(QueryString);
                            ^
Assignment2.java:235: error: cannot find symbol
          PreparedStatement ps = connection.preparedStatement(QueryString);
                                                              ^
  symbol:   variable QueryString
  location: class Assignment2
Assignment2.java:240: error: cannot find symbol
          d_ID=ps.executeQuery();
          ^
  symbol:   variable d_ID
  location: class Assignment2
Assignment2.java:247: error: cannot find symbol
        url = "jdbc:postgresql://localhost:5432/csc343h-c6fanjia";
        ^
  symbol:   variable url
  location: class Assignment2
Assignment2.java:248: error: cannot find symbol
        A2.connectDB(url, "c6fanjia","");
                     ^
  symbol:   variable url
  location: class Assignment2
28 errors