bookupdateframe.java

java小程序

import java.awt.*;
import javax.swing.*;
import javax.swing.event.*;
import java.awt.event.*;
import java.sql.*;
public class BookUpdateFrame extends JFrame implements ActionListener
{
private Container c;
private JLabel bookNameLabel,bookPubLabel,bookWriterLabel;
private JLabel addressLabel,bookPubDateLabel,bookPriceLabel,remarksLabel;
private JTextField nameText,pubText,writerText,addressText,dateText,priceText,ramarksText;
private JButton clear,ok,exit,update;
private JPanel panel1,panel2,panel3;
private JLabel messageLabel;

public BookUpdateFrame()
{
super("修改书籍信息");
c=getContentPane();
c.setLayout(new BorderLayout());
messageLabel=new JLabel("输入书名点确定，将调出此书相关信息",JLabel.CENTER);
bookNameLabel=new JLabel("名称",JLabel.CENTER);
bookPubLabel=new JLabel("出版社",JLabel.CENTER);
bookWriterLabel=new JLabel("作者",JLabel.CENTER);
addressLabel=new JLabel("地址",JLabel.CENTER);
bookPubDateLabel=new JLabel("出版日期",JLabel.CENTER);
bookPriceLabel=new JLabel("价格",JLabel.CENTER);
remarksLabel=new JLabel("备注",JLabel.CENTER);
nameText=new JTextField(12);
pubText=new JTextField(12);
writerText=new JTextField(12);
addressText=new JTextField(12);
dateText=new JTextField(12);
priceText=new JTextField(12);
ramarksText=new JTextField(12);
clear=new JButton("清空");
ok=new JButton("确定");
update=new JButton("更新");
exit=new JButton("退出");
panel1=new JPanel();
panel1.setLayout(new GridLayout(7,2));
panel1.add(bookNameLabel);
panel1.add(nameText);
panel1.add(bookPubLabel);
panel1.add(pubText);
panel1.add(bookWriterLabel);
panel1.add(writerText);
panel1.add(addressLabel);
panel1.add(addressText);
panel1.add(bookPubDateLabel);
panel1.add(dateText);
panel1.add(bookPriceLabel);
panel1.add(priceText);
panel1.add(remarksLabel);
panel1.add(ramarksText);
panel2=new JPanel();
panel2.add(clear);
panel2.add(ok);
panel2.add(update);
panel2.add(exit);
panel3=new JPanel();
panel3.add(messageLabel);
clear.addActionListener(this);
ok.addActionListener(this);
update.addActionListener(this);
exit.addActionListener(this);
c.add(panel3,BorderLayout.NORTH);
c.add(panel1,BorderLayout.CENTER);
c.add(panel2,BorderLayout.SOUTH);
setSize(400,300);
setVisible(true);
}
public void actionPerformed(ActionEvent e)
{
int findFlag=0;
if(e.getSource()==exit)
this.dispose();
else if(e.getSource()==clear)
{
nameText.setText("");
pubText.setText("");
writerText.setText("");
addressText.setText("");
dateText.setText("");
priceText.setText("");
ramarksText.setText("");
}
else if(e.getSource()==ok)
{
if(nameText.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 bookInfo");
while(rs.next())
{
if(nameText.getText().equals(rs.getString("bookName")))
{
findFlag=1;
pubText.setText(rs.getString("pubHouse"));
writerText.setText(rs.getString("writer"));
addressText.setText(rs.getString("address"));
dateText.setText(rs.getString("pubDate"));
priceText.setText(rs.getString("price"));
ramarksText.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()==update)
{
//连接数据库
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 bookInfo set pubHouse=?,writer=?,address=?,pubDate=?,price=?,remarks=? where bookName=?");
pstmt.setString(1,pubText.getText());
pstmt.setString(2,writerText.getText());
pstmt.setString(3,addressText.getText());
pstmt.setString(4,dateText.getText());
pstmt.setString(5,priceText.getText());
pstmt.setString(6,ramarksText.getText());
pstmt.setString(7,nameText.getText());
pstmt.executeUpdate();
stmt.close();
con.close();
}
catch(SQLException ex)
{
System.out.println("SQLException:"+ex.getMessage());
}
//数据库连接结束
}
}
}