bookaddframe.java

java小程序

import java.awt.*;
import javax.swing.*;
import javax.swing.event.*;
import java.awt.event.*;
import java.sql.*;
public class BookAddFrame extends JFrame implements ActionListener
{
private Container c;
private JLabel bookNameLabel,bookPubLabel,bookWriterLabel;
private JLabel addressLabel,bookPubDateLabel,bookPriceLabel,newBookNumLabel,remarksLabel;
private JTextField nameText,pubText,writerText,addressText,dateText,priceText,numText,ramarksText;
private JButton clear,add,exit;
private JPanel panel1,panel2;
public BookAddFrame()
{
super("添加书籍信息");
c=getContentPane();
c.setLayout(new BorderLayout());
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);
newBookNumLabel=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);
numText=new JTextField(12);
ramarksText=new JTextField(12);
clear=new JButton("清空");
add=new JButton("添加");
exit=new JButton("退出");
panel1=new JPanel();
panel1.setLayout(new GridLayout(8,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(newBookNumLabel);
panel1.add(numText);
panel1.add(remarksLabel);
panel1.add(ramarksText);
panel2=new JPanel();
panel2.add(clear);
panel2.add(add);
panel2.add(exit);
clear.addActionListener(this);
add.addActionListener(this);
exit.addActionListener(this);
c.add(panel1,BorderLayout.CENTER);
c.add(panel2,BorderLayout.SOUTH);
setSize(400,300);
setVisible(true);
}
public void actionPerformed(ActionEvent e)
{
String name,pub,writer,address,date,price,num,remarks;
name=nameText.getText();
pub=pubText.getText();
writer=writerText.getText();
address=addressText.getText();
date=dateText.getText();
price=priceText.getText();
num=numText.getText();
remarks=ramarksText.getText();

if(e.getSource()==exit)
{this.dispose();}
else if(e.getSource()==clear)
{
nameText.setText("");
pubText.setText("");
writerText.setText("");
addressText.setText("");
dateText.setText("");
priceText.setText("");
numText.setText("");
ramarksText.setText("");
}
else if(e.getSource()==add)
{
if(name.equals(""))
JOptionPane.showMessageDialog(null,"书名不能为空");
else if(pub.equals(""))
JOptionPane.showMessageDialog(null,"出版社不能为空");
else if(writer.equals(""))
JOptionPane.showMessageDialog(null,"作者不能为空");
else if(address.equals(""))
JOptionPane.showMessageDialog(null,"地址不能为空");
else if(date.equals(""))
JOptionPane.showMessageDialog(null,"出版日期不能为空");
else if(price.equals(""))
JOptionPane.showMessageDialog(null,"价格不能为空");
else if(num.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();
PreparedStatement pstmt=con.prepareStatement("insert into bookInfo values(?,?,?,?,?,?,?,?,?)");
pstmt.setString(1,name);
pstmt.setString(2,pub);
pstmt.setString(3,writer);
pstmt.setString(4,address);
pstmt.setString(5,date);
pstmt.setString(6,price);
pstmt.setString(7,num);
pstmt.setString(8,remarks);
pstmt.setString(9,"0");
pstmt.executeUpdate();
stmt.close();
con.close();
}
catch(SQLException ex)
{
System.out.println("SQLException:"+ex.getMessage());
}
}
}
//连接数据库结束
}
}