麻烦用Extjs 做一个前台,用表格显示数据库数据出来,谢谢1
后台已经写好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; [img=][/img]
}
}
--------------------编程问答-------------------- 怎没人来看呢 --------------------编程问答--------------------
看看这个行不行
Ext.onReady(function() {
var mycolumns = []
//可以用ExtJS自动生成的序号,或是自己获取的ID号
mycolumns.push( {
header : '书号',
dataIndex : "code",
flex : 2
});
mycolumns.push( {
header : '书名',
dataIndex : "name",
flex : 2
});
mycolumns.push( {
header : '价格',
dataIndex : "price",
flex : 2
});
var bookData = Ext.create('Ext.data.Store', {
fields : [ "code","name","price"],
autoLoad : true,
proxy : {
type : 'ajax',
url : './getData',
reader : {
type : 'json'
}
}
});
var grid = Ext.create('Ext.grid.Panel', {
layout : 'anchor',
disableSelection : true,
title : '书籍信息',
columns : mycolumns,
renderTo : Ext.get('reportgrid'),
store : bookData,
width : Ext.getBody().getWidth(),
height : Ext.getBody().getHeight()
});
});
补充:Java , Web 开发