zj.java

一个培训中心的招生系统代码 初级代码 仅用于交流

import java.awt.BorderLayout;
import java.awt.Rectangle;

import javax.swing.JButton;
import javax.swing.JLabel;
import javax.swing.JPanel;
import javax.swing.JFrame;
import javax.swing.JTextField;



import java.awt.Dimension;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.ResultSet;

public class ZJ extends JFrame {

	private static final long serialVersionUID = 1L;

	private JPanel jContentPane = null;

	private JTextField jTextFieldX1 = null;

	private JTextField jTextFieldX2 = null;

	private JTextField jTextFieldX3 = null;

	private JTextField jTextFieldX4 = null;

	private JTextField jTextFieldX5 = null;

	private JTextField jTextFieldX6 = null;

	private JTextField jTextFieldX7 = null;

	private JTextField jTextFieldX8 = null;

	private JLabel jLabelX1 = null;

	private JLabel jLabelX2 = null;

	private JLabel jLabelX3 = null;

	private JLabel jLabelX4 = null;

	private JLabel jLabelC5 = null;

	private JLabel jLabelX6 = null;

	private JLabel jLabelX7 = null;

	private JLabel jLabelX8 = null;

	private JLabel jLabelX9 = null;

	private JButton jButtonX1 = null;

	private JButton jButtonX2 = null;

	Connect b=null;
	public ZJ() {
		super();
		initialize();
	}


	private void initialize() {
		this.setSize(451, 387);
		this.setContentPane(getJContentPane());
		this.setTitle("增加课程");
		this.setVisible(true);
	}


	private JPanel getJContentPane() {
		if (jContentPane == null) {
			jLabelX9 = new JLabel();
			jLabelX9.setBounds(new Rectangle(85, 335, 136, 23));
			jLabelX9.setText("");
			jLabelX8 = new JLabel();
			jLabelX8.setBounds(new Rectangle(18, 295, 89, 32));
			jLabelX8.setText("已选人数");
			jLabelX7 = new JLabel();
			jLabelX7.setBounds(new Rectangle(16, 258, 91, 29));
			jLabelX7.setText("课程容量");
			jLabelX6 = new JLabel();
			jLabelX6.setBounds(new Rectangle(18, 219, 90, 27));
			jLabelX6.setText("教师");
			jLabelC5 = new JLabel();
			jLabelC5.setBounds(new Rectangle(18, 175, 90, 28));
			jLabelC5.setText("地点");
			jLabelX4 = new JLabel();
			jLabelX4.setBounds(new Rectangle(17, 134, 92, 32));
			jLabelX4.setText("学费");
			jLabelX3 = new JLabel();
			jLabelX3.setBounds(new Rectangle(17, 92, 90, 31));
			jLabelX3.setText("学时");
			jLabelX2 = new JLabel();
			jLabelX2.setBounds(new Rectangle(19, 55, 88, 27));
			jLabelX2.setText("课名");
			jLabelX1 = new JLabel();
			jLabelX1.setBounds(new Rectangle(20, 14, 86, 24));
			jLabelX1.setText("课号");
			jContentPane = new JPanel();
			jContentPane.setLayout(null);
			jContentPane.add(getJTextFieldX1(), null);
			jContentPane.add(getJTextFieldX2(), null);
			jContentPane.add(getJTextFieldX3(), null);
			jContentPane.add(getJTextFieldX4(), null);
			jContentPane.add(getJTextFieldX5(), null);
			jContentPane.add(getJTextFieldX6(), null);
			jContentPane.add(getJTextFieldX7(), null);
			jContentPane.add(getJTextFieldX8(), null);
			jContentPane.add(jLabelX1, null);
			jContentPane.add(jLabelX2, null);
			jContentPane.add(jLabelX3, null);
			jContentPane.add(jLabelX4, null);
			jContentPane.add(jLabelC5, null);
			jContentPane.add(jLabelX6, null);
			jContentPane.add(jLabelX7, null);
			jContentPane.add(jLabelX8, null);
			jContentPane.add(jLabelX9, null);
			jContentPane.add(getJButtonX1(), null);
			jContentPane.add(getJButtonX2(), null);
		}
		return jContentPane;
	}


