import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.awt.*;
import java.sql.*;

import javax.swing.*;
public class Newwordsbook extends JFrame implements ActionListener {
	
	

	JTextArea Newwordstext;
	
	JLabel lable;
	
	

	Newwordsbook ()
	{
		super("ʱ");
		setSize(670,400);
		setVisible(true);
		setLocationRelativeTo(null);           //ʱĻʾ
		getContentPane().add(new JScrollPane(Newwordstext));
		
	
		
		Newwordstext=new JTextArea(8,15);
		Newwordstext.setForeground(Color.RED);
		Newwordstext.setEditable(false);
		Newwordstext.setFont(new Font("",28,28));
      
     JPanel p1=new JPanel();
     JPanel p2=new JPanel();
     lable=new JLabel("£");
    
     
     lable.setFont(new Font("",20,20));
     p1.add(lable);
     JButton b1=new JButton("ʾ");
     p1.add(b1);
     b1.addActionListener(this);
    
    setResizable(false);      //ʹ󻯲
     getContentPane().add(p1,"North");
     getContentPane().add(p2,"South");
   getContentPane().add(new JScrollPane(Newwordstext),"Center");
   
		
	}

	
	
		public void newwords()throws SQLException
		{

			String Sno,cname,ename;
		try{
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		   }
			catch(ClassNotFoundException e)
			{
			System.out.println(e.getMessage());
			}
			String conURL ="jdbc:odbc:TSDIC";
			Connection con=DriverManager.getConnection(conURL);
			Statement st=con.createStatement();
				ResultSet re=st.executeQuery("select * from Addnewwords");
			
			while(re.next())
			{
				Sno=re.getString("");
				ename=re.getString("");
				cname=re.getString("");
				
				if(lable.getText().equals("ѯӢﵥʣ"))
				{
				 Newwordstext.append(Sno+" ."+ename+"   "+cname+'\n');
				}
				else if(lable.getText().equals("ѯĺﵥʣ"))
				{
					 Newwordstext.append(Sno+" ."+cname+'\n');
				}
				
			}
			
		}



		public void actionPerformed(ActionEvent arg0) {
			try
			{
				newwords();
			}
			catch(SQLException ee)
			{
				JOptionPane.showMessageDialog(this, "صʧܣ","",JOptionPane.WARNING_MESSAGE);
				
			}
			if(Newwordstext.getText().equals(""))
			{
				JOptionPane.showMessageDialog(this, "!ӣ","ʾ",JOptionPane.WARNING_MESSAGE);
			}
			
			
		}

		
	}


