Java-项目开发实例-图书信息管理系统开发文档及源码(共99页).doc

精选优质文档-倾情为你奉上图书信息管理系统一、 系统功能概述：根据图书信息管理系统的特点，可以将本系统分为2大功能模块，分别为：基础数据维护、系统数据维护。本系统各个部分及其包括的具体功能模块如下图所示：二、 数据库设计：图书信息表：字段名说明类型长度及备注ISBN国际标准书号Varchar(13)主键typeId图书类型idIntBookname书名Varchar(40)Writer作者Varchar(21)Translater译者Varchar(30)可以为空Publisher出版社Varchar(50)Date出版日期SmalldatetimePrice价格money图书类别表：字段名说明类型长度及备注TypeName图书类型Varchar(20)Id自动编号Int主键用户信息表：字段名说明类型长度及备注Id自动编号Int主键Name姓名Varchar(2)Sex性别Varchar(2)Age年龄intIdentitycard证件号码Varchar(2)Workdate办证日期datetimeTel电话号码Varchar(2)Yajin押金IntPassword密码Nvarchar(10)admin管理员Nchar(10)读者信息表：字段名说明类型长度及备注Name姓名Varchar(10)Sex性别Varchar(2)Age年龄intidentityCard证件号码Varchar(30)Date日期SmalldatetimemanNum最大书量IntTel电话号码Varchar(15)keepMoney押金MineyZj证件类型IntZy职业Varchar(50)ISBN国际标准书号Varchar(13)bztime办证时间datetime三、 系统源代码：Com.zhang.dao:Dao.java /数据库的连接与操作类package com.zhang.dao;import java.sql.Connection;import java.sql.Date;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.SQLException;import java.util.ArrayList;import java.util.List;import com.zhang.model.BookInfo;import com.zhang.model.BookType;import com.zhang.model.Operator;import com.zhang.model.Reader;import com.zhang.model.User;public class Dao protected static String dbClassName = "com.microsoft.sqlserver.jdbc.SQLServerDriver"protected static String dbUrl = "jdbc:sqlserver:/localhost:1433;"+ "DatabaseName=db_lib;SelectMethod=Cursor"protected static String dbUser = "sa"protected static String dbPwd = "zhangyong"protected static String second = null;private static Connection conn = null;/创建数据库连接private Dao() try if (conn = null) Class.forName(dbClassName).newInstance();conn = DriverManager.getConnection(dbUrl, dbUser, dbPwd);System.out.println("数据库连接成功！");elsereturn; catch (Exception ee) ee.printStackTrace();/执行查询private static ResultSet executeQuery(String sql) try if(conn=null)new Dao();return conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE).executeQuery(sql); catch (SQLException e) e.printStackTrace();return null; finally /执行更新private static int executeUpdate(String sql) try if(conn=null)new Dao();return conn.createStatement().executeUpdate(sql); catch (SQLException e) System.out.println(e.getMessage();/if(e.getMessage().equals("MicrosoftSQLServer 2000 Driver for JDBCSQLServerDELETE 语句与 COLUMN REFERENCE 约束 'FK_TB_BORRO_REFERENCE_TB_BOOKI' 冲突。该冲突发生于数据库 'db_library'，表 'tb_borrow', column 'bookISBN'。")return -1; finally /关闭数据库public static void close() try conn.close(); catch (SQLException e) e.printStackTrace();finallyconn = null;/* * 管理员登录方法 */public static Operator check(String name, String password) int i = 0;Operator operater=new Operator();String sql = "select * from tb_operator where name='" + name+ "' and password='" + password + "'and admin=1"ResultSet rs = Dao.executeQuery(sql);try while (rs.next() String names = rs.getString(1);operater.setId(rs.getString("id");operater.setName(rs.getString("name");operater.setGrade(rs.getString("admin");operater.setPassword(rs.getString("password");if (names != null) i = 1; catch (Exception e) e.printStackTrace();Dao.close();return operater;/* * 查询类别方法 */查询图书目录public static List selectBookCategory() List list=new ArrayList();String sql = "select * from tb_bookType"ResultSet rs = Dao.executeQuery(sql);try while (rs.next() BookType bookType=new BookType();bookType.setId(rs.getString("id");bookType.setTypeName(rs.getString("typeName");list.add(bookType); catch (Exception e) e.printStackTrace();Dao.close();return list;public static List selectBookCategory(String bookType) List list=new ArrayList();String sql = "select days from tb_bookType where typeName='"+bookType+"'"ResultSet rs = Dao.executeQuery(sql);try while (rs.next() BookType type=new BookType();type.setDays(rs.getString("days");list.add(type); catch (Exception e) e.printStackTrace();Dao.close();return list;/* * 图书类别表相关操作 * */插入图书类型public static int InsertBookType(String bookTypeName)int i=0;tryString sql="insert into tb_bookType(typeName) values('"+bookTypeName+"')"i=Dao.executeUpdate(sql);catch(Exception e)e.printStackTrace();return i;/更新图书类别public static int UpdatebookType(String id,String typeName)int i=0;tryString sql="update tb_bookType set typeName='"+typeName+"' where id='"+id+"'"/System.out.println(sql);i=Dao.executeUpdate(sql);catch(Exception e)e.printStackTrace();Dao.close();return i;/删除图书类别public static int DelbookType(String id)int i=0;tryString sql="delete from tb_bookType where id='"+id+"'"/System.out.println(sql);i=Dao.executeUpdate(sql);catch(Exception e)e.printStackTrace();Dao.close();return i;/* * 图书信息表相关操作 */* * 插入图书信息方法 */插入图书信息public static int Insertbook(String ISBN,String typeId,String bookname,String writer,String translator,String publisher,Date date,Double price)int i=0;tryString sql="insert into tb_bookInfo(ISBN,typeId,bookname,writer,translator,publisher,date,price) values('"+ISBN+"','"+typeId+"','"+bookname+"','"+writer+"','"+translator+"','"+publisher+"','"+date+"',"+price+")"/System.out.println(sql);i=Dao.executeUpdate(sql);catch(Exception e)System.out.println(e.getMessage();Dao.close();return i;/* * 查询图书相关信息 * */public static List selectBookInfo() List list=new ArrayList();String sql = "select * from tb_bookInfo"ResultSet rs = Dao.executeQuery(sql);try while (rs.next() BookInfo bookinfo=new BookInfo();bookinfo.setISBN(rs.getString("ISBN");bookinfo.setTypeid(rs.getString("typeid");bookinfo.setBookname(rs.getString("bookname");bookinfo.setWriter(rs.getString("writer");bookinfo.setTranslator(rs.getString("translator");bookinfo.setPublisher(rs.getString("publisher");bookinfo.setDate(rs.getDate("date");bookinfo.setPrice(rs.getDouble("price");list.add(bookinfo); catch (Exception e) e.printStackTrace();Dao.close();return list;public static List selectBookInfo(String ISBN) List list=new ArrayList();String sql = "select * from tb_bookInfo where ISBN='"+ISBN+"'"ResultSet rs = Dao.executeQuery(sql);try while (rs.next() BookInfo bookinfo=new BookInfo();bookinfo.setISBN(rs.getString("ISBN");bookinfo.setTypeid(rs.getString("typeid");bookinfo.setBookname(rs.getString("bookname");bookinfo.setWriter(rs.getString("writer");bookinfo.setTranslator(rs.getString("translator");bookinfo.setPublisher(rs.getString("publisher");bookinfo.setDate(rs.getDate("date");bookinfo.setPrice(rs.getDouble("price");list.add(bookinfo); catch (Exception e) e.printStackTrace();Dao.close();return list;/* * 修改图书信息方法 */更新图书信息public static int Updatebook(String ISBN,String typeId,String bookname,String writer,String translator,String publisher,Date date,Double price)int i=0;tryString sql="update tb_bookInfo set ISBN='"+ISBN+"',typeId='"+typeId+"',bookname='"+bookname+"',writer='"+writer+"',translator='"+translator+"',publisher='"+publisher+"',date='"+date+"',price="+price+" where ISBN='"+ISBN+"'"/System.out.println(sql);i=Dao.executeUpdate(sql);catch(Exception e)e.printStackTrace();Dao.close();return i;/*/ * 删除图书信息方法/ */public static int Delbook(String ISBN)int i=0;tryString sql="delete from tb_bookInfo where ISBN='"+ISBN+"'"/System.out.println(sql);i=Dao.executeUpdate(sql);catch(Exception e)e.printStackTrace();Dao.close();return i;/* * 对读者信息表执行的相关操作 */增加读者信息public static int InsertReader(String name,String sex,String age,String identityCard,Date date,String maxNum,String tel,Double keepMoney,String zj,String zy,Date bztime,String ISBN)int i=0;tryString sql="insert into tb_reader(name,sex,age,identityCard,date,maxNum,tel,keepMoney,zj,zy,bztime,ISBN) values('"+name+"','"+sex+"','"+age+"','"+identityCard+"','"+date+"','"+maxNum+"','"+tel+"',"+keepMoney+",'"+zj+"','"+zy+"','"+bztime+"','"+ISBN+"')"System.out.println(sql);i=Dao.executeUpdate(sql);catch(Exception e)e.printStackTrace();Dao.close();return i;public static List selectReader() List list=new ArrayList();String sql = "select * from tb_reader"ResultSet rs = Dao.executeQuery(sql);try while (rs.next() Reader reader=new Reader();/reader.setId(rs.getString("id");reader.setName(rs.getString("name");reader.setSex(rs.getString("sex");reader.setAge(rs.getString("age");reader.setIdentityCard(rs.getString("identityCard");reader.setDate(rs.getDate("date");reader.setMaxNum(rs.getString("maxNum");reader.setTel(rs.getString("tel");reader.setKeepMoney(rs.getDouble("keepMoney");reader.setZj(rs.getInt("zj");reader.setZy(rs.getString("zy");reader.setISBN(rs.getString("ISBN");reader.setBztime(rs.getDate("bztime");list.add(reader); catch (Exception e) e.printStackTrace();Dao.close();return list;public static List selectReader(String readerISBN) List list=new ArrayList();String sql = "select * from tb_reader where ISBN='"+readerISBN+"'"ResultSet rs = Dao.executeQuery(sql);try while (rs.next() Reader reader=new Reader();reader.setName(rs.getString("name");reader.setSex(rs.getString("sex");reader.setAge(rs.getString("age");reader.setIdentityCard(rs.getString("identityCard");reader.setDate(rs.getDate("date");reader.setMaxNum(rs.getString("maxNum");reader.setTel(rs.getString("tel");reader.setKeepMoney(rs.getDouble("keepMoney");reader.setZj(rs.getInt("zj");reader.setZy(rs.getString("zy");reader.setISBN(rs.getString("ISBN");reader.setBztime(rs.getDate("bztime");list.add(reader); catch (Exception e) e.printStackTrace();Dao.close();return list;/更新读者信息public static int UpdateReader(String id,String name,String sex,String age,String identityCard,Date date,String maxNum,String tel,Double keepMoney,String zj,String zy,Date bztime,String ISBN)int i=0;tryString sql="update tb_reader set name='"+name+"',sex='"+sex+"',age='"+age+"',identityCard='"+identityCard+"',date='"+date+"',maxNum='"+maxNum+"',tel='"+tel+"',keepMoney="+keepMoney+",zj='"+zj+"',zy='"+zy+"',bztime='"+bztime+"'where ISBN='"+ISBN+"'"i=Dao.executeUpdate(sql);catch(Exception e)e.printStackTrace();Dao.close();return i;/删除读者信息public static int DelReader(String ISBN)int i=0;tryString sql="delete from tb_reader where ISBN='"+ISBN+"'"/System.out.println(sql);i=Dao.executeUpdate(sql);catch(Exception e)e.printStackTrace();Dao.close();return i;/newpublic static List selectbookserch() List list=new ArrayList();String sql = "select * from tb_bookInfo"ResultSet s = Dao.executeQuery(sql);try while (s.next() BookInfo bookinfo=new BookInfo();bookinfo.setISBN(s.getString(1);bookinfo.setTypeid(s.getString(2);bookinfo.setBookname(s.getString(3);bookinfo.setWriter(s.getString(4);bookinfo.setTranslator(s.getString(5);bookinfo.setPublisher(s.getString(6);bookinfo.setDate(s.getDate(7);bookinfo.setPrice(s.getDouble(8);list.add(bookinfo); catch (Exception e) e.printStackTrace();Dao.close();return list;/插入管理员public static int Insertoperator(String name,String sex,int age,String identityCard,Date workdate,String tel,String password,int yajin)int i=0;tryString sql="insert into tb_operator(name,sex,age,identityCard,workdate,tel,password,yajin) values('"+name+"','"+sex+"',"+age+",'"+identityCard+"','"+workdate+"','"+tel+"','"+password+"','"+yajin+"')"System.out.println(sql);i=Dao.executeUpdate(sql);catch(Exception e)e.printStackTrace();Dao.close();return i;public static List selectuser() List list=new ArrayList();String sql = "select id,name,sex,age,yajin,workdate,tel,password from tb_operator where admin=0"ResultSet rs = Dao.executeQuery(sql);try while (rs.next() User user=new User();user.setId(rs.getInt(1);user.setName(rs.getString(2);user.setSex(rs.getString(3);user.setAge(rs.getInt(4);/user.setIdentityCard(rs.getString(5);user.setYajin(rs.getInt(5);user.setWorkdate(rs.getDate(6);user.setTel(rs.getString(7);user.setPassword(rs.getString(8);list.add(user); catch (Exception e) e.printStackTrace();Dao.close();return list;/删除用户public static int Deluser(int id)int i=0;tryString sql="delete from tb_operator where id='"+id+"'"/System.out.println(sql);i=Dao.executeUpdate(sql);catch(Exception e)e.printStackTrace();Dao.close();return i;public static int Updateuser(int id,String name,String sex,int age,String identityCard,Date workdate,String tel,String password)int i=0;tryString sql="update tb_operator set name='"+name+"',sex='"+sex+"',age="+age+",identityCard='"+identityCard+"',workdate='"+workdate+"',tel='"+tel+"',password='"+password+"' where id='"+id+"'"i=Dao.executeUpdate(sql);catch(Exception e)e.printStackTrace();Dao.close();return i;public static int Updatepass(String password,String name)int i=0;tryString sql="update tb_operator set password='"+password+"' where name='"+name+"'"i=Dao.executeUpdate(sql);catch(