package com.RowSetUpdations.jdbc;

import javax.sql.rowset.JdbcRowSet;
import javax.sql.rowset.RowSetFactory;
import javax.sql.rowset.RowSetProvider;

public class RowSetUpdate {

public static void main(String[] args)
{
	JdbcRowSet rowSet = null;
	try {
		RowSetFactory factory = RowSetProvider.newFactory();
		rowSet = factory.createJdbcRowSet();
		rowSet.setUrl("jdbc:mysql://localhost:3306/SaiDataBase");
		rowSet.setUsername("root");
		rowSet.setPassword("ankit");
		rowSet.setCommand("SELECT * FROM PROJECT_DETAILS");
		rowSet.execute();
		while(rowSet.next()) {
		float project_Cost = rowSet.getFloat(3);
		if(project_Cost < 1000000) {
		project_Cost = project_Cost + 50000;
		rowSet.updateFloat(3, project_Cost);
		rowSet.updateRow();
		System.out.println(rowSet.getInt(1)+" Project Details Updated Successfully");
		}
		}
		} catch (Exception e) {
			e.printStackTrace();
			}finally {
				try {
          System.out.println ("Thank you for using app....");
					rowSet.close();
				} catch (Exception e) {
					e.printStackTrace();
				}
			}

	}

}