Mysql data base connect in Java

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.*;
/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */

/**
 *
 * @author I B M
 */
public class MySql {
 private String User_Name;
 private String Email;
 private int ID_Card;
 private int Acount_Number;
 private int a;
 public MySql(String Name,String UEmail,int Card_Number,int Acount)
 {
     User_Name=Name;
     ID_Card=Card_Number;
     Acount_Number=Acount;
    Email=UEmail;
  
  
 }

    MySql(String Name, String Email, int Card_Number1) {
        throw new UnsupportedOperationException("Not supported yet."); //To change body of generated methods, choose Tools | Templates.
    }

    MySql() {
        throw new UnsupportedOperationException("Not supported yet."); //To change body of generated methods, choose Tools | Templates.
    }


 public void setEmail(String UEmail)
 {
     Email=UEmail;
 }
 public String getEmail()
 {
     return Email;
 }
 public void  setName1(String Name){
     User_Name=Name;
  
 }
 public String getName1()
 {
     return User_Name;
  
 }
 public void setCard(int Card_Number)
 {
     ID_Card=Card_Number;
 }
 public int getCard()
 {
     return ID_Card;
 }
 public void setAcount(int Acount)
 {
     Acount_Number=Acount;
  
 }
 public int getAcount()
 {
     return Acount_Number;
 }
 // connection with musql;
 

 public Connection getconnecton()
 {
     Connection con=null;
     try
     {
         PreparedStatement pst=null;
         ResultSet rs=null;
         Class.forName("com.mysql.jdbc.Driver");
         String url="jdbc:mysql://localhost:3306/javadb";
     con=DriverManager.getConnection(url,"root","");
     System.out.println("URL:"+url);
     System.out.println("Connection"+con);
  
     }
catch(Exception e)
{
    e.printStackTrace();
}
     return con;
 }
    


    }

  

..................................................................................................................................................................

/*

 * To change this template, choose Tools | Templates

 * and open the template in the editor.

 */

/**

 *

 * @author I B M

 */

import java.util.*;

import java.sql.*;

import javax.swing.*;

public class TestDataBase {

    public static void main(String []args)

    

        throws SQLException,ClassNotFoundException{

        String Choice;

      Choice= JOptionPane.showInputDialog("enter choice 1 For Find Table Name\n2 For Insert Data in the Table\n3 For read All Data Froom the table");

    int ChoiceInt=Integer.parseInt(Choice);

        switch(ChoiceInt)

        {

            

            case 1:

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

        //System.out.println("driver Loaded");

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

        DatabaseMetaData db=con.getMetaData();

                

        ResultSet rs=db.getTables(null, null, null,new String [] {"TABLE"});

        

        while(rs.next())

        

            JOptionPane.showMessageDialog(null,"Driver Loaded\nTable Found\nTable Name="+rs.getString("TABLE_NAME")+"");

      break;

            case 2:

    

            

        String Name;

        String Email = null;

        String Card_Number = null;

        String Acount = null;

       

        

        String Number_Of_Data;

     

       

        

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

       

        Number_Of_Data=JOptionPane.showInputDialog("enter number of data");

        int Number_Of_Data1=Integer.parseInt(Number_Of_Data);

        int count=1;

        while(count<=Number_Of_Data1)

        {

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

       Name= JOptionPane.showInputDialog("enter person "+count+" Name");

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

       Email= JOptionPane.showInputDialog("enter person "+count+" Email;");

       

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

     Card_Number=JOptionPane.showInputDialog("enter Id Card Number "+count+" person");

   int  Card_Number1=Integer.parseInt( Card_Number);

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

   Acount=JOptionPane.showInputDialog("enter Acount Number of "+count+" person");

        int Acount1=Integer.parseInt(Acount);

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

    MySql data=new MySql(Name,Email,Card_Number1,Acount1);

  con=data.getconnecton();

JOptionPane.showMessageDialog(null,"Name of the Student ="+data.getName1()+"\nEmail Of th student ="+data.getEmail()+"\n Id of the stusdent ="+ data. getCard()+"\nacount number"+data.getAcount());

    data.InsertData(con,data.getName1(),data.getEmail(),data.getCard(),data.getAcount());

    count++;

        }

      break;

            case 3:

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

        System.out.println("driver Loaded");

         con=DriverManager.getConnection("jdbc:mysql://localhost:3306/javadb","root","");

        Statement stm=con.createStatement();

         rs=stm.executeQuery("SELECT *FROM person");

        ResultSetMetaData rMata=rs.getMetaData();

       int i;

        for(i=1;i<=rMata.getColumnCount();i++)

       

           System.out.printf("%-12s\t", rMata.getColumnName(i));

           System.out.println();

           

        

        while(rs.next())

        {

             for(i=1;i<=rMata.getColumnCount();i++)

       

           System.out.printf("%-12s\t", rs.getObject(i));

           System.out.println();

        }

        con.close();

    }

    

        

        }

        

}