主题：java连access的问题

import java.awt.*;
import java.awt.event.*;
import java.sql.*;
import javax.swing.*;
import java.io.*;
import java.awt.event.ActionListener;
import java.util.EventListener;
public class DataBaseDemo extends JFrame implements ActionListener {
public static void main(String[] args){
  DataBaseDemo frame=new DataBaseDemo();
  }
JButton bu1;
JTextArea ta1;
public DataBaseDemo(){
  super("DataBaseDemo");
  Container c=getContentPane();
  c.setLayout(null);
  bu1=new JButton("读取odbc数据库");
  bu1.setSize(150,20);
  bu1.setLocation(160,20);
  bu1.addActionListener(this);
  c.add(bu1);
  ta1=new JTextArea();
  ta1.setSize(420,280);
  ta1.setLocation(20,50);
  c.add(ta1);
  setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
  setVisible(true);
  setSize(500,400);
  }
public void actionPerformed(ActionEvent e) {
  String str1="";
  try{
   Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
   }catch(ClassNotFoundException e1){System.out.println("Driver not found!");}
  try{
   Connection con1=DriverManager.getConnection("jdbc:odbc:成绩数据库");
   Statement st1=con1.createStatement();
   ResultSet rs1=st1.executeQuery("select * from table");
   while(rs1.next()){
    str1=str1+rs1.getString(1)+"\t"+rs1.getString(2)+"\t"+rs1.getBoolean(3)+"\n";
    }
   st1.close();
   con1.close();
   ta1.setText(str1);
   javax.swing.JOptionPane.showMessageDialog(null,"chenggong!");
   }catch(SQLException e2){System.out.println("table not found!");}
}

}

这个程序一直输出"table not found!"  不知道错在哪里了  请老师帮忙看一下 谢谢

另一个问题:java程序能不能转成exe文件?

谢谢老师

下载信息  [文件大小：   下载次数： ]

点击浏览该文件:

错误的原因在于SQL语句中使用了table这个关键词，加上中括号即可解决问题

import java.awt.*;
import java.awt.event.*;
import java.sql.*;
import javax.swing.*;
import java.io.*;
import java.awt.event.ActionListener;
import java.util.EventListener;

public class DataBaseDemo
    extends JFrame implements ActionListener
{
  public static void main(String[] args)
  {
    DataBaseDemo frame = new DataBaseDemo();
  }

  JButton bu1;
  JTextArea ta1;
  public DataBaseDemo()
  {
    super("DataBaseDemo");
    Container c = getContentPane();
    c.setLayout(null);
    bu1 = new JButton("读取odbc数据库");
    bu1.setSize(150, 20);
    bu1.setLocation(160, 20);
    bu1.addActionListener(this);
    c.add(bu1);
    ta1 = new JTextArea();
    ta1.setSize(420, 280);
    ta1.setLocation(20, 50);
    c.add(ta1);
    setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);

    setSize(500, 400);
    setVisible(true);
  }

  public void actionPerformed(ActionEvent e)
  {
    String str1 = "";
    try
    {
      Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
    }
    catch (ClassNotFoundException e1)
    {
      System.out.println("Driver not found!");
    }
    try
    {
      Connection con1 = DriverManager.getConnection("jdbc:odbc:temp");
      Statement st1 = con1.createStatement();
      ResultSet rs1 = st1.executeQuery("select * from [table]");
      while (rs1.next())
      {
        str1 = str1 + rs1.getString(1) + "\t" + rs1.getString(2) + "\t" +
            rs1.getBoolean(3) + "\n";
      }
      st1.close();
      con1.close();
      ta1.setText(str1);
      javax.swing.JOptionPane.showMessageDialog(null, "chenggong!");
    }
    catch (SQLException e2)
    {
      System.out.println(e2.getMessage());
    }
  }

}