String sqlstr= String sqlstr= "Update user Set want='" + want + "',interests='" + interests + "',books='"+books + "',movies='" + movies+"',tv='" +tv + "',music='" +music + "' where email='"+ request.getParameter("email")+"'";
错了
String sqlstr= "Update user Set want='" + want + "',interests='" + interests + "',books='"+books + "',movies='" + movies+"',tv='" +tv + "',music='" +music + "' where email='"+ request.getParameter("email")+"'";还有这句话是什么意思?
sqlStmt.executeQuery("update user");
错了
String sqlstr= "Update user Set want='" + want + "',interests='" + interests + "',books='"+books + "',movies='" + movies+"',tv='" +tv + "',music='" +music + "' where email='"+ request.getParameter("email")+"'";还有这句话是什么意思?
sqlStmt.executeQuery("update user");
解决方案 »
- 点击一个字段表中的所有信息将显示在桌面上
- visio 表示多对多关系 怎样表示啊
- Extjs 中的FormPanel不显示问题,提示两个警告fiter zoom声明被丢弃
- 今天心情很爽,散分!!!
- myeclipse维护问题???
- (急)登陆之后退出登录问题(java)
- 请问学JAVA的步骤???
- 在tomcat4上,servlet一定需要servlet-mapping才能被识别吗?它自带的例子就没有做呀
- 高分求jsp教程下载得网站!
- 为什么tomcat3.2的web.xml不能在servlet中getInitParameterNames
- 有JSP+Oracle的书籍可以推荐的吗?
- 请坐过jsp网站的朋友近来指点一二!!!!
运行错误是javax.servlet.ServletException: Can not issue data manipulation statements with executeQuery()
是怎么回事啊?
update能直接用executeUpdate()马?
要提交,用sqlConn.commit();
sqlStmt.executeQuery("update user");
这两句去掉
改为:
int k = sqlStmt.executeQuery(sqlstr); if(k>0)
{
//表示更新成功}
else
{
//表示没有与你相符合的记录
}
sqlStmt.executeQuery("update user");
这两句去掉
改为:
int k = sqlStmt.executeUpdate(sqlstr); if(k>0)
{
//表示更新成功}
else
{
//表示没有与你相符合的记录
}
<%@ page contentType="text/html; charset=GB2312" import="java.sql.*"%><html>
<head>
<title>
添加新用户</title>
</head>
<body bgcolor="#ffffff" background="file:///C:/DOCUME~1/ADMINI~1/LOCALS~1/Temp/Rar$DI00.859/images/chuangjyongh.jpg">
<h1><center>
<p> </p>
</center>
</h1>
<form action="xingqu.jsp" name="registry" method="POST" width="90%">
<table cellpadding=3 cellspacing=1 border=0 width=465><TR>
<TD width=421>兴趣:</TD>
<TD width=515>
<INPUT type=text size=30 name="interests">
</TD>
</TR>
<TR >
<TD width=421>喜欢的音乐:</TD>
<TD width="515">
<INPUT type=text size=30 name="music">
</TD>
</TR><TR>
<TD width=421>喜欢的书籍:</TD>
<TD width="515">
<INPUT type=text size=30 name="books">
</TD>
</TR>
<TR >
<TD width=490>喜欢的电视节目:</TD>
<TD width="515">
<INPUT type=text size=30 name="tv">
</TD>
</TR>
<TR>
<TD width=490>喜欢的电影:</TD>
<TD width=515>
<INPUT maxLength=50 size=30 name="movies"></TD>
</TR>
<TR>
<TD width=490>愿望:</TD>
<TD width=515>
<TEXTAREA name="want" rows=5 wrap=PHYSICAL cols=38></TEXTAREA>
</TD>
</TR>
</TABLE>
<%String email=request.getParameter("email");
%>
<input type="submit" value="Submit" name="submit">
<input type="submit" value="Reset" name="reset"> </form>
<%
java.sql.Connection sqlConn;
java.sql.Statement sqlStmt;
java.sql.ResultSet sqlRst;
java.sql.ResultSet sqlRst1;
String want,interests,books,movies,tv,music;
want=request.getParameter("want");
interests=request.getParameter("interests");
books=request.getParameter("books");
movies=request.getParameter("movies");
tv=request.getParameter("tv");
music=request.getParameter("music");String sqlstr= "update user set want="+want+" where email="+email+"";out.println(sqlstr); String DBUser="xb";
String DBPassword="xb";
String DBServer="127.0.0.1";
String DBNAME="XB"; Class.forName("org.gjt.mm.mysql.Driver").newInstance(); sqlConn=java.sql.DriverManager.getConnection
("jdbc:mysql://"+DBServer+":3306/"+DBNAME+"?useUnicode=true&characterEncoding=gb2312", DBUser,DBPassword); sqlStmt=sqlConn.createStatement(java.sql.ResultSet.TYPE_SCROLL_INSENSITIVE,java.sql.ResultSet.CONCUR_READ_ONLY);
sqlRst=sqlStmt.executeQuery(sqlstr);
//sqlStmt.executeQuery("update user");
sqlRst.close();
sqlStmt.close();
sqlConn.close();%>
</body>
</html>