bookadd.java

图书馆管理系统：该系统的开发主要包括用户登陆

import javax.swing.*;
import java.awt.event.*;
import java.awt.GridLayout;
import java.awt.BorderLayout;
import java.sql.*;

public class BookAdd extends JFrame implements ActionListener
{
	public BookAdd()
	{
		setTitle("添加书籍信息");
		setSize(200,200);
		gl=new GridLayout(11,2,20,20);
		gl2=new GridLayout(1,3,20,20);
		JPanel panel=new JPanel();
		JPanel panel2=new JPanel();
		panel.setLayout(gl);
		panel2.setLayout(gl2);
		bookclassid=new JLabel("书种类ID");
		bookid=new JLabel("书本ID");
		booknamelbl=new JLabel("书名");
	 	authorlbl=new JLabel("作者");
	 	publicnamelbl=new JLabel("出版社");
	 	ZTlbl=new JLabel("论题主题");
	 	publicdatelbl=new JLabel("出版日期(2000-0-0)");
	 	pricelbl=new JLabel("单价");
	 	detaillbl=new JLabel("内容简介");
	 	TMH=new JLabel("条码号");
	 	RGSJ=new JLabel("入馆时间(2000-0-0)");
	 	bookclassidtex=new JTextField("");
	 	bookidtex=new JTextField("");
	    booknametex=new JTextField("");
 		publicnametex=new JTextField("");
 		authortex=new JTextField("");;
 		ZTtex=new JTextField("");
 		publicdatetex=new JTextField("");
 		pricetex=new JTextField("");
 		detailtex=new JTextField("");
 		RGSJtex=new JTextField("");
 		TMHtex=new JTextField("");
		addbtn=new JButton("添加");
		cleanbtn=new JButton("清空");
		cancelbtn=new JButton("取消");
		panel.add(bookclassid);
		panel.add(bookclassidtex);
		panel.add(bookid);
		panel.add(bookidtex);
		panel.add(booknamelbl);
		panel.add(booknametex);
		panel.add(publicnamelbl);
		panel.add(publicnametex);
		panel.add(authorlbl);
		panel.add(authortex);
		panel.add(ZTlbl);
		panel.add(ZTtex);
		panel.add(publicdatelbl);
		panel.add(publicdatetex);
		panel.add(pricelbl);
		panel.add(pricetex);
		panel.add(detaillbl);
		panel.add(detailtex);
		panel.add(RGSJ);
		panel.add(RGSJtex);
		panel.add(TMH);
		panel.add(TMHtex);
		panel2.add(cleanbtn);
		panel2.add(addbtn);
		panel2.add(cancelbtn);
		cleanbtn.addActionListener(this);
		addbtn.addActionListener(this);
		cancelbtn.addActionListener(this);
		
		getContentPane().add(panel,BorderLayout.CENTER);
		getContentPane().add(panel2,BorderLayout.SOUTH);
	}
	public void actionPerformed(ActionEvent e)
	{
		Object source=e.getSource();
		if(source==addbtn)
		{
			String bookclass=new String(bookclassidtex.getText()).trim();
			if(bookclass.equals(""))
			{
			JOptionPane.showMessageDialog(null,"书种类ID不能为空!");
			}
			String bookid=new String(bookidtex.getText()).trim();
			if(bookid.equals(""))
			{
			JOptionPane.showMessageDialog(null,"书本ID不能为空!");
			return;
	    	}
			String bookname=new String(booknametex.getText()).trim();
			if(bookname.equals(""))
			{
			JOptionPane.showMessageDialog(null,"书名不能为空!");
			return;
		}
		    String authorname=new String(authortex.getText()).trim();
			if(authorname.equals(""))
			{
			authorname="不详";
			}
			String publicdate=new String(publicdatetex.getText()).trim();
			if(publicdate.equals(""))
			{
			publicdate="不详";
			}
			String  publicname=new String(publicnametex.getText()).trim();
		if(publicname.equals(""))
		{
			JOptionPane.showMessageDialog(null,"出版社名不能为空!");
			return;
		}
		String ZT=new String(ZTtex.getText()).trim();
			if(ZT.equals(""))
			{
			ZT="不详";
			}
			String  TMH=new String(TMHtex.getText()).trim();
		if(TMH.equals(""))
		{
			JOptionPane.showMessageDialog(null,"条形码号不能为空!");
			return;
		}
			String  RGSJ=new String(RGSJtex.getText()).trim();
		if(RGSJ.equals(""))
		{
			JOptionPane.showMessageDialog(null,"入馆时间不能为空!");
			return;
		}
		String price=new String(pricetex.getText()).trim();
		
		if(price.equals(""))
		{
			JOptionPane.showMessageDialog(null,"价格不能为空");
			return;
		}
		Float fprice=new Float(price);
		String detail=new String(detailtex.getText()).trim();
			if(detail.equals(""))
			{
			detail=" ";
			}
		String strsql,sql;
		strsql=("select * from 图书种类表 where 题名='"+bookname+"' and 出版社='"+publicname+"' and 单价='"+fprice+"'");
		System.out.println(strsql);
		rs=db.getResult(strsql);
		boolean isexist=false;
		try{
			isexist=rs.first();		
		}
		catch(SQLException w)
		{
			System.out.println(w);}
		if(isexist){
			JOptionPane.showMessageDialog(null,"此书已入库");
			return;
		}
		else{
				strsql=("insert into 图书种类表(书种类ID,书本ID,题名,作者,出版社,论题主题,出版时间,单价,内容简介) values('"+bookclass+"','"+bookid+"','"+bookname+"','"+authorname+"','"+publicname+"','"+ZT+"','"+publicdate+"',"+fprice+",'"+detail+"')");
				sql=("insert into 馆藏表(书本ID,书种类ID,入馆时间,条码号) values('"+bookid+"','"+bookclass+"','"+RGSJ+"','"+TMH+"')");
				System.out.println(strsql);
				System.out.println(sql);
				boolean success=db.executeSql(strsql)&db.executeSql(sql);
				if(!success)
				{
					JOptionPane.showMessageDialog(null,"添加不成功，请重试");
				}
				else
					JOptionPane.showMessageDialog(null,"添加成功");
				
			}
			this.dispose();
		}
	if(source==cancelbtn)
		{
			
			this.dispose();
			return;
		}
		if(source==cleanbtn)
		{
			bookclassidtex.setText("");
			bookidtex.setText("");
			booknametex.setText("");
			publicnametex.setText("");
			authortex.setText("");
			ZTtex.setText("");
			publicdatetex.setText("");
			pricetex.setText("");
			detailtex.setText("");
			RGSJtex.setText("");
			return;
		}
	}
	private JLabel bookclassid;
	private JLabel bookid;
	private JLabel booknamelbl;
	private JLabel publicnamelbl;
	private JLabel authorlbl;
	private JLabel ZTlbl;
	private JLabel publicdatelbl;
	private JLabel pricelbl;
	private JLabel detaillbl;
	private JLabel RGSJ;
	private JLabel TMH;
	private JTextField bookclassidtex;
	private JTextField bookidtex;
	private JTextField booknametex;
	private JTextField publicnametex;
	private JTextField authortex;
	private JTextField ZTtex;
	private JTextField publicdatetex;
	private JTextField pricetex;
	private JTextField detailtex;
	private JTextField RGSJtex;
	private JTextField TMHtex;
	private JButton addbtn;
	private JButton cleanbtn;
	private JButton cancelbtn;
	private GridLayout gl;
	private GridLayout gl2;
	private DBManager db=new DBManager();
	private ResultSet rs;
}