borrowbookinfoframe.java

java小程序

import java.awt.*;
import javax.swing.*;
import javax.swing.table.*;
import javax.swing.event.*;
import java.awt.event.*;
import java.sql.*;
import java.util.Vector;
public class BorrowBookInfoFrame extends JFrame implements ActionListener
{
private Container c;
private JLabel studentNameLabel,bookNameLabel;
private JTextField studentNameText,bookNameText;
private JButton queryButton,exitButton;
private JPanel panel1,panel2;
private JTable table=null;
private DefaultTableModel defaultModel=null;
public  BorrowBookInfoFrame()
{
super("书籍借阅一览");
c=getContentPane();
c.setLayout(new BorderLayout());
studentNameLabel=new JLabel("借阅者",JLabel.CENTER);
bookNameLabel=new JLabel("书名",JLabel.CENTER);
studentNameText=new JTextField(12);
bookNameText=new JTextField(12);
queryButton=new JButton("查询");
exitButton=new JButton("退出");
String[] name={"借阅者","书名","借阅日期","还入日期","备注"};
String[][] data=new String[0][0];
defaultModel=new DefaultTableModel(data,name);
table=new JTable(defaultModel);
table.setPreferredScrollableViewportSize(new Dimension(400,80));
JScrollPane s=new JScrollPane(table);
panel1=new JPanel();

/*panel1.setLayout(new GridLayout(2,3));
panel1.add(studentNameLabel);
panel1.add(studentNameText);
panel1.add(queryButton);
panel1.add(bookNameLabel);
panel1.add(bookNameText);
panel1.add(exitButton);*/

Box box1=Box.createHorizontalBox();
box1.add(studentNameLabel);
box1.add(studentNameText);
box1.add(queryButton);
Box box2=Box.createHorizontalBox();
box2.add(bookNameLabel);
box2.add(bookNameText);
box2.add(exitButton);
Box boxH=Box.createVerticalBox();
boxH.add(box1);
boxH.add(box2);
boxH.add(Box.createVerticalGlue());

panel1.add(boxH);
panel2=new JPanel();
panel2.add(s);
c.add(panel1,BorderLayout.CENTER);
c.add(panel2,BorderLayout.SOUTH);
queryButton.addActionListener(this);
exitButton.addActionListener(this);
setSize(400,300);
setVisible(true);
}

public void actionPerformed(ActionEvent e)
{
int findFlag=0;
if(e.getSource()==exitButton)
this.dispose();
else if(e.getSource()==queryButton)
{
int rowCount=defaultModel.getRowCount()-1;
int j=rowCount;
for(int i=0;i<=rowCount;i++)
{
defaultModel.removeRow(j);//删除rowCount行的数据；
defaultModel.setRowCount(j);//重新设置行数；
j=j-1;
}
if(studentNameText.getText().equals("")&&bookNameText.getText().equals(""))
JOptionPane.showMessageDialog(null,"查询信息不能为空!");
else if(bookNameText.getText().equals(""))
{
//连接数据库
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException e1)
{
System.out.println(e1.getMessage());
}
try
{
Connection con=DriverManager.getConnection("jdbc:odbc:bookbase");
Statement stmt=con.createStatement();
ResultSet rs=stmt.executeQuery("select * from bookBrowse");
while(rs.next())
{
if(studentNameText.getText().equals(rs.getString("StudentName")))
{
findFlag=1;
String s1=studentNameText.getText();
String s2=rs.getString("bookName");
String s3=rs.getString("BorrowDate");
String s4=rs.getString("ReturnDate");
String s5=rs.getString("remarks");
Vector v=new Vector();
v.addElement(s1);
v.addElement(s2);
v.addElement(s3);
v.addElement(s4);
v.addElement(s5);
defaultModel.addRow(v);//添加一行 
}
}
table.revalidate();
stmt.close();
con.close();
if(findFlag==0)
JOptionPane.showMessageDialog(null,"没有此借阅者!");
}
catch(SQLException ex)
{
System.out.println("SQLException:"+ex.getMessage());
}
//连接数据库结束
}
else if(studentNameText.getText().equals(""))
{
//连接数据库
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException e1)
{
System.out.println(e1.getMessage());
}
try
{
Connection con=DriverManager.getConnection("jdbc:odbc:bookbase");
Statement stmt=con.createStatement();
ResultSet rs=stmt.executeQuery("select * from bookBrowse");
while(rs.next())
{
if(bookNameText.getText().equals(rs.getString("bookName")))
{
findFlag=1;
String s1=rs.getString("StudentName");
String s2=bookNameText.getText();
String s3=rs.getString("BorrowDate");
String s4=rs.getString("ReturnDate");
String s5=rs.getString("remarks");
Vector v=new Vector();
v.addElement(s1);
v.addElement(s2);
v.addElement(s3);
v.addElement(s4);
v.addElement(s5);
defaultModel.addRow(v);//添加一行 
}
}
table.revalidate();
stmt.close();
con.close();
if(findFlag==0)
JOptionPane.showMessageDialog(null,"没有此书名!");
}
catch(SQLException ex)
{
System.out.println("SQLException:"+ex.getMessage());
}
//连接数据库结束
}
else 
{
//连接数据库
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException e1)
{
System.out.println(e1.getMessage());
}
try
{
Connection con=DriverManager.getConnection("jdbc:odbc:bookbase");
Statement stmt=con.createStatement();
ResultSet rs=stmt.executeQuery("select * from bookBrowse");
while(rs.next())
{
if(bookNameText.getText().equals(rs.getString("bookName"))&&studentNameText.getText().equals(rs.getString("StudentName")))
{
findFlag=1;
String s1=studentNameText.getText();
String s2=bookNameText.getText();
String s3=rs.getString("BorrowDate");
String s4=rs.getString("ReturnDate");
String s5=rs.getString("remarks");
Vector v=new Vector();
v.addElement(s1);
v.addElement(s2);
v.addElement(s3);
v.addElement(s4);
v.addElement(s5);
defaultModel.addRow(v);//添加一行 
}
}
table.revalidate();
stmt.close();
con.close();
if(findFlag==0)
JOptionPane.showMessageDialog(null,"没有此记录!");
}
catch(SQLException ex)
{
System.out.println("SQLException:"+ex.getMessage());
}
//连接数据库结束
}
}
}
}