cheng.java

查询和记录功能 自己写的 不知道好不好

import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import java.sql.*;
import javax.swing.table.*;
import javax.swing.tree.*;
import javax.swing.event.*;
import java.io.*;


class yue extends JFrame 
{   
	yue()
	{
		super("学生管理系统");
	
	JTabbedPane a=new JTabbedPane();
	Icon e=new ImageIcon("2.jpg");
	a.addTab("仰恩",e,new yangen());
	a.addTab("报到登记",new baodaodengji());
	a.addTab("备忘录",new beiwanglu());
	getContentPane().add(a);
	validate();
	addWindowListener(new WindowAdapter()
	{
		public void windowClosing(WindowEvent e)
	   {System.exit(0);}
	});
	setSize(500,500);
	setVisible(true);
	}
	


class yangen extends JPanel
{
	yangen()
	{
	  JButton button2=new JButton(new ImageIcon("1.jpg"));
	  Icon b=new ImageIcon("1.jpg");
	  TextArea c=new TextArea(10,15);
	  String d="仰\n恩\n大\n学\n夜\n景\n";
	  c.setText(d);
	 
	  setLayout(new BorderLayout());
	  add("West",c);
	  add("Center",button2);
	}
}

class baodaodengji extends JPanel implements ActionListener 
{	 JTextField t1;
     JButton b1;
     JTable table;
     Object[][] data=new Object[20][3];
     Object colnames[]={"学号","姓名","是否登记"};
     int j=0;
	baodaodengji()
	{ 
      setLayout(new BorderLayout());
      t1=new JTextField(10);
      b1=new JButton("查找-->");
      JPanel p1=new JPanel();
      JPanel p2=new JPanel();
      table=new JTable(data,colnames);
      JScrollPane jsp=new JScrollPane(table);
      p1.add(new JLabel("学号"));
      p1.add(t1);
      p1.add(b1);
      p2.add(jsp);
      add(p1,"North");
      add(jsp,"Center");
      b1.addActionListener(this);
      addWindowListener(new WindowAdapter()
        { public void windowClosing(WindowEvent e)
        {setVisible(false);System.exit(0);}});
   
      setBounds(150,150,450,200);
      setVisible(true);
     }
  
    public void actionPerformed(ActionEvent e) 
     { 
       if(e.getSource()==b1) 
      {  
       for( int j=0;j<20;j++)
         for(int  k=0;k<3;k++)
         { data[j][k]=null;}  
           chaxun();
          table.repaint(); }
     }  
 public void chaxun() 
    {  
        Connection con=null;
          PreparedStatement pstmt=null;
          ResultSet rs=null;
          int i=0;
      String s= "%"+t1.getText().trim()+ "%";
   try{ Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
         }catch(ClassNotFoundException ee){System.out.println(ee.getMessage());}
     try{con=DriverManager.getConnection("jdbc:odbc:jiao","jiao","123");
        
        }catch(SQLException eee){System.out.println(eee.getMessage());}
      try {
         pstmt = con.prepareStatement("select * from yue  where 学号 like ?");
pstmt.setString(1, s);
          rs= pstmt.executeQuery();
         while(rs.next())
         {   data[i][0]=rs.getString(1);
             data[i][1]=rs.getString(2);
             data[i][2]=rs.getString(3);
             i++;   }
         con.close();
        }catch(SQLException eee){System.out.println(eee.getMessage());}
       } 
 
   }
   class beiwanglu extends JPanel implements TreeSelectionListener,ActionListener
   {   DefaultMutableTreeNode root=new DefaultMutableTreeNode("04信管");
       DefaultMutableTreeNode math[]=new DefaultMutableTreeNode[40704];
       JTextArea jt= new JTextArea(20,30);
       JTree tree=new JTree(root);
       JButton b1=new JButton("保存备忘录");
       JButton b2=new JButton("删除备忘录");
   	beiwanglu()
   	{
      for(int i=40701;i<40704;i++)
       { math[i]=new DefaultMutableTreeNode(i+"班");
         root.add(math[i]) ;}
      for(int i=40701;i<40704;i++)
       { 
        if(i==40701)
         { for(int j=402130;j<=402200;j++)
           { math[i].add(new DefaultMutableTreeNode(j+"学生"));}
          }
         else if(i==40702)
         { for(int j=402250;j<=402350;j++)
          { math[i].add(new DefaultMutableTreeNode(j+"学生"));}
         }
          else if(i==40703)
         { for(int j=402351;j<=402450;j++)
          { math[i].add(new DefaultMutableTreeNode(j+"学生"));}
         }
         }
         
         JPanel pan0=new JPanel();
         JPanel pan1=new JPanel();
      
         pan1.add(b1);pan1.add(b2);
      
      JScrollPane pan2=new JScrollPane(jt);
      pan0.setLayout(new BorderLayout());
      pan0.add("North",pan1);
      pan0.add("Center",pan2);
      JScrollPane pan3=new JScrollPane(tree);
      
      JSplitPane js=new JSplitPane(JSplitPane.HORIZONTAL_SPLIT,true,pan3,pan0);
      add(js);
      tree.addTreeSelectionListener(this);
      b1.addActionListener(this);b2.addActionListener(this);
      
      addWindowListener(new WindowAdapter()
      { public void windowClosing(WindowEvent e)
      {setVisible(false);System.exit(0);}});
      
      setBounds(150,150,300,350);
      setVisible(true);
      }

   public void valueChanged(TreeSelectionEvent e)  
   { jt.setText("");
     if(e.getSource()==tree)
     {
       DefaultMutableTreeNode node=(DefaultMutableTreeNode)tree.getLastSelectedPathComponent();
     if(node.isLeaf())
       { String str=node.toString();
         for(int i=040701;i<040704;i++)
           if(node.getParent()==math[i])
           { 
            try
            {    String temp=null;
                 File f=new File(node.getParent().toString()+str+".txt");
                 FileReader file=new FileReader(f);
                 BufferedReader in=new BufferedReader(file);
                 while((temp=in.readLine())!=null)
                      jt.append(temp+'\n');
                      file.close();in.close();
             }catch(FileNotFoundException e1){} 
              catch(IOException ee){}
            }
        }
       }
      }
    public void actionPerformed(ActionEvent e)
     { if(e.getSource()==b1)
       {
        DefaultMutableTreeNode node=(DefaultMutableTreeNode)tree.getLastSelectedPathComponent();
        String str=node.toString();
        if(node.isLeaf())
         {
          try
            {   
              File f=new File(node.getParent().toString()+str+".txt");
                 FileWriter file=new FileWriter(f);
               BufferedWriter out=new BufferedWriter(file);
               out.write(jt.getText(),0,(jt.getText()).length());
               out.flush();
               file.close();out.close();
             }
               catch(FileNotFoundException e1){} 
               catch(IOException ee){}
        }
       }
       else if(e.getSource()==b2)
             {
              DefaultMutableTreeNode node=(DefaultMutableTreeNode)tree.getLastSelectedPathComponent();
              String str=node.toString();
              if(node.isLeaf())
                { File f=new File(node.getParent().toString()+str+".txt");
                  f.delete();
                }
              }
  
     }     


   	}
 }  
   public class cheng
   {  public static void main(String args[])
      {
      	new yue();
      }
   }