BooKDTO是字段和get/set方法及构造器省略BookDAO代码如下publicArrayListlist(){Stringsql="select*fromtb_book";ArrayListlist=newArrayList();try{conn...
BooKDTO是字段和get/set方法及构造器省略
BookDAO代码 如下
public ArrayList list() {
String sql = "select * from tb_book";
ArrayList list = new ArrayList();
try {
conn = DBManager.getConn();
st = conn.createStatement();
rs=st.executeQuery(sql);
while(rs.next()){
BookDTO bd=new BookDTO(rs.getInt("book_id"),
rs.getString("book_name"), rs.getString("book_author"), rs.getInt("book_num"),
rs.getString("book_des"), rs.getDate("book_time"));
list.add(bd);
System.out.println(bd.getBookName());
}
} catch (SQLException e) {
e.printStackTrace();
}finally{
DBManager.close(rs, st, conn);
}
return list;
}
如下代码在main方法中(java application 方式运行),可以得到数据,但是复制到servlet(web allpication 方式运行)就报空指针异常(已经配置)
ArrayList arr=new BookDAO().list();
Iterator it=arr.iterator();
while(it.hasNext()){
BookDTO bd=it.next();
System.out.println(bd.getBookName()+" "+bd.getBookAuthor()+" "+bd.getBookDes()+" "+
bd.getBookNum()+" "+bd.getBookTime()+" "+bd.getBookId());
}
展开