manage_teach.java

可以用的成绩管理系统

import java.awt.*;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Scanner;
import java.sql.PreparedStatement;
import javax.swing.*;
public class Manage_teach extends JFrame implements ActionListener
{
	Connection connection;     
	Statement statement;     
	ResultSet resultSet;     
	ResultSetMetaData rsMetaData; 
	
	GridBagLayout gbl=new GridBagLayout();
    GridBagConstraints gbc=new GridBagConstraints();
	JLabel jiaohao,kehao,jiantou,la1,la2,la3,la4,xiugai;
	Choice choice1,choice2;
	JButton tianjia,shanchu,fanhui;
	public Manage_teach()
	{
		super.setTitle("授课管理！");
		super.setLocation(300,80);
		super.setSize(400,400);
		jiaohao=new JLabel("教师号");
		kehao=new JLabel("课程号");
		jiantou=new JLabel("----->");
		la1=new JLabel("  ");
		la2=new JLabel("  ");
		la3=new JLabel("  ");
		la4=new JLabel("  ");
		choice1=new Choice();
		choice2=new Choice();
		tianjia=new JButton("添加");
		tianjia.addActionListener(this);
		xiugai=new JLabel("   ");
		shanchu=new JButton("删除");
		shanchu.addActionListener(this);	
		fanhui=new JButton("返回");
		fanhui.addActionListener(this);
		set(0,0,1,1,jiaohao);set(1,0,1,1,la4);set(2,0,1,1,kehao);
		set(0,1,1,1,choice1);set(1,1,1,1,jiantou);set(2,1,1,1,choice2);
		set(0,2,1,1,la1);set(1,2,1,1,la2);set(2,2,1,1,la3);
		set(0,4,1,1,tianjia);set(1,4,1,1,shanchu);set(2,4,1,1,fanhui);
		setLayout(gbl);
		String url="jdbc:odbc:StudentScore";     
	    String username="sa";     
	    String password=""; 
		try 
	    {         
	    	Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");     
	        connection=DriverManager.getConnection(url,username,password);     
	    }     
	    catch(ClassNotFoundException cnfex)  
	    {  
	    	System.err.println( "装载JDBC/ODBC驱动程序失败。");     
	        //cnfex.printStackTrace();     
	        System.exit(1);    
	    }     
	    catch(SQLException sqlex)  
	    {
	    	System.err.println("无法连接数据库");     
	        //sqlex.printStackTrace();     
	        System.exit(1);
	    } 
	    String query1="select teacher_no from teacher";
	    try
		{
			statement =connection.createStatement();     
		    resultSet=statement.executeQuery(query1);
		    while(resultSet.next())
		    {
		    	choice1.add(resultSet.getString(1));
		    }
		}
		catch(SQLException sql)
		{
			//System.out.println(sql.getMessage());
		}
		String query2="select course_no from course";
		try
		{
			statement =connection.createStatement(); 
		    resultSet=statement.executeQuery(query2);
		    while(resultSet.next())
		    {
		    	choice2.add(resultSet.getString(1));
		    }
		}
		catch(SQLException sql)
		{
			//System.out.println(sql.getMessage());
		}
	}
	public void set(int x,int y,int w,int h,Component com)
    {
   	 gbc.anchor=GridBagConstraints.CENTER;
   	 gbc.gridx=x;
   	 gbc.gridy=y;
   	 gbc.gridwidth=w;
   	 gbc.gridheight=h;
   	 gbl.setConstraints(com, gbc);
   	 add(com);
    }
	public void actionPerformed(ActionEvent e)
	{
		Object obj=e.getSource();
		if(obj==tianjia)
		{
			JOptionPane.showMessageDialog((Component)null,"确定添加吗？","提示信息",JOptionPane.QUESTION_MESSAGE);
			String select_teacherNo=choice1.getSelectedItem().trim();
			//System.out.println(select_teacherNo);
			//System.out.println(select_teacherNo.length());
			String select_courseNo=choice2.getSelectedItem().trim();
			String query="insert into teach(teacher_no,course_no) values("+"'"+select_teacherNo+"'"+","+"'"+select_courseNo+"'"+")";
			try
			{
				JOptionPane.showMessageDialog((Component)null,"添加成功!","提示信息",JOptionPane.QUESTION_MESSAGE);
				statement =connection.createStatement();     
			    statement.executeQuery(query);
			}
			catch(SQLException sql)
			{
				//System.out.println(sql.getMessage());
			}
		}
		if(obj==shanchu)
		{
			JOptionPane.showMessageDialog((Component)null,"确定删除吗？","提示信息",JOptionPane.QUESTION_MESSAGE);
			String select_teacherNo=choice1.getSelectedItem().trim();
			String select_courseNo=choice2.getSelectedItem().trim();
			String query="delete from teach where teacher_no="+"'"+select_teacherNo+"'"+"and course_no="+"'"+select_courseNo+"'";
			try
			{
				JOptionPane.showMessageDialog((Component)null,"删除成功!","提示信息",JOptionPane.QUESTION_MESSAGE);
				statement =connection.createStatement();     
			    statement.executeQuery(query);
			}
			catch(SQLException sql)
			{
				//System.out.println(sql.getMessage());
			}
		}
		if(obj==fanhui)
		{
			this.dispose();
			Admin_manage ma=new Admin_manage();
			ma.setVisible(true);
		}
	}
	public static void main(String[] args)
	{
		Manage_teach teach=new Manage_teach();
		teach.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
		teach.setVisible(true);
	}
}