Java编写的简单图书管理系统

1、Java编写的简单图书管理系统主界面代码实现package Library ;import java.awt.BorderLayout ;import java.awt.Color;import java.awt.Container;import java.awt.event.ActionEvent;import java.awt.event.ActionListener ;import java.sql.Connection ;import java.sql .DriverManager ;import java.sql.ResultSet;import java.sql.SQLExcept

2、ion;import java.sql.Statement;import javax.swing.ImageIcon;import javax.swing.JButton;import javax.swing .JFrame;import javax.swing.JLabel;import javax.swing.JOptionPane;import javax.swing.JPane;import javax.swing .JPasswordField;import javax.swing .JTextField;publicclass Login extends JFrameprivate

3、staticfinallong serialVersionUID =11;private JLabejlUsername ;private JLabejlPwd;private JTextFieldtxtUsername ;/用户名private JTextFieldtxtPassword;/ 密码private JButtonjbOk;private JButtonjbCancel;public JLabelgetJlUsername ()if (jlUsername =null ) jlUsername =new JLabel("账号");jlUsername .set

4、Foreground (Color.BLACK);jlUsername .setBounds(11840,85,30);return jlUsername;public JLabelgetJlPwd ()if (jlPwd =null )jlPwd =new JLabel("密码)jlPwd.setForeground (Color.BLACK);jlPwd.setBounds(118100 85,30); return jlPwd;public JTextFieldgetTxtUsername () if (txtUsername =null ) txtUsername =new

5、JTextField(20);txtUsername .setBounds(18Q40,200,30); return txtUsername ;public JTextFieldgetTxtPassword () if (txtPassword =null ) txtPassword =new JPasswordField(20);txtPassword .setBounds (18Q100200,30); return txtPassword; r- - / J ;public JButtongetJbOk () if (jbOk =null ) jbOk =new JButton(&qu

6、ot;登陆");jbOk.setBounds(15018090,30);/jbOk.addActionListener(this); return jbOk;public JButton getJbCancel () if (jbCancel=null ) jbCancel =new JButton("取消");jbCancel.setBounds(300,18Q90,30); return jbCancel; public Login (String title ) super (title);/JFrameframe=newJFrame();Container

7、 cantainer =this .getContentPane ();this .setDefaultCloseOperation (JFrameEXIT_ON_CLOSE );ImageIcon img =new ImageIcon (传习srcLibraryZF'XY'H48I_U)C4M2C4.jpg")，这是背景图片JLabelimgLabel =new儿abel(img);将背景图放在标签里。this .getLayeredPane().add(imgLabel ,new Integer (Integer.MIN_VALUE );/注意这里是 关键，将背景

8、标签添加到jfromjqLayeredPane面板里。imgLabel .setBounds(0,0,img.getIconWidth (),img.getIconHeight ();/ 设置背景标签的 位置cantainer. setLayout (new BorderLayout ();imgLabel .setLayout(null );imgLabel .add(getJlUsername();imgLabel .add(getTxtUsername ();imgLabel .add(getJlPwd();imgLabel .add(getTxtPassword();imgLabel

9、.add(getJbOk();imgLabel .add(getJbCancel();cantainer.add(imgLabel ,BorderLayout .NORTH );(JPanel)cantainer) .setOpaque(false);/注意这里，将 内容面板设为透明。这样 LayeredPane面板中的背景才能显示出来。this .setSize(img.getIconWidth (),img.getIconHeight (); myEvent ();this .setVisible (true );this .setResizable(true );:I1- :1 >

10、 J .privatevoid myEvent ()jbCancel.addActionListener (newActionListener () publicvoid actionPerformed (ActionEvent e) Login .this .dispose。； );jbOk .addActionListener (new ActionListener () publicvoid actionPerformed (ActionEvent e)Connection conn =null ;Statement stm =null ;ResultSetst=null ; try C

11、lass.forName();conn =DriverManager .getConnection (,"sa","123456"stm =conn .createStatement ();String sql ="select*fromuser"/Stringsql1="selectpswfromuser"st=stm .executeQuery (sql);/st1=stm.executeQuery(sql1); if (st.next() if (txtUsername .getText().equals(s

12、t.getString ("id" )&&txtPassword.getText().equals(st.getString ("psw")Login .this .setVisible (false);new Book("管理界面"); else JOptionPane.showMessageDialog(null，”您输入的账号或密码 不正确)getTxtUsername () .setText(""); getTxtPassword ().setText(""); else

13、 JOptionPane.showMessageDialog(null，”用户名不存在，请重新输入，错 误!)getTxtUsername () .setText("");getTxtPassword () .setText(""); catch (ClassNotFoundException e1) elprintStackTrace ();catch (SQLExceptione2)/ TODO Auto-generatedcatchblock e2.printStackTrace ();finally try stm.close();catch (

14、Exception e3)/ 关闭 Connectiontry conn.close();catch (Exceptione4) );publicstaticvoid main (String args) new Login ("图书管理登陆界面"); 管理界面 实现代码package Library ;import java.awt.BorderLayout ;import java.awt.Container;import java.awt.event.ActionEvent;import java.awt.event.ActionListener ;import ja

15、va.sql.Connection ;import java.sql .DriverManager ;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;import javax.swing .Imageicon;import javax.swing.JButton;import javax.swing .JFrame;import javax.swing.JLabel;import javax.swing.JPane；import javax.swing .JTable;import

16、 javax.swing .JTextField;publicclass Bookextends JFrameprivatestaticfina110ng serialVersionUID =11;private JLabellblld ;private JLabellblBname ;private JLabellblWname ;private JLabellblCbs;private JLabellblnuml ;private JLabellblnum2 ;private JTextFieldbld;/ 图书编号private JTextFieldbname;/书名private JT

17、extFieldwname;/作者名private JTextFieldcbs;/ 出版社private JTextFieldnuml;/ 现存量private JTextFieldnum2;/库存量private JButtonjbDel;private JTextFieldjDel;private JButtonjbAdd ;private JButtonjbSearch;private JButtonjbUpdate;private JTabletable;private JLabejabel;输入要查找的书号public JLabelgetJabel ()if (jabel=null

18、)jabel=new JLabe("查删学号");jabel.setBounds(50,35Q50,30);return jabel;public JButtongetJbDel ()if (jbDel =null )jbDel =new JButton ("删除)jbDel .setBounds(18Q400,60,30);return jbDel;public JTextFieldgetjDel ()if (jDel =null ) jDel =new JTextField(20); jDel.setBounds(10Q35Q15030);return jDe

19、l;public JButtongetJbAdd ()if (jbAdd =null ) jbAdd =new JButton("添加")； jbAdd.setBounds(10Q400,60,30);return jbAdd ;public JButton getJbSearch ()if (jbSearch=null ) jbSearch=new JButton("查找"); jbSearch.setBounds(100450,60,30);return jbSearch;public JButton getJbUpdate () if (jbUpd

20、ate =null ) jbUpdate =new JButton ("修改")； jbUpdate .setBounds( 180450,60,30);return jbUpdate;public JTablegetTable ()if(table=null )table=new JTable(10Q6); table .setBounds(270,50,500,600);return table;public JLabelgetLblId ()if (lblId =null )lblId =new JLabel("编号)Iblld .setBounds(50,

21、50,50,30);return Iblld ;public JLabelgetLblBname ()if (IblBname =null )IblBname =new 儿abel("书名");IblBname .setBounds(50,10Q50,30);return lblBname;public JLabelgetLblWname ()if (lblWname =null )lblWname =new JLabel("作者) lblWname .setBounds (50,15050,30);return lblWname ;public JLabelge

22、tLblnum1 ()if (lblnum1 =null )lblnum1 =new JLabel("现存量");lblnum1 .setBounds(50,200,50,30);return lblnum1 ;public JLabelgetLblnum2 ()if (lblnum2 =null )lblnum2 =new JLabel("库存量")；lblnum2 .setBounds(50,250,50,30);return lblnum2 ;public JTextFieldgetbId ()if (bId =null )bId =new JTe

23、xtField(20);bId.setBounds(10050,15030);return bId;public JTextFieldgetBname ()if (bname=null )bname=new JTextField(20);bname .setBounds(10010Q15030);return bname;public JTextFieldgetWname ()if(wname=null )wname=new JTextField(20);wname .setBounds(10Q15015030);return wname;public JTextFieldgetNum1 ()

24、if (num1=null )JInum1=new JTextField(20);num1.setBounds (10Q200,15030);return num1;public JTextFieldgetNum2 ()if (num2=null )num2=new JTextField(20);num2 .setBounds(10Q250,15030);return num2;public JLabelgetLblCbs ()if (lblCbs=null )lblCbs =new JLabel("出版社");lblCbs .setBounds(50,300,50,30)

25、;return lblCbs;public JTextFieldgetCbs ()if (cbs=null )cbs=new JTextField(20);cbs.setBounds(100300,15030);return cbs;public Book (Stringtitle )super (title);JFrameframe=newJFrame();Container cantainer =this .getContentPane ();this .setDefaultCloseOperation (JFrameEXIT_ON_CLOSE );Imageicon img =new I

26、mageicon (传习srcLibraryd50735fae6cd7b8961e8eafd0f2442a7d8330ecc1.jpg" );/ 这是背景图片 JLabelimgLabel =new儿abel(img);将背景图放在标签里。this .getLayeredPane().add(imgLabel ,new Integer (Integer.MIN_VALUE );/注意这里是 关键，将背景标签添加到jfram的LayeredPane面板里。imgLabel .setBounds(0,0,img.getIconWidth (),img.getIconHeight ();/

27、 设置背景标签的 位置cantainer. setLayout (new BorderLayout ();imgLabel .setLayout(null );imgLabel .add(getLblId ();imgLabel .add(getbId ();imgLabel .add(getLblBname (); iidjr '"-.JimgLabel .add(getBname();imgLabel .add(getLblWname ();imgLabel .add(getWname ();imgLabel .add(getLblnum1 ();imgLabel .ad

28、d(getNum1();imgLabel .add(getLblnum2 ();imgLabel .add(getNum2 ();imgLabel .add(getLblCbs();imgLabel .add(getCbs();imgLabel .add(getTable();imgLabel .add(getJbDel();imgLabel .add(getjDel ();imgLabel .add(getJbAdd();imgLabel .add(getJbSearch();imgLabel .add(getJbUpdate();imgLabel .add(getJabel();canta

29、iner.add(imgLabel ,BorderLayout .NORTH );(JPanel)cantainer) .setOpaque(false);/注意这里，将 内容面板设为透明。这样 LayeredPane面板中的背景才能显示出来。this .setSize(img.getIconWidth (),img.getIconHeight (); myEvent ();this .setVisible (true );this .setResizable(true ); privatevoid myEvent ()/ TODO Auto-generatedmethodstubjbAdd

30、.addActionListener (new ActionListener () publicvoid actionPerformed (ActionEvent ee) Connection conn =null ;Statement stm =null ;String id1 =bId.getText();String namel =bname .getText();String name2 =wname .getText();String n1=num1.getText();String n2=num2 .getText();String chubs =cbs.getText(); tr

31、y ClassforName ();conn=DriverManager .getConnection (,"sa","123456); stm =conn .createStatement ();String sql ="insertintobookvalues('" +id1+"','"+name1+"','"+name2+"','"+n1+"','"+n2+"','

32、;"+chubs+"') ;stm .executeUpdate(sql);getbId() .setText("");getBname().setText("");getWname () .setText("");getNum1() .setText("");getNum2 () .setText("");getCbs() .setText("");catch (ClassNotFoundException e) catch (SQLExcept

33、ion e)/ TODO Auto-generatedcatchblock e. printStackTrace ();finally / 关闭 Statement try stm .close();catch (Exceptione)/ 关闭 Connection try conn .close(); catch (Exceptione) );jbDel .addActionListener (new ActionListener () publicvoid actionPerformed (ActionEvent ee) String id =jDel .getText();Connect

34、ion conn =null ;Statement stm =null ; try ClassforName ();conn=DriverManager .getConnection (,"sa","123456);/Stringsql="select*frombook"String sql ="deletefrombookwhereBid='" +id +"”'stm =conn .createStatement ();stm .executeUpdate(sql);getjDel () .set

35、Text("");catch (ClassNotFoundException e)catch (SQLException e)/ TODO Auto-generatedcatchblock e. printStackTrace ();finally / 关闭 Statement try stm .close();catch (Exceptione)/ 关闭 Connection try conn .close();catch (Exceptione) );jbSearch.addActionListener (newActionListener ()publicvoid a

36、ctionPerformed (ActionEvent ee)String id =jDel .getText();Connection conn =null ;Statement stm =null ;ResultSetrst =null ;try ClassforName ();conn=DriverManager .getConnection (,"sa","123456); /Stringsql="select*frombook"Stringsql ="select*frombookwhereBid='" +

37、id+"”'stm =conn .createStatement ();rst=stm .executeQuery (sql);if(rst.next ()getbId ().setText(rst .getString ("Bid");getBname().setText(rst.getString ("Bname"); getWname ().setText(rst.getString ("Wname"); getNum1().setText(rst.getString ("num1");getNum2 ().setText(rst.getString ("num2"); ge