图书管理系统源代码.doc

import java.awt.*;import java.awt.event.*;import .*;import java.io.*;import javax.swing.event.*;import javax.swing.border.*;import java.sql.*;import java.io.*;import .*;import javax.swing.*;public class Javapublic static void main(String args)One one=new One(); class One extends JFrame implements ActionListenerJLabel jlabel1,jlabel2;JButton jbutton1,jbutton2;JTextField jtextfield1;JPanel jpanel1;JPasswordField passwordText;One()jpanel1=new JPanel(); jlabel1=new JLabel(用户名:); jlabel2=new JLabel(密 码:); jbutton1=new JButton(登录); jbutton2=new JButton(取消); Font f=new Font(楷体_GB2312,Font.BOLD,32);jlabel1.setFont(f);jlabel2.setFont(f);jtextfield1=new JTextField(10);passwordText=new JPasswordField(10);passwordText.setEchoChar(*);jbutton1.addActionListener(this);jbutton2.addActionListener(this);setLayout(new FlowLayout();jpanel1.add(jbutton1);jpanel1.add(jbutton2);add(jlabel1);add(jtextfield1);add(jlabel2); add(passwordText);add(jpanel1);setBounds(100,100,500,500);setVisible(true);validate();setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE);public void actionPerformed(ActionEvent e)if(e.getSource()=jbutton1)String str1,str2;str1=jtextfield1.getText().trim();str2=String.valueOf(passwordText.getPassword();Connection con;Statement sql;ResultSet rs;tryClass.forName(sun.jdbc.odbc.JdbcOdbcDriver);catch(ClassNotFoundException ee)System.out.println(+ee);trycon=DriverManager.getConnection(jdbc:odbc:feng,fyl,1111);sql=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);rs=sql.executeQuery(SELECT * FROM 用户);boolean boo=true;while(rs.next()String 用户编号=rs.getString(用户编号);String 用户名=rs.getString(用户名);if(用户名.trim().equals(str1)&用户编号.trim().equals(str2)JOptionPane.showMessageDialog(this,欢迎进入图书管理系统,login,JOptionPane.PLAIN_MESSAGE); setVisible(false);FrameMain t=new FrameMain();boo=false;if(boo)JOptionPane.showMessageDialog(this,用户不存在或者输入错误请重新输入！,提示,JOptionPane.WARNING_MESSAGE); jtextfield1.setText();passwordText.setText(); con.close();catch(SQLException eee)System.out.println(eee);elseSystem.exit(0); class FrameMain extends JFrame implements ActionListenerJPanel contentPane;JMenuBar mb1=new JMenuBar();JMenu readr=new JMenu(读者);JMenu book=new JMenu(图书);JMenu help=new JMenu(帮助);JMenu exit=new JMenu(退出);JMenu 借阅=new JMenu(借阅);JMenuItem r1=new JMenuItem(浏览读者信息);JMenuItem b1=new JMenuItem(浏览图书信息);JMenuItem b2=new JMenuItem(增加图书);JMenuItem b3=new JMenuItem(删除图书);JMenuItem b4=new JMenuItem(修改图书信息);JMenuItem h1=new JMenuItem(使用网络信息帮助);JMenuItem h2=new JMenuItem(读取java文件帮助信息);JMenuItem e1=new JMenuItem(退出系统);JMenuItem 借书记录=new JMenuItem(借书记录);JMenuItem 还书记录=new JMenuItem(还书记录);FrameMain()setTitle(图书馆信息管理系统);readr.add(r1); book.add(b1);book.add(b2); book.add(b3); book.add(b4); help.add(h1);借阅.add(借书记录);借阅.add(还书记录);help.add(h2);exit.add(e1);mb1.add(readr);mb1.add(book);mb1.add(借阅);mb1.add(help);mb1.add(exit);setJMenuBar(mb1);r1.addActionListener(this);b1.addActionListener(this);b2.addActionListener(this);b3.addActionListener(this);b4.addActionListener(this);h1.addActionListener(this);h2.addActionListener(this);e1.addActionListener(this);setBounds(200,200,500,500);setVisible(true);setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE); public void actionPerformed(ActionEvent e)if(e.getSource()=r1)new showReader();else if(e.getSource()=b1)new showBook();else if(e.getSource()=b2)new InsertBook();else if(e.getSource()=b3)new Delete();else if(e.getSource()=b4)new Modify();else if(e.getSource()=h1)Help1 flink=new Help1();else if(e.getSource()=h2)class Help2 extends JFrame Help2()byte b=new byte30;JTextArea text=new JTextArea(20,20);setSize(330,300);setVisible(true);setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE);add(text,BorderLayout.CENTER);tryFileInputStream input=new FileInputStream(help.java);ProgressMonitorInputStream in=new ProgressMonitorInputStream(this,读取help文件,input);ProgressMonitor p=in.getProgressMonitor();while(in.read(b)!=-1)String s=new String(b);text.append(s);Thread.sleep(200); catch(InterruptedException e)catch(IOException e)new Help2();else if(e.getSource()=e1)System.exit(0);class Help1 extends JFrame implements ActionListener,RunnableJButton button;URL url;JTextField text;JEditorPane editPane;byte b=new byte118;Thread thread;public Help1()text=new JTextField(20);editPane=new JEditorPane();editPane.setEditable(false);button=new JButton(确定);button.addActionListener(this);thread=new Thread(this);JPanel p=new JPanel();p.add(new JLabel(输入网址： );p.add(text);p.add(button);Container con=getContentPane();con.add(new JScrollPane(editPane),BorderLayout.CENTER);con.add(p,BorderLayout.NORTH);setBounds(60,60,500,500);setVisible(true);validate();setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE);editPane.addHyperlinkListener(new HyperlinkListener ()public void hyperlinkUpdate(HyperlinkEvent e)if(e.getEventType()=HyperlinkEvent.EventType.ACTIVATED)tryeditPane.setPage(e.getURL();catch(IOException e1)editPane.setText(+e1););public void actionPerformed(ActionEvent e)if(!(thread.isAlive()thread=new Thread(this);trythread.start();catch(Exception ee)text.setText(我正在读取+url);public void run()tryint n=-1;editPane.setText(null);url=new URL(text.getText().trim();editPane.setPage(url);catch(MalformedURLException e1)text.setText(+e1);return;catch(IOException eee)text.setText(+eee);return;class InsertBook extends JDialog implements ActionListenerJLabel insertBook;Object name=编号,书名,出版社,出版日期;Object a=new Object15;JTable table;JButton insert;Connection con;Statement sql;ResultSet rs;InsertBook()insertBook=new JLabel(请输入新书信息:);table=new JTable(a,name);insert=new JButton(确定插入);setLayout(new FlowLayout();add(insertBook);add(table);add(insert);setBounds(100,100,800,200);setVisible(true);insert.addActionListener(this); public void actionPerformed(ActionEvent e)tryClass.forName(sun.jdbc.odbc.JdbcOdbcDriver);catch(ClassNotFoundException ee)System.out.println(+ee);trycon=DriverManager.getConnection(jdbc:odbc:feng,fyl,1111);sql=con.createStatement();System.out.println(a00+ +a01+ +a02+ +a03);int k=sql.executeUpdate(INSERT INTO insertBook VALUES(+a00+,+a01+,+a02+,+a03+);if(k=1)JOptionPane.showMessageDialog(this,插入成功,成功,JOptionPane.PLAIN_MESSAGE); setVisible(false);con.close(); catch(SQLException ee)JOptionPane.showMessageDialog(this,插入失败,失败,JOptionPane.ERROR_MESSAGE); System.out.println(e);class showReader extends JDialog implements ActionListenerJTable table;Object a;Object name=用户编号,用户名,性别,年龄 ;JButton showReader;showReader()showReader=new JButton(显示信息);showReader.addActionListener(this);add(showReader,BorderLayout.NORTH);setBounds(200,200,500,500); setVisible(true);public void actionPerformed(ActionEvent e)Connection con;Statement sql;ResultSet rs;tryClass.forName(sun.jdbc.odbc.JdbcOdbcDriver);catch(ClassNotFoundException ee)System.out.println(+ee);trycon=DriverManager.getConnection(jdbc:odbc:feng,fyl,1111);sql=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);rs=sql.executeQuery(SELECT * FROM 用户);rs.last();int lastNumber=rs.getRow();a=new ObjectlastNumber4;int k=0;rs.beforeFirst();while(rs.next()ak0=rs.getString(1); ak1=rs.getString(2); ak2=rs.getString(3); ak3=rs.getString(4); k+;con.close();catch(SQLException ee)System.out.println(ee); table=new JTable(a,name);getContentPane().removeAll();add(showReader,BorderLayout.NORTH);add(new JScrollPane(table),BorderLayout.CENTER);setVisible(true);validate();class showBook extends JDialog implements ItemListenerJTable table;Object a;Object name=编号,书名,出版社,出版日期 ;JCheckBox showBook;showBook()showBook=new JCheckBox(显示信息);showBook.addItemListener(this);add(showBook,BorderLayout.NORTH);setBounds(200,200,500,500); setVisible(true);public void itemStateChanged(ItemEvent e)JCheckBox box=(JCheckBox)e.getItemSelectable();if(box.isSelected()Connection con;Statement sql;ResultSet rs;tryClass.forName(sun.jdbc.odbc.JdbcOdbcDriver);catch(ClassNotFoundException ee)System.out.println(+ee);trycon=DriverManager.getConnection(jdbc:odbc:feng,fyl,1111);sql=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);rs=sql.executeQuery(SELECT * FROM insertBook);rs.last();int lastNumber=rs.getRow();a=new ObjectlastNumber4;int k=0;rs.beforeFirst();while(rs.next()ak0=rs.getString(1); ak1=rs.getString(2); ak2=rs.getString(3); ak3=rs.getString(4); k+;con.close();catch(SQLException ee)System.out.println(ee); table=new JTable(a,name);getContentPane().removeAll();add(showBook,BorderLayout.NORTH);add(new JScrollPane(table),BorderLayout.CENTER);setVisible(true);validate(); else table.setVisible(false);class Delete extends JDialog implements ActionListenerJLabel input;JTextField inputNumber;Object name=编号,书名,出版社,出版日期 ;Object a=new Object14;JTable table;JButton delete;JPanel pane=new JPanel();Connection con;Statement sql;ResultSet rs;String num;Delete()input=new JLabel(请输入删除书的编号：(以回车结束);inputNumber=new JTextField(20);delete=new JButton(删除);table=new JTable(a,name);pane.add(input);pane.add(inputNumber);add(pane,BorderLayout.NORTH);add(table,BorderLayout.CENTER);add(delete,BorderLayout.SOUTH);inputNumber.addActionListener(this);delete.addActionListener(this);setBounds(100,100,800,300);setVisible(true);public void actionPerformed(ActionEvent e)tryClass.forName(sun.jdbc.odbc.JdbcOdbcDriver); catch(ClassNotFoundException eee)System.out.println(+eee); trynum=inputNumber.getText().trim();con=DriverManager.getConnection(jdbc:odbc:feng,fyl,1111);sql=con.createStatement();rs=sql.executeQuery(SELECT *FROM insertBook where 编号=+num+);boolean boo=rs.next();if(boo=false)JOptionPane.showMessageDialog(this,编号不存在,提示,JOptionPane.WARNING_MESSAGE); elsea00=rs.getString(1);a01=rs.getString(2);a02=rs.getString(3);a03=rs.getString(4);table.repaint(); if(e.getSource()=delete)int n=JOptionPane.showConfirmDialog(this,确认要删除吗？,确认对话框,JOptionPane.YES_OPTION);if(n=JOptionPane.YES_OPTION)sql=con.createStatement();int k=sql.executeUpdate(DELETE FROM insertBook WHERE 编号=+num+);if(k=1) JOptionPane.showMessageDialog(this,删除成功！,删除,JOptionPane.PLAIN_MESSAGE);setVisible(false);else JOptionPane.showMessageDialog(this,删除失败！,删除,JOptionPane.ERROR_MESSAGE); setVisible(false);con.close();catch(SQLException ee)System.out.println(ee); class Modify extends JDialog implements ActionListenerJLabel infor;JTextField inputNumber;Object name=编号,书名,出版社,出版日期;Object a=new Object14;JTable table;JButton queren;Connection con;Statement sql;ResultSet rs;String num;Modify()infor=new JLabel(输入编号(以回车确认)：);inputNumber=new JTextField(20);table=new JTable(a,name);queren=new JButton(修改记录);setLayout(new FlowLayout();infor.setPreferredSize(new Dimension(100,70);add(infor);add(inputNumber);add(table);queren.setPreferredSize