Advertisement
Guest User

Untitled

a guest
Feb 19th, 2019
65
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.03 KB | None | 0 0
  1. public class AppController {
  2. private ArrayList<User> users = new ArrayList();
  3. private final DatabaseDAO db = new DatabaseDAO();
  4. User user;
  5. @PostMapping("/applicazioni")
  6. public String saveUser(@ModelAttribute("app") @Valid SApp app, BindingResult result,Model model) {
  7.  
  8. app.setNombre(app.getNombre()+".jsp");
  9.  
  10. if (app.getNombre().equals("permisos.jsp")){
  11. getUsersProperties();
  12. GsonBuilder gsonbuilder = new GsonBuilder();
  13. Gson gson = gsonbuilder.create();
  14. // model.addAttribute("users", null);
  15. model.addAttribute("users", gson.toJson(this.users));
  16. }
  17.  
  18. return "home";
  19. }
  20.  
  21. public void getUsersProperties(){
  22. User user;
  23.  
  24. String sql = "SELECTn" +
  25. " idn" +
  26. " , nombren" +
  27. " , passwordn" +
  28. " , emailn" +
  29. " , usuarios.idroln" +
  30. " , permisos_javan" +
  31. " , permisos_java_avanzadosn" +
  32. " FROMn" +
  33. " usuariosn" +
  34. " , usuarios_rolesn" +
  35. " WHEREn" +
  36. " usuarios.idrol = usuarios_roles.idroln" +
  37. " AND usuarios.activo = 1n"
  38. + " AND ISNULL(permisos_it, '') <> ''n"
  39. + " AND (n"
  40. + " nombre NOT LIKE 'operatore%'n"
  41. + " AND nombre NOT LIKE 'call%'n"
  42. + " AND nombre NOT LIKE 'negozi%'n"
  43. + " )";
  44. try {
  45. PreparedStatement prepare = db.getConnection().prepareStatement(sql);
  46. ResultSet rs = prepare.executeQuery();
  47. if (rs != null){
  48.  
  49.  
  50. while (rs.next()){
  51. user = new User();
  52. user.setId(Integer.parseInt(rs.getString("id")));
  53. user.setIdrol(Integer.parseInt(rs.getString("idrol")));
  54. user.setNombre(rs.getString("nombre"));
  55. user.setPassword(rs.getString("password"));
  56. user.setEmail(rs.getString("email"));
  57. user.setPermisos_java(rs.getString("permisos_java"));
  58. user.setPermisos_java_avanzados(rs.getString("permisos_java_avanzados"));
  59. users.add(user);
  60. }
  61. }
  62. } catch (SQLException ex) {
  63. System.err.println(ex);
  64. }
  65.  
  66. }
  67.  
  68. <script type="text/javascript">
  69. var users = <%=request.getAttribute("users")%>;
  70.  
  71. $(document).ready(function(){
  72.  
  73. $.each(users, function(key, value){
  74. permisos = "";
  75. if (value.permisos_java != null){
  76. permisos = "data-permisos="+value.permisos_java;
  77. }
  78. $tr = $("<tr style='cursor:pointer' data-index='"+key+"' data-id='"+value.id+"' data-nombre='"+value.nombre+"' "+permisos+">");
  79. $td = $("<td align='center'>"+value.id+"</td>");
  80. $_td = $("<td align='center'>"+value.nombre+"</td>");
  81. $tr.append($td).append($_td);
  82. $("#table-permisos tbody").append($tr);
  83. });
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement