Hi!!!
HTML---------------------------
<link rel="stylesheet" href="codebase/dhtmlx.css" type="text/css" charset="utf-8">
<meta http-equiv="Content-Type" content="text/xml; charset=iso-8859-1" />
<script type="text/javascript" src="codebase/dhtmlxcommon.js"></script>
<script type="text/javascript" src="codebase/dhtmlxgrid.js"></script>
<script type="text/javascript" src="codebase/dhtmlxgridcell.js"></script>
<script type="text/javascript" src="codebase/dhtmlx.js" charset="utf-8"></script>
<script type="text/javascript" src="codebase/dhtmlxdataprocessor.js" charset="utf-8"></script>
<script src="codebase/dhtmlxdataprocessor_debug.js" type="text/javascript"></script>
<script type="text/javascript" src="codebase/connector.js" charset="utf-8"></script>
.
.
.
<div id="gridbox" style="width:700px; height:270px; background-color:white;overflow:hidden"></div>
<div id="box2" style="width:350px; height:100px; background-color:white;"></div>
<script type="text/javascript">
var mygrid = new dhtmlXGridObject('gridbox');
mygrid.setHeader("ID,NAME");
mygrid.setColumnIds("ID,NAME");
mygrid.setInitWidths("50,*);
mygrid.setColAlign("center,center);
mygrid.setColTypes("ro,ed);
mygrid.setColSorting("int,str);
mygrid.enableMultiselect(false);
mygrid.setSkin("dhx_blue");
mygrid.init();
mygrid.load("data.jsp");
var mydp = new dataProcessor ("data.jsp");
mydp.setTransactionMode("POST");
mydp.setUpdateMode("off");
mydp.enableDataNames(true);
mydp.init(mygrid);
.
.
.
<input type="button" name="some_name" value="update" onclick="mydp.sendData()">
JSP
[code]
<link rel="STYLESHEET" type="text/css" href="codebase/dhtmlxgrid.css"/>
<link rel="stylesheet" type="text/css" href="codebase/skins/dhtmlxgrid_dhx_blue.css"/>
<%@ page import = “java.sql.*” %>
<%
response.setContentType(“text/xml”);
out.println("<?xml version=\"1.0\" encoding=\"UTF-8\"?>");
String posStart = "";
if (request.getParameter("posStart") != null){
posStart = request.getParameter("posStart");
}else{
posStart = "0";
}
String count = "";
if (request.getParameter("count") != null){
count = request.getParameter("count");
}else{
count = "100";
}
Connection connection = null;
Statement statement = null;
ResultSet rs = null;
Class.forName ("oracle.jdbc.OracleDriver").newInstance ();
connection = DriverManager.getConnection("jdbc:oracle:thin:@00.0.0.000:1521:sid","user","pass");
String sql = "SELECT ID, NAME FROM MY_TABLE";
String totalCount = "";
if (posStart.equals("0")){
String sqlCount = "Select count(*) as cnt from (" + sql + ") tbl";
statement = connection.createStatement();
rs = statement.executeQuery(sqlCount);
rs.next();
totalCount = rs.getString("cnt");
rs.close();
} else {
totalCount = "";
}
if (posStart!="0"){
String update = "update tt_triggers from set nombre='prueba' where nombre = 'NOSE' ";
statement = connection.createStatement();
rs = statement.executeQuery(update);
rs.next();
rs.close();
} else {}
statement = connection.createStatement();
rs = statement.executeQuery(sql);
// output data in XML format
out.println("<rows total_count='" + totalCount + "' pos='" + posStart + "'>");
while (rs.next()) {
out.println("<row id='" + rs.getString("ID") + "'>");
out.println("<cell>");
out.println(rs.getString("ID"));
out.println("</cell>");
out.println("<cell>");
out.println(rs.getString("nombre"));
out.println("</cell>");
out.println("</row>");
}
out.write("</rows>");
rs.close();
%>
[/code]
I’m a beginner and i want use the dhtmlxgrid, i have a page html and a jsp (data), when i run my page html, appears my information from database (oracle) , but if i make some change on the grid this changes aren’t saved on the database , even i put a button for save, and don’t work, if somebody could help me please.