public static List selectBookList(String sql){
List list = new ArrayList();
ResultSet rs = BaseDao.executeQuery(sql);
Book book = null;
try {
while (rs.next()) {
book = new Book();
book.setId(ChangeDao.ISOToGBK(rs.getString("id")));
book.setType(ChangeDao.ISOToGBK(rs.getString("type")));
book.setName(ChangeDao.ISOToGBK(rs.getString("name")));
book.setAuthor(ChangeDao.ISOToGBK(rs.getString("author")));
book.setTranslator(ChangeDao.ISOToGBK(rs
.getString("translator")));
book.setPublisher(ChangeDao.ISOToGBK(rs.getString("publisher")));
book.setPublish_time(rs.getDate("publish_time"));
book.setPrice(rs.getDouble("price"));
book.setStock(rs.getInt("stock"));
list.add(book);
}
} catch (Exception e) {
e.printStackTrace();
}
BaseDao.close();
return list;
}
怎么把list添加到JTable
List list = new ArrayList();
ResultSet rs = BaseDao.executeQuery(sql);
Book book = null;
try {
while (rs.next()) {
book = new Book();
book.setId(ChangeDao.ISOToGBK(rs.getString("id")));
book.setType(ChangeDao.ISOToGBK(rs.getString("type")));
book.setName(ChangeDao.ISOToGBK(rs.getString("name")));
book.setAuthor(ChangeDao.ISOToGBK(rs.getString("author")));
book.setTranslator(ChangeDao.ISOToGBK(rs
.getString("translator")));
book.setPublisher(ChangeDao.ISOToGBK(rs.getString("publisher")));
book.setPublish_time(rs.getDate("publish_time"));
book.setPrice(rs.getDouble("price"));
book.setStock(rs.getInt("stock"));
list.add(book);
}
} catch (Exception e) {
e.printStackTrace();
}
BaseDao.close();
return list;
}
怎么把list添加到JTable
解决方案 »
- 好久没来了,发个java小问题
- 打印出2--1000的完全数
- 下载了 个 绿色版的 editplus 可是打开 html jsp java 文件 都没高亮显示???
- JAVA函数的运行顺序
- PDF自动打印的问题~
- JDBC访问SQLServer出现:java.lang.NullPointerException问题???
- 想做java程序员有没有必要学jsp 来者有分
- 请问jBuilder怎样配置jdbc for oracle?
- 没有 classes12.jar咋办
- 为了消除applet中的闪烁,我用了g.clearColor,可是编译时提示这里有错??
- 求助 ArrayList和JTable问题
- 在家認為swing發展到了盡頭了嗎?
String[] tableHeads = new String[]{"ID","Name","Type","Author","Translator",
"Publisher","Publish_time","Price","Stock"};
DefaultTableModel dtm = (DefaultTableModel)table.getModel();
dtm.setColumnIdentifiers(tableHeads); List<Book> list=new ArrayList<Book>();
list=BookDao.selectBookList("select * from book");
for(int i=0;i<list.size();i++)
{
Object[][]rowData={{list.get(i).getId()},{list.get(i).getName()},
{list.get(i).getType()},{list.get(i).getAuthor()},
{list.get(i).getTranslator()},{list.get(i).getPublisher()},
{list.get(i).getPublish_time()},{list.get(i).getPrice()},
{list.get(i).getStock()}};
dtm.addRow(rowData);
}
这样,结果各行里都是Ljava.lang.Object 类型转换错误,
大师,这是嘛意思?
dtm.addRow(rowData);