📄 readerinfof.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 ReaderInfoF 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 ReaderInfomationF readerf;
public ReaderInfoF(ReaderInfomationF readerf)
{
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.readerf=readerf;
//--创建各个组件--
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{ readerf.setnull();}
catch(SQLException ed){}
try{ Query();}
catch(SQLException ed){}
}
if(obj==btn1)//执行查询按钮
{ try{ readerf.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,borrowed;
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+"%'";}
if(jcb1.getSelectedIndex()==14)//按借阅次数查询
{ rs1="select * from 读者资料 where 借阅次数 LIKE '%"+like+"%'";}
if(jcb1.getSelectedIndex()==15)//按已借数量查询
{ rs1="select * from 读者资料 where 已借数量 LIKE '%"+like+"%'";}
if(jcb1.getSelectedIndex()==16)//按读者状态查询
{ 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=rs.getString("注册日期");zxrq=rs.getString("截止日期");csrq=rs.getString("出生日期");
lxdh=rs.getString("联系电话");lxdz=rs.getString("联系地址");dzzt=rs.getString("读者状态");
kjsl=String.valueOf(rs.getInt("可借数量"));zcqx=String.valueOf(rs.getInt("最长期限"));
jycs=String.valueOf(rs.getInt("借阅次数"));czy=rs.getString("操作员");bz=rs.getString("备注");
borrowed=rs.getString("已借数量");
readerf.rowData[i][0]=dzxm;readerf.rowData[i][1]=dzbh;readerf.rowData[i][2]=txm;
readerf.rowData[i][3]=xb;readerf.rowData[i][4]=sf;readerf.rowData[i][5]=yxzj;
readerf.rowData[i][6]=zjhm;readerf.rowData[i][7]=zcrq;readerf.rowData[i][8]=zxrq;
readerf.rowData[i][9]=csrq;readerf.rowData[i][10]=lxdh;readerf.rowData[i][11]=lxdz;
readerf.rowData[i][12]=dzzt;readerf.rowData[i][13]=kjsl;readerf.rowData[i][14]=zcqx;
readerf.rowData[i][15]=jycs;readerf.rowData[i][16]=czy;readerf.rowData[i][17]=bz;
readerf.rowData[i][18]=borrowed;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,borrowed;
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+"'";}
if(jcb1.getSelectedIndex()==14)//按借阅次数查询
{ rs1="select * from 读者资料 where 借阅次数 ='"+sure+"'";}
if(jcb1.getSelectedIndex()==15)//按已借数量查询
{ rs1="select * from 读者资料 where 已借数量 ='"+sure+"'";}
if(jcb1.getSelectedIndex()==16)//按读者状态查询
{ 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=rs.getString("注册日期");zxrq=rs.getString("截止日期");csrq=rs.getString("出生日期");
lxdh=rs.getString("联系电话");lxdz=rs.getString("联系地址");dzzt=rs.getString("读者状态");
kjsl=String.valueOf(rs.getInt("可借数量"));zcqx=String.valueOf(rs.getInt("最长期限"));
jycs=String.valueOf(rs.getInt("借阅次数"));czy=rs.getString("操作员");bz=rs.getString("备注");
borrowed=rs.getString("已借数量");
readerf.rowData[i][0]=dzxm;readerf.rowData[i][1]=dzbh;readerf.rowData[i][2]=txm;
readerf.rowData[i][3]=xb;readerf.rowData[i][4]=sf;readerf.rowData[i][5]=yxzj;
readerf.rowData[i][6]=zjhm;readerf.rowData[i][7]=zcrq;readerf.rowData[i][8]=zxrq;
readerf.rowData[i][9]=csrq;readerf.rowData[i][10]=lxdh;readerf.rowData[i][11]=lxdz;
readerf.rowData[i][12]=dzzt;readerf.rowData[i][13]=kjsl;readerf.rowData[i][14]=zcqx;
readerf.rowData[i][15]=jycs;readerf.rowData[i][16]=czy;readerf.rowData[i][17]=bz;
readerf.rowData[i][18]=borrowed;i++;
}
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -