java连接数据库的问题 求教
请问一下下面的程序是否有问题,我用的是jdk1.4,数据库为Access2002,编译通过,但是运行的时候没有结果,没有错误提示
import java.sql.*;
import java.io.*;
public class example{
public static void main(String args[])
{
String name,xuehao;
Date date;
int math,physics,english;
Connection con;
Statement sql;
ResultSet rs;
try{Class.forName("sun.jdbc.odbc.JdbcodbcDriver");}
catch (ClassNotFoundException e){}
try
{con=DriverManager.getConnection("jdbc:odbc:redsun","","");
sql=con.createStatement();
rs=sql.executeQuery("SELECT * FROM chengjibiao");
while (rs.next())
{name=rs.getString(2);
xuehao=rs.getString(1);
date=rs.getDate(3);
math=rs.getInt("数学");
System.out.println("姓名:" +name+" ");
System.out.println("学号:" +xuehao);
System.out.println("数学:" +math+" ");
System.out.println("出生:" +date.toString()+" ");
System.out.println("over");
}
con.close();
}
catch(SQLException e1){}
}
}