81,092
社区成员
发帖
与我相关
我的任务
分享为什么加了字段名就通不过了呢！！！
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<%@ page language="java"%>
<html>
<head>
<title>date</title>
</head>
<body>
<%--date--%>
<jsp:useBean id="ConBean" scope="session" class="DB.DBCon"/>
<%
Connection con=ConBean.getConnection();
Statement stmt=con.createStatement();
String strSQL="insert into user_id (user,mail) values('fangchao','adf@yeah.net')";//这里我把字段名去了就可以通过，数据就插入数据库了，
stmt.executeUpdate(strSQL);
ResultSet rs=stmt.executeQuery("SELECT * FROM USER_ID");
%>
<table bgcolor=DodgerBlue>
<tr bgcolor=SkyBlue>
<td><b>user</b></td>
<td><b>email</b></td>
</tr>
<%
while(rs.next())
{
%>
<tr bgcolor=LightGoldenrodYellow>
<td><b><%=rs.getString("user")%></b></td>
<td><b><%=rs.getString("mail")%></b></td>
</tr>
<%
}
rs.close();
stmt.close();
ConBean.close();
%>
</table>
</body>
</html>
<%@ page import="java.sql.*"%>
<%@ page language="java"%>
<html>
<head>
<title>date</title>
</head>
<body>
<%--date--%>
<jsp:useBean id="ConBean" scope="session" class="DB.DBCon"/>
<%
Connection con=ConBean.getConnection();
Statement stmt=con.createStatement();
String strSQL="insert into user_id (user,mail) values('fangchao','adf@yeah.net')";//这里我把字段名去了就可以通过，数据就插入数据库了，
stmt.executeUpdate(strSQL);
ResultSet rs=stmt.executeQuery("SELECT * FROM USER_ID");
%>
<table bgcolor=DodgerBlue>
<tr bgcolor=SkyBlue>
<td><b>user</b></td>
<td><b>email</b></td>
</tr>
<%
while(rs.next())
{
%>
<tr bgcolor=LightGoldenrodYellow>
<td><b><%=rs.getString("user")%></b></td>
<td><b><%=rs.getString("mail")%></b></td>
</tr>
<%
}
rs.close();
stmt.close();
ConBean.close();
%>
</table>
</body>
</html>
...全文
请发表友善的回复…
发表回复
flylyke 2003-07-22
- 打赏
- 举报
user是关键字。所以用[user]代替？？
flylyke 2003-07-22
- 打赏
- 举报
为什么要加[]这个呢？？
davidnim 2003-07-22
- 打赏
- 举报
高手
Henc 2003-07-22
- 打赏
- 举报
正确的如下：
into user_id ([user],mail) values('fangchao','adf@yeah.net')
记得给分呀，我。。。。。
into user_id ([user],mail) values('fangchao','adf@yeah.net')
记得给分呀，我。。。。。
Henc 2003-07-22
- 打赏
- 举报
我机子上没有SQL Server2000，没法试。你不妨在SQL server2000里执行这个语句：insert into user_id (user,mail) values('fangchao','adf@yeah.net') 看看在SQL Server里能不能通过。如果通不过的话可能是字段"user"有问题，因为user在SQL Server2000里是关键字。
painAndhappy 2003-07-22
- 打赏
- 举报
mark
flylyke 2003-07-22
- 打赏
- 举报
试过了。也不行
luckyfanjian 2003-07-22
- 打赏
- 举报
user_id(user,mail),user_id和(user,mail)之间不要有空格
wangyanqiu 2003-07-22
- 打赏
- 举报
学习。
flylyke 2003-07-22
- 打赏
- 举报
对天发誓，就这两个字段。这是select出来的
SQL> select * from user_id;
USER
---------------------------------
MAIL
---------------------------------
flyly
flyly@yeah.net
52ronger
52ronger@yeah.net
1111
1111@yeah.net
USER
---------------------------------
MAIL
---------------------------------
ww
1111@yeah.net
flyly
adf@yeah.net
fangchao
adf@yeah.net
USER
---------------------------------
MAIL
---------------------------------
fangchao
adf@yeah.net
已选择7行。
SQL> select * from user_id;
USER
---------------------------------
---------------------------------
flyly
flyly@yeah.net
52ronger
52ronger@yeah.net
1111
1111@yeah.net
USER
---------------------------------
---------------------------------
ww
1111@yeah.net
flyly
adf@yeah.net
fangchao
adf@yeah.net
USER
---------------------------------
---------------------------------
fangchao
adf@yeah.net
已选择7行。
flylyke 2003-07-22
- 打赏
- 举报
-_-## 跟这个@没有关系
zxhong 2003-07-22
- 打赏
- 举报
这是因为你的数据库中不只有user,mail 2个字段
你应该列出所有的字段名,eg：
String strSQL="insert into user_id (user,mail,name) values('fangchao','adf@yeah.net',NULL)";
你应该列出所有的字段名,eg：
String strSQL="insert into user_id (user,mail,name) values('fangchao','adf@yeah.net',NULL)";
zxhong 2003-07-22
- 打赏
- 举报
这是因为你的数据库中不只有user,mail 2个字段
你应该列出所有的字段名,eg：
String strSQL="insert into user_id (user,mail,name) values('fangchao','adf@yeah.net',NULL)";
你应该列出所有的字段名,eg：
String strSQL="insert into user_id (user,mail,name) values('fangchao','adf@yeah.net',NULL)";
davidnim 2003-07-22
- 打赏
- 举报
改成下面试试：
String strSQL="insert into user_id (user,mail) values('fangchao','adf\@yeah.net')";
String strSQL="insert into user_id (user,mail) values('fangchao','adf\@yeah.net')";
flylyke 2003-07-22
- 打赏
- 举报
这是编译信息
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
