deleteitemfromoperationrecord.java

这是一个超市管理系统

package file2;
import java.awt.*;
import javax.swing.*;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.awt.event.ItemEvent;
import java.awt.event.ItemListener;
import java.sql.*;
public class DeleteItemFromoperationRecord extends JPanel implements ActionListener {
	private DBConnection con=null;//声明数据库连接组件
	private JLabel labelOfID=new JLabel("记录ID:");
	private JLabel labelOfName=new JLabel("具体商品名称:");
	private JLabel labelOfQuantity=new JLabel("进(出)货数量:");
	private JLabel labelOfTime=new JLabel("进(出)货时间:");
	private JLabel labelOfOperationState=new JLabel("操作类型:");
	private JTextField textFieldOfID=new JTextField(10);
	private JTextField textFieldOfName=new JTextField(10);
	private JTextField textFieldOfQuantity=new JTextField(10);
	private JTextField textFieldOfTime=new JTextField(10);
	private JTextField textFieldOfOperationState=new JTextField(10);
	private JButton first=new JButton("第一条");
	private JButton previous=new JButton("上一条");
	private JButton next=new JButton("下一条");
	private JButton last=new JButton("最后一条");
	private JButton queryIn=new JButton("查询所有进货记录");
	private JButton queryOut=new JButton("查询所有出货记录");
	private JButton deleteCurrent=new JButton("删除当前记录");
	private JPanel labelAndTextFieldPane=new JPanel();
	private JPanel firstRowButtonsPane=new JPanel();
	private JPanel secondRowButtonsPane=new JPanel();
	private JPanel firstAndSecondButtonsPane=new JPanel();
	private ResultSet rs=null;
	
