40d61da63af7001d17c382fc5cbc284e

java做的客房查询系统、 仅供初学者参考！

/*
 * FraBallot.java
 *
 * Created on __DATE__, __TIME__
 */

package Fram;

import java.util.ArrayList;
import Dao.BallotDao;
import DBUtil.DBUtil;

/**
 * 窗口类
 * @author 李锡钧
 *
 */
public class FraBallot extends javax.swing.JFrame {

	/** Creates new form FraBallot */
	public FraBallot() {
		initComponents();
		this.setSize(430, 400);
		this.setResizable(false);
		this.setVisible(true);
	}

	/** This method is called from within the constructor to
	 * initialize the form.
	 * WARNING: Do NOT modify this code. The content of this method is
	 * always regenerated by the Form Editor.
	 */
	//GEN-BEGIN:initComponents
	// <editor-fold defaultstate="collapsed" desc="Generated Code">
	private void initComponents() {

		buttonGroup1 = new javax.swing.ButtonGroup();
		jLabel1 = new javax.swing.JLabel();
		jLabel2 = new javax.swing.JLabel();
		radChina = new javax.swing.JRadioButton();
		radAmerica = new javax.swing.JRadioButton();
		radFrance = new javax.swing.JRadioButton();
		jLabel3 = new javax.swing.JLabel();
		jLabel4 = new javax.swing.JLabel();
		jLabel5 = new javax.swing.JLabel();
		butAdd = new javax.swing.JButton();
		butExit = new javax.swing.JButton();
		labChina = new javax.swing.JLabel();
		labAmerica = new javax.swing.JLabel();
		labFrance = new javax.swing.JLabel();

		setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
		getContentPane().setLayout(null);

		jLabel1.setFont(new java.awt.Font("宋体", 1, 24));
		jLabel1
				.setText("2016\u5e74\u5965\u8fd0\u7533\u529e\u56fd\u5bb6\u6295\u7968\u7cfb\u7edf");
		getContentPane().add(jLabel1);
		jLabel1.setBounds(50, 20, 327, 30);

		jLabel2.setFont(new java.awt.Font("宋体", 1, 14));
		jLabel2
				.setText("\u8bf7\u4e3a\u4f60\u559c\u6b22\u7684\u56fd\u5bb6\u6295\u4e0a\u5b9d\u8d35\u7684\u4e00\u7968\uff1a");
		getContentPane().add(jLabel2);
		jLabel2.setBounds(50, 70, 300, 16);

		buttonGroup1.add(radChina);
		radChina.setFont(new java.awt.Font("宋体", 0, 18));
		radChina.setText("\u4e2d\u56fd");
		getContentPane().add(radChina);
		radChina.setBounds(80, 110, 61, 29);

		buttonGroup1.add(radAmerica);
		radAmerica.setFont(new java.awt.Font("宋体", 0, 18));
		radAmerica.setText("\u7f8e\u56fd");
		getContentPane().add(radAmerica);
		radAmerica.setBounds(80, 150, 61, 29);

		buttonGroup1.add(radFrance);
		radFrance.setFont(new java.awt.Font("宋体", 0, 18));
		radFrance.setText("\u6cd5\u56fd");
		getContentPane().add(radFrance);
		radFrance.setBounds(80, 190, 61, 29);

		jLabel3.setFont(new java.awt.Font("宋体", 0, 18));
		jLabel3.setText("\u7968\u6570\uff1a");
		getContentPane().add(jLabel3);
		jLabel3.setBounds(200, 110, 60, 20);

		jLabel4.setFont(new java.awt.Font("宋体", 0, 18));
		jLabel4.setText("\u7968\u6570\uff1a");
		getContentPane().add(jLabel4);
		jLabel4.setBounds(200, 155, 54, 20);

		jLabel5.setFont(new java.awt.Font("宋体", 0, 18));
		jLabel5.setText("\u7968\u6570\uff1a");
		getContentPane().add(jLabel5);
		jLabel5.setBounds(200, 200, 60, 20);

		butAdd.setFont(new java.awt.Font("宋体", 1, 24));
		butAdd.setText("\u6295\u7968");
		butAdd.addActionListener(new java.awt.event.ActionListener() {
			public void actionPerformed(java.awt.event.ActionEvent evt) {
				butAddActionPerformed(evt);
			}
		});
		getContentPane().add(butAdd);
		butAdd.setBounds(60, 280, 90, 40);

		butExit.setFont(new java.awt.Font("宋体", 1, 24));
		butExit.setText("\u9000\u51fa");
		butExit.addActionListener(new java.awt.event.ActionListener() {
			public void actionPerformed(java.awt.event.ActionEvent evt) {
				butExitActionPerformed(evt);
			}
		});
		getContentPane().add(butExit);
		butExit.setBounds(270, 280, 90, 40);

		labChina.setFont(new java.awt.Font("宋体", 1, 18));
		labChina.setText("0");
		getContentPane().add(labChina);
		labChina.setBounds(280, 110, 40, 20);

		labAmerica.setFont(new java.awt.Font("宋体", 1, 18));
		labAmerica.setText("0");
		getContentPane().add(labAmerica);
		labAmerica.setBounds(280, 155, 40, 20);

		labFrance.setFont(new java.awt.Font("宋体", 1, 18));
		labFrance.setText("0");
		getContentPane().add(labFrance);
		labFrance.setBounds(280, 200, 60, 20);

		pack();
	}// </editor-fold>
	//GEN-END:initComponents

