Java編寫的簡單圖書管理系統(tǒng)

1、Java編寫的簡單圖書管理系統(tǒng)主界面代碼實現(xiàn)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.SQLException;im

2、port 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.JPanel;import javax.swing.JPasswordField;import javax.swing.JTextField;public class Login extends JFrame private stati

3、c final long serialVersionUID = 1L;private JLabel jlUsername;private JLabel jlPwd;private JTextField txtUsername; /用戶名private JTextField txtPassword; /密碼private JButton jbOk;private JButton jbCancel;public JLabel getJlUsername() if(jlUsername=null)jlUsername=new JLabel("賬號");jlUsername.set

4、Foreground(Color.BLACK);jlUsername.setBounds(118, 40, 85, 30);return jlUsername;public JLabel getJlPwd() if(jlPwd=null)jlPwd=new JLabel("密碼");jlPwd.setForeground(Color.BLACK);jlPwd.setBounds(118, 100, 85, 30);return jlPwd;public JTextField getTxtUsername() if(txtUsername=null)txtUsername=n

5、ew JTextField(20);txtUsername.setBounds(180,40 , 200, 30);return txtUsername;public JTextField getTxtPassword() if(txtPassword=null)txtPassword=new JPasswordField(20);txtPassword.setBounds(180, 100, 200, 30);return txtPassword;public JButton getJbOk() if(jbOk=null)jbOk=new JButton("登陸");jb

6、Ok.setBounds(150, 180, 90, 30);/jbOk.addActionListener(this);return jbOk;public JButton getJbCancel() if(jbCancel=null)jbCancel=new JButton("取消");jbCancel.setBounds(300, 180, 90, 30);return jbCancel;public Login(String title)super(title);/JFrame frame=new JFrame();Container cantainer=this.

