booklendinfoframe.java

java小程序

import java.awt.*;
import javax.swing.*;
import javax.swing.event.*;
import java.awt.event.*;
import java.sql.*;
public class BookLendInfoFrame extends JFrame implements ActionListener
{
private Container c;
private JLabel infoLabel,userNameLabel,bookNameLabel,lendDateLabel,remarksLabel;
private JTextField userNameText,bookNameText,lendDateText,remarksText;
private JButton clearButton,okButton,updateButton,cancelButton;
private JPanel panel1,panel2,panel3;
public BookLendInfoFrame()
{
super("修改书籍出借信息");
c=getContentPane();
c.setLayout(new BorderLayout());
infoLabel=new JLabel("输入借阅者姓名和书名点击确定，将调出此书的相关信息",JLabel.CENTER);
userNameLabel=new JLabel("借阅者姓名",JLabel.CENTER);
bookNameLabel=new JLabel("书名",JLabel.CENTER);
lendDateLabel=new JLabel("借书日期",JLabel.CENTER);

remarksLabel=new JLabel("备注",JLabel.CENTER);
userNameText=new JTextField(12);
bookNameText=new JTextField(12);
lendDateText=new JTextField(12);

remarksText=new JTextField(12);
clearButton=new JButton("清空");
okButton=new JButton("确定");
updateButton=new JButton("更新");
cancelButton=new JButton("取消");
panel1=new JPanel();
panel1.setLayout(new GridLayout(4,2));
panel1.add(userNameLabel);
panel1.add(userNameText);
panel1.add(bookNameLabel);
panel1.add(bookNameText);
panel1.add(lendDateLabel);
panel1.add(lendDateText);
panel1.add(remarksLabel);
panel1.add(remarksText);
panel2=new JPanel();
panel2.add(clearButton);
panel2.add(okButton);
panel2.add(updateButton);
panel2.add(cancelButton);
clearButton.addActionListener(this);
okButton.addActionListener(this);
updateButton.addActionListener(this);
cancelButton.addActionListener(this);
panel3=new JPanel();
panel3.add(infoLabel);
c.add(panel3,BorderLayout.NORTH);
c.add(panel1,BorderLayout.CENTER);
c.add(panel2,BorderLayout.SOUTH);
setSize(300,250);
setVisible(true);
}
public void actionPerformed(ActionEvent e)
{
int findFlag=0;
String studentName,bookName;
studentName=userNameText.getText();
bookName=bookNameText.getText();
if(e.getSource()==cancelButton)
this.dispose();
else if(e.getSource()==clearButton)
{
userNameText.setText("");
bookNameText.setText("");
lendDateText.setText("");
remarksText.setText("");
}
else if(e.getSource()==okButton)
{
if(userNameText.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=0");
while(rs.next())
{
if(userNameText.getText().equals(rs.getString("StudentName"))&&bookNameText.getText().equals(rs.getString("bookName")))
{
findFlag=1;
lendDateText.setText(rs.getString("BorrowDate"));
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 StudentName=?,bookName=?,BorrowDate=?,remarks=? where bookName=? and StudentName=?");
pstmt.setString(1,userNameText.getText());
pstmt.setString(2,bookNameText.getText());//其实数据没有更改。
pstmt.setString(3,lendDateText.getText());
pstmt.setString(4,remarksText.getText());
pstmt.setString(5,bookName);
pstmt.setString(6,studentName);
pstmt.executeUpdate();
stmt.close();
con.close();
}
catch(SQLException ex)
{
System.out.println("SQLException:"+ex.getMessage());
}
//数据库连接结束
}
}
}