csadd.java

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

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

public class csAdd extends JFrame implements ActionListener
{
	public csAdd()
	{
		setTitle("添加惩罚信息");
		setSize(200,200);
		gl=new GridLayout(8,2,20,20);
		JPanel panel=new JPanel();
		panel.setLayout(gl);
		id=new JLabel("惩罚ID");
		readerid=new JLabel("读者ID");
		bookid=new JLabel("书本ID");
		yy=new JLabel("惩罚原因");
		je=new JLabel("罚款金额");
		jg=new JLabel("惩罚结果");
		zt=new JLabel("状态");
		idtex=new JTextField("");
		readertex=new JTextField("");
		booktex=new JTextField("");
		yytex=new JTextField("");
		jgtex=new JTextField("");
		zttex=new JTextField("");
		String[] str={"1.00","2.00","5.00","10.00","50.00"};
		jecob=new JComboBox(str);
		addbtn=new JButton("确认");
		cancelbtn=new JButton("取消");
		panel.add(id);
		panel.add(idtex);
		panel.add(readerid);
		panel.add(readertex);
		panel.add(bookid);
		panel.add(booktex);
		panel.add(yy);
		panel.add(yytex);
		panel.add(jg);
		panel.add(jgtex);
		panel.add(zt);
		panel.add(zttex);
		panel.add(je);
		panel.add(jecob);
		panel.add(addbtn);
		panel.add(cancelbtn);
		getContentPane().add(panel);
		addbtn.addActionListener(this);
		cancelbtn.addActionListener(this);
	}
	public void actionPerformed(ActionEvent e)
	{
		Object source=e.getSource();
		if(source==addbtn)
		{
			if(idtex.getText().trim().equals(""))
			{
			JOptionPane.showMessageDialog(null,"惩罚ID不能为空!");
			return;
		    }			
			if(readertex.getText().trim().equals(""))
			{
			JOptionPane.showMessageDialog(null,"读者ID不能为空!");
			return;
		    }
		    if(booktex.getText().trim().equals(""))
			{
			JOptionPane.showMessageDialog(null,"书本ID不能为空!");
			return;
		    }
		    if(yytex.getText().trim().equals(""))
			{
			JOptionPane.showMessageDialog(null,"惩罚原因不能为空!");
			return;
		    }
		    String jg=new String(jgtex.getText()).trim();
			if(jg.equals(""))
			{
			jg="";
			}
			String zt=new String(zttex.getText()).trim();
			if(zt.equals(""))
			{
			zt="";
			}
	    	String je=(String)jecob.getSelectedItem();
			{
			String strsql=("insert into 惩罚表(惩罚ID,读者ID,书本ID,惩罚原因,惩罚结果,惩罚金额,状态) values ('"+idtex.getText().trim()+"','"+readertex.getText().trim()+"','"+booktex.getText().trim()+"','"+yytex.getText().trim()+"','"+jg+"','"+je+"','"+zt+"')");
			System.out.println(strsql);
			boolean success=db.executeSql(strsql);
			if(!success){
				JOptionPane.showMessageDialog(null,"惩罚记录添加不成功，请重新再添加");
			}
			else{
				JOptionPane.showMessageDialog(null,"添加成功");
			}
			this.dispose();
		}
		if(source==cancelbtn)
		{
			this.dispose();
			return;
		}
	}
		if(source==cancelbtn)
		{
			
			this.dispose();
			return;
		}
		}
	
	private JLabel id;
	private JLabel readerid;
	private JLabel bookid;
	private JLabel yy;
	private JLabel jg;
	private JLabel je;
	private JLabel zt;
	private JTextField idtex;
	private JTextField readertex;
	private JTextField booktex;
	private JTextField yytex;
	private JTextField jgtex;
	private JTextField zttex;
	private JComboBox jecob;
	private JButton addbtn;
	private JButton cancelbtn;
	private GridLayout gl;
	private ResultSet rs;
	private DBManager db=new DBManager();
}