String strSql="delete from "+tables+" where id="+id;
String strSql_delCzcs="delete from ChaoZuo where SheBei="+id;
String strSql_delJx="delete from JianXiu where SheBeiLeiBie="+lb+" and SheBei="+id;
String strSql_delQx="delete from QueXian where SheBeiId="+id;
String strSql_delTz="delete from TiaoZa where SheBei="+id;
String strSql_delYd="delete from YiDongJiLu where SheBei="+id;
String strSql_delTy="delete from TiaoYa where SheBei="+id;
Connection conn=cons.Connect();
try
{
Statement stmt=conn.createStatement();
conn.setAutoCommit(false);
stmt.executeUpdate(strSql);
stmt.executeUpdate(strSql_delCzcs);
stmt.executeUpdate(strSql_delJx);
stmt.executeUpdate(strSql_delQx);
stmt.executeUpdate(strSql_delTz);
stmt.executeUpdate(strSql_delYd);
stmt.executeUpdate(strSql_delTy);//这一句出错
conn.commit();
stmt.close();
conn.close();
request.getRequestDispatcher("Error.jsp?ts=删除成功").forward(request,response);
return;
}
catch(Exception e)
{
request.getRequestDispatcher("Error.jsp?ts=数据库操作错误").forward(request,response);其中最后一句的表已经被删除,所以提示数据库操作错误,但我发现,前面几句sql语句已经执行了,这是怎么回事?
}
String strSql_delCzcs="delete from ChaoZuo where SheBei="+id;
String strSql_delJx="delete from JianXiu where SheBeiLeiBie="+lb+" and SheBei="+id;
String strSql_delQx="delete from QueXian where SheBeiId="+id;
String strSql_delTz="delete from TiaoZa where SheBei="+id;
String strSql_delYd="delete from YiDongJiLu where SheBei="+id;
String strSql_delTy="delete from TiaoYa where SheBei="+id;
Connection conn=cons.Connect();
try
{
Statement stmt=conn.createStatement();
conn.setAutoCommit(false);
stmt.executeUpdate(strSql);
stmt.executeUpdate(strSql_delCzcs);
stmt.executeUpdate(strSql_delJx);
stmt.executeUpdate(strSql_delQx);
stmt.executeUpdate(strSql_delTz);
stmt.executeUpdate(strSql_delYd);
stmt.executeUpdate(strSql_delTy);//这一句出错
conn.commit();
stmt.close();
conn.close();
request.getRequestDispatcher("Error.jsp?ts=删除成功").forward(request,response);
return;
}
catch(Exception e)
{
request.getRequestDispatcher("Error.jsp?ts=数据库操作错误").forward(request,response);其中最后一句的表已经被删除,所以提示数据库操作错误,但我发现,前面几句sql语句已经执行了,这是怎么回事?
}
解决方案 »
- 关于mybatis的一个问题
- 高分求救!!!!!!!!!!!!(在线等)
- ajax传值问题
- 有谁用过jdring啊.就是实现类似日程提醒的功能的东西
- 不同名称的复选框如何通过一个按钮触发实现全选啊?
- 新手遇见的问题~!~高手快来帮忙吧 谢谢了
- iis+tomcat问题
- 关于项目中一个数据库时间问题
- 我在classpath中加了%TOMCAT_HOME%\common\lib\servlert.jar,在DOS环境下编辑Java文件怎么还是说javax.servlet馈不存在???
- 两个String 类型的时间之间如何做减法(在线等!急)
- 请教一个关于在servlet中配置Web.xml的问题
- 在jsp中怎样实现播放视频呢?
{
conn.rollback();
request.getRequestDispatcher("Error.jsp?ts=数据库操作错误").forward(request,response);
}
{
conn.rollback();
request.getRequestDispatcher("Error.jsp?ts=数据库操作错误").forward(request,response);
}这么写后,conn.rollback();一行提示:
unreported exception java.sql.sqlexception,must be caught or declared to be thrown
{
try
{
conn.rollback();
}
catch(SQLException e1)
{
}
request.getRequestDispatcher("Error.jsp?ts=数据库操作错误").forward(request,response);
}
这里rollback也会产生异常,需要捕捉
jsf的beans里还是这样吗?