Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <link href="css/jquery-ui-1.8.16.custom.css" rel="stylesheet" type="text/css" />
- <link href="css/ui.jqgrid.css" rel="stylesheet" type="text/css" />
- <link href="css/style.css" rel="stylesheet" type="text/css" />
- <link href="plugins/ui.multiselect.css" rel="stylesheet" type="text/css" />
- <script src="js/jquery-1.5.2.min.js" type="text/javascript"></script>
- <script src="js/i18n/grid.locale-en.js" type="text/javascript"></script>
- <script src="js/jquery-ui-custom.min.js" type="text/javascript"></script>
- <script src="plugins/ui.multiselect.js" type="text/javascript"></script>
- <script src="js/jquery.jqGrid.min.js" type="text/javascript"></script>
- <script src="js/custom.js" type="text/javascript"></script>
- <script type="text/javascript">
- $().ready(function() {
- var windowWidth = (document.documentElement.clientWidth - 100) /1.2;
- jQuery("#gridUsuarios").jqGrid({
- url:'getGriddahico.jsp',
- datatype: "json",
- colNames:['UserID','UserName','Email'],
- colModel:[
- {name:'id',index:'id_Usuario', editable:true,width:90,align: 'center', hidden:false,closed:true},
- {name:'Usuario',index:'nombre_Usuario',editable:true, width:150,align: 'center'},
- {name:'Email',index:'email_Usuario',editable:true, width:170,align: 'center'},
- ],
- rowNum:10,
- rowList:[10,20,30],
- // multiselect: true,
- pager: '#pagGrid',
- sortname: 'id_Usuario',
- viewrecords: true,
- sortorder: "asc",
- width: windowWidth,
- height: "100%",
- editurl: 'edit',
- //nSelectRow: subGridReferenciasImagenes,
- caption:"ExtendedGrid"
- });
- jQuery("#gridUsuarios").jqGrid('navGrid','#pagGrid',{add: true, edit: true, del: true, search: true, refresh: true });
- });
- </script>
- </head>
- <body>
- <div id="LogoPanel" style="width:50%; border:0px solid #000;margin-left:10%; margin-top:18%; text-align:center; ">
- <table id="gridUsuarios"></table>
- <div id="pagGrid"></div>
- </div>
- </body>
- try {
- Connection conn = null;
- Class.forName("com.mysql.jdbc.Driver");
- conn = (Connection) DriverManager.getConnection("jdbc:mysql://localhost:3306/techsoft", "root", "techsoft");
- Statement st = null;
- st = (Statement) conn.createStatement();
- String IdUsuario = request.getParameter("id");
- String Usuario = request.getParameter("Usuario");
- String Email = request.getParameter("Email");
- System.out.println(IdUsuario);
- System.out.println(Usuario);
- System.out.println(Email);
- st.executeUpdate("UPDATE gridjq SET nombre_Usuario='" + Usuario + "', email_Usuario='" + Email + "' WHERE id_Usuarios = '" + IdUsuario + "'");
- System.out.println("hii");
- } catch (Exception e) {
- String msg = e.getMessage();
- }
- return true;
- }
Add Comment
Please, Sign In to add comment