add2.java

管理学生信息

import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import java.util.*;
import java.sql.*;
class Add2 extends JFrame implements ActionListener//添加成绩
{
	Choice text1;
	JLabel label1,label2;//,label3;
	JButton ok,cancel;
	JTextField text2;
	Add2(){
		super("添加任课教师");
		setSize(500,500);
		setLayout(new BorderLayout());
		setVisible(true);
		Connection con=null;
		Statement sm=null;
		String command=null;
		ResultSet rs=null;

		setBackground(Color.green);
		label1=new JLabel("课程名:");
		label2=new JLabel("教师名:");
		text1=new Choice();
		Panel p1,p2,p3;
		try{
			try{
				Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
				con=DriverManager.getConnection("jdbc:odbc:student");
			}catch(Exception mm){System.out.println(mm.getMessage());}
			sm=con.createStatement();
			command="select cname from ch order by cno";
			rs=sm.executeQuery(command);
			while(rs.next())
				text1.add(rs.getString("cname"));
			rs.close();
			sm.close();
			con.close();
		}catch(SQLException k){System.out.println(k.getMessage());}

		p1=new Panel();
		p1.add(label1);p1.add(text1);
		add("North",p1);

		p2=new Panel();
		text2=new JTextField(10);
		p2.add(label2);p2.add(text2);
		add("Center",p2);

		p3=new Panel();
		ok=new JButton("确定");
		cancel=new JButton("取消");
		p3.add(cancel);
		p3.add(ok);
		add("South",p3);

		ok.setBounds(40,350,80,20);
		cancel.setBounds(170,350,80,20);
		cancel.addActionListener(this);
		ok.addActionListener(this);
		setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE);
		pack();
		validate();
	}
	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.getSelectedItem()+"'";
			command="select teacher from ch where cname="+str1;//+" and cno in( select cno from ch where cname="+str2+")";
			ResultSet re=sm.executeQuery(command);
			int flag=0;
			if(re.next())
				flag=JOptionPane.showConfirmDialog(this,"该课程已有老师,你想要更改吗?");
			if(flag==0)
			{
				command="update ch set teacher='"+text2.getText()+"' where cname="+str1;
				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);
		}
	}
}