insert.java

管理学生信息

import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import java.util.*;
import java.sql.*;
class Insert extends JFrame implements ActionListener//插入学生记录
{
	JTextField text1,text2;
	Choice text3,text4,text5;
	JLabel label1,label2,label3,label4,label5;
	JButton ok,cancel;
	Insert(){
		super("插入学生记录");
		setSize(500,500);
		setLayout(null);
		setVisible(true);
		setBackground(Color.green);
		label1=new JLabel("*请输入该生学号:");
		label2=new JLabel("*请输入该生姓名:");
		label3=new JLabel("请输入该生性别:");
		label4=new JLabel("该学生出生年份:");
		label5=new JLabel("请输入该生学位:");
		text1=new JTextField();
		text2=new JTextField();
		text3=new Choice();
		text3.addItem("男");
		text3.addItem("女");
		text4=new Choice();
		for(int i=1900;i<2099;i++)
			text4.addItem(String.valueOf(i));
		text5=new Choice();
		text5.addItem("本科生");
		text5.addItem("研究生");
		text5.addItem("博士生");
		add(label1);add(text1);add(label2);
		add(text2);add(label3);add(text3);
		add(label4);add(text4);add(label5);
		add(text5);
		label1.setBounds(50,50,110,30);
		text1.setBounds(180,50,80,30);
		label2.setBounds(50,100,110,30);
		text2.setBounds(180,100,80,30);
		label3.setBounds(50,150,110,30);
		text3.setBounds(180,150,80,30);
		label4.setBounds(40,200,110,30);
		text4.setBounds(180,200,80,30);
		label5.setBounds(50,250,110,30);
		text5.setBounds(180,250,80,30);
		ok=new JButton("确定");
		cancel=new JButton("取消");
		add(cancel);
		add(ok);
		ok.setBounds(40,400,80,20);
		cancel.setBounds(170,400,80,20);
		cancel.addActionListener(this);
		ok.addActionListener(this);
		setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE);
	}
	public void actionPerformed(ActionEvent e)
	{
		if(e.getSource()==ok||e.getSource()==text5)
		{
		Connection con=null;
		Statement sm=null;
		String command=null;
		try{
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
			con=DriverManager.getConnection("jdbc:odbc:student");
		}catch(Exception ex){
				System.out.println(ex.getMessage());
		return;
		}
		try{
			sm=con.createStatement();
			String str1="'"+text1.getText().trim()+"'";
			String str2="'"+text2.getText().trim()+"'";
			String str3="'"+text3.getSelectedItem()+"'";
			String str4="'"+text4.getSelectedItem()+"'";
			String str5="'"+text5.getSelectedItem()+"'";
			command="select * from st where sno="+str1;
			ResultSet re=sm.executeQuery(command);
			if(re.next())
			{
				JOptionPane.showMessageDialog(this,"warring","该人以在表中!",JOptionPane.WARNING_MESSAGE);
			}
			else{
				command="insert into st(sno,sname,sex,birth,degree) values("+str1+","+str2+","+str3+","+str4+","+str5+")";
				sm.executeUpdate(command);
				JOptionPane.showMessageDialog(this,"插入成功","插入成功",JOptionPane.INFORMATION_MESSAGE);
			}
		}catch(Exception ey){
				JOptionPane.showMessageDialog(this,"有带*的空未填入数据","warring",JOptionPane.WARNING_MESSAGE);
		}
		try{
			sm.close();
			con.close();
			dispose();
		}catch(Exception ez){}
		setVisible(false);
		}
		else
		{
			dispose();
			setVisible(false);
		}
	}
}