JSP通过JavaBean连接SQL Server数据库

            //加载驱动
            Class.forName(driverName);
            //创建一个数据库连接
            Connection con = DriverManager.getConnection(url,"wxc","XXXXXXXX");
            //创建一个说明书
            PreparedStatement stat = con.prepareStatement("select * from authors where au_id=?");
            //设置要查询的作者名
            stat.setString(1, authorId);
            //获取查询结果
            ResultSet rs = stat.executeQuery();
            if(rs.next()){
                //存储结果到vector V中
                v.addElement(rs.getString("au_fname"));
                v.addElement(rs.getString("address"));
                v.addElement(rs.getString("city"));
                v.addElement(rs.getString("state"));
                v.addElement(rs.getString("zip"));
            }

jdk1.8好像没有sun.jdbc.odbc.JdbcOdbcDriver驱动了，1.7有