关于在jsp中执行两条sql语句的问题，求助高手

[cody2002]

我在一张页面上需要执行两条sql语句。因此我定义了stm1和stm2，但是系统会报错。一般的话一张页面只执行一条sql语句，请问怎么样才能执行两条。谢谢！！！

[匪六哥]

不是吧？我就用过两个以上，怎么会出错呢？！！

[acefr]

??
执行n条都可以呀，一个stmt就够了呀。

[leshui]

可以执行多条sql语句啊
mSql="select * from t_flow_f where id='"+mId+"'";
result=DbaObj.ExecuteQuery(mSql);
result.next();
myFlowNo=result.getInt("flowno");
mFlowSort=result.getString("flowsort");

mSql="select * from t_flow_f where file_source_id= '"+file_source_id+"' and flowsort= '"+mFlowSort+"' order by flowno desc";
result=DbaObj.ExecuteQuery(mSql);
result.next();
flowNo=result.getInt("flowno");
if(flowNo!=myFlowNo)
{
myFlowNo=myFlowNo+1;

mSql="update t_flow_f set enable='1' where ad_type='核稿' and flowsort= '"+mFlowSort+"' and file_source_id='"+file_source_id+"' and flowno='"+myFlowNo+"'";
prestmt=DbaObj.Conn.prepareStatement(mSql);
DbaObj.Conn.setAutoCommit(true) ;
prestmt.executeUpdate();
DbaObj.Conn.commit();

[acefr]

只要
String sql = "select * from yourtable";
String sql1 = "update yourtable1 set ......";
stmt.executeQuery(sql);
or
stmt.executeUpdate(sql1);
...
...

[cody2002]

行了
谢谢leshui(大象无形)(有物混成，先天地生) 的代码