《（项目管理）_项目开发实例_图书信息管理系统开发文档及源码》由会员分享，可在线阅读，更多相关《（项目管理）_项目开发实例_图书信息管理系统开发文档及源码（99页珍藏版）》请在金锄头文库上搜索。
1、Java 开发实例 源码图书信息管理系统图书信息管理系统一、 系统功能概述：根据图书信息管理系统的特点，可以将本系统分为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证
3、件号码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.sq
4、l.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 = c
5、om.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 = nu
6、ll;/创建数据库连接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)n
7、ew 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
8、(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 cl
9、ose() 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
10、;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.printStackTr
11、ace();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.setTypeNa
12、me(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
13、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=
