hi. I am working with dhtmlx Grid component but I can’t get any data from DB.
here are the source files ( it’s almost same to example file of Grid)
[GridConnection.java]
package storyisland.eventSave;
import com.dhtmlx.connector.ConnectorServlet;
import com.dhtmlx.connector.GridConnector;
import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
public class GridConnection extends ConnectorServlet{
private String URL = “jdbc:mysql://localhost:3306/test?zeroDateTimeBehavior=convertToNull&useUnicode=true”;
private String USER = “admin”;
private String PASSWORD = “admin”;
public GridConnector conn;
public Connection connection = null;
@Override
protected void configure() {
// TODO Auto-generated method stub
try
{
Class.forName ("com.mysql.jdbc.Driver").newInstance ();
connection = DriverManager.getConnection(URL,USER,PASSWORD);
}
catch (Throwable e)
{
e.printStackTrace();
}
conn = new GridConnector(connection);
conn.render_table("name", "email", "tel", "name,email,tel");
}
}
[InfoView.jsp]
<%@ page language=“java” contentType=“text/html; charset=EUC-KR”
pageEncoding=“EUC-KR”%>
var mygrid;
function doInitGrid(){
mygrid = new dhtmlXGridObject('mygrid_container');
mygrid.setImagePath("dhtmlxGrid/codebase/imgs/");
mygrid.setHeader("Model,Qty,Price");
mygrid.setInitWidths("*,150,150");
mygrid.setColAlign("left,right,right");
mygrid.setSkin("dhx_web");
mygrid.init();
mygrid.loadXML("GridConnection");
}
</script>
Insert title here
I think the mygrid.loadXML(“GridConnection”); part has a problem. Error message says “the requested resource (/EventSave/GridConnection) is not available.”
how can i do? what should I look into ?
please help me.