Please show/write step by step on how to set up and connect to database on NETBEANS using JDBC with the following code.

I have tried but can not connect or set up the database.

I also tried putting in the JAR into the library.

I tried this post suggestion - https://www.chegg.com/homework-help/questions-and-answers/please-show-write-step-step-set-connect-database-netbeans-using-jdbc-following-code-tried--q25326758

This is my output -

--------------------------------------------------------------------

package Database;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.util.Scanner;

public class AnimalDb{

private String name;

private String color;

private String swim;

private String vertibrate;

//creating instance variable

public static Connection getConnection(){

// here we creating static connection method

// when we required connection object that time just call this method

Connection connection=null;

try {

String driver ="com.mysql.jdbc.Driver";

// for mysql driver

String url ="jdbc:mysql://localhost:3306/mydb";

// mydb is my database name

//NOTE:whene you run this you should import jar of mysql-connection

String user ="root";

String password = "root";

// my username and password

Class.forName(driver);

connection = DriverManager.getConnection(url, user, password);

// System.out.println(connection);// driver type

} catch (ClassNotFoundException e)

{

System.out.println("Dao MSG:Excetopn occur at DbConnection class:Class not found exception ");

e.printStackTrace();

} catch (SQLException e) {

System.out.println("Dao MSG:Excetopn occur at DbConnection class:SQL exception ");

e.printStackTrace();

}

return connection;

}

// method for insert record

public void insertData(){

Scanner scan=new Scanner(System.in);

System.out.println("Enter Animal Name");

name=scan.next();

System.out.println("Enter Animal Color");

color=scan.next();

System.out.println("Can This Animal Swim");

swim=scan.next();

System.out.println("Does It is Have a Vertibrate");

vertibrate=scan.next();

try {

final String sql="insert into animal values(?,?,?,?,?)";

// query for insert record

Connection connection=AnimalDb.getConnection();

// calling getconnection() method which is static for get connection object

PreparedStatement ps=connection.prepareStatement(sql); // passing sql query to statement

ps.setInt(1,0);

ps.setString(2,name);

ps.setString(3,color);

ps.setString(4,swim);

ps.setString(5,vertibrate);

int i=ps.executeUpdate();

if(i==1) {

System.out.println("Data Inserted Sucesfully");

}

else {

System.out.println("Data Not Inserted ");

}

}

catch(SQLException ee) {

// for exception handling

ee.getStackTrace();

}

catch (Exception e) {

e.printStackTrace();

// TODO: handle exception

}

}

public static void main(String[] args) {

// TODO Auto-generated method stub

Scanner scan = new Scanner(System.in);

char ch;

AnimalDb db=new AnimalDb();

// creating object of class

/* Perform menu operations */

do

{

System.out.println("--------------Animal Database--------------------------");

System.out.println("1. Insert Animal ");

System.out.println("2. Dispay Animal Record ");

System.out.println("3. Search Animal Record ");

System.out.println("4. Update Animal Record ");

System.out.println("5. Delete Animal Record ");

System.out.println("6. Exit");

System.out.println("Enter Your choice");

System.out.println("------------------------------------------------------------");

int choice = scan.nextInt();

switch (choice)

{

case 1 :

//calling method to insert data into db

db.insertData();

break;

case 2 :

// calling method to display record

db.showData();

break;

case 3 :

System.out.println("Enter Name of Animal to Search record");

// asking user to enter record for search

String animalName=scan.next();

boolean result= db.searchData(animalName);

// calling search method

if(result!=true){

System.out.println("Rocord Not found");

}

break;

case 4 :

System.out.println("Enter Name of Animal to update record");

String animalName1=scan.next();

boolean result1= db.searchData(animalName1);

// calling method to update record ,first checking data is present or not

// using search method if present then update

if(result1!=true){

System.out.println("Rocord Not found Update found");

}else{

db.updateData(animalName1);

}

break;

case 5 :

System.out.println("Enter Name of Animal to Delete record");

String animalName2=scan.next();

boolean result2= db.searchData(animalName2);

if(result2!=true){

System.out.println("Rocord Not Found To Delete found");

}else{

db.deleteData(animalName2);

}

break;

case 6:

System.exit(0); // for exit

break;

default :

System.out.println("Wrong Entry ");

// if wrong input

break;

}

System.out.println(" Do you want to continue (Type y or n) ");

ch = scan.next().charAt(0);

} while (ch == 'Y'|| ch == 'y');

}

//method for delete record

public void deleteData(String animalName ) {

Connection conn=null;

try {

final String sql="delete from animal where name='"+animalName+"'";

conn=AnimalDb.getConnection();

PreparedStatement ps=conn.prepareStatement(sql);

int rs=ps.executeUpdate();

if(rs!=0){

System.out.println("Rocord Deleted Successfully");

}

else{

System.out.println("Rocord not Deleted ");

}

}

catch (Exception e) {

e.printStackTrace();

}

}

// method for update records

public void updateData(String animalName) {

Scanner scan=new Scanner(System.in);

// asking user for reenter data for update

System.out.println("ReEnter Animal Color");

color=scan.next();

System.out.println("ReEnter Can This Animal Swim");

swim=scan.next();

System.out.println("ReEnter Does It is Have a Vertibrate");

vertibrate=scan.next();

try {

final String sql="update animal set color=?,swim=?,vertibrate=? where name='"+animalName+"'";

// query for update record

Connection connection=AnimalDb.getConnection();

PreparedStatement ps=connection.prepareStatement(sql);

ps.setString(1,color);

ps.setString(2,swim);

ps.setString(3,vertibrate);

int i=ps.executeUpdate();

if(i!=0) {

System.out.println("Data Updated Sucesfully");

}

else {

System.out.println("Data Not Inserted ");

}

}

catch(Exception ee) {

ee.getStackTrace();

}

}

// method for show records

public void showData() {

Connection conn=null;

try {

final String sql="select * from animal";

// query for select all records

conn=AnimalDb.getConnection();

PreparedStatement ps=conn.prepareStatement(sql);

ResultSet rs=ps.executeQuery();

System.out.println("ID\tName\tColor\tSwim\tvertibrate");

while (rs.next()) {

// display all record one by one

System.out.print(rs.getInt("id")+"\t"+rs.getString("name")+"\t"+rs.getString("color")+"\t"+rs.getString("swim")+"\t"+rs.getString("vertibrate"));

System.out.println();

}

}

catch (SQLException e) {

e.printStackTrace();

}

catch(Exception e) {

e.getStackTrace();

}

}

// metod for search record

public boolean searchData(String animalName) {

boolean result=false;

Connection conn=null;

try {

final String sql="select * from animal where name='"+animalName+"'";

// query for select record by name

conn=AnimalDb.getConnection();// calling connection method to get connection object

PreparedStatement ps=conn.prepareStatement(sql);

ResultSet rs=ps.executeQuery();

if(rs.next()){

// display record from db to prompt

System.out.println("ID\tName\tColor\tSwim\tvertibrate");

System.out.print(rs.getInt("id")+"\t"+rs.getString("name")+"\t"+rs.getString("color")+"\t"+rs.getString("swim")+"\t"+rs.getString("vertibrate"));

System.out.println();

result=true;

}

else{

result=false;

}

}

catch (Exception e) {

e.printStackTrace();

}

return result;

}

}

