public int modifyRoleID(String roleIDString,String organID)
{
int flag;
try{
sqlBuf.delete(0,sqlBuf.length());
sqlBuf.append("UPDATE oa_organ SET roleID = '");
sqlBuf.append(roleIDString);
sqlBuf.append("' where id='");
sqlBuf.append(organID);
sqlBuf.append("' or parent_id='");
sqlBuf.append(organID);
sqlBuf.append("' ");
//System.out.print(sqlBuf.toString() );
flag=dbc.executeUpdate(sqlBuf.toString()) ;
modifyUserRole(roleIDString,organID);
ResultSet rs=queryParent(organID);
rs.last();
String[] organChildID=new String[rs.getRow()];
rs.close();
rs=queryParent(organID);
int i=0;
while(rs.next())
{
organChildID[i]=rs.getString("id");
i++;
}
rs.close();
for(i=0;i<organChildID.length;i++)
{
modifyRoleID(roleIDString,organChildID[i]);
}
}
catch(Exception err)
{System.out.print(err.getMessage()) ;
return -1;
}
return flag ;
}这样写就改对了
{
int flag;
try{
sqlBuf.delete(0,sqlBuf.length());
sqlBuf.append("UPDATE oa_organ SET roleID = '");
sqlBuf.append(roleIDString);
sqlBuf.append("' where id='");
sqlBuf.append(organID);
sqlBuf.append("' or parent_id='");
sqlBuf.append(organID);
sqlBuf.append("' ");
//System.out.print(sqlBuf.toString() );
flag=dbc.executeUpdate(sqlBuf.toString()) ;
modifyUserRole(roleIDString,organID);
ResultSet rs=queryParent(organID);
rs.last();
String[] organChildID=new String[rs.getRow()];
rs.close();
rs=queryParent(organID);
int i=0;
while(rs.next())
{
organChildID[i]=rs.getString("id");
i++;
}
rs.close();
for(i=0;i<organChildID.length;i++)
{
modifyRoleID(roleIDString,organChildID[i]);
}
}
catch(Exception err)
{System.out.print(err.getMessage()) ;
return -1;
}
return flag ;
}这样写就改对了
rs.last();
String[] organChildID=new String[rs.getRow()];
rs.close();
rs=queryParent(organID);
int i=0;
while(rs.next())
{
organChildID[i]=rs.getString("id");
i++;
}
rs.close();
for(i=0;i<organChildID.length;i++)
{
modifyRoleID(roleIDString,organChildID[i]);
}这段怎么改好呢,不然连了两次数据库,还有就是要有人拿分啊