import java.sql.*;
public class TestQuery {
static{
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
System.out.println("Success loading JDBC-ODBC Bridge Driver...\n");
}
catch(Exception e){
System.out.println("Error loading JDBC-ODBC Bridge Driver...\n");
e.printStackTrace();
}
}
public static void main(String[] args) {
try{
Connection con1=DriverManager.getConnection("jdbc:odbc:student","1002sfl","1");
System.out.println("数据库连接成功!");
Statement stmt1=con1.createStatement();
ResultSet rs1=stmt1.executeQuery("SELECT xm,xh,sj,zz FROM stu");
while(rs1.next()){
String xingming=rs1.getString(1);
String xuehao=rs1.getString(1);
String shouji=rs1.getString(1);
String zhuzhi=rs1.getString(1);
System.out.println(xingming+" "+xuehao+" "+shouji+" "+zhuzhi);
}
con1.close();
}
catch(Exception e){
e.printStackTrace();
}
}
}
D:\javawork\l20\sfl>java TestQuery
Success loading JDBC-ODBC Bridge Driver...数据库连接成功!
java.sql.SQLException: No data found
at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7138)
at sun.jdbc.odbc.JdbcOdbc.SQLGetDataString(JdbcOdbc.java:3907)
at sun.jdbc.odbc.JdbcOdbcResultSet.getDataString(JdbcOdbcResultSet.java:
5698)
at sun.jdbc.odbc.JdbcOdbcResultSet.getString(JdbcOdbcResultSet.java:354) at TestQuery.main(TestQuery.java:23)
请问是那里出了问题?
public class TestQuery {
static{
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
System.out.println("Success loading JDBC-ODBC Bridge Driver...\n");
}
catch(Exception e){
System.out.println("Error loading JDBC-ODBC Bridge Driver...\n");
e.printStackTrace();
}
}
public static void main(String[] args) {
try{
Connection con1=DriverManager.getConnection("jdbc:odbc:student","1002sfl","1");
System.out.println("数据库连接成功!");
Statement stmt1=con1.createStatement();
ResultSet rs1=stmt1.executeQuery("SELECT xm,xh,sj,zz FROM stu");
while(rs1.next()){
String xingming=rs1.getString(1);
String xuehao=rs1.getString(1);
String shouji=rs1.getString(1);
String zhuzhi=rs1.getString(1);
System.out.println(xingming+" "+xuehao+" "+shouji+" "+zhuzhi);
}
con1.close();
}
catch(Exception e){
e.printStackTrace();
}
}
}
D:\javawork\l20\sfl>java TestQuery
Success loading JDBC-ODBC Bridge Driver...数据库连接成功!
java.sql.SQLException: No data found
at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7138)
at sun.jdbc.odbc.JdbcOdbc.SQLGetDataString(JdbcOdbc.java:3907)
at sun.jdbc.odbc.JdbcOdbcResultSet.getDataString(JdbcOdbcResultSet.java:
5698)
at sun.jdbc.odbc.JdbcOdbcResultSet.getString(JdbcOdbcResultSet.java:354) at TestQuery.main(TestQuery.java:23)
请问是那里出了问题?
解决方案 »
- 无赖啊
- 异常怎么用
- a href 的submit 提交(他提交后给本页面不能得到equest.getparameter("startdate")
- System.out有没有内置的方法,将输出的内容可以输入到文件中?
- 请教一个模糊的问题
- 关于JComponent.repaint(Graphics g,int x,int y,int width,int height) 与 paintComponent()
- 关于java的多线程问题。
- 《Jsp与Servelet权威指南》和《Jsp与Servelet核心技术》那本翻译比较好?
- 急急急!!!关于Applet生命周期问题
- 如何在JAVA中做一个累加计数器
- 如何对jLable用for循环声明对象及使用?(就像QQ游戏里面那样,一个座位一个座位的)
- JAVA聊天室应用
stu存在不?
错误提示为:未找到数据!
这个提示就是说在你的TestQuery.java文件的23行发生错误,netbeans这类的开发工具可以帮助你快速定位