package jdbcdemos;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Scanner;

public class SelectDemo4 {



	public static void main(String[] args) throws ClassNotFoundException, SQLException
	{

		 String address,name;
		 int billAmount, id;

		Class.forName("oracle.jdbc.driver.OracleDriver");
		Connection connection = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl","scott","tiger");

		String query = "insert into customer values ( ?,?,?,?)";

		Scanner scanner = new Scanner(System.in);

		System.out.println("Enter the id:");
		id = scanner.nextInt();

		System.out.println("Enter the name : ");
		name = scanner.nextLine();

		System.out.println("Enter the address :");
		address = scanner.nextLine();

		System.out.println("Enter the billAmount:");
		billAmount = scanner.nextInt();



		PreparedStatement statement = connection.prepareStatement(query);


		statement.setInt(1,id);
		statement.setString(2, name);
		statement.setString(3, address);
		statement.setInt(4,billAmount);


		statement.executeUpdate();
		System.out.println(name+" your record saved");
		scanner.close();
		statement.close();
		connection.close();
	}
}