Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public ArrayList<String> select(String[] columnsArray, String table){
- ArrayList<String> data = new ArrayList<String>();
- String columnsString = String.join(", ", columnsArray);
- 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";
- System.out.println(sql);
- try{
- stmt = conn.createStatement();
- rs = stmt.executeQuery(sql);
- while(rs.next()){
- data.add(rs.getString("FirstName") + "---" +
- rs.getString("LastName") + "---" +
- rs.getString("Title") + "---" +
- rs.getString("City") + "---" +
- rs.getString("Country") + "---" +
- rs.getString("RepName"));
- }
- } catch (SQLException e) {
- System.out.println(e.getMessage());
- }
- return data;
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement