java项目开发实例图书信息管理系统开发及源码336.pdf

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

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

2、ney 图书类别表：字段名 说明 类型 长度及备注 TypeName 图书类型 Varchar(20)Id 自动编号 Int 主键 用户信息表：字段名 说明 类型 长度及备注 Id 自动编号 Int 主键 Name 姓名 Varchar(2)Sex 性别 Varchar(2)Age 年龄 int Identitycard 证件号码 Varchar(2)Workdate 办证日期 datetime Tel 电话号码 Varchar(2)Yajin 押金 Int Password 密码 Nvarchar(10)admin 管理员 Nchar(10)读者信息表：字段名 说明 类型 长度及备注 Nam

3、e 姓名 Varchar(10)Sex 性别 Varchar(2)Age 年龄 int identityCard 证件号码 Varchar(30)Date 日期 Smalldatetime manNum 最大书量 Int Tel 电话号码 Varchar(15)keepMoney 押金 Miney Zj 证件类型 Int Zy 职业 Varchar(50)ISBN 国际标准书号 Varchar(13)bztime 办证时间 datetime 三、系统源代码：ewInstance();conn=(dbUrl,dbUser,dbPwd);数据库连接成功！);else return;catch(Ex

4、ception ee)();xecuteQuery(sql);catch(SQLException e)();return null;finally xecuteUpdate(sql);catch(SQLException e)quals(MicrosoftSQLServer 2000 Driver for JDBCSQLServerDELETE 语句与 COLUMN REFERENCE 约束 FK_TB_BORRO_REFERENCE_TB_BOOKI 冲突。该冲突发生于数据库 db_library，表 tb_borrow,column bookISBN。)return-1;finally

5、etLayout(borderLayout);setIconifiable(true);dd(panel);final JLabel label_2=new JLabel();(图书编号：);(label_2);ISBN=new JTextField(请输入13位书号,13);(new MyDocument(13);dd(panel_1,;final FlowLayout flowLayout=new FlowLayout();(2);(30);(flowLayout);buttonadd=new JButton();(new addBookActionListener();(添加);(but

6、tonadd);buttonclose=new JButton();(new CloseActionListener();(关闭);(buttonclose);final JLabel label_5=new JLabel();ImageIcon bookAddIcon=();(bookAddIcon);(new Dimension(400,80);(new LineBorder,1,false);getContentPane().add(label_5,;(新书定购(LOGO图片);setVisible(true);rim().isEmpty()(null,添加书号重复！);return;c

7、lass ISBNkeyListener extends KeyAdapter public void keyPressed(final KeyEvent e)if()=13)();class CloseActionListener implements ActionListener ength()=0)(null,书号文本框不可以为空);return;if().length()!=13)(null,书号文本框输入位数为13位);return;if().length()=0)(null,图书名称文本框不可以为空);return;if().length()=0)(null,作者文本框不可以为空)

8、;return;if().length()=0)(null,出版日期文本框不可以为空);return;if().length()=0)(null,单价文本框不可以为空);return;String ISBNs=().trim();rim();String bookNames=().trim();String writers=().trim();String publishers=(String)().trim();String pubDates=().trim();String prices=().trim();int i=(ISBNs,bookTypes,bookNames,writers,

9、translators,publishers,if(i=1)(null,添加成功);doDefaultCloseAction();class NumberListener extends KeyAdapter public void keyTyped(KeyEvent e)String numStr=09.+(char)8;if()0)();et();resultsi1=booktypename;resultsi2=();resultsi3=();resultsi4=();resultsi5=();resultsi6=();resultsi7=();return results;public

