1、文本图书号文本(主键)单价作者出版社入库时间2.表user用户名密码系统源码程序代码1登陆界面:程序名Login.javaimport java.awt.event.*;import javax.swing.*;import java.awt.*;import java.awt.Container;import java.util.*;import java.sql.*; class Login extends JFrame implements ActionListener Container cp=null; JFrame f=null; JButton j1,j2; JTextField
2、 t1; JPasswordField t2; JLabel jlable1,jlable2; Color c; JPanel jp1,jp2; Login() f=new JFrame(小型图书管理系统); j1=new JButton(确定 j2=new JButton(取消 cp=f.getContentPane(); jlable1=new JLabel( 输入用户名 jlable2=new JLabel( 用户密码 jp1=new JPanel(); jp2=new JPanel(); t1=new JTextField(18); t2=new JPasswordField(18);
3、 jp1.add(jlable1); jp1.add(t1); jp1.add(jlable2); jp1.add(t2); JLabel JL=new JLabel(=0) ari0= ari1= ari2= ari3= ari4= ari5= i-; i=0; String s=select * from book Statement sql=con.createStatement(); ResultSet rs=sql.executeQuery(s); while(rs.next() String bname=rs.getString(1); String bno=rs.getStrin
4、g(2); String price=rs.getString(3); String writer=rs.getString(4); String publish=rs.getString(5); String indate=rs.getString(6); ari0=bname; ari1=bno; ari2=price; ari3=writer; ari4=publish; ari5=indate; i+; count=+i+ L.setText(书库现在共有图书+count+本 f.repaint(); con.close(); catch(SQLException g) f.(Stri
5、ng arg) BookBrower a=new BookBrower(); a.showRecord();3图书查询:程序名QueryBook.javaclass QueryBook implements ActionListener JFrame f3; JPanel jp1,jp2,jp3,jp4,jp,jpanelWest;按钮,确定、取消 JLabel label; 标签:请输入图书号 JTextField tf,tf1,tf2,tf3,tf4,tf5,tf6; JLabel label1,label2,label3,label4; QueryBook() f3=new JFrame
6、(); cp=f3.getContentPane(); jp1=new JPanel(); jp2=new JPanel(); jp3=new JPanel(); jp4=new JPanel(); jp=new JPanel(); f3.setVisible(true); *f3.addWindowListener(new WindowAdapter()public void showRecord() Statement sql; String ql=tf.getText().trim();select * from book where 图书号 =+ql + sql=con.createS
7、tatement(); if(rs.next() String bname=rs.getString(1); tf1.setText(bname); tf2.setText(bno); tf3.setText(price); tf4.setText(writer); tf5.setText(publish); tf6.setText(indate); else JOptionPane.showMessageDialog(null,您输入的图书号不存在,请重新输入, 输入错误, JOptionPane.YES_NO_OPTION); tf1.setEditable(false); tf2.set
8、Editable(false); tf3.setEditable(false); tf4.setEditable(false); tf5.setEditable(false); tf6.setEditable(false);public void actionPerformed(ActionEvent e) showRecord(); tf.setText( else if(cmd.equals( f3.(String arg) QueryBook a=new QueryBook();4图书删除:程序名RemoveBook.javaclass RemoveBook implements ActionListener JButton jbt1,jbt2,jbt3;请输入学号 JTextField tf; RemoveBook()查询 jbt3=new JButton(删除 jbt3.addActionListener(this); *f.addWindowListener(new WindowAdapter() public void showRecord(String ql)select * from book where 图书名 = String writer=rs.getStri
copyright@ 2008-2022 冰豆网网站版权所有
经营许可证编号:鄂ICP备2022015515号-1