📄 fktj.java
字号:
//超期罚款/挂失图书赔偿统计
import java.awt.*;
import javax.swing.*;
import javax.swing.table.*;
import java.awt.event.*;
import javax.swing.event.*;
import java.sql.*;
import java.io.*;
import java.util.*;
import java.util.Date;
import java.text.SimpleDateFormat;
public class Fktj extends JFrame implements ActionListener
{ public JToolBar JTB;
public JButton btn2,btn3,btn7,btn8,btn9;
public JPanel jp1;
public JTable jta,jta1;
public int bc,rbc,bdc;
public Statement stmt,stmt1,stmt2;
public Connection con,con1,con2;
public Date nowTime;
public SimpleDateFormat matter;
public JFrame frame;
public Object rowData[][],rowData1[][];
public Toolkit tool;
public Dimension wndsize;
public Fktj()
{
JFrame.setDefaultLookAndFeelDecorated(true);
frame=new JFrame("超期罚款/挂失图书赔偿统计");
ImageIcon icon=new ImageIcon("images/home.gif");
frame.setIconImage(icon.getImage());
frame.setResizable(false);
Font font1=new Font("宋体",Font.PLAIN,15);
Container content=frame.getContentPane();
content.setLayout(null);
tool=frame.getToolkit();
wndsize=tool.getScreenSize();
int width=tool.getScreenSize().width;
int height=tool.getScreenSize().height;
//--初始化工具栏各个组件--
btn3=new JButton("升序",new ImageIcon("images/asc.gif"));
btn2=new JButton("降序",new ImageIcon("images/desc.gif"));
btn7=new JButton("打印预览",new ImageIcon("images/text.gif"));
btn8=new JButton("导出数据",new ImageIcon("images/save.gif"));
btn9=new JButton("退出",new ImageIcon("images/ren1.gif"));
//--设置工具栏各个组件的提示--
btn2.setToolTipText("升序排列今日到/超期图书信息");
btn3.setToolTipText("降序排列今日到/超期图书信息");
btn7.setToolTipText("打印预览");
btn8.setToolTipText("导出数据");
btn9.setToolTipText("退出");
//--为工具栏中各个组件添加事件--
btn2.addActionListener(this);
btn3.addActionListener(this);
btn7.addActionListener(this);
btn8.addActionListener(this);
btn9.addActionListener(this);
//--为工具栏中各个组件设置字体--
btn2.setFont(font1);
btn3.setFont(font1);
btn7.setFont(font1);
btn8.setFont(font1);
btn9.setFont(font1);
//--添加工具栏各个组件--
JTB=new JToolBar();
JTB.addSeparator();
JTB.addSeparator();
JTB.add(btn3);
JTB.add(btn2);
JTB.addSeparator();
JTB.add(btn7);
JTB.add(btn8);
JTB.addSeparator();
JTB.add(btn9);
JTB.setFont(font1);
JTB.setFloatable(false);
JTB.setBorder(BorderFactory.createLoweredBevelBorder());
JTB.setBounds(0,2,width-10,45);
//--初始化基本设置各个组件--
Object columnNames[]={"读者编号","读者条形码","读者姓名","图书编号","图书条形码","图书名称","是否超期","超期天数","每日罚金","罚款总额","罚款日期","操作员"};
rowData=new Object[100][12];
jta=new JTable(rowData,columnNames);
jta.setRowHeight(20);
jta.setAutoResizeMode(JTable.AUTO_RESIZE_SUBSEQUENT_COLUMNS);
try{ Query();}
catch(SQLException ed){}
jta.setPreferredScrollableViewportSize(new Dimension(500,30));
JScrollPane scrollPane=new JScrollPane(jta,
JScrollPane.VERTICAL_SCROLLBAR_ALWAYS,
JScrollPane.HORIZONTAL_SCROLLBAR_ALWAYS);
Object columnNames1[]={"图书编号","图书条形码","图书名称","读者编号","读者条形码","读者姓名","丢失数量","丢失时间","是否超期","超期天数","每日罚金","罚款总计","赔偿总额","操作员"};
rowData1=new Object[100][14];
jta1=new JTable(rowData1,columnNames1);
jta1.setRowHeight(20);
jta1.setAutoResizeMode(JTable.AUTO_RESIZE_OFF);
try{ view();}
catch(SQLException ed){}
jta1.setPreferredScrollableViewportSize(new Dimension(500,30));
JScrollPane scrollPane1=new JScrollPane(jta1,
JScrollPane.VERTICAL_SCROLLBAR_ALWAYS,
JScrollPane.HORIZONTAL_SCROLLBAR_ALWAYS);
//--设置各个组件的大小和位置--
scrollPane.setBounds(10,24,width-40,height-450);
scrollPane1.setBounds(10,350,width-40,height-435);
//--设置各个组件的字体--
jta.setFont(font1);
jta1.setFont(font1);
//--将各个组件添加到容器中--
jp1=new JPanel();
jp1.setLayout(null);
jp1.add(scrollPane);
jp1.add(scrollPane1);
jp1.setBorder(
BorderFactory.createCompoundBorder(
BorderFactory.createTitledBorder("查询结果"),
BorderFactory.createLoweredBevelBorder()));
jp1.setBounds(8,45,width-20,height-75);
//--把各个组件添加到窗口中--
content.add(JTB);
content.add(jp1);
frame.setSize(wndsize);
frame.setLocationRelativeTo(null);
frame.setVisible(true);
}
public void actionPerformed(ActionEvent e)
{ Object obj=e.getSource();
if(obj==btn2)//降序按钮事件
{try{ view();}
catch(SQLException ed){}
try{ Query();}
catch(SQLException ed){}
}
if(obj==btn3)//升序按钮事件
{try{ view1();}
catch(SQLException ed){}
try{ Query1();}
catch(SQLException ed){}
}
if(obj==btn7)//打印预览按钮事件
{}
if(obj==btn8)//导出数据按钮事件
{}
if(obj==btn9)//退出按钮事件
{frame.dispose();}
}
/////////////////////设置罚款统计表格为空///////////////////////////////////////////////////////////////////
public void setnull() throws SQLException
{int i=0;
try{
String strurl =
"jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=DataBase/Library.mdb";
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con= DriverManager.getConnection(strurl);
stmt = con.createStatement();
ResultSet rs=stmt.executeQuery("SELECT * From 罚款统计 ");
while(rs.next())
{
rowData[i][0]=null;rowData[i][1]=null;rowData[i][2]=null;
rowData[i][3]=null;rowData[i][4]=null;rowData[i][5]=null;
rowData[i][6]=null;rowData[i][7]=null;rowData[i][8]=null;
rowData[i][9]=null;rowData[i][10]=null;rowData[i][11]=null;
i++;
validate();
}
rowData[i][0]=null;rowData[i][1]=null;rowData[i][2]=null;
rowData[i][3]=null;rowData[i][4]=null;rowData[i][5]=null;
rowData[i][6]=null;rowData[i][7]=null;rowData[i][8]=null;
rowData[i][9]=null;rowData[i][10]=null;rowData[i][11]=null;
jta.repaint();
}
catch(Exception g)
{g.printStackTrace();}
}
//降序显示罚款统计数据库中数据实现代码///////////////////////////////////////////////////////////////////////////////////////////
public void Query() throws SQLException
{ String frbh,frtxm,frname,fbbh,fbtxm,fbname,fchao,fdays,fday,ftotal,fdate,fzcy;
int i=0;
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 罚款统计 ORDER BY 罚款日期 DESC");
while(rs.next())
{ frbh=rs.getString("读者编号");frtxm=rs.getString("读者条形码");frname=rs.getString("读者姓名");
fbbh=rs.getString("图书编号");fbtxm=rs.getString("图书条形码");fbname=rs.getString("图书名称");
fchao=rs.getString("是否超期");fdays=rs.getString("超期天数");fday=rs.getString("每日罚金");ftotal=rs.getString("罚款总额");
fdate=rs.getString("罚款日期");fzcy=rs.getString("操作员");
rowData[i][0]=frbh;rowData[i][1]=frtxm;rowData[i][2]=frname;
rowData[i][3]=fbbh;rowData[i][4]=fbtxm;rowData[i][5]=fbname;
rowData[i][6]=fchao;rowData[i][7]=fdays;rowData[i][8]=fday;
rowData[i][9]=ftotal;rowData[i][10]=fdate;rowData[i][11]=fzcy;
i++;
}
con.close();
}
//升序显示罚款统计数据库中数据实现代码///////////////////////////////////////////////////////////////////////////////////////////
public void Query1() throws SQLException
{ String frbh,frtxm,frname,fbbh,fbtxm,fbname,fchao,fdays,fday,ftotal,fdate,fzcy;
int i=0;
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 罚款统计 ORDER BY 罚款日期 ASC");
while(rs.next())
{ frbh=rs.getString("读者编号");frtxm=rs.getString("读者条形码");frname=rs.getString("读者姓名");
fbbh=rs.getString("图书编号");fbtxm=rs.getString("图书条形码");fbname=rs.getString("图书名称");
fchao=rs.getString("是否超期");fdays=rs.getString("超期天数");fday=rs.getString("每日罚金");ftotal=rs.getString("罚款总额");
fdate=rs.getString("罚款日期");fzcy=rs.getString("操作员");
rowData[i][0]=frbh;rowData[i][1]=frtxm;rowData[i][2]=frname;
rowData[i][3]=fbbh;rowData[i][4]=fbtxm;rowData[i][5]=fbname;
rowData[i][6]=fchao;rowData[i][7]=fdays;rowData[i][8]=fday;
rowData[i][9]=ftotal;rowData[i][10]=fdate;rowData[i][11]=fzcy;
i++;
}
con.close();
}
/////////////////////设置罚款统计为空///////////////////////////////////////////////////////////////////
public void setnull1() throws SQLException
{int i=0;
try{
String strurl =
"jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=DataBase/Library.mdb";
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con= DriverManager.getConnection(strurl);
stmt = con.createStatement();
ResultSet rs=stmt.executeQuery("SELECT * From 挂失图书");
while(rs.next())
{
rowData1[i][0]=null;rowData1[i][1]=null;rowData1[i][2]=null;
rowData1[i][3]=null;rowData1[i][4]=null;rowData1[i][5]=null;
rowData1[i][6]=null;rowData1[i][7]=null;rowData1[i][8]=null;
rowData1[i][9]=null;rowData1[i][10]=null;rowData1[i][11]=null;
rowData1[i][12]=null;rowData1[i][13]=null;
i++;
validate();
}
rowData1[i][0]=null;rowData1[i][1]=null;rowData1[i][2]=null;
rowData1[i][3]=null;rowData1[i][4]=null;rowData1[i][5]=null;
rowData1[i][6]=null;rowData1[i][7]=null;rowData1[i][8]=null;
rowData1[i][9]=null;rowData1[i][10]=null;rowData1[i][11]=null;
rowData1[i][12]=null;rowData1[i][13]=null;
jta1.repaint();
}
catch(Exception g)
{g.printStackTrace();}
}
/////////////////////升序显示数据库续借统计中数据代码///////////////////////////////////////////////////////////////////
public void view1() throws SQLException
{int i=0;
try{ String frbh,frtxm,frname,fbbh,fbtxm,fbname,fcount,fdate,flate,fdays,fday,ftotal,fmoney,fzcy;
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 挂失图书 ORDER BY 丢失时间 ASC");
while(rs.next())
{fbbh=rs.getString("图书编号");fbtxm=rs.getString("图书条形码");fbname=rs.getString("图书名称");
frbh=rs.getString("读者编号");frtxm=rs.getString("读者条形码");frname=rs.getString("读者姓名");
fcount=rs.getString("丢失数量");fdate=rs.getString("丢失时间");flate=rs.getString("是否超期");
fdays=rs.getString("超期天数");fday=rs.getString("每日罚金");ftotal=rs.getString("罚款总计");
fmoney=rs.getString("赔偿金额");fzcy=rs.getString("操作员");
rowData1[i][0]=fbbh;rowData1[i][1]=fbtxm;rowData1[i][2]=fbname;rowData1[i][3]=frbh;
rowData1[i][4]=frtxm;rowData1[i][5]=frname;rowData1[i][6]=fcount;rowData1[i][7]=fdate;
rowData1[i][8]=flate;rowData1[i][9]=fdays;rowData1[i][10]=fday;rowData1[i][11]=ftotal;
rowData1[i][12]=fmoney;rowData1[i][13]=fzcy;
i++;
}
jta1.repaint();
con.close();
}
catch(Exception es)
{es.printStackTrace();}
}
/////////////////////降序显示数据库续借统计中数据代码///////////////////////////////////////////////////////////////////
public void view() throws SQLException
{int i=0;
try{ String frbh,frtxm,frname,fbbh,fbtxm,fbname,fcount,fdate,flate,fdays,fday,ftotal,fmoney,fzcy;
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 挂失图书 ORDER BY 丢失时间 DESC");
while(rs.next())
{fbbh=rs.getString("图书编号");fbtxm=rs.getString("图书条形码");fbname=rs.getString("图书名称");
frbh=rs.getString("读者编号");frtxm=rs.getString("读者条形码");frname=rs.getString("读者姓名");
fcount=rs.getString("丢失数量");fdate=rs.getString("丢失时间");flate=rs.getString("是否超期");
fdays=rs.getString("超期天数");fday=rs.getString("每日罚金");ftotal=rs.getString("罚款总计");
fmoney=rs.getString("赔偿金额");fzcy=rs.getString("操作员");
rowData1[i][0]=fbbh;rowData1[i][1]=fbtxm;rowData1[i][2]=fbname;rowData1[i][3]=frbh;
rowData1[i][4]=frtxm;rowData1[i][5]=frname;rowData1[i][6]=fcount;rowData1[i][7]=fdate;
rowData1[i][8]=flate;rowData1[i][9]=fdays;rowData1[i][10]=fday;rowData1[i][11]=ftotal;
rowData1[i][12]=fmoney;rowData1[i][13]=fzcy;
i++;
}
jta1.repaint();
con.close();
}
catch(Exception es)
{es.printStackTrace();}
}
public static void main(String[]args)
{ try {
UIManager.setLookAndFeel("com.sun.java.swing.plaf.windows.WindowsLookAndFeel");
}
catch(Exception e) {
e.printStackTrace();
}
new Fktj();
}
}⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -