bm.java

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

  

import java.awt.BorderLayout;
import javax.swing.JPanel;
import javax.swing.JFrame;
import java.awt.Dimension;
import javax.swing.JButton;
import java.awt.Rectangle;
import javax.swing.JLabel;
import java.awt.Color;
import java.awt.Font;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.text.DateFormat;
import java.text.SimpleDateFormat;
import java.sql.Date;
import java.sql.ResultSet;

import javax.swing.JTextField;




public class bm extends JFrame {

	private static final long serialVersionUID = 1L;

	private static int S_no = 1;
	private JPanel jContentPane = null;

	private JLabel jLabelB1 = null;                                                                                                                    

	private JLabel jLabelB2 = null;

	private JLabel jLabelB3 = null;

	private JLabel jLabelB4 = null;

	private JTextField jTextFieldB1 = null;

	private JTextField jTextFieldB2 = null;

	private JTextField jTextFieldB3 = null;

	private JButton jButtonB1 = null;

	private JButton jButtonB2 = null;
	Connect b=null;

	private JLabel jLabelB5 = null;

	private JLabel jLabelB6 = null;

	private JTextField jTextFieldB4 = null;
	

	public bm() {
		super();
		
		initialize();
	}


	private void initialize() {
		this.setSize(483, 407);
		this.setContentPane(getJContentPane());
		this.setTitle("JFrame");
		this.setVisible(true);
	}


	private JPanel getJContentPane() {
		if (jContentPane == null) {
			jLabelB6 = new JLabel();
			jLabelB6.setBounds(new Rectangle(48, 97, 63, 31));
			jLabelB6.setText("    学号");
			jLabelB5 = new JLabel();
			jLabelB5.setBounds(new Rectangle(142, 244, 173, 23));
			jLabelB5.setText("");
			jLabelB4 = new JLabel();
			jLabelB4.setBounds(new Rectangle(47, 208, 66, 30));
			jLabelB4.setText("  报名时间");
			jLabelB3 = new JLabel();
			jLabelB3.setBounds(new Rectangle(49, 173, 64, 30));
			jLabelB3.setText("   所选课程");
			jLabelB2 = new JLabel();
			jLabelB2.setBounds(new Rectangle(48, 138, 64, 30));
			jLabelB2.setText("    姓名");
			jLabelB1 = new JLabel();
			jLabelB1.setBounds(new Rectangle(34, 15, 406, 46));
			jLabelB1.setForeground(new Color(255, 51, 51));
			jLabelB1.setFont(new Font("\u9ed1\u4f53", Font.BOLD, 24));
			jLabelB1.setText("      请正确输入个人信息");
			jContentPane = new JPanel();
			jContentPane.setLayout(null);
			jContentPane.add(jLabelB1, null);
			jContentPane.add(jLabelB2, null);
			jContentPane.add(jLabelB3, null);
			jContentPane.add(jLabelB4, null);
			jContentPane.add(getJTextFieldB1(), null);
			jContentPane.add(getJTextFieldB2(), null);
			jContentPane.add(getJTextFieldB3(), null);
			jContentPane.add(getJButtonB1(), null);
			jContentPane.add(getJButtonB2(), null);
			jContentPane.add(jLabelB5, null);
			jContentPane.add(jLabelB6, null);
			jContentPane.add(getJTextFieldB4(), null);
		}
		return jContentPane;
	}


	private JTextField getJTextFieldB1() {
		if (jTextFieldB1 == null) {
			jTextFieldB1 = new JTextField();
			jTextFieldB1.setBounds(new Rectangle(139, 137, 178, 29));
		}
		return jTextFieldB1;
	}


	private JTextField getJTextFieldB2() {
		if (jTextFieldB2 == null) {
			jTextFieldB2 = new JTextField();
			jTextFieldB2.setBounds(new Rectangle(141, 175, 175, 29));
		}
		return jTextFieldB2;
	}


