org.kernelab.basis.test.TestSQLKit Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of basis Show documentation

Basis Library

There is a newer version: 0.0.19-RELEASE

package org.kernelab.basis.test;

import java.sql.SQLException;

import org.kernelab.basis.JSON.JSAN;
import org.kernelab.basis.Tools;
import org.kernelab.basis.sql.DataBase;
import org.kernelab.basis.sql.DataBase.OracleClient;
import org.kernelab.basis.sql.SQLKit;
import org.kernelab.basis.sql.Sequel;

public class TestSQLKit
{

	public static void main(String[] args) throws SQLException
	{
		DataBase db = new OracleClient("orcl", "test", "TEST");

		SQLKit kit = db.getSQLKit();

		String sql = "insert into jdl_test_uuid (name, id, seq) values (?, CVM_GEN_ID, SEQ_DEMO.nextval)";

		Sequel seq = kit.execute(sql, new String[] { "id", "SEQ" }, new JSAN().add("mike"));

		Sequel keys = seq.getGeneratedKeys();

		String uuid = keys.getValueString(1);
		String seqno = keys.getValueString(2);

		Tools.debug(uuid + " " + seqno);

	}

}