7、getContentPane();this.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);ImageIcon img = new ImageIcon("F:Java傳習srcLibraryZFXYH48I_U)C4M2C4.jpg");/這是背景圖片JLabel imgLabel = new JLabel(img);/將背景圖放在標簽里。this.getLayeredPane().add(imgLabel, new Integer(Integer.MIN_VALUE);/注意這里是關鍵，將背景標簽添加到jfram的Layere

8、dPane面板里。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.add(getJbOk();imgLabel.add(getJb

9、Cancel();cantainer.add(imgLabel,BorderLayout.NORTH);(JPanel)cantainer).setOpaque(false); /注意這里，將內(nèi)容面板設為透明。這樣LayeredPane面板中的背景才能顯示出來。this.setSize(img.getIconWidth(),img.getIconHeight();myEvent();this.setVisible(true);this.setResizable(true);private void myEvent()jbCancel.addActionListener(new ActionLi

10、stener()public void actionPerformed(ActionEvent e)Login.this.dispose(););jbOk.addActionListener(new ActionListener()public void actionPerformed(ActionEvent e)Connection conn=null;Statement stm=null;ResultSet st=null;tryClass.forName("com.mysql.jdbc.Driver");conn=DriverManager.getConnection

11、("jdbc:mysql:/localhost:3306/library","sa","123456");stm=conn.createStatement();String sql="select * from user"/String sql1="select psw from user"st=stm.executeQuery(sql);/ st1=stm.executeQuery(sql1);if(st.next()if(txtUsername.getText().equals(st.get

12、String("id")&&txtPassword.getText().equals(st.getString("psw")Login.this.setVisible(false);new Book("管理界面");elseJOptionPane.showMessageDialog(null, "您輸入的賬號或密碼不正確");getTxtUsername().setText("");getTxtPassword().setText("");else JOpti

13、onPane.showMessageDialog(null,"用戶名不存在,請重新輸入,錯誤!"); getTxtUsername().setText("");getTxtPassword().setText("");catch(ClassNotFoundException e1)e1.printStackTrace(); catch (SQLException e2) / TODO Auto-generated catch blocke2.printStackTrace();finallytrystm.close();catch (

14、Exception e3) / 關閉Connection try conn.close(); catch (Exception e4) );public static void main(String args)new Login("圖書管理登陸界面");管理界面實現(xiàn)代碼package Library;import java.awt.BorderLayout;import java.awt.Container;import java.awt.event.ActionEvent;import java.awt.event.ActionListener;import java.

15、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.JPanel;import javax.swing.JTable;import javax.s

16、wing.JTextField;public class Book extends JFrame private static final long serialVersionUID = 1L;private JLabel lblId;private JLabel lblBname;private JLabel lblWname;private JLabel lblCbs;private JLabel lblnum1;private JLabel lblnum2;private JTextField bId; /圖書編號private JTextField bname; /書名private

17、JTextField wname; /作者名private JTextField cbs; /出版社private JTextField num1; /現(xiàn)存量private JTextField num2; /庫存量private JButton jbDel;private JTextField jDel;private JButton jbAdd;private JButton jbSearch;private JButton jbUpdate;private JTable table;private JLabel jabel;/輸入要查找的書號public JLabel getJabel(

18、) if(jabel=null)jabel=new JLabel("查刪學號");jabel.setBounds(50, 350, 50, 30);return jabel;public JButton getJbDel() if(jbDel=null)jbDel=new JButton("刪除");jbDel.setBounds(180, 400, 60, 30);return jbDel;public JTextField getjDel() if(jDel=null)jDel=new JTextField(20);jDel.setBounds(10

19、0, 350, 150, 30);return jDel;public JButton getJbAdd() if(jbAdd=null)jbAdd=new JButton("添加");jbAdd.setBounds(100,400,60,30);return jbAdd;public JButton getJbSearch() if(jbSearch=null)jbSearch=new JButton("查找");jbSearch.setBounds(100, 450, 60, 30);return jbSearch;public JButton ge

20、tJbUpdate() if(jbUpdate=null)jbUpdate=new JButton("修改");jbUpdate.setBounds(180, 450, 60, 30);return jbUpdate;public JTable getTable() if(table=null)table=new JTable(100,6);table.setBounds(270, 50, 500, 600);return table;public JLabel getLblId() if(lblId=null)lblId=new JLabel("編號"

21、);lblId.setBounds(50, 50, 50, 30);return lblId;public JLabel getLblBname() if(lblBname=null)lblBname=new JLabel("書名");lblBname.setBounds(50, 100, 50, 30);return lblBname;public JLabel getLblWname() if(lblWname=null)lblWname=new JLabel("作者");lblWname.setBounds(50,150, 50, 30);retu

22、rn lblWname;public JLabel getLblnum1() if(lblnum1=null)lblnum1=new JLabel("現(xiàn)存量");lblnum1.setBounds(50,200, 50, 30);return lblnum1;public JLabel getLblnum2() if(lblnum2=null)lblnum2=new JLabel("庫存量");lblnum2.setBounds(50,250, 50, 30);return lblnum2;public JTextField getbId() if(bI

23、d=null)bId=new JTextField(20);bId.setBounds(100, 50,150, 30);return bId;public JTextField getBname() if(bname=null)bname=new JTextField(20);bname.setBounds(100, 100, 150, 30);return bname;public JTextField getWname() if(wname=null)wname=new JTextField(20);wname.setBounds(100, 150, 150, 30);return wn

24、ame;public JTextField getNum1() if(num1=null)num1=new JTextField(20);num1.setBounds(100, 200, 150, 30);return num1;public JTextField getNum2() if(num2=null)num2=new JTextField(20);num2.setBounds(100, 250, 150, 30);return num2;public JLabel getLblCbs() if(lblCbs=null)lblCbs=new JLabel("出版社"

25、);lblCbs.setBounds(50,300, 50, 30);return lblCbs;public JTextField getCbs() if(cbs=null)cbs=new JTextField(20);cbs.setBounds(100, 300, 150, 30);return cbs;public Book(String title)super(title);/JFrame frame=new JFrame();Container cantainer=this.getContentPane();this.setDefaultCloseOperation(JFrame.E

26、XIT_ON_CLOSE);ImageIcon img = new ImageIcon("F:Java傳習srcLibraryd50735fae6cd7b8961e8eafd0f2442a7d8330ecc1.jpg");/這是背景圖片JLabel imgLabel = new JLabel(img);/將背景圖放在標簽里。this.getLayeredPane().add(imgLabel, new Integer(Integer.MIN_VALUE);/注意這里是關鍵，將背景標簽添加到jfram的LayeredPane面板里。imgLabel.setBounds(0,0

27、,img.getIconWidth(), img.getIconHeight();/設置背景標簽的位置cantainer.setLayout(new BorderLayout();imgLabel.setLayout(null);imgLabel.add(getLblId();imgLabel.add(getbId();imgLabel.add(getLblBname();imgLabel.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();cantainer.add(imgLa

29、bel,BorderLayout.NORTH);(JPanel)cantainer).setOpaque(false); /注意這里，將內(nèi)容面板設為透明。這樣LayeredPane面板中的背景才能顯示出來。this.setSize(img.getIconWidth(),img.getIconHeight();myEvent();this.setVisible(true);this.setResizable(true);private void myEvent() / TODO Auto-generated method stubjbAdd.addActionListener(new Actio

30、nListener()public void actionPerformed(ActionEvent ee)Connection conn=null;Statement stm=null;String id1=bId.getText();String name1=bname.getText();String name2=wname.getText();String n1=num1.getText();String n2=num2.getText();String chubs=cbs.getText();tryClass.forName("com.mysql.jdbc.Driver&q

31、uot;);conn=DriverManager.getConnection("jdbc:mysql:/localhost:3306/library","sa","123456");stm=conn.createStatement();String sql="insert into book values('"+id1+"','"+name1+"','"+name2+"','"+n1+"&#

32、39;,'"+n2+"','"+chubs+"')"stm.executeUpdate(sql);getbId().setText("");getBname().setText("");getWname().setText("");getNum1().setText("");getNum2().setText("");getCbs().setText("");catch(ClassNotFoun

33、dException e) catch (SQLException e) / TODO Auto-generated catch blocke.printStackTrace();finally / 關閉Statement try stm.close(); catch (Exception e) / 關閉Connection try conn.close(); catch (Exception e) );jbDel.addActionListener(new ActionListener()public void actionPerformed(ActionEvent ee)String id

34、=jDel.getText();Connection conn=null;Statement stm=null;tryClass.forName("com.mysql.jdbc.Driver");conn=DriverManager.getConnection("jdbc:mysql:/localhost:3306/library","sa","123456");/String sql="select * from book"String sql="delete from book w

35、here Bid='"+id+"'"stm=conn.createStatement();stm.executeUpdate(sql);getjDel().setText("");catch(ClassNotFoundException e) catch (SQLException e) / TODO Auto-generated catch blocke.printStackTrace();finally / 關閉Statement try stm.close(); catch (Exception e) / 關閉Connec

36、tion try conn.close(); catch (Exception e) );jbSearch.addActionListener(new ActionListener()public void actionPerformed(ActionEvent ee)String id=jDel.getText();Connection conn=null;Statement stm=null;ResultSet rst=null;tryClass.forName("com.mysql.jdbc.Driver");conn=DriverManager.getConnect

37、ion("jdbc:mysql:/localhost:3306/library","sa","123456");/String sql="select * from book"String sql="select * from book where Bid='"+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");getCbs().setText(rst.getString("ch