Zero Exception – Java, Spring Boot & System Design Tutorials

Write a Java Program to insert the details of Actor(ano, name, movie) into database and display result in Uppercase.

Program:

import java.sql.*;
import java.io.*;

class Actor {
    public static void main(String args[]) throws SQLException, ClassNotFoundException, IOException {
        String name, movie;
        int ano;
        char ch;
        BufferedReader br;

        Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
        COnnection con = DriverManager.getConnection("jdbc:odbc:actorDSN");

        do {
            PreparedStatement stmt = con.prepareStatement("insert into actor values(?,?,?)");
            br = new BufferedReader(new InputStreamReader(System.in));

            System.out.println("Enter Actor No:");
            ano = Integer.parseInt(br.readLine());

            System.out.println("Enter Name:");
            name = br.readLine();

            System.out.println("Enter Movie Name:");
            movie = br.readLine();

            stmt.setInt(1, rollNo);
            stmt.setString(2, name);
            stmt.setString(3, movie);

            int r = stmt.executeUpdate();

            if(r>0) {
                System.out.println("Record Inserted.");
            }

            stmt.close();
            System.out.println("Add more Record Y/N");
            ch = (char)(br.read());
        } while(ch == 'y' || ch == 'Y');

        Statement s = con.createStatement();
        ResultSet res = s.executeQuery("select * from actor");

        while(res.next()){
            System.out.println("Actor No: "+res.getInt(1));
            System.out.println("Actor Name: "+res.getString(2).toUpperCase());
            System.out.println("Movie Name: "+res.getString(3).toUpperCase());
        }

        res.close();
        con.close();
    }
}