Question

[Microsoft][ODBC Microsoft Access 驱动程序] 字符串的语法错误 在查询表达式

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

20: ResultSet rs = stat.executeQuery(sql);
具体代码如下：

<%

String account = request.getParameter("xuehao");
account=new String(account.getBytes("ISO-8859-1"),"gb2312");
String name = request.getParameter("xingming");
name=new String(name.getBytes("ISO-8859-1"),"gb2312");

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection conn = DriverManager.getConnection("jdbc:odbc:School");
Statement stat = conn.createStatement();
String sql = "SELECT STUNO,STUNAME,STUSEX FROM T_STUDENT where STUNO is ' " +account +
" ' and STUNAME is ' " + name + " " ;

//String sql = "SELECT STUNO,STUNAME,STUSEX FROM T_STUDENT";
ResultSet rs = stat.executeQuery(sql);

System.out.println(sql);
System.out.println(rs);

%>

Answer 1

String sql = "SELECT STUNO,STUNAME,STUSEX FROM T_STUDENT where STUNO is ' " +account +
" ' and STUNAME is ' " + name + " " ;

把 is 改成 =

追问

改了，还是同样报错。