returninfoframe.java

java小程序

import java.awt.*;
import javax.swing.*;
import javax.swing.event.*;
import java.awt.event.*;
import java.sql.*;
public class ReturnInfoFrame extends JFrame implements ActionListener
{
private Container c;
private JLabel studentNameLabel,bookNameLabel,returnDateLabel,remarksLabel,infoLabel;
private JTextField studentNameText,bookNameText,returnDateText,remarksText;
private JButton clearButton,okButton,cancelButton,updateButton;
private JPanel panel1,panel2,panel3;
public ReturnInfoFrame()
{
super("修改书籍还入信息");
c=getContentPane();
c.setLayout(new BorderLayout());
studentNameLabel=new JLabel("还书者姓名",JLabel.CENTER);
bookNameLabel=new JLabel("书名",JLabel.CENTER);
returnDateLabel=new JLabel("还书日期",JLabel.CENTER);
remarksLabel=new JLabel("备注",JLabel.CENTER);
infoLabel=new JLabel("输入还书者姓名和书名点击确定，将调出此书的相关信息",JLabel.CENTER);
studentNameText=new JTextField(12);
bookNameText=new JTextField(12);
returnDateText=new JTextField(12);
remarksText=new JTextField(12);
clearButton=new JButton("清空");
okButton=new JButton("确定");
updateButton=new JButton("更新");
cancelButton=new JButton("取消");
clearButton.addActionListener(this);
okButton.addActionListener(this);
updateButton.addActionListener(this);
cancelButton.addActionListener(this);
panel1=new JPanel();
panel1.add(infoLabel);
panel2=new JPanel();
panel2.setLayout(new GridLayout(4,2));
panel2.add(studentNameLabel);
panel2.add(studentNameText);
panel2.add(bookNameLabel);
panel2.add(bookNameText);
panel2.add(returnDateLabel);
panel2.add(returnDateText);
panel2.add(remarksLabel);
panel2.add(remarksText);
panel3=new JPanel();
panel3.add(clearButton);
panel3.add(okButton);
panel3.add(updateButton);
panel3.add(cancelButton);
c.add(panel1,BorderLayout.NORTH);
c.add(panel2,BorderLayout.CENTER);
c.add(panel3,BorderLayout.SOUTH);
setSize(400,300);
setVisible(true);
}
public void actionPerformed(ActionEvent e)
{
int findFlag=0;
if(e.getSource()==cancelButton)
this.dispose();
else if(e.getSource()==clearButton)
{
studentNameText.setText("");
bookNameText.setText("");
returnDateText.setText("");
remarksText.setText("");
}
else if(e.getSource()==okButton)
{

if(studentNameText.getText().equals(""))
JOptionPane.showMessageDialog(null,"还书者姓名不能为空!");
else if(bookNameText.getText().equals(""))
JOptionPane.showMessageDialog(null,"书名不能为空!");
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 where Is_Returned=1");
while(rs.next())
{
if(studentNameText.getText().equals(rs.getString("StudentName"))&&bookNameText.getText().equals(rs.getString("bookName")))
{
findFlag=1;
returnDateText.setText(rs.getString("ReturnDate"));
remarksText.setText(rs.getString("remarks"));
break;
}
}
stmt.close();
con.close();
if(findFlag==0)
JOptionPane.showMessageDialog(null,"没有此记录!");
}
catch(SQLException ex)
{
System.out.println("SQLException:"+ex.getMessage());
}
//连接数据库结束
}

}
else if(e.getSource()==updateButton)
{
//连接数据库
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();
PreparedStatement pstmt=con.prepareStatement("update bookBrowse set ReturnDate=?,remarks=? where bookName=? and StudentName=?");
pstmt.setString(1,returnDateText.getText());
pstmt.setString(2,remarksText.getText());
pstmt.setString(3,bookNameText.getText());
pstmt.setString(4,studentNameText.getText());
pstmt.executeUpdate();
stmt.close();
con.close();
}
catch(SQLException ex)
{
System.out.println("SQLException:"+ex.getMessage());
}
//数据库连接结束
}
}
}