Guest User

Untitled

a guest
Jan 22nd, 2019
142
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.06 KB | None | 0 0
  1. <link href="css/jquery-ui-1.8.16.custom.css" rel="stylesheet" type="text/css" />
  2. <link href="css/ui.jqgrid.css" rel="stylesheet" type="text/css" />
  3. <link href="css/style.css" rel="stylesheet" type="text/css" />
  4. <link href="plugins/ui.multiselect.css" rel="stylesheet" type="text/css" />
  5. <script src="js/jquery-1.5.2.min.js" type="text/javascript"></script>
  6. <script src="js/i18n/grid.locale-en.js" type="text/javascript"></script>
  7. <script src="js/jquery-ui-custom.min.js" type="text/javascript"></script>
  8. <script src="plugins/ui.multiselect.js" type="text/javascript"></script>
  9. <script src="js/jquery.jqGrid.min.js" type="text/javascript"></script>
  10. <script src="js/custom.js" type="text/javascript"></script>
  11.  
  12.  
  13.  
  14.  
  15. <script type="text/javascript">
  16. $().ready(function() {
  17. var windowWidth = (document.documentElement.clientWidth - 100) /1.2;
  18.  
  19. jQuery("#gridUsuarios").jqGrid({
  20. url:'getGriddahico.jsp',
  21. datatype: "json",
  22. colNames:['UserID','UserName','Email'],
  23. colModel:[
  24. {name:'id',index:'id_Usuario', editable:true,width:90,align: 'center', hidden:false,closed:true},
  25. {name:'Usuario',index:'nombre_Usuario',editable:true, width:150,align: 'center'},
  26. {name:'Email',index:'email_Usuario',editable:true, width:170,align: 'center'},
  27. ],
  28. rowNum:10,
  29. rowList:[10,20,30],
  30.  
  31. // multiselect: true,
  32. pager: '#pagGrid',
  33. sortname: 'id_Usuario',
  34. viewrecords: true,
  35. sortorder: "asc",
  36. width: windowWidth,
  37. height: "100%",
  38. editurl: 'edit',
  39. //nSelectRow: subGridReferenciasImagenes,
  40. caption:"ExtendedGrid"
  41. });
  42.  
  43. jQuery("#gridUsuarios").jqGrid('navGrid','#pagGrid',{add: true, edit: true, del: true, search: true, refresh: true });
  44.  
  45. });
  46.  
  47. </script>
  48. </head>
  49.  
  50. <body>
  51.  
  52.  
  53. <div id="LogoPanel" style="width:50%; border:0px solid #000;margin-left:10%; margin-top:18%; text-align:center; ">
  54. <table id="gridUsuarios"></table>
  55. <div id="pagGrid"></div>
  56. </div>
  57.  
  58.  
  59. </body>
  60.  
  61. try {
  62. Connection conn = null;
  63. Class.forName("com.mysql.jdbc.Driver");
  64. conn = (Connection) DriverManager.getConnection("jdbc:mysql://localhost:3306/techsoft", "root", "techsoft");
  65. Statement st = null;
  66. st = (Statement) conn.createStatement();
  67.  
  68. String IdUsuario = request.getParameter("id");
  69. String Usuario = request.getParameter("Usuario");
  70. String Email = request.getParameter("Email");
  71.  
  72. System.out.println(IdUsuario);
  73. System.out.println(Usuario);
  74. System.out.println(Email);
  75.  
  76. st.executeUpdate("UPDATE gridjq SET nombre_Usuario='" + Usuario + "', email_Usuario='" + Email + "' WHERE id_Usuarios = '" + IdUsuario + "'");
  77.  
  78.  
  79. System.out.println("hii");
  80.  
  81. } catch (Exception e) {
  82. String msg = e.getMessage();
  83. }
  84. return true;
  85. }
Add Comment
Please, Sign In to add comment