YY757563246 2012-11-08 11:12 采纳率: 0%
浏览 120

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

后台已经写好
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;
}

}

  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥15 NAO机器人的录音程序保存问题
    • ¥15 C#读写EXCEL文件,不同编译
    • ¥15 MapReduce结果输出到HBase,一直连接不上MySQL
    • ¥15 扩散模型sd.webui使用时报错“Nonetype”
    • ¥15 stm32流水灯+呼吸灯+外部中断按键
    • ¥15 将二维数组,按照假设的规定,如0/1/0 == "4",把对应列位置写成一个字符并打印输出该字符
    • ¥15 NX MCD仿真与博途通讯不了啥情况
    • ¥15 win11家庭中文版安装docker遇到Hyper-V启用失败解决办法整理
    • ¥15 gradio的web端页面格式不对的问题
    • ¥15 求大家看看Nonce如何配置