主题:呵呵,帮小弟看看错在那了??????
import java.sql.*;
public class Example1{
public static void main(String args[]){
String sno,sname;
int age;
Connection con;
Statement sql;
ResultSet rs;
try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");}
catch(ClassNotFoundException e){}
try{con=DriverManager.getConnection("jdbc:odbc:longqiaostudent","","");
sql=con.createStatement();
rs=sql.executeQuery("SELECT * FROM student");
while(rs.next()){
sname=rs.getString(2);
sno=rs.getString(1);
age=rs.getInt(2);
System.out.print("姓名"+sname+" ");
System.out.print("学号"+sno+" ");
System.out.print("年龄"+age+" ");
System.out.print("。");
}
con.close();
}
catch(SQLException e){}
}
}
我的程序能编译过去,可是就是没执行啊?????
我已经在ODBC数据源里面添加我要连接的数据库了,而且测试已经成功了,可是为什么程序没有执行呢?//
呵呵请大家帮小弟看看吧,小弟在此谢谢了!!!!!!!!
public class Example1{
public static void main(String args[]){
String sno,sname;
int age;
Connection con;
Statement sql;
ResultSet rs;
try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");}
catch(ClassNotFoundException e){}
try{con=DriverManager.getConnection("jdbc:odbc:longqiaostudent","","");
sql=con.createStatement();
rs=sql.executeQuery("SELECT * FROM student");
while(rs.next()){
sname=rs.getString(2);
sno=rs.getString(1);
age=rs.getInt(2);
System.out.print("姓名"+sname+" ");
System.out.print("学号"+sno+" ");
System.out.print("年龄"+age+" ");
System.out.print("。");
}
con.close();
}
catch(SQLException e){}
}
}
我的程序能编译过去,可是就是没执行啊?????
我已经在ODBC数据源里面添加我要连接的数据库了,而且测试已经成功了,可是为什么程序没有执行呢?//
呵呵请大家帮小弟看看吧,小弟在此谢谢了!!!!!!!!