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

Index.jsp %@ page Ianguage=,,javaM importJjava.sql.*” pageE %@page errorpage =,,error.jsp,,% html head title图书管理系统/title /head body centerxa href二add?jsp添力U 图书信息v/ax/centerxp table align=center width=50% border=l trxth 书名 /thxth 作者 /thxth 价格 /thth 管理 /thx/tr % Class.forName(Hcom .mysql.jdbc. Driver”)； Connect! on con = DriverManager.getConnection(,,jdbc:mysql://localhost:3307/schoor,/,,root,,,,，ylxu); Statement stmt = con.createStatement(); String s = Select * FROM book; ResultSet rs = stmt.executeQuery(s); while(rs.next()) { int id=rs.getlnt⑴； out.println(trtd+rs.getString(2)+/td/tr+rs.getString(3)+/tdx/tr +rs.getString(4)+/tdx/trxa href=edit.jsp?id=+id+ 修 改 v/an bsp;a href=,del.jsp?id=+id+,H 删除 /ax/tdx/tr)； } rs.close)); stmt.close(); con .close(); % /table /body /html Add.jsp %@ page conten tType=,,text/html;charset=gb2312H import=Hjava.sql.*u errorPage=nerror.jspn% html head title添加图书信息/title /head body form action=”add.jsp” method=,,post,, table align Jcenter^widthiWO% border二,T caption 添加图书信息 v/caption tr th width=30%书名:/th td width=70%input name=bookname type=text/td /tr tr vth作者：/th tdvinput name=author type=textx/td /tr tr vth价格：/th tdvinput name=price type=text7t/td /tr tr th colspan=2 input type=submit name=submit value=添力 vin put type=reset value=M3 /th /tr /table /form % request.setCharacterE ncoding(”gb2312“)； Stri ng submit=request.getParameter(,,submit); if(submit!=null!submit.equals(”“)) { Stri ng book name二request.getParameter(“bookname”)； String author=request.getParameter(nauthor); String price=request.getParameter(price,); Class.forName(com.mysql.jdbc. Driver)； Connect! on con = DriverManager.getConnection(jdbc:mysql://localhost:3307/schoor,/,rootzylx)； Statement stmt = con.createStatement(); String sql=i nsert into book(book name,author;price) values(,+bookname+7+author+,,,,+price+)； int i=stmt.executellpdate(sql); if(i==l) { out.println(script language=javaScriptalert(添加成功，单击确定跳转到主页！ );/script)； resp on se.setHeader(refresh/l;url=i ndex.jsp)