Question

Java program

*Connects to a MySQL database

*Retrieves a table's rows

*displays that table's rows.

*insert the rows via MySQL Workbench

Answer 1

If you have any problem with the code feel free to comment.

Program

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class DBConnNFetch {

   public static void main(String[] args) {

       DBConnNFetch dbc = new DBConnNFetch();
       dbc.createConnection();

   }

   void createConnection() {
       try {

           Class.forName("com.mysql.cj.jdbc.Driver");// this is the name of the mysql driver

           // (Database Driver, server address, port no., database name, username,
           // password)
           // supress the SSL error
           Connection con = DriverManager.getConnection(
                   "jdbc:mysql://localhost:3306/employee?autoReconnect=true&useSSL=false", "root",
                   "Aman@123");
          
           System.out.println("Database Connected Successfully");
           Statement stmt = con.createStatement(); // for creating statement to fetch and retrieve data from DB
           ResultSet rs = stmt.executeQuery("SELECT * FROM employees");// resultset hold the data
           rs.next();
           // using column name to get the value from that particular column
           System.out.print(rs.getString("id")+" ");
           System.out.print(rs.getString("first_name")+" ");
           System.out.print(rs.getString("last_name")+" ");
           System.out.print(rs.getString("age")+" ");
           System.out.print(rs.getString("current_status")+" ");
           stmt.close();

       } catch (ClassNotFoundException e) {

           System.err.println("Load Falied: " + e);

       } catch (SQLException e) {
           System.err.println("Connection Falied: " + e);
       }
   }

}

Output

Database Connected Successfully 1 John Wick 32 Excommunicado

Inserting Row to MySQL

1 . 2 INSERT INTO employees (id, last_name, first_name, middle_name, age, current_status) VALUES (4, "Kent", "Clark", 30, "Employed"); SELECT * FROM employee.employees;|| 3. Filter Rows: Edit: Result Grid id last_name 1 Wick 2 Wayne 3 Cage 4 Kent first_name middle_name John Bruce Cassie Clark NULL NULL age 32 29 26 30 3 Export/Import: Wrap Cell Content: LA current_status Excommunicado Vigilant employed Employed NULL NULL NULL NULL