我想实现 从页面修改数据库的功能,但是 无法插入数据 为什么 if(rs1.getString("chengshi_name").equals(chengshi))
{
s=rs1.getInt("chengshi_id");
sql4="insert into chengshi_jd(jd_name,cs_id)values('"+jingdian+"','"+s+"')";
stmt4.executeUpdate(sql2);
这步无法执行
全部代码如下
<%@ page contentType="text/html;charset=gb2312" language="java"%>
<%@include file="../inc/dbstart.jsp"%>
<link rel="stylesheet" href="../css/css.css" type="text/css">
<% int s=0; if(request.getParameter("add")!=null)
{
String jingdian=request.getParameter("chengshiJd");
String chengshi=request.getParameter("chengshiName");
sql1 = "select * from chengshi where chengshi_name='"+chengshi+"'";
rs1 = stmt1.executeQuery(sql1);
while (rs1.next()){ if(rs1.getString("chengshi_name").equals(chengshi))
{
s=rs1.getInt("chengshi_id");
sql4="insert into chengshi_jd(jd_name,cs_id)values('"+jingdian+"','"+s+"')";
stmt4.executeUpdate(sql2);
}
else {
sql2="insert into chengshi (chengshi_name) values('"+chengshi+"')";
stmt2.executeUpdate(sql2);
sql3="insert into chengshi_jd(jd_name,cs_id)values ('"+jingdian+"','"+s+"')";
stmt3.executeUpdate(sql3);}
} %>
<jsp:forward page="../index/you.jsp"/>
<%
}%>
<TABLE align="center">
<TR>
<TD>添加:</TD>
</TR>
<form METHOD=POST ACTION="add.jsp" name="tx"><TR>
<TD>旅游景点:<INPUT TYPE="text" NAME="chengshiJd"></TD>
</TR><TR>
<TD>旅游城市:<INPUT TYPE="text" NAME="chengshiName"></TD>
</TR>
<TR>
<TD><INPUT TYPE="submit" value="确定" name="add"> <INPUT TYPE="reset"></TD>
</TR>
</form>
</TABLE>
<%@include file="../inc/dbclose.jsp"%>
{
s=rs1.getInt("chengshi_id");
sql4="insert into chengshi_jd(jd_name,cs_id)values('"+jingdian+"','"+s+"')";
stmt4.executeUpdate(sql2);
这步无法执行
全部代码如下
<%@ page contentType="text/html;charset=gb2312" language="java"%>
<%@include file="../inc/dbstart.jsp"%>
<link rel="stylesheet" href="../css/css.css" type="text/css">
<% int s=0; if(request.getParameter("add")!=null)
{
String jingdian=request.getParameter("chengshiJd");
String chengshi=request.getParameter("chengshiName");
sql1 = "select * from chengshi where chengshi_name='"+chengshi+"'";
rs1 = stmt1.executeQuery(sql1);
while (rs1.next()){ if(rs1.getString("chengshi_name").equals(chengshi))
{
s=rs1.getInt("chengshi_id");
sql4="insert into chengshi_jd(jd_name,cs_id)values('"+jingdian+"','"+s+"')";
stmt4.executeUpdate(sql2);
}
else {
sql2="insert into chengshi (chengshi_name) values('"+chengshi+"')";
stmt2.executeUpdate(sql2);
sql3="insert into chengshi_jd(jd_name,cs_id)values ('"+jingdian+"','"+s+"')";
stmt3.executeUpdate(sql3);}
} %>
<jsp:forward page="../index/you.jsp"/>
<%
}%>
<TABLE align="center">
<TR>
<TD>添加:</TD>
</TR>
<form METHOD=POST ACTION="add.jsp" name="tx"><TR>
<TD>旅游景点:<INPUT TYPE="text" NAME="chengshiJd"></TD>
</TR><TR>
<TD>旅游城市:<INPUT TYPE="text" NAME="chengshiName"></TD>
</TR>
<TR>
<TD><INPUT TYPE="submit" value="确定" name="add"> <INPUT TYPE="reset"></TD>
</TR>
</form>
</TABLE>
<%@include file="../inc/dbclose.jsp"%>
解决方案 »
- 如何页面一次性提交多个相同类型的form?或者提交表格?
- 一台电脑登陆两个角色,二者的权限出现串联,有什么办法解决?
- jquery 下拉列表 添加限制条件
- 谁有java读rss的例子??
- 关于JSP表单想要实现的一个功能,高手来帮忙,谢谢
- dhtmlxtree与后台数据交互问题
- 求教:jsp报错
- JBuilder8中,遇到下面错误提示怎么解决? "ChatApplet.java": Error #: 704 : cannot access directory com\borland\jbcl\layout at line
- 菜鸟问题:Servlet到底实现的是哪个接口???
- 使用mysql的问题?
- jboss web 有服务,但没有进程
- 页面传递的乱码问题
错了
sql4="insert into chengshi_jd(jd_name,cs_id) values('"+jingdian+"','"+s+"')";
values前面应该有个空格