📄 newbookreport.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 NewBookReport extends JFrame implements ActionListener
{ public JButton btn;
public JPanel jp1;
public JLabel lb1;
public JRadioButton jrb1,jrb2,jrb3;
public ButtonGroup bg;
public JComboBox jcb;
public JTable jta;
public Date nowTime;
public SimpleDateFormat matter;
public Calendar calendar;
public String year1,month1,day1,year,month,day,month2,week1,week2,week3,time,time1,time2;
public String count[];
public Statement stmt;
public Connection con;
public JFrame frame;
public Object rowData[][],rowData1[][];
public NewBookReport()
{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);
Font font2=new Font("宋体",Font.PLAIN,20);
Container content=frame.getContentPane();
content.setLayout(null);
//初始化各个组件
jrb1=new JRadioButton("近一周");
jrb2=new JRadioButton("近一个月");
jrb3=new JRadioButton("近三个月");
jrb1.setSelected(true);
ButtonGroup bg=new ButtonGroup();
bg.add(jrb1);
bg.add(jrb2);
bg.add(jrb3);
lb1=new JLabel("新书分类:");
jcb=new JComboBox();
try{ View();}
catch(SQLException eg){}
btn=new JButton("查询",new ImageIcon("images/find.gif"));
Object columnNames[]={"书名","编号","条形码","分类法","作者","类型","价格","出版社名称","书架名称","页码","出版日期","入库日期","库存量","借阅次数","图书状态","操作员","摘要"};
rowData=new Object[100][17];
jta=new JTable(rowData,columnNames);
jta.setRowHeight(20);
jta.setAutoResizeMode(JTable.AUTO_RESIZE_OFF);
jta.setPreferredScrollableViewportSize(new Dimension(500,30));
JScrollPane scrollPane=new JScrollPane(jta,
JScrollPane.VERTICAL_SCROLLBAR_ALWAYS,
JScrollPane.HORIZONTAL_SCROLLBAR_ALWAYS);
//--设置各个组件的字体--
lb1.setFont(font1);
jrb1.setFont(font1);
jrb2.setFont(font1);
jrb3.setFont(font1);
jcb.setFont(font1);
btn.setFont(font1);
jta.setFont(font1);
//--设置各个组件的大小和位置--
jrb1.setBounds(250,10,100,25);
jrb2.setBounds(360,10,100,25);
jrb3.setBounds(480,10,100,25);
lb1.setBounds(212,48,80,25);
jcb.setBounds(282,48,180,25);
btn.setBounds(480,40,120,40);
scrollPane.setBounds(2,85,785,537);
//设置各个组件的事件
jrb1.addActionListener(this);
jrb2.addActionListener(this);
jrb3.addActionListener(this);
btn.addActionListener(this);
jcb.addActionListener(this);
//添加各个组件
jp1=new JPanel();
jp1.setLayout(null);
jp1.add(jrb1);
jp1.add(jrb2);
jp1.add(jrb3);
jp1.add(lb1);
jp1.add(jcb);
jp1.add(btn);
jp1.add(scrollPane);
jp1.setBorder(BorderFactory.createLoweredBevelBorder());
jp1.setBounds(1,1,790,623);
content.add(jp1);
//定义日期
nowTime=new Date();
matter=new SimpleDateFormat("yyyy-MM-dd");
calendar=Calendar.getInstance();
calendar.setTime(new Date());
year1=String.valueOf(calendar.get(Calendar.YEAR));
month1=String.valueOf(calendar.get(Calendar.MONTH)+1);
day=String.valueOf(calendar.get(Calendar.DAY_OF_MONTH));
day1=String.valueOf(calendar.get(Calendar.DAY_OF_MONTH)-7);//近一周
month=String.valueOf(calendar.get(Calendar.MONTH)-2);//近三月
month2=String.valueOf(calendar.get(Calendar.MONTH));//近一月
if(month1.length()==1)
{time="0"+month1;}
if(month2.length()==1)
week1=year1+"-"+time+"-"+day1;
{time1="0"+month2;}
if(month.length()==1)
if(time1.equals("00"))
{time1=String.valueOf(12-Integer.parseInt(month));year1=String.valueOf(Integer.parseInt(year1)-1);}
week2=year1+"-"+time1+"-"+day;
{time2="0"+month;}
if(time2.equals("00"))
{time2=String.valueOf(12-Integer.parseInt(month));year1=String.valueOf(Integer.parseInt(year1)-1);}
week3=year1+"-"+time2+"-"+day;
frame.setSize(800,658);
frame.setLocationRelativeTo(null);
frame.setVisible(true);
}
public void actionPerformed(ActionEvent e)
{Object obj=e.getSource();
if(obj==btn)
{try{ setnull();}
catch(SQLException eg){}
try{ Query();}
catch(SQLException eg){}
}
}
////////////////////////////////查询图书类型设置信息代码///////////////////////////////////////////////
public void View() throws SQLException
{
try{
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);
Statement stmt= con.createStatement();
ResultSet rs = stmt.executeQuery("select * from 图书类型设置 ORDER BY 编号");
while(rs.next())
{String bianhao=rs.getString(1);
String typename=rs.getString(2);
jcb.addItem(typename);
}
con.close();
}
catch(Exception es)
{es.printStackTrace();}
}
////////////////////////////////查询新书代码///////////////////////////////////////////////
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 e) {}
con= DriverManager.getConnection(strurl);
Statement stmt = con.createStatement();
ResultSet rs=stmt.executeQuery("select * from 图书资料 where 类型 ='"+jcb.getSelectedItem()+"'");
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(jrb1.isSelected())
{if(rkrq.compareTo(week1)>0)
{rowData[i][0]=tsmc;rowData[i][1]=bh;rowData[i][2]=txm;
rowData[i][3]=flf;rowData[i][4]=zz;rowData[i][5]=lx;
rowData[i][6]=jg;rowData[i][7]=cbs;rowData[i][8]=ym;
rowData[i][9]=sjmc;rowData[i][10]=cbrq;rowData[i][11]=rkrq;
rowData[i][12]=kcl;rowData[i][13]=jycs;rowData[i][14]=tszt;
rowData[i][15]=czy;rowData[i][16]=zy;i++;
}
btn.setToolTipText(week1);
}
else if(jrb2.isSelected())
{if(rkrq.compareTo(week2)>0)
{rowData[i][0]=tsmc;rowData[i][1]=bh;rowData[i][2]=txm;
rowData[i][3]=flf;rowData[i][4]=zz;rowData[i][5]=lx;
rowData[i][6]=jg;rowData[i][7]=cbs;rowData[i][8]=ym;
rowData[i][9]=sjmc;rowData[i][10]=cbrq;rowData[i][11]=rkrq;
rowData[i][12]=kcl;rowData[i][13]=jycs;rowData[i][14]=tszt;
rowData[i][15]=czy;rowData[i][16]=zy;i++;
}
btn.setToolTipText(week2);
}
else if(jrb3.isSelected())
{if(rkrq.compareTo(week3)>0)
{rowData[i][0]=tsmc;rowData[i][1]=bh;rowData[i][2]=txm;
rowData[i][3]=flf;rowData[i][4]=zz;rowData[i][5]=lx;
rowData[i][6]=jg;rowData[i][7]=cbs;rowData[i][8]=ym;
rowData[i][9]=sjmc;rowData[i][10]=cbrq;rowData[i][11]=rkrq;
rowData[i][12]=kcl;rowData[i][13]=jycs;rowData[i][14]=tszt;
rowData[i][15]=czy;rowData[i][16]=zy;i++;
}
btn.setToolTipText(week3);
}
}
}
/////////////////////设置图书信息表格为空///////////////////////////////////////////////////////////////////
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;
rowData[i][12]=null;rowData[i][13]=null;rowData[i][14]=null;
rowData[i][15]=null;rowData[i][16]=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;
rowData[i][12]=null;rowData[i][13]=null;rowData[i][14]=null;
rowData[i][15]=null;rowData[i][16]=null;
jta.repaint();
}
catch(Exception g)
{g.printStackTrace();}
}
public static void main(String[]args)
{ try {
UIManager.setLookAndFeel("com.sun.java.swing.plaf.windows.WindowsLookAndFeel");
}
catch(Exception e) {
e.printStackTrace();
}
new NewBookReport();
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -