Java Web开发技术教程第六章连接数据库实现图书管理系统源代码.docx

Index.jsp 图书管理系统 添加图书信息 书名作者价格管理 % Class.forName(com.mysql.jdbc.Driver); Connection con = DriverManager.getConnection(jdbc:mysql:/localhost:3307/school,root,ylx); Statement stmt = con.createStatement(); String s = Select * FROM book; ResultSet rs = stmt.executeQuery(s); while(rs.next() int id=rs.getInt(1); out.println(+rs.getString(2)+rs.getString(3)+rs.getString(4)+修改 删除); rs.close(); stmt.close(); con.close(); % Add.jsp添加图书信息添加图书信息 书名： 作者： 价格： 元 %request.setCharacterEncoding(gb2312);String submit=request.getParameter(submit);if(submit!=null&!submit.equals() String bookname=request.getParameter(bookname); String author=request.getParameter(author); String price=request.getParameter(price); Class.forName(com.mysql.jdbc.Driver); Connection con = DriverManager.getConnection(jdbc:mysql:/localhost:3307/school,root,ylx); Statement stmt = con.createStatement(); String sql=insert into book(bookname,author,price) values(+bookname+,+author+,+price+); int i=stmt.executeUpdate(sql); if(i=1) out.println(alert(添加成功，单击确定跳转到主页！);); response.setHeader(refresh,1;url=index.jsp); else out.println(alert(添加失败，单击确定返回添加页面！),); response.setHeader(refresh,1;url=add.jsp); stmt.close(); con.close();%Edit.jsp 修改图书信息 修改图书信息 书名： input name=bookname type=text value= 作者： input name=author type=text value= 价格： input name=price type=text value=元 input type=hidden name=id value= Update.jsp 修改完成 % request.setCharacterEncoding(gb2312); String bookname=request.getParameter(bookname); String author=request.getParameter(author); String price=request.getParameter(price); String id=request.getParameter(id); Class.forName(com.mysql.jdbc.Driver); Connection con = DriverManager.getConnection(jdbc:mysql:/localhost:3307/school,root,ylx); Statement stmt = con.createStatement(); String sql=update book set bookname=+bookname+,author=+author+,price=+price+ where id=+id; int i=stmt.executeUpdate(sql); if(i=1) out.println(alert(修改成功，单击确定后自动跳转到主页！);); response.setHeader(refresh,1;url=index.jsp); stmt.close(); con.close(); % Del.jsp 删除图书信息 % request.setCharacterEncoding(gb2312); Class.forName(com.mysql.jdbc.Driver); Connection con = DriverManager.getConnection(jdbc:mysql:/localhost:3307/school,root,ylx); Statement stmt = con.createStatement(); String id=request.getParameter(id); int i=stmt.executeUpdate(delete from book where id=+id); if(i=1) out.println(alert(删除成功，单击确定后自动跳转到主页！);); response.setHeader(refresh,1;url=index.jsp); else out.println(al