String sql=stmt.executeUpdate("insert into STUDENT(SNO,SNAME,SEX,BDATE,HEIGHT) values('"+sno+"','"+sname+"','"+sex+"','"+bdate+"',"+height+")");
该怎么改啊? String sq ="insert into STUDENT(SNO,SNAME,SEX,BDATE,HEIGHT) values('"+sno+"','"+sname+"','"+sex+"','"+bdate+"',"+height+")";
这样写,不能往数据库中增加?各位大虾,帮帮忙啊!
该怎么改啊? String sq ="insert into STUDENT(SNO,SNAME,SEX,BDATE,HEIGHT) values('"+sno+"','"+sname+"','"+sex+"','"+bdate+"',"+height+")";
这样写,不能往数据库中增加?各位大虾,帮帮忙啊!
sq.executeUpdate();
这句话本身就有问题吧
-- System.out.println('sql:'+sql);
请问它报的是什么错?报错的行能不能贴出来?
能不能把表的结构打印出来? 在 Command Window 中 desc STUDENT;
System.out.println("sql:"+sql);
String sql ="insert into STUDENT(SNO,SNAME) values('"+sno+"','"+sname+"','"sex"','"+bdate+"',"+height+")";
stmt.executeUpdate(sql);
主要的是这个executeUpdate 该怎么写?
int value=stmt.executeUpdate(sql); 也报错
56: int nResult=0;
57: Statement st=conn.createStatement();
58: nResult=st.executeUpdate(sql);
59: st.close();
60: conn.close();
61: %>
Stacktrace:
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:467)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:371)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:315)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
root cause javax.servlet.ServletException: ORA-00936: 缺少表达式 org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:846)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:779)
org.apache.jsp.add3_jsp._jspService(add3_jsp.java:123)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:328)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:315)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
root cause java.sql.SQLException: ORA-00936: 缺少表达式 oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
oracle.jdbc.ttc7.Oall7.receive(Oall7.java:573)
oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1891)
oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:1093)
oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:2047)
oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:1940)
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2709)
oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:796)
org.apache.jsp.add3_jsp._jspService(add3_jsp.java:108)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:328)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:315)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
这是sql的问题吧 ..能不能把执行后的sql值贴出来?