📄 bookinfo.java
字号:
//图书信息查询
import javax.swing.*;
import java.awt.*;
import java.awt.event.*;
import javax.swing.table.*;
import java.util.*;
import java.sql.*;
import javax.swing.table.AbstractTableModel;
public class BookInfo implements ActionListener
{ private JFrame frame;
private Statement stmt;
private Connection con;
private JButton btn;
private JRadioButton rbtn1,rbtn2,rbtn3,rbtn4,rbtn5,rbtn6,rbtn7,rbtn8,rbtn9,rbtn10,rbtn11,rbtn12;
private JTextField jtfd;
private BookInfomation book;
public BookInfo(BookInfomation book)
{
frame=new JFrame("图书信息查询");
ImageIcon icon=new ImageIcon("images/home.gif");
frame.setIconImage(icon.getImage());
frame.setResizable(false);
Font font1=new Font("宋体",Font.PLAIN,13);
Container content=frame.getContentPane();
this.book=book;
//--创建各个组件--
btn=new JButton("执行查询");
jtfd=new JTextField();
JPanel pl=new JPanel();
JPanel p2=new JPanel();
rbtn1=new JRadioButton("图书名称");
rbtn2=new JRadioButton("编号");
rbtn3=new JRadioButton("条形码");
rbtn4=new JRadioButton("分类法");
rbtn5=new JRadioButton("作者");
rbtn6=new JRadioButton("类型");
rbtn7=new JRadioButton("价格");
rbtn8=new JRadioButton("出版社");
rbtn9=new JRadioButton("书架名称");
rbtn10=new JRadioButton("出版日期");
rbtn11=new JRadioButton("入库日期");
rbtn12=new JRadioButton("图书状态");
rbtn1.setSelected(true);
//--设置各个组件的事件--
rbtn1.addActionListener(this);
rbtn2.addActionListener(this);
rbtn3.addActionListener(this);
rbtn4.addActionListener(this);
rbtn5.addActionListener(this);
rbtn6.addActionListener(this);
rbtn7.addActionListener(this);
rbtn8.addActionListener(this);
rbtn9.addActionListener(this);
rbtn10.addActionListener(this);
rbtn11.addActionListener(this);
rbtn12.addActionListener(this);
btn.addActionListener(this);
//--设置单选按钮组--
ButtonGroup group=new ButtonGroup();
group.add(rbtn1);
group.add(rbtn2);
group.add(rbtn3);
group.add(rbtn4);
group.add(rbtn5);
group.add(rbtn6);
group.add(rbtn7);
group.add(rbtn8);
group.add(rbtn9);
group.add(rbtn10);
group.add(rbtn11);
group.add(rbtn12);
//--设置各个组件的大小和位置--
rbtn1.setBounds(20,20,80,25);
rbtn2.setBounds(110,20,80,25);
rbtn3.setBounds(200,20,80,25);
rbtn4.setBounds(290,20,80,25);
rbtn5.setBounds(20,50,80,25);
rbtn6.setBounds(110,50,80,25);
rbtn7.setBounds(200,50,80,25);
rbtn8.setBounds(290,50,80,25);
rbtn9.setBounds(20,80,80,25);
rbtn10.setBounds(110,80,80,25);
rbtn11.setBounds(200,80,80,25);
rbtn12.setBounds(290,80,80,25);
jtfd.setBounds(80,160,120,25);
btn.setBounds(220,160,100,25);
//--设置各个组件的字体--
rbtn1.setFont(font1);
rbtn2.setFont(font1);
rbtn3.setFont(font1);
rbtn4.setFont(font1);
rbtn5.setFont(font1);
rbtn6.setFont(font1);
rbtn7.setFont(font1);
rbtn8.setFont(font1);
rbtn9.setFont(font1);
rbtn10.setFont(font1);
rbtn11.setFont(font1);
rbtn12.setFont(font1);
jtfd.setFont(font1);
btn.setFont(font1);
//--添加各个组件--
pl.setLayout(null);
p2.setLayout(null);
pl.add(rbtn1);
pl.add(rbtn2);
pl.add(rbtn3);
pl.add(rbtn4);
pl.add(rbtn5);
pl.add(rbtn6);
pl.add(rbtn7);
pl.add(rbtn8);
pl.add(rbtn9);
pl.add(rbtn10);
pl.add(rbtn11);
pl.add(rbtn12);
p2.add(jtfd);
p2.add(btn);
pl.setBorder(BorderFactory.createTitledBorder("查询条件"));
pl.setBounds(10,10,400,140);
content.add(pl);
content.add(p2);
frame.pack();
frame.setBounds(300,200,430,230);
frame.setVisible(true);
}
public void actionPerformed(ActionEvent e)
{Object obj=e.getSource();
if(obj==btn)//执行查询按钮
{try{ book.setnull();}
catch(SQLException ed){}
try{ Query();}
catch(SQLException ed){}
}
}
public void Query() throws SQLException
{ int i=0;
String tsmc,bh,txm,flf,zz,lx,jg,cbs,ym,sjmc,cbrq,rkrq,tszt,kcl,jycs,czy,zy;
String strurl=
"jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=DataBase/Library.mdb";
try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");}
catch (ClassNotFoundException eg) {}
con= DriverManager.getConnection(strurl);
stmt= con.createStatement();
ResultSet rs = stmt.executeQuery("select * from 图书资料");
while(rs.next())
{ tsmc=rs.getString("图书名称");bh=rs.getString("编号");txm=rs.getString("条形码");
flf=rs.getString("分类法");zz=rs.getString("作者");lx=rs.getString("类型");
jg=rs.getString("价格");cbs=rs.getString("出版社");ym=rs.getString("页码");
sjmc=rs.getString("书架名称");cbrq=rs.getString("出版日期");rkrq=rs.getString("入库日期");
kcl=rs.getString("库存量");jycs=rs.getString("借阅次数");tszt=rs.getString("图书状态");czy=rs.getString("操作员");zy=rs.getString("摘要");
if(rbtn1.isSelected())//按图书名称
{ if(tsmc.equals(jtfd.getText()))
{book.rowData[i][0]=tsmc;book.rowData[i][1]=bh;book.rowData[i][2]=txm;
book.rowData[i][3]=flf;book.rowData[i][4]=zz;book.rowData[i][5]=lx;
book.rowData[i][6]=jg;book.rowData[i][7]=cbs;book.rowData[i][8]=ym;
book.rowData[i][9]=sjmc;book.rowData[i][10]=cbrq;book.rowData[i][11]=rkrq;
book.rowData[i][12]=kcl;book.rowData[i][13]=jycs;book.rowData[i][14]=tszt;
book.rowData[i][15]=czy;book.rowData[i][16]=zy;
i++;
}
}
if(rbtn2.isSelected())//按编号
{ if(bh.equals(jtfd.getText()))
{ book.rowData[i][0]=tsmc;book.rowData[i][1]=bh;book.rowData[i][2]=txm;
book.rowData[i][3]=flf;book.rowData[i][4]=zz;book.rowData[i][5]=lx;
book.rowData[i][6]=jg;book.rowData[i][7]=cbs;book.rowData[i][8]=ym;
book.rowData[i][9]=sjmc;book.rowData[i][10]=cbrq;book.rowData[i][11]=rkrq;
book.rowData[i][12]=kcl;book.rowData[i][13]=jycs;book.rowData[i][14]=tszt;
book.rowData[i][15]=czy;book.rowData[i][16]=zy;
i++;
}
}
if(rbtn3.isSelected())//按条形码
{ if(txm.equals(jtfd.getText()))
{ book.rowData[i][0]=tsmc;book.rowData[i][1]=bh;book.rowData[i][2]=txm;
book.rowData[i][3]=flf;book.rowData[i][4]=zz;book.rowData[i][5]=lx;
book.rowData[i][6]=jg;book.rowData[i][7]=cbs;book.rowData[i][8]=ym;
book.rowData[i][9]=sjmc;book.rowData[i][10]=cbrq;book.rowData[i][11]=rkrq;
book.rowData[i][12]=kcl;book.rowData[i][13]=jycs;book.rowData[i][14]=tszt;
book.rowData[i][15]=czy;book.rowData[i][16]=zy;
i++;
}
}
if(rbtn4.isSelected())//按分类法
{ if(flf.equals(jtfd.getText()))
{ book.rowData[i][0]=tsmc;book.rowData[i][1]=bh;book.rowData[i][2]=txm;
book.rowData[i][3]=flf;book.rowData[i][4]=zz;book.rowData[i][5]=lx;
book.rowData[i][6]=jg;book.rowData[i][7]=cbs;book.rowData[i][8]=ym;
book.rowData[i][9]=sjmc;book.rowData[i][10]=cbrq;book.rowData[i][11]=rkrq;
book.rowData[i][12]=kcl;book.rowData[i][13]=jycs;book.rowData[i][14]=tszt;
book.rowData[i][15]=czy;book.rowData[i][16]=zy;
i++;
}
}
if(rbtn5.isSelected())//按作者
{ if(zz.equals(jtfd.getText()))
{ book.rowData[i][0]=tsmc;book.rowData[i][1]=bh;book.rowData[i][2]=txm;
book.rowData[i][3]=flf;book.rowData[i][4]=zz;book.rowData[i][5]=lx;
book.rowData[i][6]=jg;book.rowData[i][7]=cbs;book.rowData[i][8]=ym;
book.rowData[i][9]=sjmc;book.rowData[i][10]=cbrq;book.rowData[i][11]=rkrq;
book.rowData[i][12]=kcl;book.rowData[i][13]=jycs;book.rowData[i][14]=tszt;
book.rowData[i][15]=czy;book.rowData[i][16]=zy;
i++;
}
}
if(rbtn6.isSelected())//按类型
{ if(lx.equals(jtfd.getText()))
{ book.rowData[i][0]=tsmc;book.rowData[i][1]=bh;book.rowData[i][2]=txm;
book.rowData[i][3]=flf;book.rowData[i][4]=zz;book.rowData[i][5]=lx;
book.rowData[i][6]=jg;book.rowData[i][7]=cbs;book.rowData[i][8]=ym;
book.rowData[i][9]=sjmc;book.rowData[i][10]=cbrq;book.rowData[i][11]=rkrq;
book.rowData[i][12]=kcl;book.rowData[i][13]=jycs;book.rowData[i][14]=tszt;
book.rowData[i][15]=czy;book.rowData[i][16]=zy;
i++;
}
}
if(rbtn7.isSelected())//按价格
{ if(jg.equals(jtfd.getText()))
{ book.rowData[i][0]=tsmc;book.rowData[i][1]=bh;book.rowData[i][2]=txm;
book.rowData[i][3]=flf;book.rowData[i][4]=zz;book.rowData[i][5]=lx;
book.rowData[i][6]=jg;book.rowData[i][7]=cbs;book.rowData[i][8]=ym;
book.rowData[i][9]=sjmc;book.rowData[i][10]=cbrq;book.rowData[i][11]=rkrq;
book.rowData[i][12]=kcl;book.rowData[i][13]=jycs;book.rowData[i][14]=tszt;
book.rowData[i][15]=czy;book.rowData[i][16]=zy;
i++;
}
}
if(rbtn8.isSelected())//按出版社
{ if(cbs.equals(jtfd.getText()))
{ book.rowData[i][0]=tsmc;book.rowData[i][1]=bh;book.rowData[i][2]=txm;
book.rowData[i][3]=flf;book.rowData[i][4]=zz;book.rowData[i][5]=lx;
book.rowData[i][6]=jg;book.rowData[i][7]=cbs;book.rowData[i][8]=ym;
book.rowData[i][9]=sjmc;book.rowData[i][10]=cbrq;book.rowData[i][11]=rkrq;
book.rowData[i][12]=kcl;book.rowData[i][13]=jycs;book.rowData[i][14]=tszt;
book.rowData[i][15]=czy;book.rowData[i][16]=zy;
i++;
}
}
if(rbtn9.isSelected())//按书架名称
{ if(sjmc.equals(jtfd.getText()))
{ book.rowData[i][0]=tsmc;book.rowData[i][1]=bh;book.rowData[i][2]=txm;
book.rowData[i][3]=flf;book.rowData[i][4]=zz;book.rowData[i][5]=lx;
book.rowData[i][6]=jg;book.rowData[i][7]=cbs;book.rowData[i][8]=ym;
book.rowData[i][9]=sjmc;book.rowData[i][10]=cbrq;book.rowData[i][11]=rkrq;
book.rowData[i][12]=kcl;book.rowData[i][13]=jycs;book.rowData[i][14]=tszt;
book.rowData[i][15]=czy;book.rowData[i][16]=zy;
i++;
}
}
if(rbtn10.isSelected())//按出版日期
{ if(cbrq.equals(jtfd.getText()))
{ book.rowData[i][0]=tsmc;book.rowData[i][1]=bh;book.rowData[i][2]=txm;
book.rowData[i][3]=flf;book.rowData[i][4]=zz;book.rowData[i][5]=lx;
book.rowData[i][6]=jg;book.rowData[i][7]=cbs;book.rowData[i][8]=ym;
book.rowData[i][9]=sjmc;book.rowData[i][10]=cbrq;book.rowData[i][11]=rkrq;
book.rowData[i][12]=kcl;book.rowData[i][13]=jycs;book.rowData[i][14]=tszt;
book.rowData[i][15]=czy;book.rowData[i][16]=zy;
i++;
}
}
if(rbtn11.isSelected())//按入库日期
{ if(rkrq.equals(jtfd.getText()))
{ book.rowData[i][0]=tsmc;book.rowData[i][1]=bh;book.rowData[i][2]=txm;
book.rowData[i][3]=flf;book.rowData[i][4]=zz;book.rowData[i][5]=lx;
book.rowData[i][6]=jg;book.rowData[i][7]=cbs;book.rowData[i][8]=ym;
book.rowData[i][9]=sjmc;book.rowData[i][10]=cbrq;book.rowData[i][11]=rkrq;
book.rowData[i][12]=kcl;book.rowData[i][13]=jycs;book.rowData[i][14]=tszt;
book.rowData[i][15]=czy;book.rowData[i][16]=zy;
i++;
}
}
if(rbtn12.isSelected())//按图书状态
{ if(tszt.equals(jtfd.getText()))
{ book.rowData[i][0]=tsmc;book.rowData[i][1]=bh;book.rowData[i][2]=txm;
book.rowData[i][3]=flf;book.rowData[i][4]=zz;book.rowData[i][5]=lx;
book.rowData[i][6]=jg;book.rowData[i][7]=cbs;book.rowData[i][8]=ym;
book.rowData[i][9]=sjmc;book.rowData[i][10]=cbrq;book.rowData[i][11]=rkrq;
book.rowData[i][12]=kcl;book.rowData[i][13]=jycs;book.rowData[i][14]=tszt;
book.rowData[i][15]=czy;book.rowData[i][16]=zy;
i++;
}
}
}
con.close();
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -