连接数据库实现图书管理系统.docVIP

项目构思 使用JDBC技术连接MySQL数据库，实现对图书管理系统中图书信息的浏览，增加，修改，删除功能。 项目设计 1,安装并配置数据库，创建数据库，创建表及添加数据 2程序设计 1 文件名：index.jsp %@ page language=java import=java.sql.* pageEncoding=gb2312% %@page errorPage=error.jsp% html head title图书管理系统/title /head body centera href=add.jsp添加图书信息/a/centerp table align=center width=70% border=1 trth书名/thth作者/thth价格/thth管理/th/tr % 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(trtd+rs.getString(2)+/tdtd+rs.getString(3)+/tdtd+rs.getString(4)+/tdtda href=edit.jsp?id=+id+修改/anbsp;a href=del.jsp?id=+id+删除/a/td/tr); } rs.close(); stmt.close(); con.close(); % /table /body /html 2文件名：add.jsp %@ page contentType=text/html;charset=UTF-8 import=java.sql.* errorPage=error.jsp% html head title添加图书信息/title /head body form action=add.jsp method=post table align=centerwidth=50% border=1 caption添加图书信息/caption tr th width=30%书名：/th td width=70%input name=bookname type=text/td /tr tr th作者：/th tdinput name=author type=text/td /tr tr th价格：/th tdinput name=price type=text元/td /tr tr th colspan=2 input type=submit name=submit value=添加 input type=reset value=重置 /th /tr /table % request.setCharacterEncoding(UTF-8); 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(+book