Question

求解java报错！sql server的三个jar包已经导入！

报错：（java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver）
<% try{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
Connection conn= DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=web;", "sa", "06180812");
Statement stmt= conn.createStatement();
String sql="select * from person";
ResultSet rs= stmt.executeQuery(sql);

//定义 字符串
String username =request.getParameter("username");
String password =request.getParameter("password");
if(username.equals(rs.getString("name"))&& password.equals(rs.getString("password"))){
//登录成功的,跳转到main.jsp
//request.getRequestDispatcher("main.jsp").forward(request,response);
response.sendRedirect("mainpag.jsp");
}
else{
//跳转到login.jsp
//request.getRequestDispatcher("login.jsp").forward(request,response);
response.sendRedirect("0login.jsp");
}
}
catch(Exception e){
e.printStackTrace();
}
%>

Answer 1

“java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver”缺少JAR包，把JAR包添加上，刷新下工程，重试下即可。如果JAR包导入了，那就看下JAR包是否符合对应的版本或者你直接换成jtds-1.2.2.jar这个JAR包