public static Collection<User> getUsers()
   {
      List<User> users = new LinkedList<User>();
      try
      {
         String sql = "SELECT user_id,name from user_table";
         PreparedStatement ps = Connect.getConnection().getPreparedStatement(sql);
         ResultSet rs = ps.executeQuery();
         while (rs.next())
            users.add(new User(rs.getInt(1), rs.getString(2)));
      }
      catch (SQLException e)
      {
         e.printStackTrace();
      }

      return users;
   }