用jsp连接MySQL只能插入数字 不能插入英文字母
我用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);
望哪位高手知道错在何处帮我第一把 呵呵 谢了!