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

《Java-项目开发实例-图书信息管理系统开发文档及源码(共99页).doc》由会员分享，可在线阅读，更多相关《Java-项目开发实例-图书信息管理系统开发文档及源码(共99页).doc（99页珍藏版）》请在淘文阁 - 分享文档赚钱的网站上搜索。

1、精选优质文档-倾情为你奉上图书信息管理系统一、 系统功能概述：根据图书信息管理系统的特点，可以将本系统分为2大功能模块，分别为：基础数据维护、系统数据维护。本系统各个部分及其包括的具体功能模块如下图所示：二、 数据库设计：图书信息表：字段名说明类型长度及备注ISBN国际标准书号Varchar(13)主键typeId图书类型idIntBookname书名Varchar(40)Writer作者Varchar(21)Translater译者Varchar(30)可以为空Publisher出版社Varchar(50)Date出版日期SmalldatetimePrice价格money图书类别表：字段名说

2、明类型长度及备注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证件号码Varc

3、har(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.Resul

4、tSet;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 = "co

5、m.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

6、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

7、 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(co

8、nn=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_li

9、brary'，表 '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

10、=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"

11、;);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 selectBook

12、Category() 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); ca

13、tch (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(

14、) 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) value

15、s('"+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+

16、"'"/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.exe

17、cuteUpdate(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_b

18、ookInfo(ISBN,typeId,bookname,writer,translator,publisher,date,price) values('"+ISBN+"','"+typeId+"','"+bookname+"','"+writer+"','"+translator+"','"+publisher+"','"+date+"',&q

19、uot;+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.exec

20、uteQuery(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(r

21、s.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 selectB

22、ookInfo(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.ge

23、tString("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");

24、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)i

25、nt i=0;tryString sql="update tb_bookInfo set ISBN='"+ISBN+"',typeId='"+typeId+"',bookname='"+bookname+"',writer='"+writer+"',translator='"+translator+"',publisher='"+publisher+"',date=

26、9;"+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 fro

27、m 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 max

28、Num,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+"','"

29、+identityCard+"','"+date+"','"+maxNum+"','"+tel+"',"+keepMoney+",'"+zj+"','"+zy+"','"+bztime+"','"+ISBN+"')"System.out.println(sql);i=Dao.executeUpdat

30、e(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"

31、);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.s

32、etTel(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 (Exceptio

33、n 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 Read

34、er();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");reade

35、r.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 (Excep

36、tion 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 n

37、ame='"+name+"',sex='"+sex+"',age='"+age+"',identityCard='"+identityCard+"',date='"+date+"',maxNum='"+maxNum+"',tel='"+tel+"',keepMoney="+keepMoney+",zj='"+

38、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

39、_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.exe

40、cuteQuery(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.ge

41、tDate(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="inser

42、t into tb_operator(name,sex,age,identityCard,workdate,tel,password,yajin) values('"+name+"','"+sex+"',"+age+",'"+identityCard+"','"+workdate+"','"+tel+"','"+password+"','"+y

43、ajin+"')"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"Resul

44、tSet 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

45、(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);ca

46、tch(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+"'

47、;,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(