ext1.1.1 可编辑的grid例子！

tylzhuang

浏览: 55230 次
性别:
来自: 上海

最近访客更多访客>>

wangzemin

xiyf2046

耳东叁石

yanwt

博主相关

博客

微博

相册

留言

关于我

文章分类

社区版块

存档分类

博客分类：

java

EXT json SQL Excel

ext可编辑的例子：

js 代码

/*
* hr
* Copyright(c) 2006-2007, tylzhuang.
*/
var GridUI = function() {
var myPageSize = 20;
// shorthand alias
var fm = Ext.form, Ed = Ext.grid.GridEditor;
// the column model has information about grid columns
// dataIndex maps the column to the specific data field in
// the data store (created below)
var gridForm;
function initForm()
{
gridForm = new Ext.BasicForm(
Ext.get("gridFm"),
{}
);
}
var cm;
function getCm()
{
if(!cm)
{
cm= new Ext.grid.ColumnModel([{
id: 'bh',
header: "编号",
dataIndex: 'bh',
hidden: false
},
{ header: "说明",
dataIndex: 'sm',
width: 300,
hidden: false,
editor: new Ed(new fm.TextField({
allowBlank: false
}))
}
]);
// by default columns are sortable
cm.defaultSortable = true;
}
return cm;
}
// create the Data Store
var ds;
var Plant;
function setupDs()
{
// this could be inline, but we want to define the Plant record
// type so we can add records dynamically
Plant = Ext.data.Record.create([
// the "name" below matches the tag name to read, except "availDate"
// which is mapped to the tag "availability"
{name: 'bh', mapping: 'bh', type: 'string'},
{name: 'sm', mapping: 'sm', type: 'string'}
]);
ds = new Ext.data.Store({
// load using script tags for cross domain, if the data in on the same domain as
// this page, an HttpProxy would be better
proxy: new Ext.data.HttpProxy({
url: myPath + '/editBaseData.do?eventSubmit_doList=doList'
}),
// create reader that reads the Topic records
reader: new Ext.data.JsonReader({
root: 'results',
totalProperty: 'totalCount',
id: 'bh'
}, Plant),
// turn on remote sorting
remoteSort: true
});
ds.setDefaultSort('bh', 'ASC');//排序用的列名和排序方式
ds.baseParams = {tableName : tableName};
// trigger the data store load
ds.load({params:{start:0, limit:myPageSize}});
}
// create the editor grid
var grid;
function buildGrid()
{
grid = new Ext.grid.EditorGrid('editor-grid', {
ds: ds,
cm: getCm(),
//selModel: new Ext.grid.CellSelectionModel(),
selModel: new Ext.grid.RowSelectionModel({singleSelect:false}),
enableColLock:false
});
// render it
grid.render();
grid.loadMask = {msg: '正在加载数据，请等待...'};
var gridFoot = grid.getView().getFooterPanel(true);
// add a paging toolbar to the grid's footer
var paging = new Ext.PagingToolbar(gridFoot, ds, {
pageSize: myPageSize,
displayInfo: true,
displayMsg: '总 {2} 条记录，当前显示 {0} - {1}',
emptyMsg: "没有记录"
});
// add the detailed view button
paging.add('-', {
pressed: true,
enableToggle:true,
text: '增加',
cls: '',
toggleHandler: doAdd
});
// add the detailed view button
paging.add('-', {
pressed: true,
enableToggle:true,
text: '提交',
cls: '',
toggleHandler: doMod
});
// add the detailed view button
paging.add('-', {
pressed: true,
enableToggle:true,
text: '删除',
cls: '',
toggleHandler: doDel
});
}
function getModifiedData(){
var m = ds.modified.slice(0);
//ds.modified = [];//将修改过的记录置为空
for(var i = 0, len = m.length; i < len; i++){
alert(m[i].data['sm']);
}
}
function doAdd(){
var p = new Plant({
bh: '',
sm: ''
});
grid.stopEditing();
//alert(ds.data.length);
ds.insert(0, p);
grid.startEditing(0, 1);
}
function doMod(){
var m = ds.modified.slice(0);
if(m.length > 0)
{
Ext.MessageBox.confirm('提示框', '您确定要进行该操作？' , doMod2);
}
else
{
Ext.MessageBox.alert('提示框', '对不起，您没有增加或修改记录！');
}
}
function doMod2(btn){
//alert(btn);
if(btn == 'yes')
{
var m = ds.getModifiedRecords();
jsonData = "[";
for(var i = 0, len = m.length; i < len; i++) {
jsonData += JSON.stringify(m[i].data) + ",";
}
jsonData = jsonData.substring(0, jsonData.length-1) + "]";
gridForm.url = myPath + '/editBaseData.do?eventSubmit_doEdit=doEdit&tableName=' + tableName;
var options =
{
waitMsg: '正在处理中，请等待...',
waitTitle: '进度条',
reset: false,
success: function(isOk, a) {
Ext.MessageBox.alert('提示框', a.result.msg);
if(isOk){
ds.modified = [];//将修改过的记录置为空，如果不清空，则修改过的数据会一直保留
ds.load({params:{start:0, limit:myPageSize}});
}
},
params:{modData:jsonData},
scope: gridForm
}
gridForm.submit(options);
}
else
{
//Ext.MessageBox.alert('提示框', '您取消了该操作！');
}
}
function doDel(){
var m = grid.getSelections();
if(m.length > 0)
{
Ext.MessageBox.confirm('提示框', '您确定要进行该操作？' , doDel2);
}
else
{
Ext.MessageBox.alert('提示框', '对不起，请选择要删除的记录！');
}
}
function doDel2(btn)
{
if(btn == 'yes')
{
var m = grid.getSelections();
//alert(m.length);
var jsonData = '[' + JSON.stringify(m[0].data);
for(i=1;i<m.length;i++)
{
jsonData = jsonData + ',' + JSON.stringify(m[i].data);
}
jsonData = jsonData + ']' ;
gridForm.url = myPath + '/editBaseData.do?eventSubmit_doDel=doDel&tableName=' + tableName;
var options =
{
waitMsg: '正在处理中，请等待...',
waitTitle: '进度条',
reset: false,
success: function(isOk, a) {
Ext.MessageBox.alert('提示框', a.result.msg);
if(isOk){
ds.load({params:{start:0, limit:myPageSize}});
}
},
params:{delData:jsonData},
scope: gridForm
}
gridForm.submit(options);
}
else
{
//Ext.MessageBox.alert('提示框', '您取消了该操作！');
grid.getSelectionModel().clearSelections();
}
}
return {
init : function() {
initForm();
setupDs();
buildGrid();
},
getDs: function() {
return ds;
}
}
}();
Ext.onReady(GridUI.init, GridUI, true);

