错误如下:
com.microsoft.sqlserver.jdbc.SQLServerException: “null”附近有语法错误。
代码如下:
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%@ page import="java.sql.*"%>
<%@ page import="java.io.*"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
登录验证
This is my JSP page.这是一个登陆检查页面
<%
String driverName = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
String dbURL = "jdbc:sqlserver://localhost:1433;DatabaseName=bank";
String userName = "team";
String userPwd = "123456";
try {
Class.forName(driverName);
Connection dbConn = DriverManager.getConnection(dbURL, userName,
userPwd);
String s = request.getParameter("IDNum");
session.setAttribute("IDNum",s);
String IDNum = request.getParameter("IDNum");
String UserPassword = request.getParameter("UserPassword");
String a = request.getParameter("UserName");
session.setAttribute("UserName",a);
String UserName = request.getParameter("UserName");
//byte b[] = UserName.getBytes("UTF-8");
//UserName = new String(b); //防止出现乱码
Statement stmt = dbConn.createStatement();
String sql = "select * from hello where IDNum'" + s
+ "' and UserPassword='" + UserPassword
+ "'and UserName='" + a + "'";
//RS.execute();
ResultSet rs = stmt.executeQuery(sql);
if (rs.next()) {
out.println("欢迎您回来");
//reSsponse.sendRedirect("Business.jsp");
} else {
out.println("对不起您的用户ID或者密码错误");
%> 返回首页<%
}
}
catch (Exception e) {
e.printStackTrace();
}
%>
初哥新手盼大神回复解答,尽快。谢谢!