分别是delete.jsp deleteresult.jsp和servlet..出现出错,但没有出错提示。
delete.jsp 中内容:<form name="form2" target="frame4" action="AServlet?action=delete" method="POST">
请输入要删除表格的条件:
<table>
<tr><td><select name=selectopt2 onchange="change()">
<option value=1>请选择</option>
<option value=eno>编号</option>
<option value=ename>名字</option>
<option value=esex>性别</option>
<option value=gz>工作</option>
<option value=ezc>职称</option>
</select></td>
<td><input type="text" name="Submitselect2" ></td>
<td colspan="2" align="center"><input type="submit" name="SubmitD" value="SubmitD"></td></tr>
</table>
</form>deleteresult.jsp内容:
<div style="border: 1px solid;width:300px;height:50px"><table border="0" width="100%">删除结果:
<% String flag="init";
if(request.getParameter("flag")!=null){flag=request.getParameter("flag");};
if(flag.equals("true")){out.print("删除成功!");}
else if(flag.equals("false")){out.print("无此用户名,删除失败!");}
else out.print("在这里显示!");%>
</table>
</div>servlet内容:
if ("delete".equalsIgnoreCase(action)) {
String selectopt2 = (String)request.getParameter("selectopt2");
String Submitselect2 = (String)request.getParameter("Submitselect2");
String sql = "select * from zg where '" + selectopt2 + "'='"
+ Submitselect2 + "'";
try {
sqlBean db = new sqlBean();
ResultSet rs = db.executeQuery(sql);
if (rs.next()) {
String strsql = "delete from zg where '" + selectopt2 + "'='"
+ Submitselect2+"'";
db.executeDelete(strsql);
response.sendRedirect("Deleteresult.jsp?flag=true");
} else {
response.sendRedirect("Deleteresult.jsp?flag=false");
}
} catch (Exception ex) {
System.out.println(ex.getMessage());
}
}
delete.jsp 中内容:<form name="form2" target="frame4" action="AServlet?action=delete" method="POST">
请输入要删除表格的条件:
<table>
<tr><td><select name=selectopt2 onchange="change()">
<option value=1>请选择</option>
<option value=eno>编号</option>
<option value=ename>名字</option>
<option value=esex>性别</option>
<option value=gz>工作</option>
<option value=ezc>职称</option>
</select></td>
<td><input type="text" name="Submitselect2" ></td>
<td colspan="2" align="center"><input type="submit" name="SubmitD" value="SubmitD"></td></tr>
</table>
</form>deleteresult.jsp内容:
<div style="border: 1px solid;width:300px;height:50px"><table border="0" width="100%">删除结果:
<% String flag="init";
if(request.getParameter("flag")!=null){flag=request.getParameter("flag");};
if(flag.equals("true")){out.print("删除成功!");}
else if(flag.equals("false")){out.print("无此用户名,删除失败!");}
else out.print("在这里显示!");%>
</table>
</div>servlet内容:
if ("delete".equalsIgnoreCase(action)) {
String selectopt2 = (String)request.getParameter("selectopt2");
String Submitselect2 = (String)request.getParameter("Submitselect2");
String sql = "select * from zg where '" + selectopt2 + "'='"
+ Submitselect2 + "'";
try {
sqlBean db = new sqlBean();
ResultSet rs = db.executeQuery(sql);
if (rs.next()) {
String strsql = "delete from zg where '" + selectopt2 + "'='"
+ Submitselect2+"'";
db.executeDelete(strsql);
response.sendRedirect("Deleteresult.jsp?flag=true");
} else {
response.sendRedirect("Deleteresult.jsp?flag=false");
}
} catch (Exception ex) {
System.out.println(ex.getMessage());
}
}
解决方案 »
- hibernate4 映射文件找不到异常,帮忙看下. 分少,问题简单...
- 有用过poi.jar的人嘛,进来交流下心得经验
- 方法重写
- spring+struts+hibernate问题 在线急等
- 是不是FileSystemXmlApplicationContext只能在main()中使用?
- 请教ejb编译打包时的警告问题
- tomcat连接mysql使用连接池的小问题?!高手来看看
- 妹子第一次做struts应用,求struts分页怎么解决?
- 求:全文检索工具
- 错误代码截图,String date2 =new DateFormat().format(date);
- struts2 源码里面的 UtilTimerStack这个类是干什么用的
- java EE 问题 求大神速度解决
+ Submitselect2 + "'";String strsql = "delete from zg where '" + selectopt2 + "'='"
+ Submitselect2+"'";你这两个sql写的是什么东西? where后面跟的是数据库表的字段。。你这是么? 如果是的话,你加上'' 干什么如果不是,你觉得怎么解释通?