麻烦用Extjs 做一个前台，用表格显示数据库数据出来，谢谢

0 0

麻烦用Extjs 做一个前台，用表格显示数据库数据出来，谢谢15

后台已经写好
package bean;
public class Book {
private int id;
private String Code;
private String BookName;
private String BookPrice;
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getCode() {
return Code;
}
public void setCode(String code) {
Code = code;
}
public String getBookName() {
return BookName;
}
public void setBookName(String bookName) {
BookName = bookName;
}
public String getBookPrice() {
return BookPrice;
}
public void setBookPrice(String bookPrice) {
BookPrice = bookPrice;
}

}

package dao;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;

import bean.Book;

public class AllBook {

public static final String URL="jdbc:sqlserver://localhost:1433;DatabaseName=demodb";
public static final String serName="sa";
public static final String Pwd="888888";

protected static Connection conn=null;
protected static PreparedStatement pst=null;
protected static ResultSet rs=null;
public List fillbook(){
//List menuList=new ArrayList();
List<Book> list1=new ArrayList<Book>();
try {
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
Connection con=DriverManager.getConnection(URL,serName,Pwd); //得到连接
Statement st=con.createStatement();

String sql="select * from book"; //查询数据SQL语句s

ResultSet rs=st.executeQuery(sql); //获取结果集

while (rs.next()){
Book book=new Book();
book.setCode(rs.getString("Code"));
book.setBookName(rs.getString("Name"));
book.setBookPrice(rs.getString("Price"));
list1.add(book);
}
con.close(); //关闭连接
}
catch (Exception ex) {
ex.printStackTrace(); //输出出错信息
}
return list1;
}

}

问题补充：效果大概和图片的差不多

2012年11月08日 11:12

chenhua1228
3
0 0 4

查看图片附件

1个答案按时间排序按投票排序

0 0

采纳的答案

var mycolumns=[]
mycolumns.push(Ext.create('Ext.grid.RowNumberer'));// 添加行号列，不需要导入外部插件
mycolumns.push( {
	header : '书号',
	dataIndex : "code",
	flex : 2
});
mycolumns.push( {
	header : '书名',
	dataIndex : "name",
	flex : 2
});
mycolumns.push( {
	header : '价格',
	dataIndex : "price",
	flex : 2
});

var store = Ext.create('Ext.data.Store', {
	fields : [ "code","name","price"],
	autoLoad : true,
	proxy : {
		type : 'ajax',
		//通过web请求获取格式如下的数据，返回是这种格式的字符串就可以
		/*
		[{"name":"name","price":"12","code":"SBN-1111"},
		{"name":"name","price":"12","code":"SBN-1111"},
		{"name":"name","price":"12","code":"SBN-1111"}]
		*/
		url : './getBookData',
		reader : {
			type : 'json'
		}
	}
});
var grid=Ext.create('Ext.grid.Panel',{
	    layout:'anchor',
	    disableSelection: true,
	    title:'书籍信息',
	    columns:mycolumns,
		//这里的reportgrid是你要填充的div的id
	    renderTo:Ext.get('reportgrid'),
	    store:store,
	    width:Ext.getBody().getWidth(),
	    height:Ext.getBody().getHeight()
	    });

2012年11月08日 17:39

剑锋凛冽
244
0 1 27