netservice.java

大型数据库课程设计源码

package com.vbank.operate;

import com.vbank.db.*;
import javax.swing.JPanel;
import java.awt.Frame;
import java.awt.BorderLayout;
import javax.swing.JDialog;
import java.awt.Dimension;
import java.awt.Graphics;
import java.awt.HeadlessException;
import java.awt.Rectangle;
import java.awt.GridBagLayout;
import javax.swing.JLabel;
import java.awt.Point;

import javax.swing.JFrame;
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;
import java.sql.SQLException;
import java.util.Random;
import java.util.StringTokenizer;

public class NetService extends JFrame {

	private static final long serialVersionUID = 1L;
	
	private static Random randGen = null;

	private JPanel jContentPane = null;

	private JPanel jPanel = null;

	private JLabel jLabel = null;

	private JLabel jLabel1 = null;

	private JLabel jLabel2 = null;

	private JTextField jTextField = null;

	private JTextField jTextField1 = null;

	private JTextField jTextField2 = null;

	private JButton jButton = null;

	/**
	 * @param owner
	 */
	public NetService(String f) {
		super(f);
		initialize();
	}

	/**
	 * This method initializes this
	 * 
	 * @return void
	 */
	private void initialize() {
		this.setSize(505, 381);
		this.setLocation(200, 150);
		this.setContentPane(getJContentPane());
	}

	/**
	 * This method initializes jContentPane
	 * 
	 * @return javax.swing.JPanel
	 */
	private JPanel getJContentPane() {
		if (jContentPane == null) {
			jContentPane = new JPanel();
			jContentPane.setLayout(null);
			jContentPane.add(getJPanel(), null);
		}
		return jContentPane;
	}

	/**
	 * This method initializes jPanel	
	 * 	
	 * @return javax.swing.JPanel	
	 */
	private JPanel getJPanel() {
		if (jPanel == null) {
			jLabel2 = new JLabel();
			jLabel2.setText("银行帐号：");
			jLabel2.setLocation(new Point(48, 131));
			jLabel2.setSize(new Dimension(83, 32));
			jLabel1 = new JLabel();
			jLabel1.setText("身份证号码：");
			jLabel1.setLocation(new Point(48, 92));
			jLabel1.setSize(new Dimension(83, 32));
			jLabel = new JLabel();
			jLabel.setText("姓名：");
			jLabel.setSize(new Dimension(82, 32));
			jLabel.setLocation(new Point(48, 53));
			jPanel = new JPanel();
			jPanel.setLayout(null);
			jPanel.setBounds(new Rectangle(7, 16, 476, 338));
			jPanel.setBorder(BorderFactory.createTitledBorder(BorderFactory.createEtchedBorder(EtchedBorder.RAISED), "\u5f00\u901a\u7f51\u4e0a\u670d\u52a1", TitledBorder.CENTER, TitledBorder.DEFAULT_POSITION, new Font("Dialog", Font.PLAIN, 14), Color.green));
			jPanel.add(jLabel, null);
			jPanel.add(jLabel1, null);
			jPanel.add(jLabel2, null);
			jPanel.add(getJTextField(), null);
			jPanel.add(getJTextField1(), null);
			jPanel.add(getJTextField2(), null);
			jPanel.add(getJButton(), null);
			jPanel.add(getJButton1(), null);
		}
		return jPanel;
	}

	/**
	 * This method initializes jTextField	
	 * 	
	 * @return javax.swing.JTextField	
	 */
	private JTextField getJTextField() {
		if (jTextField == null) {
			jTextField = new JTextField();
			jTextField.setLocation(new Point(135, 51));
			jTextField.setSize(new Dimension(212, 32));
		}
		return jTextField;
	}

	/**
	 * This method initializes jTextField1	
	 * 	
	 * @return javax.swing.JTextField	
	 */
	private JTextField getJTextField1() {
		if (jTextField1 == null) {
			jTextField1 = new JTextField();
			jTextField1.setLocation(new Point(135, 92));
			jTextField1.setSize(new Dimension(212, 32));
		}
		return jTextField1;
	}

