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

项目构思
使用JDBC技术连接MySQL数据库，实现对图书管理系统中图书信息旳浏览，增长，修改，删除功能。
项目设计
1,安装并配置数据库，创立数据库，创立表及添加数据
2程序设计
1 文献名：index.jsp
<%@ page language="java" import="java.sql.*" pageEncoding="gb2312"%>
<%@page errorPage="error.jsp"%>

图书管理系统

add.jsp>添加图书信息 Statement stmt = con.createStatement();
String s = "Select * FROM book";
ResultSet rs = stmt.executeQuery(s);
while(rs.next())
{
int id=rs.getInt(1);
out.println("ref='edit.jsp?id="+id+"'>修改 删除or.jsp"%>

添加图书信息

<%
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");
ClassforName("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();
}
%>
t.setCharacterEncoding("UTF-8");
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");
ResultSet rs = stmt.executeQuery("select*from book where id="+id);
rs.next();
%>
>put type="hidden" name="id" value="<%=id%>">

pageEncoding="UTF-8" errorPage="error.jsp"%>

修改完毕

<%
request.setCharacterEncoding("UTF-8");
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();
%>

html>

5文献名：del.jsp
<%@ page contentType="text/html;charset=gb2312" import="java.sql.*" errorPage="error.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('删除成功，单击确定</p><p style='height:0px;padding:0;overflow:hidden'>20、后自动跳转到主页！');");
response.setHeader("refresh","1;url=index.jsp");
}
else{
out.println("alert('删除失败，单击确定后自动跳转到主页！');");
response.setHeader("refresh","1;url=index.jsp");
}
con.close();
stmt.close();
%>

</html>

6文献名：error.jsp
<%@ page language="java" isErrorPage="true" pageEncoding="UTF-8"%>

error page

错误信息为
<%=exception.getMessage()%>
<%=exception.toString()%>

项目运行
1

显示图书信息页面
2
添加图书信息
3
添加图书信息成功页面

4
添加成功返回主页面
5.

修改图书信息页面

6.
修改成功页面
7

删除成功页面
创立旳数据库
数据库表