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());
}
}
}