	@SuppressWarnings("unused")
	/**
	 * 退出功能
	 */
	private void butExitActionPerformed(final java.awt.event.ActionEvent evt) {
		FraBallot.this.dispose();
	}
    /**
     * 获得选中的值
     * @return
     */
	public String select() {
		String country = "";
		if (radChina.isSelected()) {
			country = "中国";
		}
		if (radAmerica.isSelected()) {
			country = "美国";
		}
		if (radFrance.isSelected()) {
			country = "法国";
		}
		return country;
	}
    /**
     * 查询票数
     */
	public void queryTicket() {
		BallotDao bd = new BallotDao();

		ArrayList al = bd.queryTicket("中国");
		labChina.setText(al.get(0).toString());

		ArrayList al1 = bd.queryTicket("美国");
		labAmerica.setText(al1.get(0).toString());

		ArrayList al2 = bd.queryTicket("法国");
		labFrance.setText(al2.get(0).toString());

	}

	private void butAddActionPerformed(java.awt.event.ActionEvent evt) {
		String country = select();
		BallotDao bd = new BallotDao();
		if (bd.updateTicket(country)) {
			javax.swing.JOptionPane.showMessageDialog(this, "投票成功！", "成功",
					javax.swing.JOptionPane.INFORMATION_MESSAGE);
			queryTicket();
		} else {
			javax.swing.JOptionPane.showMessageDialog(this, "投票失败！", "失败",
					javax.swing.JOptionPane.ERROR_MESSAGE);

		}

	}

	/**
	 * @param args the command line arguments
	 */
	public static void main(String args[]) {
		java.awt.EventQueue.invokeLater(new Runnable() {
			public void run() {
				new FraBallot().setVisible(true);
			}
		});
	}

	//GEN-BEGIN:variables
	// Variables declaration - do not modify
	private javax.swing.JButton butAdd;
	private javax.swing.JButton butExit;
	private javax.swing.ButtonGroup buttonGroup1;
	private javax.swing.JLabel jLabel1;
	private javax.swing.JLabel jLabel2;
	private javax.swing.JLabel jLabel3;
	private javax.swing.JLabel jLabel4;
	private javax.swing.JLabel jLabel5;
	private javax.swing.JLabel labAmerica;
	private javax.swing.JLabel labChina;
	private javax.swing.JLabel labFrance;
	private javax.swing.JRadioButton radAmerica;
	private javax.swing.JRadioButton radChina;
	private javax.swing.JRadioButton radFrance;
	// End of variables declaration//GEN-END:variables

}