package bd

import com.kms.katalon.core.annotation.Keyword

import groovy.sql.Sql

public class conexion {

@Keyword

def conectar(String host, String port, String sid, String username, String password){

String connectionString

connectionString = "jdbc:oracle:thin:@" + host + ":" + port + ":" + sid

def sql = Sql.newInstance(connectionString, username, password)

try {

        sql.eachRow("select a.cimsi, a.ciccid, b.cserial from tdatos_cliente a, tcliente b where a.qmovil=b.qmovil and a.qmovil='149083062'"){ row ->

         println row

   }
} finally {

sql.close()
}

}

}