addstudent.java

来自「主要是对于JAVA的编程的基本语言 希望能够帮得上你。」· Java 代码 · 共 136 行

package exercise;

import javax.swing.*;
import java.awt.event.*;
import java.awt.*;
import java.sql.*;

public class AddStudent extends JFrame{
	
	//声明部分
	JPanel panel1,panel2;
	JLabel lblNumber,lblName,lblSex,lblAge,lblDepartment;
	JTextField txtNumber,txtName,txtSex,txtAge,txtDepartment;
	JButton btnOK,btnCancel,btnExit;
	Connection conn;
	Statement stmt;
	ResultSet rs;		
	
	//构造方法
	public AddStudent(String title){
		super(title);
		initialize();		
	}
	
	private void initialize() {	
		//创建组件
		panel1=new JPanel();
		panel2=new JPanel();
		lblNumber=new JLabel("学号：");
		lblName=new JLabel("姓名：");
		lblSex=new JLabel("性别：");
		lblAge=new JLabel("年龄：");
		lblDepartment=new JLabel("系名：");
		txtNumber=new JTextField("",10);
		txtName=new JTextField("",10);
		txtSex=new JTextField("",5);
		txtAge=new JTextField("",5);
		txtDepartment=new JTextField("",15);
		btnOK=new JButton("确定[O]");
		btnCancel=new JButton("取消[C]");		
		btnExit=new JButton("退出[X]");
		//添加组件	
		this.getContentPane().setLayout(new BorderLayout());
		this.getContentPane().add(panel1,"Center");
		this.getContentPane().add(panel2,"South");
		panel1.setLayout(new GridLayout(5,2));
		panel1.add(lblNumber);
		panel1.add(txtNumber);
		panel1.add(lblName);
		panel1.add(txtName);
		panel1.add(lblSex);
		panel1.add(txtSex);
		panel1.add(lblAge);
		panel1.add(txtAge);
		panel1.add(lblDepartment);
		panel1.add(txtDepartment);
		panel2.add(btnOK);
		panel2.add(btnCancel);		
		panel2.add(btnExit);		
		//设置属性
		this.setSize(500, 300);		
		this.setResizable(false);
		this.pack();
		this.setLocationRelativeTo(null);
		this.setVisible(true);	
		
		btnOK.setMnemonic(KeyEvent.VK_O);
		btnCancel.setMnemonic(KeyEvent.VK_C);
		btnExit.setMnemonic(KeyEvent.VK_X);
		
		//注册监听器，编写事件处理代码
		btnExit.addActionListener(new ActionListener(){		
			public void actionPerformed(ActionEvent arg0) {				
				System.exit(0);
			}			
		});		
		
		btnOK.addActionListener(new ActionListener(){			
			public void actionPerformed(ActionEvent e) {				
				if(txtNumber.getText().trim().equals("")){
					JOptionPane.showMessageDialog(null,"学号不能为空！","增加学生记录",JOptionPane.WARNING_MESSAGE);
					txtNumber.requestFocus();
				}else{
					long number=Long.parseLong(txtNumber.getText().trim());
					String name=txtName.getText().trim();
					String sex=txtSex.getText().trim();
					int age=Integer.parseInt(txtAge.getText().trim());
					String department=txtDepartment.getText().trim();
					String strSQL="insert into studentbase values("+number+
						",'"+name+"', "+age+", '"+sex+"', '"+department+"');";
					try {
						stmt.execute(strSQL);
						JOptionPane.showMessageDialog(null,"添加记录成功！","增加学生记录",JOptionPane.INFORMATION_MESSAGE);
						txtNumber.setText("");
						txtName.setText("");
						txtSex.setText("");
						txtAge.setText("");
						txtDepartment.setText("");
						txtNumber.requestFocus();
					} catch (SQLException e2) {						
						JOptionPane.showMessageDialog(null,e2.getMessage(),"增加学生记录",JOptionPane.ERROR_MESSAGE);
					} catch (Exception e1){
						JOptionPane.showMessageDialog(null,e1.getMessage(),"增加学生记录",JOptionPane.ERROR_MESSAGE);
					}
				}
			}	
		});
		
		btnCancel.addActionListener(new ActionListener(){			
			public void actionPerformed(ActionEvent arg0) {				
								
			}	
		});		
				
		try {
			//安装驱动程序
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
			//连接数据库
			conn=DriverManager.getConnection("jdbc:odbc:student");
			//创建SQL语句
			stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
					ResultSet.CONCUR_UPDATABLE);						
		} catch (ClassNotFoundException e) {			
			JOptionPane.showMessageDialog(null,e.getMessage(),"显示学生表记录",JOptionPane.ERROR_MESSAGE);
		} catch (SQLException e) {			
			JOptionPane.showMessageDialog(null,e.getMessage(),"显示学生表记录",JOptionPane.ERROR_MESSAGE);
		}
		
	}

	public static void main(String[] args) {		
		new AddStudent("增加学生表记录");
	}

}