| package online; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.SQLException; import java.sql.Statement; import java.util.Scanner; public class InsertRecord { public static void main(String args[]) throws Exception { Connection conn = null; String driver = “oracle.jdbc.driver.OracleDriver”; try { Class.forName(driver); System.out.println(“Driver loaded”); String url = “jdbc:oracle:thin:@localhost:1521:xe”; String uname = “system”; String pwd = “admin”; conn = DriverManager.getConnection(url, uname, pwd); System.out.println(“Connection is ready”); String query = “insert into account values(?, ?, ?)”; PreparedStatement ps = conn.prepareStatement(query); System.out.println(“Enter Account details : “); Scanner scan = new Scanner(System.in); int num = scan.nextInt(); String name = scan.next(); int balance = scan.nextInt(); ps.setInt(1, num); ps.setString(2, name); ps.setInt(3, balance); int count = ps.executeUpdate(); System.out.println(“Records updated : ” + count); } finally { if(conn != null) { conn.close(); System.out.println(“Connection closed”); } } } } |