Write a JDBC program to insert a record in student table (rollno,name, course, percentage) and display all records of student table.

iimport java.sql.*; import java.util.Scanner;   class InsertStudent1 {     public static void main(String args[]) throws Exception {         Connection con;         PreparedStatement pstmt;         Statement stmt;         Scanner sc = new Scanner(System.in);           Class.forName("com.mysql.jdbc.Driver");           ...

Read More

Write a JDBC program to accept employee no from the user and update an employee record in employee table and display all record

import java.sql.*; import java.util.Scanner;   class UpdateEmployee {     public static void main(String args[]) throws Exception {                 PreparedStatement pstmt;         Statement stmt;         Scanner sc = new Scanner(System.in);                         Class.forName("com.mysql.jdbc.Driver");            Connection...

Read More

Write a JDBC program to accept rollno from the user and delete a record from student table and display all record after deleting.

   import java.sql.*; import java.util.Scanner;   class DeleteStudent {     public static void main(String args[]) throws Exception {                PreparedStatement pstmt;         Statement stmt;         Scanner sc = new Scanner(System.in);                           Class.forName("com.mysql.jdbc.Driver");            Connection...

Read More

Write a JDBC program to update the Doctor (dno, dname, city) information. Update city from ‘Pune’ to ‘Mumbai

  import java.sql.*;   class UpdateDoctor {     public static void main(String args[]) throws Exception {                 Statement stmt;              Class.forName("com.mysql.jdbc.Driver");           Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/mca", "root", "");               stmt = con.createStatement();           int...

Read More

Create JDBC application for product table with fields Id, name & price perform insert operation & display inserted data retrieved from table to the user

  import java.sql.*;   import java.util.Scanner;   class ProductJDBC {     public static void main(String args[]) throws Exception {                Class.forName("com.mysql.jdbc.Driver");                    Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/mca", "root", "");           Scanner sc...

Read More