关键代码是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)
展开