h

package com.atos.java.jdbc;

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

public class Demo_prepared {

	 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) {



	       final String sql= "INSERT INTO bill_master (billno,customer,amount) VALUES(?,?,?)";

	       Connection conn = null;
	        try
	        {
	            Class.forName("oracle.jdbc.OracleDriver");
	            conn = DriverManager.getConnection(DB_URL, USER_ID, PASSWORD);

	            PreparedStatement pstmt = conn.prepareStatement(sql);



	            Scanner sc = new Scanner(System.in);
	            System.out.println("enter billno");
		    	Integer a = sc.nextInt();
		    	System.out.println("enter customer name");
		    	String b = sc.next();
		    	System.out.println("enter amount");
		    	Integer c = sc.nextInt();
		    	pstmt.setInt(1, a);
		    	pstmt.setString(2, b);
		    	pstmt.setInt(3, c);

		    	int x = pstmt.executeUpdate();
		    	conn.commit();

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


	        }

	    }

	}