jdbc EOFException问题

[YeeDRain]

小弟初学java，下面的代码执行后发生EOFException，请问是哪里的问题？是不是cursor设置问题？具体应该怎么设？多谢了
public String getConnection() throws Exception{
Driver drv=(Driver)Class.forName("org.gjt.mm.mysql.Driver").newInstance();
String url="jdbc:mysql://localhost/test?user=root&password=123&useUnicode=true&characterEncoding=8859_1";
Connection conn=DriverManager.getConnection(url);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
String sql="SELECT COUNT(*) AS D FROM Lyrics";
ResultSet Rs=stmt.executeQuery(sql);
return Rs.getString("D");
}

[miaoliujun]

可能是你的Rs是空的

[YeeDRain]

库Lyrics里面是有记录的，到底问题出在哪呢？请大虾们指教阿

[老土豆T]

加上
public String getConnection() throws Exception{
Driver drv=(Driver)Class.forName("org.gjt.mm.mysql.Driver").newInstance();
String url="jdbc:mysql://localhost/test?user=root&password=123&useUnicode=true&characterEncoding=8859_1";
Connection conn=DriverManager.getConnection(url);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
String sql="SELECT COUNT(*) AS D FROM Lyrics";
ResultSet Rs=stmt.executeQuery(sql);

return Rs.getString("D");
}

[老土豆T]

加上
public String getConnection() throws Exception{
Driver drv=(Driver)Class.forName("org.gjt.mm.mysql.Driver").newInstance();
String url="jdbc:mysql://localhost/test?user=root&password=123&useUnicode=true&characterEncoding=8859_1";
Connection conn=DriverManager.getConnection(url);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
String sql="SELECT COUNT(*) AS D FROM Lyrics";
ResultSet Rs=stmt.executeQuery(sql);
if Rs.next()
return Rs.getString("D");
else
return null;

}