帮忙调试下这段代码，我自己弄不出来了，头都晕了，急用！！！

Question

import javax.swing.*;
import java.awt.*;
import java.awt.event.*;
import java.sql.*;
import java.util.*;
import java.util.Date;
import java.text.*;
import java.text.SimpleDateFormat;
import java.io.*;
public class LookFrame extends JFrame 
{
JTextArea   Ta=new JTextArea();
JButton     bt1=new JButton("确定");
JButton     bt2=new JButton("退出");
JScrollPane  sl=new JScrollPane(Ta);
public LookFrame()
{
super();
Container con=getContentPane();
con.setLayout(new BorderLayout());
JPanel pane=new JPanel();
pane.setLayout(new BorderLayout());
pane.add(sl,BorderLayout.CENTER);
    Ta.append("日期\t 时间\t 标题\t 事件\t");

JPanel p1=new JPanel();    
    p1.add(bt1,"SOUTH");
    p1.add(bt2,"SOUTH");
    ButtonHandler handler = new ButtonHandler();
    bt1.addActionListener(handler);
pane.add(p1,BorderLayout.SOUTH);
con.add(pane,BorderLayout.CENTER);

bt2.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent e)
{
   dispose();
}
});

  

}
private class ButtonHandler implements ActionListener{ 
    public void actionPerformed(ActionEvent e)  
        {
            ResultSet rs;
            
            String sql="";
            int i=0;
            try{
             Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
             String source="jdbc:odbc:design";
             Connection  con=DriverManager.getConnection(source);
             Statement stmt=con.createStatement();
            
             sql="SELECT * FROM Th1";
            
             rs=stmt.executeQuery(sql);
            
             while(rs.next())
             {
             i++;
             Ta.setText(rs.getString(1));
             Ta.setText(rs.getString(2));
             Ta.setText(rs.getString(3));
             Ta.setText(rs.getString(4));
             }              
             rs.close();
             if(i==0)
             {
             JOptionPane.showMessageDialog(this,"没有备忘可查看!","message",JOptionPane.INFORMATION_MESSAGE);
             return;
             }
            
            }catch(Exception ew)
            {
             ;
            }
            
        }
    }
public void rePaint()
{
Ta.setText(" ");
Ta.append("日期\t 时间\t 标题\t 事件\t");
}
public static void main(String[] args)
{
LookFrame  lookframe=new LookFrame();
lookframe.setVisible(true);
}
}代码中的表Th1中的字段是date,time,lab,thing;我试了好多次都不能成功，帮忙看下！！！其中JOptionPane的那个错误我也不会改啊．

Answer 1

先把JOptionPane.showMessageDialog改了，应该是这样JOptionPane.showMessageDialog(LookFrame.this, "没有备忘可查看!","message",JOptionPane.INFORMATION_MESSAGE);

Answer 2

再给你一个我写的 连接access数据库的类，或者把我的连接数据库的代码加到你那里，试试import java.sql.*;public class DBConnection 
{
//jdbc driver, jdbc-odbc bridge
String dbDriver = "sun.jdbc.odbc.JdbcOdbcDriver";

//the database to be connected
String dbName = "jdbc:odbc:user";

//database's user name
String dbUser = "";

//database's password
String dbPass= "";

//connection
Connection connection = null;

//result collection
ResultSet resultSet = null; /**
 * constructor
 * */
public DBConnection()
{
try
{
Class.forName( dbDriver );
}
catch( ClassNotFoundException classNotFoundException ) 
{
System.err.println( "DBConnection(): " + classNotFoundException.getMessage() );
}
}
 

/**
 * execute query
 * @param sql sentence
 * @return the result collection
 * */
public ResultSet executeQuery( String sql ) 
{
resultSet = null;
try
{
connection = DriverManager.getConnection( dbName, dbUser, dbPass );
Statement stmt = connection.createStatement();
resultSet = stmt.executeQuery( sql );
}
catch( SQLException sqlException ) 
{
System.err.println( "executeQuery:"+sqlException.getMessage() );
}
return resultSet;
}

public static void main( String[] args )
{

}
}