Scriptella excel and javascript and database working demo

etl.xml

<!DOCTYPE etl SYSTEM "http://scriptella.javaforge.com/dtd/etl.dtd">
<etl>
    <connection id="log" driver="text"/>
    <connection id="log2" driver="text"/>
    <connection id="out" driver="text" url="data.sql"/>
    <connection id="in" driver="csv" url="tjzy.csv"/>
    <connection id="script" driver="script"/>
    <connection id="db" driver="oracle" url="jdbc:oracle:thin:@9.9.9.9:1528:r0Name" user="UserName"
                password="PASSWORD" classpath="$classpath"/>
    <!--   use JDK 1.7 change $JAVA_HOME , use IDEA  -->
    <!--    <query connection-id="script">-->
    <!--        <![CDATA[-->
    <!--        var daycount = 1;-->
    <!--        for (var i = 0; i < 60; i++) {-->
    <!--            daycount=i;-->
    <!--            query.next(); //Executes a child script element-->
    <!--        }]]>-->
    <!--        <script connection-id="log">-->
    <!--        </script>-->
    <!--    </query>-->
    <query connection-id="in">
        <query connection-id="db">
            SELECT ID FROM SECURITY.SEC_RESOURCE_T WHERE URL = '$URL';
            <script connection-id="log2" if="ID != null">
                $URL, $ID
            </script>
        </query>
        <script connection-id="out">

            -- $PAGE
            DELETE FROM SECURITYDATA.SEC_RESOURCE_T WHERE ID = '$RESOURCEID';
            INSERT INTO SECURITYDATA.SEC

        </script>
        <script connection-id="out">

            -- $PAGE
            DELETE FROM SECURITYDATA.SEC_MEMBER_RESOURCE_PAGE_T WHERE ID = '$RESOURCEPAGEID';

        </script>
    </query>

</etl>

image.png