关于jdbc的怪问题,谁能帮我解决一下
import java.sql.*;
import java.awt.*;
import javax.swing.*;
import java.util.*;
public class HelloWorld extends JFrame {
public HelloWorld() {
JPanel p1 = new JPanel();
JTable t1;
String drv = "sun.jdbc.odbc.JdbcOdbcDriver";
String url = "jdbc:odbc:ycjxc";
String user = "ycjxc";
String password = "ycjxc";
String errMsg = "";
Connection conn;
Statement stat;
ResultSet result;
ResultSetMetaData rsmd;
Vector columnHeads = new Vector();
Vector rows = new Vector();
int colNum;
try {
Class.forName(drv);
conn = DriverManager.getConnection(url, user, password);
stat = conn.createStatement();
result = stat.executeQuery("select * from monthlist");
rsmd = result.getMetaData();
colNum = rsmd.getColumnCount() + 1;
while (result.next()) {
for (int i=1; i<colNum; i++) {
System.out.print(rsmd.getColumnName(i) + " " );
System.out.println(result.getString(i) + " ");
System.out.println(result.getString(i) + " ");
// columnHeads.add(rsmd.getColumnName(i));
// rows.add(result.getString(i));
}
System.out.println();
}
}
catch (Exception e) {
errMsg += e.toString();
}
System.out.println(errMsg);
t1 = new JTable(columnHeads, rows);
// super("Hello World - JTable");
p1.setLayout(new BorderLayout());
p1.add(t1, BorderLayout.NORTH);
this.getContentPane().add(p1);
this.setSize(400, 300);
this.setVisible(true);
}
public static void main(String[] args) {
HelloWorld hw = new HelloWorld();
System.out.println("Hello World!");
}
}
上面这段代码运行时总是报错“java.sql.SQLException: No data found”;后来发现第二个System.out.println(result.getString(i) + " ");有问题,请教各位,小弟初学java