java 代码

public ActionForward doEdit(ActionMapping mapping, ActionForm form,
HttpServletRequest request, HttpServletResponse response)
throws Exception {
try {
String tableName = (String) request
.getParameter("tableName");
System.out.println("-----tableName--1----" + tableName);
// 从前台获得组织json格式数据进行传送
String modData = (String) request.getParameter("modData");
if (modData != null) {
System.out.println("-----modData--1----" + modData);
JSONArray jsonArr = new JSONArray(modData);
for (int i = 0; i < jsonArr.length(); i++) {
String bh = jsonArr.getJSONObject(i).getString("bh");
String sm = jsonArr.getJSONObject(i).getString("sm");
// sm = Escape.unescape(sm);
System.out.println("-----bh--2----" + bh);
System.out.println("-----sm--2----" + sm);
if (bh != null && !bh.equals("")) {
System.out.println(" bh == " + bh + " sm == " + sm);
StringBuffer sql = new StringBuffer(" update ").append(
tableName).append(" set sm='").append(sm)
.append("' where bh=").append(bh);
System.out.println("update sql == " + sql);
int iii = BasePeer.executeStatement(sql.toString());
System.out.println("update result == " + iii);
} else {
System.out.println(" bh == " + bh + " sm == " + sm);
StringBuffer sql = new StringBuffer(" insert into ")
.append(tableName).append(" (sm) values ('")
.append(sm).append("')");
System.out.println("insert sql == " + sql);
int iii = BasePeer.executeStatement(sql.toString());
System.out.println("insert result == " + iii);
}
}
}
ResponseUtil.procFormResponse(response, true, "提交编辑成功！");
} catch (Exception ex) {
System.out.println("-----failure------" + ex);
ResponseUtil.procFormResponse(response, false, "提交编辑失败，出现异常："
+ ex.getMessage());
}
return null;
}
public ActionForward doDel(ActionMapping mapping, ActionForm form,
HttpServletRequest request, HttpServletResponse response)
throws Exception {
try {
String tableName = (String) (String) request
.getParameter("tableName");
System.out.println("--doDel---tableName--1----" + tableName);
// 从前台获得组织json格式数据进行传送
String delData = (String) request.getParameter("delData");
if (delData != null) {
delData = Convertor.iso2utf(delData);
System.out.println("-----delData--1----" + delData);
JSONArray jsonArr = new JSONArray(delData);
for (int i = 0; i < jsonArr.length(); i++) {
String bh = jsonArr.getJSONObject(i).getString("bh");
if (bh != null && !bh.equals("")) {
System.out.println(" bh == " + bh);
StringBuffer sql = new StringBuffer(" delete from ")
.append(tableName).append(" where bh=").append(
bh);
System.out.println("delete sql == " + sql);
int iii = BasePeer.executeStatement(sql.toString());
System.out.println("delete result == " + iii);
}
}
}
ResponseUtil.procResponse(response, true, "删除成功！");
} catch (Exception ex) {
System.out.println("-----failure------" + ex);
ResponseUtil.procResponse(response, false, "删除失败，出现异常："
+ ex.getMessage());
}
return null;
}

分享到：

聊天记录 | ext + struts1.2 + torque

2007-09-13 10:41
浏览 4752
评论(4)
论坛回复 / 浏览 (2 / 9047)
分类:Web前端
查看更多

4 楼 stworthy 2008-01-04

建议升级到EXT2.0。

3 楼 sugerboy 2008-01-04

请教楼主，你那JSON.stringify是从json.js中来的吗？我把它link到我的页面，js提示仍然找不到JSON,请教一下这是什么原因

2 楼 zjc-888 2007-11-21

顶

1 楼 cnliuxj 2007-09-13

nice,如果有导出Excel文件功能就完美了，建议LZ再进一步

发表评论

您还没有登录,请您登录后再发表评论

最近访客更多访客>>

博主相关

文章分类

社区版块

存档分类

最新评论

ext1.1.1 可编辑的grid例子！

评论

发表评论

相关推荐

最近访客 更多访客>>

博主相关

文章分类

社区版块

存档分类

最新评论

ext1.1.1 可编辑的grid例子！

评论

发表评论

相关推荐

将torque的数据库连接池由DBCP替换为C3P0

关于适配器模式的介绍以及torque中的实现

使用 jcaptcha 产生图片校验码

如何使用ant

如何使用 apache torque （二）

如何使用 apache torque （一）

ext + struts1.2 + torque

文件上传方法（ext1.1.1）

ext1.1b1的bug太多，建议大家暂时不要使用

最近访客更多访客>>