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.

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

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`));

*/