Insert Record -JDBC

 

import java.sql.*;

 class InsertRecord {

    public static void main(String args[])throws Exception

             {

   Class.forName("com.mysql.jdbc.Driver");

 Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3307/mca", "root", "");

 

                       Statement stmt = con.createStatement();

 

               stmt.executeUpdate("INSERT INTO class (cno, cname) VALUES (1, 'CS')");

            stmt.executeUpdate("INSERT INTO class (cno, cname) VALUES (2, 'IT')");

            stmt.executeUpdate("INSERT INTO class (cno, cname) VALUES (3, 'AI')");

 

              System.out.println("Multiple records inserted successfully");

 

                        con.close();

        } 

    }