trainmanage.java

可以对教师任课信息进行增删改查 希望大家帮我

//教师任课管理类


package classsource;

import java.awt.*;
import javax.swing.*;
import java.awt.event.*;
import java.sql.*;

public class Trainmanage extends JInternalFrame {
	
	private JButton btadd,btamend,btdelet,btleft,btright,btsave;
    private JLabel lb1,lb2,lb3,lb4,lb5;
    private JTextField tcourse,taddress,ttime,tid,tname;

    public Trainmanage() {

        initComponents();
    }

    private void initComponents() {

    	setTitle("教师任课信息管理");
    	Font f = new Font("新宋体", 0, 14);
        lb1 = new JLabel("教师任课信息管理");
        lb2 = new JLabel("教师编号:");
        lb3 = new JLabel("课程名:");
        lb4 = new JLabel("班级地址:");
        lb5 = new JLabel("上课时间:");
        JLabel lb6 = new JLabel("教师姓名：");
        tid = new JTextField();
        tcourse = new JTextField();
        ttime = new JTextField();
        taddress = new JTextField();
        tname = new JTextField();
        btright = new JButton("<<");
        btleft = new JButton(">>");
        btdelet = new JButton("删除");
        btamend = new JButton("修改");
        btsave = new JButton("保存");
        btsave.setEnabled(false);
        btadd = new JButton("添加");

        getContentPane().setLayout(null);

        lb1.setFont(new java.awt.Font("新宋体", 1, 18));
        lb1.setForeground(new Color(0, 51, 255));

        getContentPane().add(lb1);
        lb1.setBounds(110, 10, 160, 30);

        lb6.setFont(f);
        getContentPane().add(lb6);
        lb6.setBounds(30,40,70,20);

        lb2.setFont(f);
        getContentPane().add(lb2);
        lb2.setBounds(30, 80, 70, 20);

        lb3.setFont(f);
        getContentPane().add(lb3);
        lb3.setBounds(30, 200, 70, 20);

        lb4.setFont(f);
        getContentPane().add(lb4);
        lb4.setBounds(30, 120, 70, 20);

        lb5.setFont(f);
        getContentPane().add(lb5);
        lb5.setBounds(30, 160, 70, 20);

        getContentPane().add(tname);
        tname.setBounds(120,40,110,23);

        getContentPane().add(tid);
        tid.setBounds(120, 80, 110, 23);

        getContentPane().add(tcourse);
        tcourse.setBounds(120, 200, 170, 23);

        getContentPane().add(ttime);
        ttime.setBounds(120, 160, 140, 23);

        getContentPane().add(taddress);
        taddress.setBounds(120, 120, 110, 23);
        btright.setFont(f);
        getContentPane().add(btright);
        btright.setBounds(330, 255, 50, 20);

        btleft.setFont(f);
        getContentPane().add(btleft);
        btleft.setBounds(330, 235, 50, 20);

        btdelet.setFont(f);
        getContentPane().add(btdelet);
        btdelet.setBounds(250, 245, 70, 25);

        btamend.setFont(f);
        getContentPane().add(btamend);
        btamend.setBounds(170, 245, 70, 25);

        btsave.setFont(f);
        getContentPane().add(btsave);
        btsave.setBounds(10, 245, 70, 25);

        btadd.setFont(f);
        getContentPane().add(btadd);
        btadd.setBounds(90, 245, 70, 25);

//连接数据库
        Database.joinDB();
//初始化窗体数据-----------------------------------------------------------------------------
        String sql="select * from teacher_course";
        try{
        	if(Database.query(sql)){
        		Database.rs.next();
        		tname.setText(Database.rs.getString("teacher_name"));
        		tid.setText(Database.rs.getString("teacher_id"));
                tcourse.setText(Database.rs.getString("course_name"));
                ttime.setText(Database.rs.getString("class_time"));
                taddress.setText(Database.rs.getString("class_address"));
        		}
        	}
        catch(Exception e){
        	System.out.println(e);
        	}

//----------------------------------------------------------------------------------------

//为上一条下一条按钮加事件-----------------------------------------------------------------
        btright.addActionListener(new ActionListener(){
        	public void actionPerformed(ActionEvent e){
        		try{
        			if(Database.rs.previous()){
		        		tname.setText(Database.rs.getString("teacher_name"));
		        		tid.setText(Database.rs.getString("teacher_id"));
		                tcourse.setText(Database.rs.getString("course_name"));
		                ttime.setText(Database.rs.getString("class_time"));
		                taddress.setText(Database.rs.getString("class_address"));
        				}
        			}
        		catch(Exception er){}
        		}
        	});

        btleft.addActionListener(new ActionListener(){
        	public void actionPerformed(ActionEvent e){
        		try{
        			if(Database.rs.next()){
		        		tname.setText(Database.rs.getString("teacher_name"));
		        		tid.setText(Database.rs.getString("teacher_id"));
		                tcourse.setText(Database.rs.getString("course_name"));
		                ttime.setText(Database.rs.getString("class_time"));
		                taddress.setText(Database.rs.getString("class_address"));
        				}
        			}
        		catch(Exception el){}
               }
        	});
//------------------------------------------------------------------

//为添加保存按钮加事件------------------------------------------------------------
        btadd.addActionListener(new ActionListener(){
        	public void actionPerformed(ActionEvent e){
        		btsave.setEnabled(true);
        		tid.setText("");
		        tcourse.setText("");
		        ttime.setText("");
		        taddress.setText("");
		        tname.setText("");
               }
        	});

        btsave.addActionListener(new ActionListener(){
        	public void actionPerformed(ActionEvent e){
        		if(tid.getText().equals("")||tcourse.getText().equals("")||ttime.getText().equals("")
        		   ||taddress.getText().equals("")||tname.getText().equals("")){
        		   	new JOptionPane().showMessageDialog(null,"所有数据均不能为空！");
        		   	}
        		else{
        			String sqlInsert="insert teacher_course values('"+ tid.getText() +"'," +
        			                 "'"+ tcourse.getText() +"','"+ tname.getText() +"','"+ taddress.getText() +"'," +
        			                 "'"+ ttime.getText() +"')";
        			try{
        				if(Database.executeSQL(sqlInsert)){
        					new JOptionPane().showMessageDialog(null,"数据添加成功！");
        					Database.joinDB();
        					String sql="select * from teacher_course";
        					Database.query(sql);
        					}
        				}
        			catch(Exception einsert){}
        			}
               }
        	});
//-----------------------------------------------------------------------------------

//为修改删除按钮加事件---------------------------------------------------------------
        btdelet.addActionListener(new ActionListener(){
        	public void actionPerformed(ActionEvent e){
        		String sqldelete="delete from teacher_course where teacher_id='"+ tid.getText() +"'";
                try{
                	if(Database.executeSQL(sqldelete)){
                		new JOptionPane().showMessageDialog(null,"数据删除成功！");
    					Database.joinDB();
    					String sql="select * from teacher_course";
    					Database.query(sql);
    					Database.rs.first();
		        		tname.setText(Database.rs.getString("teacher_name"));
		        		tid.setText(Database.rs.getString("teacher_id"));
		                tcourse.setText(Database.rs.getString("course_name"));
		                ttime.setText(Database.rs.getString("class_time"));
		                taddress.setText(Database.rs.getString("class_address"));
                		}
                	}
                catch(Exception edelete){}
               }
        	});

        btamend.addActionListener(new ActionListener(){
        	public void actionPerformed(ActionEvent e){
        	   String sqlupdate="update teacher_course set class_time='"+ ttime.getText() +"'," +
        	                    "course_name='"+ tcourse.getText() +"',teacher_name='"+ tname.getText() +"',"+
        	                    "class_address='"+ taddress.getText() +"' where teacher_id='"+ tid.getText()+"'";
                try{
                	if(Database.executeSQL(sqlupdate)){
                		new JOptionPane().showMessageDialog(null,"数据修改成功！");
    					Database.joinDB();
    					String sql="select * from teacher_course";
    					Database.query(sql);
                		}
                	}
                catch(Exception edelete){}
                }
        	});
//-----------------------------------------------------------------------------------
        Dimension screenSize = Toolkit.getDefaultToolkit().getScreenSize();
        setBounds((screenSize.width-403)/2, (screenSize.height-329)/2, 403, 329);
       this.setLocation(200, 100);
        this.setClosable(true);
        setVisible(true);
    }

//    public static void main(String args[]) {
//
//                new Trainmanage().setClosable(true);
//    }

}