图书馆管理系统(6)

mydb.closed(); req.setAttribute(\操作成功\req.setAttribute(\\ String targetURL = \ } public void catelogDel(HttpServletRequest dispatch(targetURL, req, res); req,HttpServletResponse res) { String sql=\id=\ Object[] params={}; DB mydb=new DB(); mydb.doPstm(sql, params); mydb.closed(); req.setAttribute(\操作成功\req.setAttribute(\\ String targetURL = \ } dispatch(targetURL, req, res); - 22 -

public void catelogMana(HttpServletRequest req,HttpServletResponse res) throws ServletException, IOException { List catelogList=new ArrayList(); String sql=\Object[] params={}; DB mydb=new DB(); try { mydb.doPstm(sql, params); ResultSet rs=mydb.getRs(); while(rs.next()) { Tcatelog catelog=new Tcatelog(); catelog.setId(rs.getInt(\catelog.setName(rs.getString(\catelog.setJieshao(rs.getString(\catelogList.add(catelog); } } catch(Exception e) { } e.printStackTrace(); rs.close(); - 23 -

req.getRequestDispatcher(\ mydb.closed(); req.setAttribute(\\ }

5.3 图书管理模块

（1）图书管理界面

管理员登陆系统后，点击左面的菜单“图书管理”，页面调转到图书管理界面，录入图书的基本信息。包括名称、出版社、出版日期、ISBN、库存数量、单价等，点击保存按钮，调用后台的java类BookServet把图书信息保存到数据库。图书管理界面如下图

图5.3 图书管理模块界面

（2）图书管理模块关键代码

- 24 -

String name=req.getParameter(\图书名称 List bookList=new ArrayList(); String sql=\; Object[] params={}; DB mydb=new DB(); try String zuozhe=req.getParameter(\作者 String chubanshe=req.getParameter(\出版社 String chubanriqi=req.getParameter(\出版日期 String isbm=req.getParameter(\书号 String price=req.getParameter(\定价 String yeshu=req.getParameter(\页数 String kucun=req.getParameter(\库存 String catelog_id=req.getParameter(\ String sql=\ Object[] params={name,zuozhe,chubanshe,chubanriqi, isbm,price,yeshu,kucun, catelog_id,\ DB mydb=new DB(); mydb.doPstm(sql, params); mydb.closed(); - 25 -

{ mydb.doPstm(sql, params); ResultSet rs=mydb.getRs(); while(rs.next()) { TBook book=new TBook(); book.setId(rs.getInt(\)); book.setName(rs.getString(\));//书名 book.setZuozhe(rs.getString(\));//作者 book.setChubanshe(rs.getString(\));//出版社 期 book.setIsbm(rs.getString(\)); book.setPrice(rs.getString(\)); book.setYeshu(rs.getString(\));//页数 book.setKucun(rs.getString(\));//库存 book.setCatelog_id(rs.getInt(\)); book.setDel(rs.getString(\));//删除 bookList.add(book); book.setChubanriqi(rs.getString(\));//出版日 } rs.close(); - 26 -