cashpanel.java

大型数据库课程设计源码

package com.vbank.operate;

import com.vbank.db.*;
import java.awt.GridBagLayout;
import javax.swing.JPanel;
import java.awt.Dimension;
import javax.swing.JLabel;
import java.awt.Rectangle;

import javax.swing.JOptionPane;
import javax.swing.JTextField;
import javax.swing.JButton;
import javax.swing.BorderFactory;
import javax.swing.border.EtchedBorder;
import javax.swing.border.TitledBorder;
import java.awt.Font;
import java.awt.Color;

public class CashPanel extends JPanel {

	private static final long serialVersionUID = 1L;
	
	private static String opnum=null;
	private JLabel jLabel = null;
	private JTextField jTextField = null;
	private JLabel jLabel1 = null;
	private JTextField jTextField1 = null;
	private JLabel jLabel2 = null;
	private JTextField jTextField2 = null;
	private JButton jButton = null;
	/**
	 * This is the default constructor
	 */
	public CashPanel(String operator) {
		super();
		this.opnum=operator;
		initialize();
	}

	/**
	 * This method initializes this
	 * 
	 * @return void
	 */
	private void initialize() {
		jLabel2 = new JLabel();
		jLabel2.setBounds(new Rectangle(17, 141, 68, 33));
		jLabel2.setText("取款金额：");
		jLabel1 = new JLabel();
		jLabel1.setBounds(new Rectangle(20, 95, 65, 33));
		jLabel1.setText("密码：");
		jLabel = new JLabel();
		jLabel.setBounds(new Rectangle(22, 52, 62, 30));
		jLabel.setText("帐号：");
		this.setSize(446, 320);
		this.setLayout(null);
		this.setBorder(BorderFactory.createTitledBorder(BorderFactory.createEtchedBorder(EtchedBorder.LOWERED), "\u53d6\u6b3e", TitledBorder.CENTER, TitledBorder.DEFAULT_POSITION, new Font("\u5b8b\u4f53", Font.BOLD, 14), Color.red));
		this.add(jLabel, null);
		this.add(getJTextField(), null);
		this.add(jLabel1, null);
		this.add(getJTextField1(), null);
		this.add(jLabel2, null);
		this.add(getJTextField2(), null);
		this.add(getJButton(), null);
	}

	/**
	 * This method initializes jTextField	
	 * 	
	 * @return javax.swing.JTextField	
	 */
	private JTextField getJTextField() {
		if (jTextField == null) {
			jTextField = new JTextField();
			jTextField.setBounds(new Rectangle(91, 51, 194, 34));
		}
		return jTextField;
	}

	/**
	 * This method initializes jTextField1	
	 * 	
	 * @return javax.swing.JTextField	
	 */
	private JTextField getJTextField1() {
		if (jTextField1 == null) {
			jTextField1 = new JTextField();
			jTextField1.setBounds(new Rectangle(92, 96, 194, 34));
		}
		return jTextField1;
	}

	/**
	 * This method initializes jTextField2	
	 * 	
	 * @return javax.swing.JTextField	
	 */
	private JTextField getJTextField2() {
		if (jTextField2 == null) {
			jTextField2 = new JTextField();
			jTextField2.setBounds(new Rectangle(92, 140, 193, 33));
		}
		return jTextField2;
	}

	/**
	 * This method initializes jButton	
	 * 	
	 * @return javax.swing.JButton	
	 */
	private JButton getJButton() {
		if (jButton == null) {
			jButton = new JButton();
			jButton.setBounds(new Rectangle(49, 266, 84, 34));
			jButton.setText("取款");
			jButton.addActionListener(new java.awt.event.ActionListener() {
				public void actionPerformed(java.awt.event.ActionEvent e) {
					cash(); // TODO Auto-generated Event stub actionPerformed()
				}
			});
			jButton.addActionListener(new java.awt.event.ActionListener() {
				public void actionPerformed(java.awt.event.ActionEvent e) {
					cash();
				}
			});
		}
		return jButton;
	}
	private void cash() {
		String acc=jTextField.getText().trim();
		String pwd=jTextField1.getText().trim();
		String money=jTextField2.getText().trim();
		System.out.println(acc);
		System.out.println(pwd);
		System.out.println(money);
		if(acc.length()==0||pwd==null||money==null) {
			JOptionPane.showMessageDialog(this, "您需要填写完整信息", "alert", JOptionPane.ERROR_MESSAGE); 
			return;
		}
		float mon=Float.valueOf(money);
		System.out.println("money="+mon);
		 clear();
		String sql="select * from account where accountNum='"+acc+
		"' and accountPwd='"+pwd+"'";
		DBManager.getConnection();
		int i=DBManager.executeQuery(sql);
		//DBManager.releaseCon();
		if(i!=0) {
			JOptionPane.showMessageDialog(this, "帐号或密码错误", "alert", JOptionPane.ERROR_MESSAGE); 
			return;
		}else {
			sql="insert into cashLog(operateNum ,cashMoney,accountNum)"+
			"values('"+opnum+"',"+mon+",'"+acc+"')";
			//DBManager.getConnection();
			DBManager.execInsert(sql);
			//DBManager.releaseCon();
			sql="update account set interests=interests+balance*interest where accountnum='"+acc+"'";
			//DBManager.getConnection();
			DBManager.execUpdate(sql);
			//DBManager.releaseCon();
			sql="update account set balance=balance-"+mon+" where accountNum='"+acc+"'";
				//DBManager.getConnection();
				int t=DBManager.execUpdate(sql);
				DBManager.releaseCon();
			if(t!=0)
				JOptionPane.showMessageDialog(this, "ok");
			
		}
		
		
	}
	private void clear() {
		jTextField.setText("");
		jTextField1.setText("");
		jTextField2.setText("");
	}

}  //  @jve:decl-index=0:visual-constraint="10,10"