sql更新表:
String upd ="update meetingroo set mno = " + mno1+ " ,mname = " +mname1+ ",mloc = " + mloc1 + " ,mcapa = " + mcapa1 + "where mno= " + mno1 ;运行出现错误:
org.apache.jasper.JasperException: An exception occurred processing JSP page /manager/update-meetroom2.jsp at line 2118: String upd ="update meetingroo set mno = " + mno1+ " ,mname = " +mname1+ ",mloc = " + mloc1 + " ,mcapa = " + mcapa1 + "where mno= " + mno1 ;
19: String sql = "select * from meetingroo where mno="+mno1;
20: //ResultSet rs1 =
21: stmt.executeUpdate(upd);
22: ResultSet rs = stmt.executeQuery(sql);
23: out.print("<center>");
24: out.print("<table border=1 width='80%'>");
root cause javax.servlet.ServletException: java.sql.SQLException: [Microsoft][ODBC SQL Server Driver]COUNT 字段不正确或语法错误
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:852)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:781)
org.apache.jsp.manager.update_002dmeetroom2_jsp._jspService(update_002dmeetroom2_jsp.java:99)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:342)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:267)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
String upd ="update meetingroo set mno = " + mno1+ " ,mname = " +mname1+ ",mloc = " + mloc1 + " ,mcapa = " + mcapa1 + "where mno= " + mno1 ;运行出现错误:
org.apache.jasper.JasperException: An exception occurred processing JSP page /manager/update-meetroom2.jsp at line 2118: String upd ="update meetingroo set mno = " + mno1+ " ,mname = " +mname1+ ",mloc = " + mloc1 + " ,mcapa = " + mcapa1 + "where mno= " + mno1 ;
19: String sql = "select * from meetingroo where mno="+mno1;
20: //ResultSet rs1 =
21: stmt.executeUpdate(upd);
22: ResultSet rs = stmt.executeQuery(sql);
23: out.print("<center>");
24: out.print("<table border=1 width='80%'>");
root cause javax.servlet.ServletException: java.sql.SQLException: [Microsoft][ODBC SQL Server Driver]COUNT 字段不正确或语法错误
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:852)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:781)
org.apache.jsp.manager.update_002dmeetroom2_jsp._jspService(update_002dmeetroom2_jsp.java:99)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:342)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:267)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
----------
1、数值型两边不需要单引号,我全加了
2、where前面没有空格
这样运行试试