这是编译信息
java.sql.SQLException: ORA-00928: 缺少 SELECT 关键字 at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:180)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:543)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1451)
at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:862
)
at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.ja
va:1839)
at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.jav
a:1764)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStateme
nt.java:2354)
at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java
:858)
at jsp_servlet._dbcon._jspService(_dbcon.java:109)
at weblogic.servlet.jsp.JspBase.service(JspBase.java:27)
at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubIm
pl.java:263)
at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubIm
pl.java:200)
at weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppSe
rvletContext.java:2390)
at weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestIm
pl.java:1959)
at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:137)
at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:120)
>环境是:weblogic6.1+oracle9i
java.sql.SQLException: ORA-00928: 缺少 SELECT 关键字 at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:180)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:543)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1451)
at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:862
)
at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.ja
va:1839)
at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.jav
a:1764)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStateme
nt.java:2354)
at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java
:858)
at jsp_servlet._dbcon._jspService(_dbcon.java:109)
at weblogic.servlet.jsp.JspBase.service(JspBase.java:27)
at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubIm
pl.java:263)
at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubIm
pl.java:200)
at weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppSe
rvletContext.java:2390)
at weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestIm
pl.java:1959)
at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:137)
at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:120)
>环境是:weblogic6.1+oracle9i
String strSQL="insert into user_id (user,mail) values('fangchao','adf\@yeah.net')";
你应该列出所有的字段名,eg:
String strSQL="insert into user_id (user,mail,name) values('fangchao','[email protected]',NULL)";
你应该列出所有的字段名,eg:
String strSQL="insert into user_id (user,mail,name) values('fangchao','[email protected]',NULL)";
SQL> select * from user_id;USER
---------------------------------
MAIL
---------------------------------
flyly
[email protected]
[email protected]
[email protected]
USER
---------------------------------
MAIL
---------------------------------
ww
[email protected]
[email protected]
[email protected]
USER
---------------------------------
MAIL
---------------------------------
fangchao
[email protected]
已选择7行。
into user_id ([user],mail) values('fangchao','[email protected]') 记得给分呀,我。。