addstudent.java

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

package database;

import java.sql.*;

import javax.swing.*;

import java.awt.event.*;
import java.awt.*;

public class AddStudent extends JFrame{
	
	//声明部分
	JPanel panel1,panel2;
	JLabel lblNumber,lblName,lblAge,lblSex,lblDepartment;
	JTextField txtNumber,txtName,txtAge,txtSex,txtDepartment;
	JButton btnOK,btnCancel,btnExit;
	Connection conn;
	Statement stmt;
	
	//构造方法
	public AddStudent(String title){
		super(title);
		initialize();
	}
	
	//初始化方法
	private void initialize() {		
		//创建组件
		panel1=new JPanel();
		panel2=new JPanel();
		lblNumber=new JLabel("学号：");
		lblName=new JLabel("姓名：");
		lblAge=new JLabel("年龄：");
		lblSex=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.setResizable(false);
		this.pack();
		this.setLocationRelativeTo(null);
		this.setVisible(true);
		
		try {
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
			conn=DriverManager.getConnection("jdbc:odbc:student");
			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);
		}
		
		//注册监听器，编写事件处理代码
		btnExit.addActionListener(new ActionListener(){
			public void actionPerformed(ActionEvent arg0) {	
				System.exit(0);				
			}			
		});
		
		btnCancel.addActionListener(new ActionListener(){
			public void actionPerformed(ActionEvent arg0) {	
				txtNumber.setText("");
				txtName.setText("");
				txtAge.setText("");
				txtSex.setText("");
				txtDepartment.setText("");
				txtNumber.requestFocus();
			}			
		});		
		
		btnOK.addActionListener(new ActionListener(){
			public void actionPerformed(ActionEvent arg0) {	
				if(txtNumber.getText().trim().equals("")){
					JOptionPane.showMessageDialog(null, "学号不能为空！",
							"增加学生记录",JOptionPane.ERROR_MESSAGE);
					txtNumber.requestFocus();
				}else{
					String strSQL="insert into studentbase values ("
						+Long.parseLong(txtNumber.getText().trim())+", '"
						+txtName.getText().trim()+"', "+
						Integer.parseInt(txtAge.getText().trim())+", '"
						+txtSex.getText().trim()+"', '"
						+txtDepartment.getText().trim()+"')";
					try {
						stmt.execute(strSQL);
						JOptionPane.showMessageDialog(null,"增加记录成功！",
								"添加学生记录",JOptionPane.INFORMATION_MESSAGE);
						txtNumber.setText("");
						txtName.setText("");
						txtAge.setText("");
						txtSex.setText("");
						txtDepartment.setText("");
						txtNumber.requestFocus();
					} catch (SQLException e) {						
						JOptionPane.showMessageDialog(null,e.getMessage(),
								"添加学生记录",JOptionPane.ERROR_MESSAGE);
					}
					
				}
			}			
		});
	}	

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