restorepanel.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 java.awt.Color;
import javax.swing.border.TitledBorder;
import java.awt.Font;
import java.util.Vector;

public class restorePanel extends JPanel {

	private static final long serialVersionUID = 1L;
	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;
	private JButton jButton1 = null;
	private JLabel jLabel3 = null;
	private JTextField jTextField3 = null;
	/**
	 * This is the default constructor
	 */
	public restorePanel() {
		super();
		initialize();
	}

	/**
	 * This method initializes this
	 * 
	 * @return void
	 */
	private void initialize() {
		jLabel3 = new JLabel();
		jLabel3.setBounds(new Rectangle(78, 89, 115, 32));
		jLabel3.setText("密码：");
		jLabel2 = new JLabel();
		jLabel2.setBounds(new Rectangle(75, 188, 118, 37));
		jLabel2.setText("目的帐户：");
		jLabel1 = new JLabel();
		jLabel1.setBounds(new Rectangle(75, 140, 120, 38));
		jLabel1.setText("转账金额：");
		jLabel = new JLabel();
		jLabel.setBounds(new Rectangle(79, 47, 111, 33));
		jLabel.setText("帐号：");
		this.setSize(482, 343);
		this.setLayout(null);
		this.setBorder(BorderFactory.createTitledBorder(BorderFactory.createMatteBorder(5, 5, 5, 5, Color.black), "\u8f6c\u8d26\u9762\u677f", TitledBorder.CENTER, TitledBorder.DEFAULT_POSITION, new Font("\u5b8b\u4f53", Font.BOLD, 14), Color.darkGray));
		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.add(getJButton1(), null);
		this.add(jLabel3, null);
		this.add(getJTextField3(), null);
	}

	/**
	 * This method initializes jTextField	
	 * 	
	 * @return javax.swing.JTextField	
	 */
	private JTextField getJTextField() {
		if (jTextField == null) {
			jTextField = new JTextField();
			jTextField.setBounds(new Rectangle(196, 45, 209, 38));
		}
		return jTextField;
	}

	/**
	 * This method initializes jTextField1	
	 * 	
	 * @return javax.swing.JTextField	
	 */
	private JTextField getJTextField1() {
		if (jTextField1 == null) {
			jTextField1 = new JTextField();
			jTextField1.setBounds(new Rectangle(197, 140, 207, 39));
		}
		return jTextField1;
	}

	/**
	 * This method initializes jTextField2	
	 * 	
	 * @return javax.swing.JTextField	
	 */
	private JTextField getJTextField2() {
		if (jTextField2 == null) {
			jTextField2 = new JTextField();
			jTextField2.setBounds(new Rectangle(197, 190, 207, 34));
		}
		return jTextField2;
	}

	/**
	 * This method initializes jButton	
	 * 	
	 * @return javax.swing.JButton	
	 */
	private JButton getJButton() {
		if (jButton == null) {
			jButton = new JButton();
			jButton.setBounds(new Rectangle(121, 273, 88, 33));
			jButton.setText("转账");
			jButton.addActionListener(new java.awt.event.ActionListener() {
				public void actionPerformed(java.awt.event.ActionEvent e) {
					System.out.println("actionPerformed()"); // TODO Auto-generated Event stub actionPerformed()
					restore();
				}
			});
		}
		return jButton;
	}
	private void restore() {
		String myAcc=jTextField.getText().trim();
		String pwd=jTextField3.getText().trim();
		String money=jTextField1.getText().trim();
		String destAcc=jTextField2.getText().trim();
		
		System.out.println(money);
		if(myAcc.length()==0||pwd.length()==0||money.length()==0||destAcc.length()==0) {
			JOptionPane.showMessageDialog(this, 
					"本次操作需要填写完整信息", "信息不完整", JOptionPane.ERROR_MESSAGE ); 
			
		}else {
		clear();
		String sql="select * from account where accountNum='"+myAcc+"' and accountPwd='"+pwd+"'";
		DBManager.getConnection();
		int i=DBManager.executeQuery(sql);
		if(i!=0) {
			JOptionPane.showMessageDialog(this, 
					"您的帐号或密码错误", "出错了", JOptionPane.ERROR_MESSAGE ); 
			return;
		}
		sql="select * from account where accountNum='"+destAcc+"'";
		DBManager.getConnection();
		 i=DBManager.executeQuery(sql);
		 if(i!=0) {
				JOptionPane.showConfirmDialog(this, 
						"您要转账到的帐号不存在", "出错了", JOptionPane.ERROR_MESSAGE ); 
			}else {
				float gold=new Float(money).floatValue();
				sql="update account set balance=balance-"+gold+" where accountNum='"+myAcc+"'";
				String sql1="update account set balance=balance+"+gold+" where accountNum='"+destAcc+"'";
				DBManager.getConnection();
				Vector<String> v=new Vector<String>();
				v.add(sql);
				v.add(sql1);
				DBManager.execBatch(v);
				JOptionPane.showConfirmDialog(this, 
						"已经转账,请查看", "ok", JOptionPane.INFORMATION_MESSAGE); 
			}
		}
		clear();
	}
	private void clear() {
		jTextField.setText("");
		jTextField1.setText("");
		jTextField2.setText("");
		jTextField3.setText("");
	}
	/**
	 * This method initializes jButton1	
	 * 	
	 * @return javax.swing.JButton	
	 */
	private JButton getJButton1() {
		if (jButton1 == null) {
			jButton1 = new JButton();
			jButton1.setBounds(new Rectangle(229, 273, 101, 31));
			jButton1.setText("取消");
			jButton1.addActionListener(new java.awt.event.ActionListener() {
				public void actionPerformed(java.awt.event.ActionEvent e) {
					clear(); // TODO Auto-generated Event stub actionPerformed()
				}
			});
		}
		return jButton1;
	}

	/**
	 * This method initializes jTextField3	
	 * 	
	 * @return javax.swing.JTextField	
	 */
	private JTextField getJTextField3() {
		if (jTextField3 == null) {
			jTextField3 = new JTextField();
			jTextField3.setBounds(new Rectangle(197, 94, 209, 36));
		}
		return jTextField3;
	}

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