reword.java

是一个电子词典

import javax.swing.*; 
import SqlConnection.JdbcOdbcConn;
import java.awt.*; 
import java.awt.event.*;
import java.sql.ResultSet;
import java.sql.SQLException;

public class Reword 
{
	public Reword()
	{
		JFrame f=new JFrame(); 
		Object[][] p=new Object[1000][3];
		String[] n={"单词原型", "单词词性", "解释项",};
		JTable t; 
		t=new JTable(p,n);
		ResultSet rs;
		String key;String value,WordX;		
		JdbcOdbcConn con=new JdbcOdbcConn();
		int r=0;
		String sql="select distinct * from 生词本";
		rs=con.exeSql(sql);
		try{
				if(rs!=null)
					{
					while(rs.next())
						{
						DataItem dataitem=new DataItem();
						key=rs.getString(1);//获得英文单词
						WordX=rs.getString(2);//获得单词词性
						value=rs.getString(3);//获得中文解释
						dataitem.setWordX(WordX);
						dataitem.setValue(value);			
						t.setValueAt(key, r, 0);
						t.setValueAt(WordX,r, 1);
						t.setValueAt(value, r, 2);
						r++;
						}//end while
					con.close(rs);//关闭结果集
					con.closestat();//关闭语句
					con.closeconn();//关闭连接
					}   //end if
			}catch(SQLException ee){ee.printStackTrace();}
		
	    t.setPreferredScrollableViewportSize(new Dimension(550, 300)); 
		JScrollPane s = new JScrollPane(t); 
		f.getContentPane().add(s, BorderLayout.CENTER); 
		f.setTitle("生词本"); 
		f.pack(); 
		f.setVisible(true); 
		f.addWindowListener(new WindowAdapter() 
		{ 
			public void windowClosing(WindowEvent e) 
			{ 
			System.exit(0); 
			} 
		}); 
	}
}