10、BookModiAndDelIFrame()super();final BorderLayout borderLayout=new BorderLayout();getContentPane().setLayout(borderLayout);setIconifiable(true);setClosable(true);setTitle(图书信息修改与删除);setBounds(100,100,640,406);dd(panel_1,;final FlowLayout flowLayout=new FlowLayout();(2);(30);(flowLayout);final JButton

11、 button=new JButton();(new addBookActionListener();(修改);(button);final JButton button_2=new JButton();(new ActionListener()public void actionPerformed(final ActionEvent e)String ISBNs=().trim();int i=(ISBNs);if(i=1)(null,删除成功);Object results=getFileStates();dd(headLogo,;final JPanel panel_2=new JPan

12、el();final BorderLayout borderLayout_1=new BorderLayout();(5);(borderLayout_1);(new EmptyBorder(5,10,5,10);getContentPane().add(panel_2);final JScrollPane scrollPane=new JScrollPane();(scrollPane);Object results=getFileStates();columnNames=new String图书编号,图书类别,图书名称,作者,译者,出版商,出版日期,价格;table=new JTable(

13、results,columnNames);oString().trim();typeids=(selRow,1).toString().trim();bookNames=(selRow,2).toString().trim();writers=(selRow,3).toString().trim();translators=(selRow,4).toString().trim();publishers=(selRow,5).toString().trim();dates=(selRow,6).toString().trim();prices=(selRow,7).toString().trim

14、();(ISBNs);ength()=0)(null,书号文本框不可以为空或则输入数字不可以大于 13 个);return;if().length()!=13)(null,书号文本框输入位数为 13 位);return;if().length()=0)(null,图书名称文本框不可以为空);return;if().length()=0)(null,作者文本框不可以为空);return;if().length()=0)(null,出版人文本框不可以为空);return;ength()=0)(null,出版日期文本框不可以为空);return;if().length()=0)(null,单价文本框

15、不可以为空);return;String ISBNs=().trim();rim();String bookNames=().trim();String writers=().trim();String publishers=().trim();String pubDates=().trim();String prices=().trim();int i=(ISBNs,bookTypes,bookNames,writers,translators,publishers,(pubDates),(prices);if(i=1)(null,修改成功);Object results=getFileSt

16、ates();+(char)8;if()0)();dd(panel,;final JLabel label_4=new JLabel();ImageIcon bookTypeAddIcon=();(bookTypeAddIcon);(new Dimension(360,80);(图书类别图片（400*80）);(label_4);final JPanel panel_3=new JPanel();(new FlowLayout();getContentPane().add(panel_3,;final JLabel label_1=new JLabel();(new Dimension(20,

17、50);(label_1);final JLabel label_2=new JLabel();(new Dimension(90,20);(图书类别名称：);(label_2);bookTypeName=new JTextField();(new MyDocument(20);(30);(bookTypeName);final JButton button=new JButton();(保存);(new ActionListener()public void actionPerformed(final ActionEvent e)if().length()=0)(null,图书类别文本框不可

18、为空);return;int i=().trim();if(i=1)(null,添加成功！);doDefaultCloseAction();else (null,图书类别名已存在，请重新输入！););(button);final JButton buttonDel=new JButton();(关闭);(new ActionListener()public void actionPerformed(final ActionEvent e)doDefaultCloseAction(););(buttonDel);setVisible(true);class NumberListener exte

19、nds KeyAdapter public void keyTyped(KeyEvent e)String numStr=09.+(char)8;if()0)();dd(panel,;final JLabel logoLabel=new JLabel();ImageIcon bookTypeModiAndDelIcon=();(bookTypeModiAndDelIcon);(new Dimension(400,80);(logo);(logoLabel);final JPanel panel_1=new JPanel();getContentPane().add(panel_1);final

20、 JScrollPane scrollPane=new JScrollPane();(new Dimension(400,130);(scrollPane);model=new DefaultTableModel();Object results=getFileStates();(results,columnNames);table=new JTable();(model);(new TableListener();(table);final JPanel panel_2=new JPanel();(panel_2);final GridLayout gridLayout=new GridLa

21、yout(0,6);(5);(5);(gridLayout);(new Dimension(400,26);final JLabel label=new JLabel();(类别编号：);(label);BookTypeId=new JTextField();(false);(BookTypeId);final JLabel label_1=new JLabel();(类别名称：);(label_1);comboBox=new JComboBox();bookTypeModel=(DefaultComboBoxModel)();oString().trim();(selRow,1).toStr

22、ing().trim();class ButtonAddListener implements ActionListener public void actionPerformed(ActionEvent e)Object selectedItem=();int i=().trim(),();if(i=1)(null,修改成功);Object results=getFileStates();(results,columnNames);(model);class ButtonDelListener implements ActionListener public void actionPerfo

23、rmed(ActionEvent e)int i=().trim();if(i=1)(null,删除成功);Object results=getFileStates();(results,columnNames);(model);class CloseActionListener implements ActionListener etLayout(borderLayout);setTitle(图书馆管理系统登录);setBounds(100,100,285,194);final JPanel panel=new JPanel();(new BorderLayout();(new EmptyB

24、order(0,0,0,0);getContentPane().add(panel);final JPanel panel_2=new JPanel();final GridLayout gridLayout=new GridLayout(0,2);(5);(20);(gridLayout);(panel_2);final JLabel label=new JLabel();(new Dimension(0,0);(new Dimension(0,0);(label);(用 户 名：);username=new JTextField(20);(new Dimension(0,0);(usern

25、ame);final JLabel label_1=new JLabel();(label_1);(密 码：);password=new JPasswordField(20);(new MyDocument(6);(*);etSystemLookAndFeelClassName();new LoginIFrame();dd(toolBar,;final JLabel label=new JLabel();(0,0,0,0);(null);etSize();().getSize();(););(label,new Integer);getContentPane().add(DESKTOP_PAN

26、E);/*创建工具栏 *return JToolBar */private JToolBar createToolBar()etLayout(new GridBagLayout();setBounds(100,100,300,228);final JLabel label_4=new JLabel();(new Font(,14);(注：每个操作员只能修改自己的密码。);final GridBagConstraints gridBagConstraints_10=new GridBagConstraints();=;=4;=0;=0;getContentPane().add(label_4,g

27、ridBagConstraints_10);final JLabel label_5=new JLabel();(new Font(,14);(登 录 名：);final GridBagConstraints gridBagConstraints_11=new GridBagConstraints();=2;=0;getContentPane().add(label_5,gridBagConstraints_11);username =new JTextField();final GridBagConstraints gridBagConstraints_12=new GridBagConst

28、raints();=2;=1;=;getContentPane().add(username,gridBagConstraints_12);(false);final JLabel label_1=new JLabel();(new Font(,14);(旧 密 码：);final GridBagConstraints gridBagConstraints_2=new GridBagConstraints();=3;=0;getContentPane().add(label_1,gridBagConstraints_2);oldPass=new JPasswordField();(new My

29、Document(6);final GridBagConstraints gridBagConstraints_3=new GridBagConstraints();=;=new Insets(0,0,0,10);=;=3;=3;=1;getContentPane().add(oldPass,gridBagConstraints_3);final JLabel label_2=new JLabel();(new Font(,14);(新 密 码：);final GridBagConstraints gridBagConstraints_4=new GridBagConstraints();=4

30、;=0;getContentPane().add(label_2,gridBagConstraints_4);newPass1=new JPasswordField();(new MyDocument(6);(new Font(,14);final GridBagConstraints gridBagConstraints_5=new GridBagConstraints();=;=30;=new Insets(0,0,0,10);=;=3;=4;=1;getContentPane().add(newPass1,gridBagConstraints_5);final JLabel label_

31、3=new JLabel();(new Font(,14);(确认新密码：);final GridBagConstraints gridBagConstraints_6=new GridBagConstraints();=5;=0;getContentPane().add(label_3,gridBagConstraints_6);newPass2=new JPasswordField();(new MyDocument(6);(new Font(,14);final GridBagConstraints gridBagConstraints_7=new GridBagConstraints(

32、);=;=30;=new Insets(0,0,0,10);=;=;=3;=5;=1;getContentPane().add(newPass2,gridBagConstraints_7);final JButton button=new JButton();(new ActionListener()public void actionPerformed(final ActionEvent e)if().equals()if().equals()();(),();(null);(null);(null);(getContentPane(),密码修改成功。);doDefaultCloseActi

33、on();else (getContentPane(),两次输入的密码不一致，请重新输入。);else (getContentPane(),旧密码输入错误，请确认密码。););(确认);final GridBagConstraints gridBagConstraints_8=new GridBagConstraints();=;=;=6;=1;getContentPane().add(button,gridBagConstraints_8);final JButton button_1=new JButton();(new ActionListener()public void action

34、Performed(final ActionEvent e)(null);(null);(null););(重写);final GridBagConstraints gridBagConstraints_9=new GridBagConstraints();=2;=;=6;=2;getContentPane().add(button_1,gridBagConstraints_9);setVisible(true);dd(logoLabel,;final JPanel panel=new JPanel();(new FlowLayout();getContentPane().add(panel)

35、;final JPanel panel_1=new JPanel();final GridLayout gridLayout=new GridLayout(0,4);(15);(10);(gridLayout);(new Dimension(450,200);(panel_1);final JLabel label_2=new JLabel();(姓 名：);(label_2);readername=new JTextField();(new MyDocument(10);(readername);final JLabel label_3=new JLabel();(性 别：);(label_

36、3);final JPanel label_13=new JPanel();final FlowLayout flowLayout=new FlowLayout();(0);(0);(flowLayout);(label_13);final JRadioButton radioButton1=new JRadioButton();(radioButton1);(true);(radioButton1);(男);final JRadioButton radioButton2=new JRadioButton();(radioButton2);(radioButton2);(女);final JL

37、abel label_4=new JLabel();(年 龄：);(label_4);age=new JTextField();(new MyDocument(2);ength()2|().length()0)(););(keepmoney);final JLabel label=new JLabel();(办证日期：);(label);bztime=new JFormattedTextField();(new (new DateListener();(bztime);final JLabel label_1=new JLabel();(读者编号：);(label_1);ISBN=new JT

38、extField();(new MyDocument(13);(ISBN);final JPanel panel_2=new JPanel();(new Dimension(450,100);(panel_2);final JButton save=new JButton();(save);(保存);(new ButtonAddListener(radioButton1);final JButton back=new JButton();(back);(返回);(new CloseActionListener();setVisible(true);class DateListener exte

39、nds KeyAdapter public void keyTyped(KeyEvent e)if().isEmpty()(null,时间格式请使用2007-05-10格式);class NumberListener extends KeyAdapter public void keyTyped(KeyEvent e)String numStr=09+(char)8;if()20)(null,职业文本框位数为20);return;if().length()=0)(null,读者条形码文本框不可为空);return;if().length()!=13)(null,读者条形码文本框为13位);re

40、turn;if().length()=0)(null,电话号码文本框不可为空);return;if().length()11|().length()2|().length()0)(null,最大借书量为两位数字);return;if().isEmpty()|().isEmpty()(null,时间格式请使用2007-05-10格式);return;String sex=1;if(!()sex=2;String zj=();int i=().trim(),(),().trim(),().trim(),().trim(),().trim(),().trim(),().trim(),zj,().tr

41、im(),().trim(),().trim();if(i=1)(null,添加成功！);doDefaultCloseAction();class TelListener extends KeyAdapter public void keyTyped(KeyEvent e)String numStr=09-+(char)8;if()0)();class CloseActionListener implements ActionListener quals(1)sex=男;else sex=女;resultsi1=sex;resultsi2=();resultsi3=();resultsi4=(

42、);resultsi5=();resultsi6=();resultsi7=();resultsi8=array();resultsi9=();resultsi10=();resultsi11=();return results;public ReaderModiAndDelIFrame()super();setIconifiable(true);setClosable(true);setTitle(读者信息修改与删除);setBounds(50,0,600,500);final JPanel panel=new JPanel();(new BorderLayout();(new Dimens

43、ion(400,80);getContentPane().add(panel,;final JLabel logoLabel=new JLabel();ImageIcon readerModiAndDelIcon=();(readerModiAndDelIcon);(true);(new Dimension(400,80);(logoLabel);(读者信息修改logo（400*80）);final JPanel panel_1=new JPanel();(new BorderLayout();getContentPane().add(panel_1);final JScrollPane sc

44、rollPane=new JScrollPane();(new Dimension(0,100);(scrollPane,;final DefaultTableModel model=new DefaultTableModel();Object results=getFileStates();(results,columnNames);table=new JTable();(model);(table);(new TableListener();final JPanel panel_2=new JPanel();final GridLayout gridLayout=new GridLayou

45、t(0,4);(9);(gridLayout);(new Dimension(0,220);(panel_2,;final JLabel label_1=new JLabel();(姓 名：);(label_1);readername=new JTextField();(new MyDocument(10);(readername);final JLabel label_2=new JLabel();(性 别：);(label_2);final JPanel panel_3=new JPanel();final FlowLayout flowLayout_1=new FlowLayout();

46、(0);(flowLayout_1);(panel_3);JRadioButton1=new JRadioButton();(true);(JRadioButton1);(JRadioButton1);(男);JRadioButton2=new JRadioButton();(JRadioButton2);(JRadioButton2);(女);final JLabel label_3=new JLabel();(年 龄：);(label_3);age=new JTextField();(new MyDocument(2);(new NumberListener();(age);final J

47、Label label_5=new JLabel();(职 业：);(label_5);zy=new JTextField();(new MyDocument(30);(zy);final JLabel label=new JLabel();(有效证件：);(label);comboBox=new JComboBox();(new DefaultComboBoxModel(array);for(int i=1;i;i+)(i);(array);(comboBox);final JLabel label_6=new JLabel();(证件号码：);(label_6);zjnumber=new

48、JTextField();(new MyDocument(13);(new NumberListener();(zjnumber);final JLabel label_7=new JLabel();(办证日期：);(label_7);SimpleDateFormat myfmt=new SimpleDateFormat(yyyy-MM-dd);bztime=new JFormattedTextField();(bztime);final JLabel label_9=new JLabel();(最大借书量：);(label_9);maxnumber=new JTextField();(new

49、 NumberListener();(maxnumber);final JLabel label_13=new JLabel();(会员证有效日期：);(label_13);date=new JFormattedTextField();(date);final JLabel label_8=new JLabel();(电 话：);(label_8);tel=new JFormattedTextField();(new TelListener();(new MyDocument(11);(tel);final JLabel label_14=new JLabel();(押 金：);(label_

50、14);keepmoney=new JTextField();(new KeepmoneyListener();(keepmoney);final JLabel label_4=new JLabel();(读者编号：);(label_4);ISBN=new JTextField();(false);(new MyDocument(13);(ISBN);final JPanel panel_4=new JPanel();(new Dimension(0,0);final FlowLayout flowLayout=new FlowLayout();(0);(4);(flowLayout);(pa