package com.javaorigin.jdbc.sample.cachedrowset;

import java.sql.*;

import javax.sql.rowset.CachedRowSet;

import com.sun.rowset.CachedRowSetImpl;

public class InsertCachedRowSet {
	public static void main(String[] args) throws Exception {
		CachedRowSet crs = new CachedRowSetImpl();
		//Class.forName("org.sqlite.JDBC");
		//Connection conn = DriverManager.getConnection("jdbc:sqlite:test.db");
		Class.forName("oracle.jdbc.driver.OracleDriver");
		Connection conn= DriverManager.getConnection("jdbc:oracle:thin:@javaorigin.com:1521:orcl","mydb","password123");		
		crs.setCommand("drop table if exists people;");
		crs.execute(conn);
		crs.setCommand("create table people (name)");
		crs.execute(conn);

		// First way to insert
		crs.setCommand("insert into people(name) values(?)");
		crs.setString(1, "Arunkumar");
		crs.execute(conn);
		// end of first way

		crs.setCommand("select * from people ");
		crs.execute(conn);

		// Second way to insert
		crs.moveToInsertRow();
		crs.updateString(1, "Arunkumar Subramaniam");
		crs.insertRow();
		crs.moveToCurrentRow();
		// end of second way

		while (crs.next()) {
			System.out.println("Name : " + crs.getString("name"));
		}

		conn.close();
	}
}