我觉得应该没问题吧!你看一下是不是你的字段名搞错了!
我这个和你的都差不多一样的,我的可以运行,没问题.你对照一下吧!public class SQLDemo
{
public static void main(String[] args)
{
try
{
String id,name,sex;
String strURL = "jdbc:odbc:testData";
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager.getConnection(strURL);
Statement Stmt = con.createStatement();
ResultSet rs = Stmt.executeQuery("SELECT id,name,sex FROM test1");
System.out.println("id,name,sex");
while(rs.next())
{
id = rs.getString("id");
name = rs.getString("name");
sex = rs.getString("sex");
System.out.println(id+","+name+","+sex);
}
}
catch (Exception e)
{
e.printStackTrace();
}
}
}
我这个和你的都差不多一样的,我的可以运行,没问题.你对照一下吧!public class SQLDemo
{
public static void main(String[] args)
{
try
{
String id,name,sex;
String strURL = "jdbc:odbc:testData";
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager.getConnection(strURL);
Statement Stmt = con.createStatement();
ResultSet rs = Stmt.executeQuery("SELECT id,name,sex FROM test1");
System.out.println("id,name,sex");
while(rs.next())
{
id = rs.getString("id");
name = rs.getString("name");
sex = rs.getString("sex");
System.out.println(id+","+name+","+sex);
}
}
catch (Exception e)
{
e.printStackTrace();
}
}
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货