	public DeleteItemFromoperationRecord(){
		con=new DBConnection();
		labelAndTextFieldPane.setLayout(new GridLayout(5,2));
		labelAndTextFieldPane.add(labelOfID);
		labelAndTextFieldPane.add(textFieldOfID);
		labelAndTextFieldPane.add(labelOfName);
		labelAndTextFieldPane.add(textFieldOfName);
		labelAndTextFieldPane.add(labelOfQuantity);
		labelAndTextFieldPane.add(textFieldOfQuantity);
		labelAndTextFieldPane.add(labelOfTime);
		labelAndTextFieldPane.add(textFieldOfTime);
		labelAndTextFieldPane.add(labelOfOperationState);	
		labelAndTextFieldPane.add(textFieldOfOperationState);
		firstRowButtonsPane.setLayout(new FlowLayout(FlowLayout.LEFT));
		firstRowButtonsPane.add(first);
		firstRowButtonsPane.add(previous);
		firstRowButtonsPane.add(next);
		firstRowButtonsPane.add(last);
		secondRowButtonsPane.setLayout(new FlowLayout(FlowLayout.LEFT));
		secondRowButtonsPane.add(queryIn);
		secondRowButtonsPane.add(queryOut);
		secondRowButtonsPane.add(deleteCurrent);
		//firstAndSecondButtonsPane.setLayout(new GridLayout(2,1));
		firstAndSecondButtonsPane.add(firstRowButtonsPane,BorderLayout.CENTER);
		firstAndSecondButtonsPane.add(secondRowButtonsPane,BorderLayout.SOUTH);
		this.setLayout(new GridLayout(2,1));
		this.add(labelAndTextFieldPane);
		this.add(firstAndSecondButtonsPane);
		first.addActionListener(this);
		previous.addActionListener(this);
		next.addActionListener(this);
		last.addActionListener(this);
		queryIn.addActionListener(this);
		queryOut.addActionListener(this);
		deleteCurrent.addActionListener(this);
		first.setEnabled(false);
		previous.setEnabled(false);
		next.setEnabled(false);
		last.setEnabled(false);
		deleteCurrent.setEnabled(false);
	}
	public void actionPerformed(ActionEvent e){
		if(e.getSource()==queryIn){
			try{
				textFieldOfID.setText("");
				textFieldOfName.setText("");
				textFieldOfQuantity.setText("");
				textFieldOfTime.setText("");
				textFieldOfOperationState.setText("");
				String queryOperationRecord="select* from operationRecord where operationState=0 order by Fourth_ID";
				rs=con.executeSelect1(queryOperationRecord);
				if(!rs.next()){
					JOptionPane.showMessageDialog(null, "数据库中没有任何进货记录!", "提示", JOptionPane.INFORMATION_MESSAGE);
					queryIn.setEnabled(false);
					first.setEnabled(false);
					previous.setEnabled(false);
					next.setEnabled(false);
					last.setEnabled(false);
					deleteCurrent.setEnabled(false);
				}
				rs.beforeFirst();
				int num=0;
				while(rs.next()){
					num++;
				}
				rs.beforeFirst();
				if(rs.next()){
					textFieldOfID.setText((new Integer(rs.getInt(1))).toString());
					textFieldOfName.setText(rs.getString(2));
					textFieldOfQuantity.setText((new Integer(rs.getInt(3))).toString());
					textFieldOfTime.setText(rs.getDate(4).toString());
					if(rs.getString(5).equals("0")){
						textFieldOfOperationState.setText("进货");
					}else{
						textFieldOfOperationState.setText("出货");
					}
				}
				textFieldOfID.setEditable(false);
				textFieldOfName.setEditable(false);
				textFieldOfQuantity.setEditable(false);
				textFieldOfTime.setEditable(false);
				textFieldOfOperationState.setEditable(false);
				if(num==1){
					JOptionPane.showMessageDialog(null, "数据库中只有一条该类型的记录!", "提示", JOptionPane.INFORMATION_MESSAGE);
					previous.setEnabled(false);
					next.setEnabled(false);
					last.setEnabled(false);
					deleteCurrent.setEnabled(true);
				}else if(num>1){
					previous.setEnabled(false);
					next.setEnabled(true);
					last.setEnabled(true);
					deleteCurrent.setEnabled(true);
				}
				first.setEnabled(false);
			}catch(Exception excep){
				excep.printStackTrace();
			}
		}
		if(e.getSource()==queryOut){
			try{
				textFieldOfID.setText("");
				textFieldOfName.setText("");
				textFieldOfQuantity.setText("");
				textFieldOfTime.setText("");
				textFieldOfOperationState.setText("");
				String queryOperationRecord="select* from operationRecord where operationState=1 order by Fourth_ID";
				rs=con.executeSelect1(queryOperationRecord);
				if(!rs.next()){
					JOptionPane.showMessageDialog(null, "数据库中没有任何出货记录!", "提示", JOptionPane.INFORMATION_MESSAGE);
					queryOut.setEnabled(false);
					first.setEnabled(false);
					previous.setEnabled(false);
					next.setEnabled(false);
					last.setEnabled(false);
					deleteCurrent.setEnabled(false);
				}
				rs.beforeFirst();
				int num=0;
				while(rs.next()){
					num++;
				}
				rs.beforeFirst();
				if(rs.next()){
					textFieldOfID.setText((new Integer(rs.getInt(1))).toString());
					textFieldOfName.setText(rs.getString(2));
					textFieldOfQuantity.setText((new Integer(rs.getInt(3))).toString());
					textFieldOfTime.setText(rs.getDate(4).toString());
					if(rs.getString(5).equals("0")){
						textFieldOfOperationState.setText("进货");
					}else{
						textFieldOfOperationState.setText("出货");
					}
				}
				textFieldOfID.setEditable(false);
				textFieldOfName.setEditable(false);
				textFieldOfQuantity.setEditable(false);
				textFieldOfTime.setEditable(false);
				textFieldOfOperationState.setEditable(false);
				if(num==1){
					JOptionPane.showMessageDialog(null, "数据库中只有一条该类型的记录!", "提示", JOptionPane.INFORMATION_MESSAGE);
					previous.setEnabled(false);
					next.setEnabled(false);
					last.setEnabled(false);
					//queryIn.setEnabled(false);
					deleteCurrent.setEnabled(true);
				}else if(num>1){
					previous.setEnabled(false);
					next.setEnabled(true);
					last.setEnabled(true);
					deleteCurrent.setEnabled(true);
				}
				first.setEnabled(false);
			}catch(Exception excep){
				excep.printStackTrace();
			}
		}
		if(e.getSource()==deleteCurrent){
			try{
				String fourthID=textFieldOfID.getText();
				if(fourthID!=null){
					if(!fourthID.equals("")){
						ResultSet set=con.executeSelect("select operationState from operationRecord"+
								" where Fourth_ID="+fourthID);
						if(set.next()){
							String opState=set.getString(1);
							rs=con.executeSelect1("select* from operationRecord where operationState='"+opState+"'");
						}
						con.executeDML("delete from operationRecord where Fourth_ID="+fourthID);
						JOptionPane.showMessageDialog(null, "删除成功!", "提示", JOptionPane.INFORMATION_MESSAGE);
						textFieldOfID.setText("");
						textFieldOfName.setText("");
						textFieldOfQuantity.setText("");
						textFieldOfTime.setText("");
						textFieldOfOperationState.setText("");
					}
				}
			}catch(Exception excep){
				excep.printStackTrace();
			}
			
		}
		if(e.getSource()==first){
			try{
				if(!rs.first()){
					textFieldOfID.setText("");
					textFieldOfName.setText("");
					textFieldOfQuantity.setText("");
					textFieldOfTime.setText("");
					textFieldOfOperationState.setText("");
					return;
				}
				rs.beforeFirst();
				if(rs.next()){
					textFieldOfID.setText((new Integer(rs.getInt(1))).toString());
					textFieldOfName.setText(rs.getString(2));
					textFieldOfQuantity.setText((new Integer(rs.getInt(3))).toString());
					textFieldOfTime.setText(rs.getDate(4).toString());
					if(rs.getString(5).equals("0")){
						textFieldOfOperationState.setText("进货");
					}else{
						textFieldOfOperationState.setText("出货");
					}
				}
				first.setEnabled(false);
				previous.setEnabled(false);
				next.setEnabled(true);
				last.setEnabled(true);
			}catch(Exception excep){
				excep.printStackTrace();
			}
			
		}
		if(e.getSource()==previous){
			try{
				if(!rs.previous()){
					textFieldOfID.setText("");
					textFieldOfName.setText("");
					textFieldOfQuantity.setText("");
					textFieldOfTime.setText("");
					textFieldOfOperationState.setText("");
					return;
				}
				rs.next();
				if(rs.previous()){
					textFieldOfID.setText((new Integer(rs.getInt(1))).toString());
					textFieldOfName.setText(rs.getString(2));
					textFieldOfQuantity.setText((new Integer(rs.getInt(3))).toString());
					textFieldOfTime.setText(rs.getDate(4).toString());
					if(rs.getString(5).equals("0")){
						textFieldOfOperationState.setText("进货");
					}else{
						textFieldOfOperationState.setText("出货");
					}
				}
				if(rs.isFirst()){
					previous.setEnabled(false);
					first.setEnabled(false);
					next.setEnabled(true);
					last.setEnabled(true);
				}else{
					previous.setEnabled(true);
					first.setEnabled(true);
					next.setEnabled(true);
					last.setEnabled(true);
				}
			}catch(Exception excep){
				excep.printStackTrace();
			}
			
		}
		if(e.getSource()==next){
			try{
				if(!rs.next()){
					textFieldOfID.setText("");
					textFieldOfName.setText("");
					textFieldOfQuantity.setText("");
					textFieldOfTime.setText("");
					textFieldOfOperationState.setText("");
					return;
				}
				rs.previous();
				if(rs.next()){
					textFieldOfID.setText((new Integer(rs.getInt(1))).toString());
					textFieldOfName.setText(rs.getString(2));
					textFieldOfQuantity.setText((new Integer(rs.getInt(3))).toString());
					textFieldOfTime.setText(rs.getDate(4).toString());
					if(rs.getString(5).equals("0")){
						textFieldOfOperationState.setText("进货");
					}else{
						textFieldOfOperationState.setText("出货");
					}
				}
				if(rs.isLast()){
					previous.setEnabled(true);
					first.setEnabled(true);
					next.setEnabled(false);
					last.setEnabled(false);
				}else{
					previous.setEnabled(true);
					first.setEnabled(true);
					next.setEnabled(true);
					last.setEnabled(true);
				}
			}catch(Exception excep){
				excep.printStackTrace();
			}
			
		}
		if(e.getSource()==last){
			try{
				if(!rs.last()){
					textFieldOfID.setText("");
					textFieldOfName.setText("");
					textFieldOfQuantity.setText("");
					textFieldOfTime.setText("");
					textFieldOfOperationState.setText("");
					return;
				}
				rs.afterLast();
				if(rs.previous()){
					textFieldOfID.setText((new Integer(rs.getInt(1))).toString());
					textFieldOfName.setText(rs.getString(2));
					textFieldOfQuantity.setText((new Integer(rs.getInt(3))).toString());
					textFieldOfTime.setText(rs.getDate(4).toString());
					if(rs.getString(5).equals("0")){
						textFieldOfOperationState.setText("进货");
					}else{
						textFieldOfOperationState.setText("出货");
					}
				}
				
				first.setEnabled(true);
				previous.setEnabled(true);
				next.setEnabled(false);
				last.setEnabled(false);
			}catch(Exception excep){
				excep.printStackTrace();
			}
			
		}
	}
}