Advertisement
lemansky

Untitled

Nov 30th, 2020
578
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 1.02 KB | None | 0 0
  1.  public ArrayList<String> select(String[] columnsArray, String table){
  2.         ArrayList<String> data = new ArrayList<String>();
  3.        
  4.         String columnsString = String.join(", ", columnsArray);
  5.         String sql = "SELECT w.FirstName, w.LastName, w.Title, w.City, w.Country, m.FirstName as RepName FROM Employees w LEFT JOIN Employees m ON m.EmployeeId = w.ReportsTo";
  6.        
  7.         System.out.println(sql);
  8.         try{
  9.             stmt = conn.createStatement();
  10.             rs = stmt.executeQuery(sql);
  11.             while(rs.next()){
  12.                 data.add(rs.getString("FirstName") + "---" +
  13.                         rs.getString("LastName") + "---" +
  14.                         rs.getString("Title") + "---" +
  15.                         rs.getString("City") + "---" +
  16.                         rs.getString("Country") + "---" +
  17.                         rs.getString("RepName"));
  18.             }
  19.         } catch (SQLException e) {
  20.             System.out.println(e.getMessage());
  21.         }
  22.         return data;
  23.     }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement