tiq.java

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

//教师任课查询类


package classsource;

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

public class TIQ extends JInternalFrame{

	JLabel lb1=new JLabel("教师任课查询");
   	JLabel lb2=new JLabel("教师编号:");
   	
   	JTextField ttxtid=new JTextField(10);
   	JLabel lb3=new JLabel("教师姓名:");
   	JTextField ttxtname=new JTextField(10);
   	JButton btn1=new JButton("查询");

   	JTable table;
	DefaultTableModel dtm;
	String columns[] = {"教师编号","课程","教师姓名","上课地址","时间","班级"};
	public TIQ(){
		setTitle("教师任课查询");

		dtm=new DefaultTableModel();
		table = new JTable(dtm);
		JScrollPane s1=new JScrollPane(table);
		//sl.HORIZONTAL_SCROLLBAR_ALWAYS;
		//sl.VERTICAL_SCROLLBAR_ALWAYS;
		dtm.setColumnCount(5);
		dtm.setColumnIdentifiers(columns);

		getContentPane().setLayout(null);
		lb1.setBounds(200,10,300,30);
		lb1.setFont(new Font("宋体",Font.BOLD,24));
		getContentPane().add(lb1);

		Font f=new Font("宋体",Font.PLAIN,12);
		lb2.setBounds(10,60,80,25);
		lb2.setFont(f);
		getContentPane().add(lb2);
		ttxtid.setBounds(80,60,80,23);
		ttxtid.setFont(f);
		getContentPane().add(ttxtid);
		lb3.setBounds(10,90,80,25);
		lb3.setFont(f);
   	    getContentPane().add(lb3);
   	    ttxtname.setBounds(80,90,80,23);
   	    ttxtname.setFont(f);
   	    getContentPane().add(ttxtname);
   	    btn1.setBounds(90,130,60,25);
   	    btn1.setFont(f);
   	    getContentPane().add(btn1);

		s1.setBounds(180,60,425,290);
		getContentPane().add(s1);

//设置边框---------------------------------------------------------------------------
		ttxtid.setBorder(BorderFactory.createLineBorder(Color.black));
   	    ttxtname.setBorder(BorderFactory.createLineBorder(Color.black));
   	    btn1.setBorder(BorderFactory.createRaisedBevelBorder());
		s1.setBorder(BorderFactory.createLineBorder(Color.black));

 //___________连接数据库_______________________________________________________________
		Database.joinDB();

		String Tim="select * from teacher_course";
		if(Database.query(Tim)){
			System.out.println(Tim);
			try{
				while(Database.rs.next()){
					String t_id=(""+Database.rs.getString("teacher_id"));
					System.out.println(t_id);
					String t_course=Database.rs.getString("course_name");
					System.out.println(t_course);
					String t_name=Database.rs.getString("teacher_name");
					System.out.println(t_name);
					String t_address=Database.rs.getString("class_address");
					System.out.println(t_address);
					String t_time=Database.rs.getString("class_time");
					System.out.println(t_time);

					Vector v=new Vector();
					v.add(t_id);
					v.add(t_course);
					v.add(t_name);
					v.add(t_address);
					v.add(t_time);

					dtm.addRow(v);


				}
			}
			catch(Exception eTIQ){
			  System.out.println("初始化表格失败！");
			}
		}
//为查询按钮加事件--------------------------------------------------------
        btn1.addActionListener(new ActionListener(){
        	public void actionPerformed(ActionEvent e){
        		System.out.println("查询按钮加事件");
        		String STIQ;
        		int rc=dtm.getRowCount();
        		for(int i=0;i<rc;i++){
        			dtm.removeRow(0);
        		}
      //------------------------
        		if(ttxtid.getText().equals("")&&ttxtname.getText().equals("")){
        		   STIQ="select * from teacher_course";
        		}
        		else if(ttxtname.getText().equals("")){
        			STIQ="select * from teacher_course where teacher_name = '" + ttxtname.getText() +"'";
        			}
        		else{
        		   STIQ="select * from teacher_course where teacher_id = '" + ttxtid.getText() +"' or teacher_name like '%"+ ttxtname.getText() +"%'";
          		}
        		System.out.println(STIQ);
        		if(Database.query(STIQ)){
        			try{
						while(Database.rs.next()){
							String t_id=(""+Database.rs.getString("teacher_id"));
							System.out.println(t_id);
							String t_course=Database.rs.getString("course_name");
							System.out.println(t_course);
							String t_name=Database.rs.getString("teacher_name");
							System.out.println(t_name);
							String t_address=Database.rs.getString("class_address");
							System.out.println(t_address);
							String t_time=Database.rs.getString("class_time");
							System.out.println(t_time);

							Vector v=new Vector();
							v.add(t_id);
							v.add(t_course);
							v.add(t_name);
							v.add(t_address);
							v.add(t_time);

							dtm.addRow(v);


						}
        			}
        			catch(Exception eT){}

        		}
        	}

        });

		setSize(630,400);
		this.setClosable(true);
		setVisible(true);
		}
	}