📄 borrowinfof.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 BorrowInfoF extends JFrame implements ActionListener
{ private JFrame frame;
private Statement stmt;
private Connection con;
private JButton btn,btn1;
private JRadioButton rbtn1,rbtn2;
private JComboBox jcb1,jcb2;
private JLabel lb1,lb2;
private JTextField jtfd1,jtfd2;
private BorrowInfomationF borrow;
public BorrowInfoF(BorrowInfomationF borrow)
{
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.borrow=borrow;
//--创建各个组件--
btn=new JButton("执行查询",new ImageIcon("images/findddd.gif"));
btn1=new JButton("执行查询1",new ImageIcon("images/findddd.gif"));
lb1=new JLabel("关键词语:");
lb2=new JLabel("关键词语:");
String[] s1={"读者姓名","读者编号","读者条形码","图书名称","图书编号","图书条形码","图书价格","出版社名称","书架名称","图书类型","借书日期","应还日期","是否续借","是否超期"};
jcb1=new JComboBox(s1);
jcb2=new JComboBox(s1);
jtfd1=new JTextField();
jtfd2=new JTextField();
JPanel pl=new JPanel();
rbtn1=new JRadioButton("模糊查询方式:");
rbtn2=new JRadioButton("精确查询方式:");
//--设置各个组件的事件--
jcb1.addActionListener(this);
jcb2.addActionListener(this);
rbtn1.addActionListener(this);
rbtn2.addActionListener(this);
btn.addActionListener(this);
btn1.addActionListener(this);
//--设置单选按钮组--
ButtonGroup group=new ButtonGroup();
group.add(rbtn1);
group.add(rbtn2);
//--设置各个组件的大小和位置--
rbtn1.setBounds(30,20,120,25);
jcb1.setBounds(160,20,150,25);
lb1.setBounds(60,50,80,25);
jtfd1.setBounds(160,50,150,25);
rbtn2.setBounds(30,80,120,25);
jcb2.setBounds(160,80,150,25);
lb2.setBounds(60,110,80,25);
jtfd2.setBounds(160,110,150,25);
btn.setBounds(100,145,150,40);
btn1.setBounds(100,145,150,40);
//--设置各个组件的字体--
lb1.setFont(font1);
lb2.setFont(font1);
jcb1.setFont(font1);
jcb2.setFont(font1);
rbtn1.setFont(font1);
rbtn2.setFont(font1);
jtfd1.setFont(font1);
jtfd2.setFont(font1);
btn.setFont(font1);
btn1.setFont(font1);
//设置各个组件初始化时不可用
rbtn1.setSelected(true);
jcb2.setEnabled(false);
jtfd2.setEnabled(false);
btn.setVisible(true);
btn1.setVisible(false);
//--添加各个组件--
pl.setLayout(null);
pl.add(rbtn1);
pl.add(jcb1);
pl.add(lb1);
pl.add(jtfd1);
pl.add(rbtn2);
pl.add(jcb2);
pl.add(lb2);
pl.add(jtfd2);
pl.add(btn);
pl.add(btn1);
pl.setBorder(BorderFactory.createLoweredBevelBorder());
pl.setBounds(30,30,300,120);
content.add(pl);
frame.pack();
frame.setBounds(300,200,350,230);
frame.setVisible(true);
}
public void actionPerformed(ActionEvent e)
{Object obj=e.getSource();
if(obj==btn)//执行查询按钮
{ try{ borrow.setnull();}
catch(SQLException ed){}
try{ Query();}
catch(SQLException ed){}
}
if(obj==btn1)//执行查询按钮
{ try{ borrow.setnull();}
catch(SQLException ed){}
try{ Query1();}
catch(SQLException ed){}
}
if(rbtn1.isSelected())//按模糊方式查询
{jcb1.setEnabled(true);
jtfd1.setEnabled(true);
jcb2.setEnabled(false);
jtfd2.setEnabled(false);
btn.setVisible(true);
btn1.setVisible(false);
}
if(rbtn2.isSelected())//按精确方式查询
{jcb1.setEnabled(false);
jtfd1.setEnabled(false);
jcb2.setEnabled(true);
jtfd2.setEnabled(true);
btn.setVisible(false);
btn1.setVisible(true);
}
}
//模糊查询借书统计代码///////////////////////////////////////////////////////////////////////
public void Query() throws SQLException
{ int i=0;
String rs1="";
String like=jtfd1.getText().trim();
String dzxm,dzbh,txm,xb,sf,yxzj,zjhm,zcrq,zxrq,csrq,lxdh,lxdz,dzzt,kjsl,zcqx,jycs,czy,bz;
String strurl =
"jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=DataBase/Library.mdb";
try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");}
catch (ClassNotFoundException e) {}
con= DriverManager.getConnection(strurl);
Statement stmt = con.createStatement();
if(jcb1.getSelectedIndex()==0)//按读者姓名模糊查询
{ rs1="select * from 借书统计 where 读者姓名 LIKE '%"+like+"%'";}
if(jcb1.getSelectedIndex()==1)//按读者编号模糊查询
{ rs1="select * from 借书统计 where 读者编号 LIKE '%"+like+"%'";}
if(jcb1.getSelectedIndex()==2)//按读者条形码模糊查询
{ rs1="select * from 借书统计 where 读者条形码 LIKE '%"+like+"%'";}
if(jcb1.getSelectedIndex()==3)//按图书名称模糊查询
{ rs1="select * from 借书统计 where 图书名称 LIKE '%"+like+"%'";}
if(jcb1.getSelectedIndex()==4)//按图书编号模糊查询
{ rs1="select * from 借书统计 where 图书编号 LIKE '%"+like+"%'";}
if(jcb1.getSelectedIndex()==5)//按图书条形码模糊查询
{ rs1="select * from 借书统计 where 图书条形码 LIKE '%"+like+"%'";}
if(jcb1.getSelectedIndex()==6)//按图书价格模糊查询
{ rs1="select * from 借书统计 where 图书价格 LIKE '%"+like+"%'";}
if(jcb1.getSelectedIndex()==7)//按出版社名称模糊查询
{ rs1="select * from 借书统计 where 出版社 LIKE '%"+like+"%'";}
if(jcb1.getSelectedIndex()==8)//按图书书架名称模糊查询
{ rs1="select * from 借书统计 where 存放位置 LIKE '%"+like+"%'";}
if(jcb1.getSelectedIndex()==9)//按图书类型模糊查询
{ rs1="select * from 借书统计 where 图书类型 LIKE '%"+like+"%'";}
if(jcb1.getSelectedIndex()==10)//按借书日期模糊查询
{ rs1="select * from 借书统计 where 借书日期 LIKE '%"+like+"%'";}
if(jcb1.getSelectedIndex()==11)//按应还日期模糊查询
{ rs1="select * from 借书统计 where 应还日期 LIKE '%"+like+"%'";}
if(jcb1.getSelectedIndex()==12)//按是否续借模糊查询
{ rs1="select * from 借书统计 where 续借 LIKE '%"+like+"%'";}
if(jcb1.getSelectedIndex()==13)//按是否超期查询
{ rs1="select * from 借书统计 where 是否超期 LIKE '%"+like+"%'";}
ResultSet rs=stmt.executeQuery(rs1);
while(rs.next())
{ dzxm=rs.getString("读者姓名");dzbh=rs.getString("读者编号");txm=rs.getString("读者条形码");
xb=rs.getString("图书名称");sf=rs.getString("图书编号");yxzj=rs.getString("图书条形码");zjhm=rs.getString("借阅数量");
zcrq=String.valueOf(rs.getInt("图书价格"));zxrq=rs.getString("出版社");csrq=rs.getString("存放位置");
lxdh=rs.getString("图书类型");lxdz=rs.getString("借书日期");dzzt=rs.getString("应还日期");
zcqx=rs.getString("操作员");jycs=rs.getString("续借");czy=rs.getString("是否超期");
borrow.rowData[i][0]=dzxm;borrow.rowData[i][1]=dzbh;borrow.rowData[i][2]=txm;
borrow.rowData[i][3]=xb;borrow.rowData[i][4]=sf;borrow.rowData[i][5]=yxzj;
borrow.rowData[i][6]=zjhm;borrow.rowData[i][7]=zcrq;borrow.rowData[i][8]=zxrq;
borrow.rowData[i][9]=csrq;borrow.rowData[i][10]=lxdh;borrow.rowData[i][11]=lxdz;
borrow.rowData[i][12]=dzzt;borrow.rowData[i][13]=zcqx;borrow.rowData[i][14]=jycs;
borrow.rowData[i][15]=czy;i++;
}
}
//精确查询借书统计代码///////////////////////////////////////////////////////////////////////
public void Query1() throws SQLException
{ int i=0;
String rs1="";
String sure=jtfd2.getText().trim();
String dzxm,dzbh,txm,xb,sf,yxzj,zjhm,zcrq,zxrq,csrq,lxdh,lxdz,dzzt,kjsl,zcqx,jycs,czy,bz;
String strurl =
"jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=DataBase/Library.mdb";
try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");}
catch (ClassNotFoundException e) {}
con= DriverManager.getConnection(strurl);
Statement stmt = con.createStatement();
if(jcb1.getSelectedIndex()==0)//按读者姓名精确查询
{ rs1="select * from 借书统计 where 读者姓名 ='"+sure+"'";}
if(jcb1.getSelectedIndex()==1)//按读者编号精确查询
{ rs1="select * from 借书统计 where 读者编号 ='"+sure+"'";}
if(jcb1.getSelectedIndex()==2)//按读者条形码精确查询
{ rs1="select * from 借书统计 where 读者条形码 ='"+sure+"'";}
if(jcb1.getSelectedIndex()==3)//按图书名称精确查询
{ rs1="select * from 借书统计 where 图书名称 ='"+sure+"'";}
if(jcb1.getSelectedIndex()==4)//按图书编号精确查询
{ rs1="select * from 借书统计 where 图书编号 ='"+sure+"'";}
if(jcb1.getSelectedIndex()==5)//按图书条形码精确查询
{ rs1="select * from 借书统计 where 图书条形码 ='"+sure+"'";}
if(jcb1.getSelectedIndex()==6)//按图书价格精确查询
{ rs1="select * from 借书统计 where 图书价格 ='"+sure+"'";}
if(jcb1.getSelectedIndex()==7)//按出版社名称精确查询
{ rs1="select * from 借书统计 where 出版社 ='"+sure+"'";}
if(jcb1.getSelectedIndex()==8)//按图书书架名称精确查询
{ rs1="select * from 借书统计 where 存放位置 ='"+sure+"'";}
if(jcb1.getSelectedIndex()==9)//按图书类型精确查询
{ rs1="select * from 借书统计 where 图书类型 ='"+sure+"'";}
if(jcb1.getSelectedIndex()==10)//按借书日期精确查询
{ rs1="select * from 借书统计 where 借书日期 ='"+sure+"'";}
if(jcb1.getSelectedIndex()==11)//按应还日期精确查询
{ rs1="select * from 借书统计 where 应还日期 ='"+sure+"'";}
if(jcb1.getSelectedIndex()==12)//按是否续借精确查询
{ rs1="select * from 借书统计 where 续借 ='"+sure+"'";}
if(jcb1.getSelectedIndex()==13)//按是否超期查询
{ rs1="select * from 借书统计 where 是否超期 ='"+sure+"'";}
ResultSet rs=stmt.executeQuery(rs1);
while(rs.next())
{ dzxm=rs.getString("读者姓名");dzbh=rs.getString("读者编号");txm=rs.getString("读者条形码");
xb=rs.getString("图书名称");sf=rs.getString("图书编号");yxzj=rs.getString("图书条形码");zjhm=rs.getString("借阅数量");
zcrq=String.valueOf(rs.getInt("图书价格"));zxrq=rs.getString("出版社");csrq=rs.getString("存放位置");
lxdh=rs.getString("图书类型");lxdz=rs.getString("借书日期");dzzt=rs.getString("应还日期");
zcqx=rs.getString("操作员");jycs=rs.getString("续借");czy=rs.getString("是否超期");
borrow.rowData[i][0]=dzxm;borrow.rowData[i][1]=dzbh;borrow.rowData[i][2]=txm;
borrow.rowData[i][3]=xb;borrow.rowData[i][4]=sf;borrow.rowData[i][5]=yxzj;
borrow.rowData[i][6]=zjhm;borrow.rowData[i][7]=zcrq;borrow.rowData[i][8]=zxrq;
borrow.rowData[i][9]=csrq;borrow.rowData[i][10]=lxdh;borrow.rowData[i][11]=lxdz;
borrow.rowData[i][12]=dzzt;borrow.rowData[i][13]=zcqx;borrow.rowData[i][14]=jycs;
borrow.rowData[i][15]=czy;i++;
}
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -