数据库连接的问题，请问高手该程序还有缺陷吗？

源代码如下：
--------------------------------
package budaoweng;
/*  数据库的连接
    BUDAOWENG DATE:2005-08-08 */
import java.sql.*;
public class DBDemo
{
    public static void main(String[] args)
    {
        Connection con=null;
        Statement smt=null;
        ResultSet rs=null;
        try
        {
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            con=DriverManager.getConnection("jdbc:odbc:job","sa","");
            smt=con.createStatement();
            rs=smt.executeQuery("select * from alluser");
            while(rs.next())
            {
                System.out.println("name="+rs.getString("name"));
            }
            rs.close();
            smt.close();
            con.close();
        }
        catch(Exception e)
        {
            System.out.println(e);
        }
    }
}