No suitable driver found for jdbc:odbc:bookinfo求解决

Question

java.sql.SQLException: No suitable driver found for jdbc:odbc:bookinfo

代码部分：
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
String url = "jdbc:odbc:bookinfo";// 2 其中odbc是系统dsn中的数据源名称
Connection conn = DriverManager.getConnection(url,"sa","sa");
String sql = "Inser into stu_info(accnumber,password,password2,username,id) values(?,?,?,?,?)";
PreparedStatement pstmt = conn.prepareStatement(sql);
pstmt.setString(1, accnumber);
pstmt.setString(2, password);
pstmt.setString(3, password2);
pstmt.setString(4, username);
pstmt.setString(5, id);
pstmt.executeUpdate();
pstmt.close();
conn.close();

Answer 1

感觉貌似你的URL有问题吧？