Data Retrive from mysql in java

In previous post we see hoe to connect mysql database in java now we see how to perform data insert and other operation
Data insert in mysql by java.
Samole code:

     Connection connection;
    Statement statement;
    ResultSet resultSet ;
    ResultSetMetaData metaData;
    String JDBC_DRIVER = "com.mysql.jdbc.Driver";
    String DATABASE_URL = "jdbc:mysql://localhost/mysql";
    //JOptionPane.showMessageDialog(null,"adsas");
    try{
    Class.forName( JDBC_DRIVER );
        connection =DriverManager.getConnection( DATABASE_URL, "root", "" );
            statement =connection.createStatement();
            DATABASE_URL = "jdbc:mysql://localhost/address";
            connection =DriverManager.getConnection( DATABASE_URL, "root", "" );
            statement =connection.createStatement();

           String Name=jTextField1.getText();
        String sql2="INSERT INTO addressbook VALUES('"+Name+"')";
            statement.executeUpdate(sql2);

    }
    catch(Exception e)
    {
         JOptionPane.showMessageDialog(null,e.toString());
    }
   
   
   
Data update in mysql by java.

Sample code:

   Connection connection;
    Statement statement;
    ResultSet resultSet ;
    ResultSetMetaData metaData;
    String JDBC_DRIVER = "com.mysql.jdbc.Driver";
    String DATABASE_URL = "jdbc:mysql://localhost/mysql";
    //JOptionPane.showMessageDialog(null,"adsas");
    try{
    Class.forName( JDBC_DRIVER );
        connection =DriverManager.getConnection( DATABASE_URL, "root", "" );
            statement =connection.createStatement();
            DATABASE_URL = "jdbc:mysql://localhost/address";
            connection =DriverManager.getConnection( DATABASE_URL, "root", "" );
            statement =connection.createStatement();

           String Name=jTextField1.getText();
           String Name1=jTextField2.getText();
       String sql3="UPDATE addressbook SET Name='"+Name1+"'where Name='"+Name+"'";
            statement.executeUpdate(sql3);

    }
    catch(Exception e)
    {
         JOptionPane.showMessageDialog(null,e.toString());
    }
   
Delete query in java.
Sample code:


          Connection connection;
    Statement statement;
    ResultSet resultSet ;
    ResultSetMetaData metaData;
    String JDBC_DRIVER = "com.mysql.jdbc.Driver";
    String DATABASE_URL = "jdbc:mysql://localhost/mysql";
    //JOptionPane.showMessageDialog(null,"adsas");
    try{
    Class.forName( JDBC_DRIVER );
        connection =DriverManager.getConnection( DATABASE_URL, "root", "" );
            statement =connection.createStatement();
            DATABASE_URL = "jdbc:mysql://localhost/address";
            connection =DriverManager.getConnection( DATABASE_URL, "root", "" );
            statement =connection.createStatement();

           String Name=jTextField1.getText();

       String sql4="DELETE FROM addressbook WHERE Name ='"+Name+"'";
            statement.executeUpdate(sql4);

    }
    catch(Exception e)
    {
         JOptionPane.showMessageDialog(null,e.toString());
    }
   
Data retrive in java.

Sample code1:

Connection connection;
    Statement statement;
    ResultSet resultSet ;
    ResultSetMetaData metaData;
    String JDBC_DRIVER = "com.mysql.jdbc.Driver";
    String DATABASE_URL = "jdbc:mysql://localhost/address";

    try{
    Class.forName( JDBC_DRIVER );
    connection =DriverManager.getConnection( DATABASE_URL, "root", "" );
    statement =connection.createStatement();
     String Name=jTextField1.getText();
    resultSet = statement.executeQuery(
             "SELECT * FROM addressbook where Name ='"+Name+"'" );
 while ( resultSet.next() )
 {
          String str=""+resultSet.getObject( 1 );
          jTextField2.setText(str);
  }

    }
    catch(Exception e)
    {
         JOptionPane.showMessageDialog(null,e.toString());
    }
   
Sample code2:

Connection connection;
    Statement statement;
    ResultSet resultSet ;
    ResultSetMetaData metaData;
    String JDBC_DRIVER = "com.mysql.jdbc.Driver";
    String DATABASE_URL = "jdbc:mysql://localhost/address";

    try{
    Class.forName( JDBC_DRIVER );
    connection =DriverManager.getConnection( DATABASE_URL, "root", "" );
    statement =connection.createStatement();
    resultSet = statement.executeQuery(
             "SELECT * FROM addressbook" );
 while ( resultSet.next() )
 {
          String str=""+resultSet.getObject( 1 );
          jTextField2.setText(str);
          JOptionPane.showMessageDialog(null,str);
  }

    }
    catch(Exception e)
    {
         JOptionPane.showMessageDialog(null,e.toString());
    }
   
   
Download full project.
Sample java Project
If you have any question please ask me.