bookadd.java

基于目前许多中小型公司, 机关,中小学校,大学院系等都有自己的图书库, 供内部人员借阅。传统的手工登记办法

import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import java.sql.*;
public class BookAdd extends JFrame implements ActionListener
{

	JPanel panel1,panel2,panel3;
	JLabel BookNameLabel,PressNameLabel,
	       AuthorLabel,BookIdLabel,
	       PressDateLabel,PriceLabel;
	JTextField BookNameTextField,PressNameTextField,
	           AuthorTextField,BookIdTextField,
	           PressDateTextField,PriceTextField;
	Container c;
	JButton ClearBtn,AddBtn,ExitBtn;
	public BookAdd()
	{
		super("添加书籍信息");
		c=getContentPane();
		c.setLayout(null);
		BookIdLabel=new JLabel("编号",JLabel.CENTER);
		BookNameLabel=new JLabel("书名",JLabel.CENTER);
		AuthorLabel=new JLabel("作者",JLabel.CENTER);
		PressNameLabel=new JLabel("出版社",JLabel.CENTER);
		PressDateLabel=new JLabel("出版日期",JLabel.CENTER);
		PriceLabel=new JLabel("价格",JLabel.CENTER);
		BookNameTextField=new JTextField(20);
		PressNameTextField=new JTextField(20);
		AuthorTextField=new JTextField(20);
		BookIdTextField=new JTextField(20);
		PressDateTextField=new JTextField(20);
		PriceTextField=new JTextField(20);
		panel1=new JPanel();
		panel3=new JPanel();
		panel1.setLayout(new GridLayout(6,1));
		panel3.setLayout(new GridLayout(6,1));
		panel1.add(BookIdLabel);
		panel3.add(BookIdTextField);
		panel1.add(BookNameLabel);
		panel3.add(BookNameTextField);
		panel1.add(PressNameLabel);
		panel3.add(PressNameTextField);
		panel1.add(AuthorLabel);
		panel3.add(AuthorTextField);
		panel1.add(PressNameLabel);
		panel3.add(PressNameTextField);
		panel1.add(PressDateLabel);
		panel3.add(PressDateTextField);
		panel1.add(PriceLabel);
		panel3.add(PriceTextField);
		panel1.setBounds(0,0,100,220);
		panel3.setBounds(100,0,220,220);
		panel2=new JPanel();
		panel2.setBounds(10,230,300,30);
		panel2.setLayout(new GridLayout(1,3));
		ClearBtn=new JButton("清空");
		ClearBtn.addActionListener(this);
		AddBtn=new JButton("添加");
		AddBtn.addActionListener(this);
		ExitBtn=new JButton("退出");
		ExitBtn.addActionListener(this);
		panel2.add(ClearBtn);
		panel2.add(AddBtn);
		panel2.add(ExitBtn);
		c.add(panel1);
		c.add(panel3);
		c.add(panel2);
		setBounds(300,300,320,300);
		setVisible(true);
		
		
	}
	public void actionPerformed(ActionEvent e)
	{
		Connection con;
        PreparedStatement sql;
		if(e.getSource()==ExitBtn)
		{
			this.dispose();
		}
		else if(e.getSource()==ClearBtn)
		{
		BookNameTextField.setText("");
		PressNameTextField.setText("");
		AuthorTextField.setText("");
		BookIdTextField.setText("");
		PressDateTextField.setText("");
		PriceTextField.setText("");
		}
		else if(e.getSource()==AddBtn)
		{
			if(BookNameTextField.getText().trim().equals(""))
			{
				JOptionPane.showMessageDialog(null,"书名不能为空！");
			}
			else if(PressNameTextField.getText().trim().equals(""))
			{
				JOptionPane.showMessageDialog(null,"出版社不能为空！");
			}
			else if(AuthorTextField.getText().trim().equals(""))
			{
				JOptionPane.showMessageDialog(null,"作者不能为空！");
			}
			else if(BookIdTextField.getText().trim().equals(""))
			{
				JOptionPane.showMessageDialog(null,"图书编号不能为空！");
			}
	     else
			{
				try {  Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");  
              }
             catch(ClassNotFoundException f){}
             try {  con=DriverManager.getConnection("jdbc:odbc:tushuguan");
             sql=con.prepareStatement("insert into book values (?,?,?,?,?,?,?)");
             String bianhao,worker,name,printe,date,price;
             String s="in";
             bianhao=BookIdTextField.getText();
             name=BookNameTextField.getText();
             worker=AuthorTextField.getText();	
             printe=PressNameTextField.getText();
             date=PressDateTextField.getText();
             price=PriceTextField.getText();
             sql.setString(1,bianhao);
             sql.setString(3,worker);
             sql.setString(2,name);
             sql.setString(4,printe);
             sql.setString(5,date);
             sql.setString(6,price);
             sql.setString(7,s);
             sql.executeUpdate();  
             JOptionPane.showMessageDialog(this,"增加图书成功！","提示对话框",JOptionPane.WARNING_MESSAGE);
    	con.close();
         } 
      catch(SQLException e2) 
           {  System.out.println(e2);
          }
			}
				
		}
		
	}
	public static void main(String args[]){
			BookAdd b=new BookAdd();
			b.show();
		}
}