	private JTextField getJTextFieldX1() {
		if (jTextFieldX1 == null) {
			jTextFieldX1 = new JTextField();
			jTextFieldX1.setBounds(new Rectangle(152, 12, 225, 25));
		}
		return jTextFieldX1;
	}


	private JTextField getJTextFieldX2() {
		if (jTextFieldX2 == null) {
			jTextFieldX2 = new JTextField();
			jTextFieldX2.setBounds(new Rectangle(153, 53, 227, 27));
		}
		return jTextFieldX2;
	}

	private JTextField getJTextFieldX3() {
		if (jTextFieldX3 == null) {
			jTextFieldX3 = new JTextField();
			jTextFieldX3.setBounds(new Rectangle(154, 95, 226, 27));
		}
		return jTextFieldX3;
	}


	private JTextField getJTextFieldX4() {
		if (jTextFieldX4 == null) {
			jTextFieldX4 = new JTextField();
			jTextFieldX4.setBounds(new Rectangle(154, 134, 227, 29));
		}
		return jTextFieldX4;
	}

	private JTextField getJTextFieldX5() {
		if (jTextFieldX5 == null) {
			jTextFieldX5 = new JTextField();
			jTextFieldX5.setBounds(new Rectangle(154, 176, 228, 29));
		}
		return jTextFieldX5;
	}


	private JTextField getJTextFieldX6() {
		if (jTextFieldX6 == null) {
			jTextFieldX6 = new JTextField();
			jTextFieldX6.setBounds(new Rectangle(156, 213, 225, 28));
		}
		return jTextFieldX6;
	}

	
	private JTextField getJTextFieldX7() {
		if (jTextFieldX7 == null) {
			jTextFieldX7 = new JTextField();
			jTextFieldX7.setBounds(new Rectangle(157, 254, 226, 31));
		}
		return jTextFieldX7;
	}

	
	private JTextField getJTextFieldX8() {
		if (jTextFieldX8 == null) {
			jTextFieldX8 = new JTextField();
			jTextFieldX8.setBounds(new Rectangle(156, 297, 229, 29));
		}
		return jTextFieldX8;
	}

	
	private JButton getJButtonX1() {
		if (jButtonX1 == null) {
			jButtonX1 = new JButton();
			jButtonX1.setBounds(new Rectangle(274, 333, 74, 26));
			jButtonX1.setText("提交");
		}
		jButtonX1.addActionListener(new myframe());
		return jButtonX1;
	}

	
	private JButton getJButtonX2() {
		if (jButtonX2 == null) {
			jButtonX2 = new JButton();
			jButtonX2.setBounds(new Rectangle(365, 332, 72, 28));
			jButtonX2.setText("返回");
		}
		jButtonX2.addActionListener(new myframe());
		return jButtonX2;
	}
	class myframe implements ActionListener
	{

		public void actionPerformed(ActionEvent e) {
			
			if(e.getSource() == jButtonX1)
			{
				b = new Connect();
				ResultSet rs;
				try {
					b.ps = b.con.prepareStatement("select C_no from Course where C_no = ?" );
					b.ps.setString(1, jTextFieldX1.getText().trim());
					rs = b.ps.executeQuery();
					if (rs.next())
					{
						jLabelX9.setText("已有此课");
						return;
					}
					
					b.ps = b.con.prepareStatement("insert into Course (C_no,C_name,C_period,C_charge,C_place,C_teacher,C_capacity,C_have) values(?,?,?,?,?,?,?,?)");
					b.ps.setString(1, jTextFieldX1.getText().trim()); 
					b.ps.setString(2, jTextFieldX2.getText().trim());
					b.ps.setString(3, jTextFieldX3.getText().trim());
					b.ps.setString(4, jTextFieldX4.getText().trim());
					b.ps.setString(5, jTextFieldX5.getText().trim());
					b.ps.setString(6, jTextFieldX6.getText().trim());
					b.ps.setString(7, jTextFieldX7.getText().trim());
					b.ps.setString(8, jTextFieldX8.getText().trim());
					b.ps.executeUpdate();
					b.con.close();
				}catch (Exception e1) {
					jLabelX9.setText("添加未成功");
				}
				
				jLabelX9.setText("添加成功");
			}
		
			else if(e.getSource() == jButtonX2)
			{
				ZJ.this.dispose();
				new evil();
			}
		}
	}
}