	private JTextField getJTextFieldB3() {
		if (jTextFieldB3 == null) {
			jTextFieldB3 = new JTextField();
			jTextFieldB3.setBounds(new Rectangle(141, 210, 175, 27));
		}
		return jTextFieldB3;
	}


	private JButton getJButtonB1() {
		if (jButtonB1 == null) {
			jButtonB1 = new JButton();
			jButtonB1.setBounds(new Rectangle(107, 289, 86, 34));
			jButtonB1.setText("提交");
		}
		jButtonB1.addActionListener(new myframe());
		return jButtonB1;
	}


	private JButton getJButtonB2() {
		if (jButtonB2 == null) {
			jButtonB2 = new JButton();
			jButtonB2.setBounds(new Rectangle(225, 288, 103, 34));
			jButtonB2.setText("返回主页");
		}
		jButtonB2.addActionListener(new myframe());
		return jButtonB2;
	}
	
	
	
	class myframe implements ActionListener
	{
		
		public void actionPerformed(ActionEvent e) {
			
			if(e.getSource() == jButtonB2)
			{
				bm.this.dispose();
				new evil();
			}
			else if(e.getSource() == jButtonB1)
			{	
				b = new Connect();
				ResultSet rs;
				try {
					//String strSQL = ;
					
					//判断
				/*	int count = 0;
					b.ps = b.con.prepareStatement("select S_no from student");
					rs = b.ps.executeQuery();
					rs.next();
						count = rs.getInt("S_no");
						count += 1;
						System.out.println(count + "");
		*/			b.ps = b.con.prepareStatement("select S_no from Student where S_no = ?" );
		            b.ps.setString(1, jTextFieldB4.getText().trim());
		            rs = b.ps.executeQuery();
		            if(rs.next()){
		            	jLabelB5.setText("学号已存在");
		            	return;
		             
		            }
					b.ps = b.con.prepareStatement("select C_name from Course where C_no = ?" );
					b.ps.setString(1, jTextFieldB2.getText().trim());
					rs = b.ps.executeQuery();
					if (!rs.next())
					{
						jLabelB5.setText("没有此课");
						return;
					}
					//System.out.println("kdfjsfhdfkashdfkasdhfksdhfksdf");
					else{
						b.ps = b.con.prepareStatement("INSERT INTO Student(S_no,S_name,S_date) VALUES(?,?,?)");
						b.ps.setString(1,jTextFieldB4.getText().trim() );
						b.ps.setString(2, jTextFieldB1.getText().trim());
						
						///System.out.println("kdfjsfhdfkashdfkasdhfksdhfksdf");
						b.ps.setString(3, jTextFieldB3.getText().trim());
						b.ps.executeUpdate();
					}
					
					b.ps = b.con.prepareStatement("select C_no from Course where C_name = ?");
					b.ps.setString(1, jTextFieldB2.getText().trim());
					rs = b.ps.executeQuery();
					//System.out.println("kdfjsfhdfkashdfkasdhfksdhfksdf");
					//rs = b.ps.executeQuery();
					if (!rs.next())
						return;
					//String str = rs.getString("C_no");
					b.ps = b.con.prepareStatement("INSERT INTO SC(S_no,C_no) VALUES(?,?)");
					
					b.ps.setString(1,jTextFieldB4.getText().trim() );
					b.ps.setString(2, rs.getString("C_no"));
					b.ps.executeUpdate();
					
					b.ps = b.con.prepareStatement("update Course set C_have = C_have + 1 where C_name = ?");
					//System.out.println("kdfjsfhdfkashdfkasdhfksdhfksdf");
					b.ps.setString(1, jTextFieldB2.getText().trim());

					b.ps.executeUpdate();
					System.out.println("success insert");
					b.con.close();
				} catch (Exception e1) {
					System.out.println(e1.toString());
				}

				jLabelB5.setText("报名成功");
			}
		}
	}




	private JTextField getJTextFieldB4() {
		if (jTextFieldB4 == null) {
			jTextFieldB4 = new JTextField();
			jTextFieldB4.setBounds(new Rectangle(140, 97, 178, 33));
		}
		return jTextFieldB4;
	}

}