package com.atos.jdbc;

import java.sql.*;
import java.util.Scanner;

public class JDBCDemo2 {

	private static final String DB_URL=
			"jdbc:oracle:thin:@localhost:1521:xe";
	private static final String USER_ID ="hr";
	private static final String PASSWORD ="hr";

	public static void main(String[] args) {
		// TODO Auto-generated method stub

		Connection conn = null;
		try{
			Class.forName("oracle.jdbc.OracleDriver");
			conn = DriverManager.getConnection(DB_URL,USER_ID,PASSWORD);
			Statement statement = conn.createStatement();
			int a,b;
			String c;
			Scanner scn = new Scanner(System.in);
			a=scn.nextInt();
			c=scn.nextLine();
			b=scn.nextInt();
			String sql1= "insert into Bill_Master values(?,?,?)";
			PreparedStatement p = conn.prepareStatement(sql1);
			p.setInt(1, a);
			p.setString(2, c);
			p.setInt(3,b);
			int insertCount = p.executeUpdate();
			final String sql=
					"Select * FROM Bill_Master";
			ResultSet result = statement.executeQuery(sql);

			while(result.next())
			{
				int bill = result.getInt("bill_no");
				String name = result.getString("customer_name");
				int amt = result.getInt("amount");
				System.out.println(bill+" "+name+" "+amt);

			}
		}catch(SQLException e){
			e.printStackTrace();
		}catch (ClassNotFoundException e){
			e.printStackTrace();
		}finally{

			try{
				conn.close();
			}catch (SQLException e){
				e.printStackTrace();
			}
		}

	}


}