(core)jsp without using spring only being implemented Binding to remote data.
test.jsp and test_data.jsp search, sorting, paging, try to implement.
############# /test.jsp ########################
<kendo:grid name='grid' pageable='true' sortable='true' filterable='true' columnMenu='true'>
<kendo:grid-columns>
<kendo:grid-column title='Order ID' field='orderId' />
<kendo:grid-column title='Ship Country' field='shipCountry' />
<kendo:grid-column title='Ship Name' field='shipName' />
<kendo:grid-column title='Ship Address' field='shipAddress' />
</kendo:grid-columns>
<kendo:dataSource pageSize='10' serverPaging='true' serverSorting='true' serverFiltering='true'>
<kendo:dataSource-transport>
<kendo:dataSource-transport-read url='/test_data.jsp' type='POST' contentType='application/json'/>
<kendo:dataSource-transport-parameterMap>
<script>
function parameterMap(options) {
return JSON.stringify(options);
}
</script>
</kendo:dataSource-transport-parameterMap>
</kendo:dataSource-transport>
<kendo:dataSource-schema data='data' total='total'>
<kendo:dataSource-schema-model>
<kendo:dataSource-schema-model-fields>
<kendo:dataSource-schema-model-field name='orderId' type='number' />
<kendo:dataSource-schema-model-field name='shipCountry' type='string' />
<kendo:dataSource-schema-model-field name='shipName' type='string' />
<kendo:dataSource-schema-model-field name='shipAddress' type='string' />
</kendo:dataSource-schema-model-fields>
</kendo:dataSource-schema-model>
</kendo:dataSource-schema>
</kendo:dataSource>
<kendo:grid-pageable />
</kendo:grid>
############# /test_data.jsp ########################
<%@ page contentType='text/html; charset=utf-8' %>
<%
response.setContentType('application/json');
%>
{'orderId':'26','shipCountry':'acanet','shipName':'wdkang','shipAddress':'wdkang'},{'orderId':'27','shipCountry':'acanet1','shipName':'wdkang1','shipAddress':'wdkang1'}
test_data.jsp written as above, but of course "No items to display" coming out.
1. How should receive the parameters test_data.jsp?
2. How would you describe the json data test_data.jsp should I do?
In other words,
header('Content-Type: application/json');$request = json_decode(file_get_contents('php://input'));$result = new DataSourceResult('sqlite:../../sample.db');echo json_encode($result->read('Orders', array('ShipName', 'Freight' => array('type' => 'number') , 'OrderDate', 'OrderID', 'ShipCity'), $request));
Pure jsp, php code above if you want to implement, what should I do?
test.jsp and test_data.jsp search, sorting, paging, try to implement.
############# /test.jsp ########################
<kendo:grid name='grid' pageable='true' sortable='true' filterable='true' columnMenu='true'>
<kendo:grid-columns>
<kendo:grid-column title='Order ID' field='orderId' />
<kendo:grid-column title='Ship Country' field='shipCountry' />
<kendo:grid-column title='Ship Name' field='shipName' />
<kendo:grid-column title='Ship Address' field='shipAddress' />
</kendo:grid-columns>
<kendo:dataSource pageSize='10' serverPaging='true' serverSorting='true' serverFiltering='true'>
<kendo:dataSource-transport>
<kendo:dataSource-transport-read url='/test_data.jsp' type='POST' contentType='application/json'/>
<kendo:dataSource-transport-parameterMap>
<script>
function parameterMap(options) {
return JSON.stringify(options);
}
</script>
</kendo:dataSource-transport-parameterMap>
</kendo:dataSource-transport>
<kendo:dataSource-schema data='data' total='total'>
<kendo:dataSource-schema-model>
<kendo:dataSource-schema-model-fields>
<kendo:dataSource-schema-model-field name='orderId' type='number' />
<kendo:dataSource-schema-model-field name='shipCountry' type='string' />
<kendo:dataSource-schema-model-field name='shipName' type='string' />
<kendo:dataSource-schema-model-field name='shipAddress' type='string' />
</kendo:dataSource-schema-model-fields>
</kendo:dataSource-schema-model>
</kendo:dataSource-schema>
</kendo:dataSource>
<kendo:grid-pageable />
</kendo:grid>
############# /test_data.jsp ########################
<%@ page contentType='text/html; charset=utf-8' %>
<%
response.setContentType('application/json');
%>
{'orderId':'26','shipCountry':'acanet','shipName':'wdkang','shipAddress':'wdkang'},{'orderId':'27','shipCountry':'acanet1','shipName':'wdkang1','shipAddress':'wdkang1'}
test_data.jsp written as above, but of course "No items to display" coming out.
1. How should receive the parameters test_data.jsp?
2. How would you describe the json data test_data.jsp should I do?
In other words,
header('Content-Type: application/json');$request = json_decode(file_get_contents('php://input'));$result = new DataSourceResult('sqlite:../../sample.db');echo json_encode($result->read('Orders', array('ShipName', 'Freight' => array('type' => 'number') , 'OrderDate', 'OrderID', 'ShipCity'), $request));
Pure jsp, php code above if you want to implement, what should I do?