Write a Java Program to insert the details of Actor(ano, name, movie) into database and display result in Uppercase.
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(); } }
Comments
Post a Comment