• Home
• io.accur8
• a8-sync-api_3
• 1.0.0-20240221_1247_master
• source code
• SimpleJdbc.scala

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

a8.sync.demos.SimpleJdbc.scala Maven / Gradle / Ivy

package a8.sync.demos

import a8.shared.jdbcf

import java.sql.DriverManager
import com.ibm.as400.access.AS400JDBCDriver
import a8.shared.SharedImports._
import java.sql.{ Connection, ResultSet }

object SimpleJdbc extends App {

  new AS400JDBCDriver(): @scala.annotation.nowarn()

  val conn: Connection = DriverManager.getConnection("jdbc:as400://localhost", "gmarches", "mwrt3967")
//    val conn = DriverManager.getConnection("jdbc:as400://dev400.goodville.com?proxy server=goodville.vpn.accur8.io:3470", "gmarches", "mwrt3967")

  //  conn.createStatement().executeQuery("select * from PPITGDATA.CLPT006")

//  val rs = conn.getMetaData.getColumns(null, "PPITGDATA", "CLPT006", null)
//  val rs = conn.getMetaData.getPrimaryKeys(null, "PPITGDATA", "CLPT006")

  val rs: ResultSet =
    conn.createStatement.executeQuery("""
select * from table(key_list('PPITGDATA','CLPT006'))
  """)

  val l: Vector[jdbcf.Row] = jdbcf.resultSetToVector(rs)

//  l.foreach(row => println(row.unsafeAsJsObj.compactJson))


  println(l)

}