Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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 COUNTRIES (COUNTRY_ID,COUNTRY_NAME,REGION_ID) 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(sql);
- conn.commit();
- }
- catch (SQLException e)
- {
- e.printStackTrace();
- }
- catch(ClassNotFoundException e)
- {
- e.printStackTrace();
- }
- finally
- {
- try
- {
- conn.close();
- }
- catch (SQLException e)
- {
- e.printStackTrace();
- }
- }
- }
- }
Add Comment
Please, Sign In to add comment