jsp连接数据库问题   未解决   悬赏分: 0   -离问题结束还有: 0
报错信息如下:
An error occurred at line: 35 in the jsp file: /UserAdd.jsp
Syntax error on token ""','"", delete this token
32: String s_NickName=request.getParameter("NickName");
33: String s_Sex=request.getParameter("Sex");
34: String s_Email=request.getParameter("Email");
35: strSql="insert into users(UserName,UserPassword,NickName,Sex,Email)values('"+s_UserName+"','"+s_UserPassword+"','"+s_NickName+"','"+s_Sex"','"+s_Email+"')";
36: stmt.executeUpdate(strSql);
37: out.println("<h1 align=center>阎剑鍩涘▔銊ュ斀阉存劕濮涢敍灞惧亶阎ㄥ嫭鏁为崘灞间缪阉垰顩ф稉?/h1>");
38: out.println("<p align=center>阎剑鍩涢崥宥忕窗<font color=blue>"+s_UserName+"</font></p>");
出错的35代码比较长 如果中间加回车符分成几段 会出现不同的报错 很郁闷 下面是另一种报错:
An error occurred at line: 35 in the jsp file: /UserAdd.jsp
String literal is not properly closed by a double-quote
32: String s_NickName=request.getParameter("NickName");
33: String s_Sex=request.getParameter("Sex");
34: String s_Email=request.getParameter("Email");
35: strSql="insert into users(UserName,UserPassword,NickName,Sex,Email)
36: values('"+s_UserName+"','"+s_UserPassword+"','"+s_NickName+"','"+s_Sex"','"+s_Email+"')";
37: stmt.executeUpdate(strSql);
38: out.println("<h1 align=center>阎剑鍩涘▔銊ュ斀阉存劕濮涢敍灞惧亶阎ㄥ嫭鏁为崘灞间缪阉垰顩ф稉?/h1>");
代码如下:
String s_UserPassword=request.getParameter("UserPassword");
String s_NickName=request.getParameter("NickName");
String s_Sex=request.getParameter("Sex");
String s_Email=request.getParameter("Email");
strSql="insert into users(UserName,UserPassword,NickName,Sex,Email)values('"+s_UserName+"','"+s_UserPassword+"','"+s_NickName+"','"+s_Sex"','"+s_Email+"')";
stmt.executeUpdate(strSql);

补充:文字乱码不是错误原因
提问者: ξ霜月☆遥  - 试用 二级     回答数: 1
  

答复
又是错误又是乱码,呵呵
Syntax error on token ""','"", delete this token
An error occurred at line: 35 in the jsp file: /UserAdd.jsp
String literal is not properly closed by a double-quote

双引号,符号问题。用个ide 查看

回答者: ing  - 试用 二级  回答时间: 2008-06-10 17:25:09


您尚未登陆, 无法进行对该问题进行解答! 点击这里登陆!