	/**
	 * This method initializes jTextField2	
	 * 	
	 * @return javax.swing.JTextField	
	 */
	private JTextField getJTextField2() {
		if (jTextField2 == null) {
			jTextField2 = new JTextField();
			jTextField2.setBounds(new Rectangle(135, 133, 212, 32));
		}
		return jTextField2;
	}

	/**
	 * This method initializes jButton	
	 * 	
	 * @return javax.swing.JButton	
	 */
	private JButton getJButton() {
		if (jButton == null) {
			jButton = new JButton();
			jButton.setBounds(new Rectangle(113, 226, 137, 37));
			jButton.setText("开通网上服务");
			jButton.addActionListener(new java.awt.event.ActionListener() {
				public void actionPerformed(java.awt.event.ActionEvent e) {
					openNetService();
				}
			});
		}
		return jButton;
	}
	
	private void openNetService() {
		
		//repaint();
		String name=jTextField.getText().trim();
		String idcard=jTextField1.getText().trim();
		String account=jTextField2.getText().trim();
		if(name==null||idcard==null||account==null) {
			JOptionPane.showMessageDialog(this, 
					"请输入完整信息", "警告", JOptionPane.YES_NO_OPTION);

;
		}else {
			String sql="select * from account a,customer c  where a.accountNum='"+account+
			"' and c.customername='"+name+"' and c.idcard='"+idcard+"' and a.customerid=c.customerid";
			
			DBManager.getConnection();
			java.sql.ResultSet rs=DBManager.executeSelect(sql);
			try {
				if(!rs.next()) {
					JOptionPane.showMessageDialog(this, "帐号不存在", "alert", JOptionPane.ERROR_MESSAGE);
				}else {
					String pwd=pwdCardGen();
					showPwdCard(pwd);
					sql="insert into netbank(customerid,accountnum,passwordcard)values('"+
					rs.getString("customerid").trim()+"','"+rs.getString("accountnum").trim()+"','"+pwd+"')";
					System.out.println(sql);
					DBManager.getConnection();
					DBManager.execInsert(sql);
				}
			} catch (HeadlessException e) {
				// TODO 自动生成 catch 块
				e.printStackTrace();
			} catch (SQLException e) {
				// TODO 自动生成 catch 块
				e.printStackTrace();
			}
		}
	}
	private String pwdCardGen() {
		;
		 
		return randomString(36);
	}
	private boolean showPwdCard(String pwd) {
		PwdDialog d=new PwdDialog(this,pwd);
		return true;
	}
	private static Object initLock = new Object(); 
	private static char c[];

	private JButton jButton1 = null;
	 public  final String randomString(int length) {

         if (length < 1) {
             return null;
         }
         if (randGen == null) {
             synchronized (initLock) {
                 if (randGen == null) {
                     randGen = new Random();
                     c = ("0123456789abcdefghijklmnopqrstuvwxyz" +
                     "0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ").toCharArray();
                 }
             }
         }
         char [] randBuffer = new char[length];
         StringBuffer bf=new StringBuffer();
         
         for (int i=0; i<length; i++) {
             bf.append(c[randGen.nextInt(71)]);
             bf.append(c[randGen.nextInt(71)]);
             if(i<length-1)
            	 bf.append(",");
         }
         return bf.toString();
     }

	/**
	 * This method initializes jButton1	
	 * 	
	 * @return javax.swing.JButton	
	 */
	private JButton getJButton1() {
		if (jButton1 == null) {
			jButton1 = new JButton();
			jButton1.setBounds(new Rectangle(270, 227, 122, 37));
			jButton1.setText("退出");
			jButton1.addActionListener(new java.awt.event.ActionListener() {
				public void actionPerformed(java.awt.event.ActionEvent e) {
					//System.out.println("actionPerformed()"); // TODO Auto-generated Event stub actionPerformed()
					close();
				}
			});
		}
		return jButton1;
	}
	 private void close() {
		 this.dispose();
	 }

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