java朗控点异常_jsp中Class.forName(driverClass)出错

关键代码是Stringuser=request.getParameter("username");Stringpass=request.getParameter("password");StringdriverClass="com.microsoft.sqlserver.jdbc.SQLServerDriver";Stringu...

关键代码是

String user = request.getParameter("username");

String pass = request.getParameter("password");

String driverClass = "com.microsoft.sqlserver.jdbc.SQLServerDriver";

String url = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=JSP";

String username = "sa";

String password = "";

Class.forName(driverClass);

Connection conn = DriverManager.getConnection(url, username,

password);

Statement stmt = conn.createStatement();

String sql = "select * from tb_users where username='" + user

+ "' and userpwd='" + pass + "'";

ResultSet rs = stmt.executeQuery(sql);

if (rs.next()) {

rs.close();

stmt.close();

conn.close();

out.print("登陆成功！");

response.sendRedirect("show.jsp");

} else {

out.print("登陆错误！");

response.sendRedirect("login.jsp");

}

错误是

org.apache.jasper.JasperException: An exception occurred processing JSP page /dologin.jsp at line 25

22: String url = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=JSP";

23: String username = "sa";

24: String password = "";

25: Class.forName(driverClass);

26: Connection conn = DriverManager.getConnection(url, username,

27: password);

28: Statement stmt = conn.createStatement();

Stacktrace:

org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:524)

org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:417)

org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320)

org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)

javax.servlet.http.HttpServlet.service(HttpServlet.java:803)

展开