//程序如下
//结果只输出: 姓名:张三
//就Process completed
import java.sql.*;
public class database {
public static void main(String args[]) {
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String url="jdbc:odbc:telbook";
Connection connection=DriverManager.getConnection(url);
Statement statement = connection.createStatement();
String sql="SELECT * FROM telbook";
ResultSet rs = statement.executeQuery(sql);
String tt;
while (rs.next()) {
System.out.print("姓名:" + rs.getString("Name"));
System.out.println(" 电话:" + rs.getString("tel"));
System.out.println(" Email:" + rs.getString("email"));
}
rs.close();
connection.close();
}
catch(Exception ex){
System.out.println(ex);
System.exit(0);
}
}
}
高手同学帮忙解答,谢谢!
------解决方案--------------------
我觉得应该没问题吧!你看一下是不是你的字段名搞错了!
我这个和你的都差不多一样的,我的可以运行,没问题.你对照一下吧!
- Java code
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(); } }}