我用MySQL和jsp做一个论坛的注册用户名时 ,如果只插入数字正常运行 ,但一旦有英文字母就出错误 报错如下:
root cause javax.servlet.ServletException: java.sql.SQLException: Unknown column 'try' in 'where clause'
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:855)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:784)
org.apache.jsp.userRegOK_jsp._jspService(userRegOK_jsp.java:117)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:384)
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)我的jsp代码如下:
String sql2="insert into users(username,password,sex,names,email,touxiang) values('"+username+"','"+password+"',"+male+
",'"+names+"','"+email+"','"+touxiang+"')";
stmt.executeUpdate(sql2);
session.setAttribute("username",username);
望哪位高手知道错在何处帮我第一把 呵呵 谢了!
root cause javax.servlet.ServletException: java.sql.SQLException: Unknown column 'try' in 'where clause'
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:855)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:784)
org.apache.jsp.userRegOK_jsp._jspService(userRegOK_jsp.java:117)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:384)
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)我的jsp代码如下:
String sql2="insert into users(username,password,sex,names,email,touxiang) values('"+username+"','"+password+"',"+male+
",'"+names+"','"+email+"','"+touxiang+"')";
stmt.executeUpdate(sql2);
session.setAttribute("username",username);
望哪位高手知道错在何处帮我第一把 呵呵 谢了!
解决方案 »
- 宿主机和虚拟机数据库连接的问题
- java运行Runtime.getRuntime().exec命令权限问题
- spring MVC谁有入门资料,带例子的那种
- unexpected token: * near line 1, column 8 [select * form com.user]
- java.lang.OutOfMemoryError: Java heap space
- 统计在线人数
- 两张表的问题
- JDBC查询或插入oracle数据时不能用中文的问题、
- tomcat中能不能把session迁移到其他服务中去
- java怎么读取几行记录
- 获取 xmlHttp.responseText乱码问题,高手指点下
- 高手指点下,JSP页面老报错(java.lang.NullPointerException)
javax.servlet.ServletException: java.sql.SQLException: Unknown column 'try' in 'where clause'
你检查一下,你的数据库表中有没有try这一列,
你上面的sql语句代码贴全没?
Unknown column 'try' in 'where clause'
你仔细检查一下,或者贴出来我帮你看看
之前把SQL2输出,看看SQL到底是啥?