insert2.java

管理学生信息

import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import java.util.*;
import java.sql.*;
class Insert2 extends JFrame implements ActionListener//插入课程
{
	JTextField text1,text2,text3,text4;
	JLabel label1,label2,label3,label4;
	JButton ok,cancel;
	Insert2(){
		super("添加课程");
		setSize(500,500);
		setLayout(null);
		setVisible(true);
		setBackground(Color.green);
		label1=new JLabel("*请输入课程号:");
		label2=new JLabel("*请输入课程名:");
		label3=new JLabel("*该课程的学分:");
		label4=new JLabel("教该课程的教师:");
		text1=new JTextField();
		text2=new JTextField();
		text3=new JTextField();
		text4=new JTextField();
		add(label1);add(text1);add(label2);
		add(text2);add(label3);add(text3);
		add(label4);add(text4);
		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);
		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)
		{
		Connection con=null;
		Statement sm=null;
		String command=null;
		try{
			//DriverManager.registerDriver(new com.microsoft.jdbc.sqlserver.SQLServerDriver());
			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.getText().trim();
			String str4="'"+text4.getText().trim()+"'";
			command="select * from ch where cno="+str1;
			ResultSet re=sm.executeQuery(command);
			if(re.next())
			{
				JOptionPane.showMessageDialog(this,"该人以在表中!","warring",JOptionPane.WARNING_MESSAGE);
			}
			else{
				command="insert into ch(cno,cname,cgrade,teacher) values("+str1+","+str2+","+str3+","+str4+")";
				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);
		}
	}
}