addprojectmember.java

这是一个用java语言开发的运动员成绩统计系统

package com.insert;

import com.MainFrame;
import com.component.MyFrame;
import java.awt.Dimension;
import java.awt.Rectangle;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.ResultSet;
import java.sql.SQLException;
import javax.swing.JButton;
import javax.swing.JComboBox;
import javax.swing.JLabel;
import javax.swing.JOptionPane;

/**
 * @author  Laiger
 */
public class AddProjectMember extends MyFrame  implements ActionListener{

	private JLabel jLabel1 = null;
	private JComboBox jComboBox1 = null;
	private JLabel jLabel2 = null;
	private JComboBox jComboBox2 = null;
	private JButton add = null;
	private JButton cancel = null;
	/**
	 * This method initializes 
	 * 
	 */
	public AddProjectMember(MainFrame m) {
		super(m);
		initialize();
	}
	public AddProjectMember() {
		super();
		initialize();
	}
	/**
	 * This method initializes this
	 * 
	 */
	private void initialize() {
        jLabel2 = new JLabel();
        jLabel2.setBounds(new Rectangle(24, 82, 60, 28));
        jLabel2.setText("运动员号");
        jLabel1 = new JLabel();
        jLabel1.setBounds(new Rectangle(22, 38, 64, 28));
        jLabel1.setText("项目选择");
        this.setSize(new Dimension(301, 207));
        this.setTitle("添加项目成员");
        this.add(jLabel1, null);
        this.add(getJComboBox1(), null);
        this.add(jLabel2, null);
        this.add(getJComboBox2(), null);
        this.add(getAdd(), null);
        this.add(getCancel(), null);
			
	}

	/**
	 * This method initializes jComboBox1	
	 * @return  javax.swing.JComboBox
	 * @uml.property  name="jComboBox1"
	 */
	private JComboBox getJComboBox1() {
		if (jComboBox1 == null) {
			jComboBox1 = new JComboBox();
			jComboBox1.setBounds(new Rectangle(108, 38, 156, 31));
			
			ResultSet rs=db.executeQuery("select * from project");
			try {
				while(rs.next()){
					jComboBox1.addItem(rs.getString("name"));
				}
			} catch (SQLException e) {
				
				e.printStackTrace();
			}
		}
		return jComboBox1;
	}

	/**
	 * This method initializes jComboBox2	
	 * @return  javax.swing.JComboBox
	 * @uml.property  name="jComboBox2"
	 */
	private JComboBox getJComboBox2() {
		if (jComboBox2 == null) {
			jComboBox2 = new JComboBox();
			jComboBox2.setBounds(new Rectangle(108, 79, 156, 29));
			ResultSet rs=db.executeQuery("select * from Athlete");
			try {
				while(rs.next()){
					jComboBox2.addItem(rs.getString("id"));
				}
			} catch (SQLException e) {
				
				e.printStackTrace();
			}
		}
		return jComboBox2;
	}

	/**
	 * This method initializes add	
	 * @return  javax.swing.JButton
	 * @uml.property  name="add"
	 */
	private JButton getAdd() {
		if (add == null) {
			add = new JButton();
			add.setBounds(new Rectangle(31, 153, 89, 29));
			add.setText("添加");
			add.addActionListener(this);
			
		}
		return add;
	}

	/**
	 * This method initializes cancel	
	 * @return  javax.swing.JButton
	 * @uml.property  name="cancel"
	 */
	private JButton getCancel() {
		if (cancel == null) {
			cancel = new JButton();
			cancel.setBounds(new Rectangle(191, 152, 82, 29));
			cancel.setText("取消");
			cancel.addActionListener(this);
		
		}
		return cancel;
	}

	@Override
	public void actionPerformed(ActionEvent e) {

		String projectID=db.getString("select * from project where name='"+jComboBox1.getSelectedItem().toString().trim()+"'", "id");
		String athlete=jComboBox2.getSelectedItem().toString().trim();
		if(e.getSource()==add)
		{
			ResultSet rs=db.executeQuery("select * from achievement where Projectid='"+projectID+"' and athleteID="+athlete+"");
		    try {
				if(rs.next()){
					JOptionPane.showMessageDialog(this,"已经添加了");
				}
				else{
					
					if(db.executeUpdate("insert into achievement(athleteID,projectID,achievement,score) values("+athlete+",'"+projectID+"',0,0)"))
					{
						if(db.executeUpdate("update project set attendnumber=attendnumber+1 where Id="+projectID+""))
						   JOptionPane.showMessageDialog(this,"添加成功");
						else{
							 db.executeQuery("delete from achievement where athleteID="+athlete+" ");
							
						}
						  
						
					}
					
				}
			}  catch (SQLException e1) {
				
				e1.printStackTrace();
			}
		}
		else{
			db.close();
			if(m!=null)
			m.setVisible(true);
			dispose();
		}
	
		
	}

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