/* table creation script and output

CREATE TABLE animal (

`id` INT NOT NULL AUTO_INCREMENT,

`name` VARCHAR(45) NULL,

`color` VARCHAR(45) NULL,

`swim` VARCHAR(45) NULL,

`vertibrate` VARCHAR(45) NULL,

PRIMARY KEY (`id`));

*/

To change this license header, choose License Headers in Project Properties To change thia template file, choose ToolaTemplates source Packages database and open the enplae in the edicr imelDb.java Libraries mysdeonnectorjava-5.1-44on.jar R- JDK 1.8 (Default package databaac: e | in port java . sql . Connection; 101mport java.aql. DriverManager: 2mport java.sq1.PreparedStatement: elo World myNumber Project420 ER Singleton database .AnmaDb > name > Output-Database (run) Testrg :D week! weFour - weekoneTest weekThree T1ger Enter Anaral Color Can Thi Animal Suin name-Navigator Animabb Do you want to contine Type y or nl sun. reflect.NetiveConstructorAcces5or Impl .nevInstence(Kst1veConstructorAcce 5 50r Impl. Jara :62) sun 'reflect Del t j.lang.reflect. Consrutor newInstance Constructor.jva:423 t com.my gl jdbe.Ui1 handl-NxIn tance (Util.jus 425) serchDSting animal eme): booleen ssor Impl.nevInstancetDe sorImpl :45) color : String name : String swim String ] veitute : String - e co.ay gi.jdbe.Mys4110.initr Myagiio-j v:841 con.ayaqi.1dbc.Connectionil.connectoaeTryonly IConnectionIpi2-3ava:2222) com.mysq1.1dbc.connection2tp1.1n1> name > Output-Database (run) Testrg :D week! weFour - weekoneTest weekThree T1ger Enter Anaral Color Can Thi Animal Suin name-Navigator Animabb Do you want to contine Type y or nl sun. reflect.NetiveConstructorAcces5or Impl .nevInstence(Kst1veConstructorAcce 5 50r Impl. Jara :62) sun 'reflect Del t j.lang.reflect. Consrutor newInstance Constructor.jva:423 t com.my gl jdbe.Ui1 handl-NxIn tance (Util.jus 425) serchDSting animal eme): booleen ssor Impl.nevInstancetDe sorImpl :45) color : String name : String swim String ] veitute : String - e co.ay gi.jdbe.Mys4110.initr Myagiio-j v:841 con.ayaqi.1dbc.Connectionil.connectoaeTryonly IConnectionIpi2-3ava:2222) com.mysq1.1dbc.connection2tp1.1n1>