这是页面代码:
Ext.onReady(init);function init(){
var viewport=new Ext.Viewport({
layout:'border',
items:[gridPanel]
})

queryStore.load();

}var queryStore=new Ext.data.Store({
autoDestory:'true',
url:'./query',
reader:new Ext.data.JsonReader({
idProperty:'id',
root:'arr',
fields:[
{name:'id',mapping:'id',type:'string'},
{name:'name',mapping:'name',type:'string'},
{name:'password',mapping:'password',type:'string'}
]
})
})var gridPanel=new Ext.grid.GridPanel({
id:'gridPanel',
region:'center',
title:'用户',
tbar:[
new Ext.Button({
text:'增加',
handler:function(){}
}),
new Ext.Button({
text:'删除',
handler:function(){}
}),
new Ext.Button({
text:'查看',
handler:function(){}
}),
new Ext.Button({
text:'修改',
jandler:function(){}
})
],
store:queryStore,
cm:new Ext.grid.ColumnModel({
defaults:{
dortable:false
},
columns:[
new Ext.grid.Column({
dataIndex:'id',
header:'编号'
}),
new Ext.grid.Column({
dataIndex:'name',
header:'姓名'
}),
new Ext.grid.Column({
dataIndex:'password',
header:'密码'
})
]
})
})
这是servlet代码:
public class Query extends HttpServlet{ protected void service(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
request.setCharacterEncoding("UTF-8");
List list=new ArrayList();
Connection conn=null;
PreparedStatement stmt=null;
ResultSet rs=null;
String sql="select * from T_USER";
try{
Class.forName("oracle.jdbc.driver.OracleDriver");
conn=DriverManager.getConnection("jdbc:oracle:thin:@192.168.0.6:1521:cespdb","scgl","1");
stmt=conn.prepareStatement(sql);
rs=stmt.executeQuery();
while(rs.next()){
User user=new User();
user.setId(rs.getInt(1));
user.setName(rs.getString(2));
user.setPassword(rs.getString(3));
list.add(user);
}
}catch(Exception e){
e.printStackTrace();
}
JSONArray arr=new JSONArray();
arr.put(list);
PrintWriter out=response.getWriter();
out.print(arr.toString());
out.close();
}

}