How to copy Mysql databse from one Computer to another / backup database using mysqldump

             We can take backup of MySQL database by using musqldump.

             We can transfer a MySQL database from one PC to another PC using mysqldump command. We have to create dump file of database to transfer database from one PC to another PC.

          MySQL databse is not portable database i.e. we cannot transfer it from one PC to another PC by copying and pasting it. We can use following method to transfer database.

1.   Creating a dumpfile from database/ Taking backup of MySQL database:

-  Open command prompt.

-  Execute following commands to change directory

>c:  “press enter”

>cd  program files/MySQL/MySQL Server 5.1/ bin “press enter”

>mysqldump -u root  -p databse_name > database_name.sql  “press enter”

  Enter password: password of MySQL

Copy sql file and paste it in PC where you want to transfer database.

.          2. Dumping sql file into database:-

          - Open MySQL  command line client command prompt.

          - Execute following command to create database.

                 >create database database_name;  “press enter”

Database name is must as that of your database _name.

Copy that sql file into location “c:/program files/MySQL/MySQL Server 5.1/bin”

          - Now open command prompt and execute following commands.

                >C: “press enter”

                >cd program files/MySQL/MySQL Server5.1/bin “press enter”

                >mysql –u root –p database_name < database_name.sql “press enter”

           Your database is created on PC.

           Now in MySQL command prompt check your database.  

Java database connectivity with MySQL Server Databse

easywayprogramming.com java database connectivity with mysql database

Before executing following program follow instruction in following link:

database connectivity instruction 

my_sql.java
import java.sql.*;
import java.io.*;

public class my_sql
{
    public my_sql()
    {
        try
        {
            Class.forName("com.mysql.jdbc.Driver").newInstance();
            System.out.println("Driver loaded!!!!!!!!!");
            Connection con = DriverManager.getConnection("jdbc:mysql://localhost/employee","root","ashu");
            System.out.println("connection made!!!!!!!!!");
            Statement stmt = con.createStatement();
            ResultSet rs = stmt.executeQuery("select *from emp");

            while (rs.next())
            {
                 System.out.println(rs.getInt(1)+"\t"+rs.getString(2)+"\t\t\t"+rs.getString(3)+"\t\t\t"+rs.getString(4));
            } //end while

            con.close();
        }
        catch(Exception e)
        {
            e.printStackTrace();
        }
    }

       public static void main(String[] args)
    {
        new my_sql();
    }
}

click here: Back to Tricks/Solution

sending image object through socket in java classic example

easywayprogramming.com sending image object through socket in java classic example 

       Sending image through socket connection in java is not so difficult task. Many peoples found it difficult to do it. many times we need to send images through network socket from one computer to another computer. Now we are going to see how we can send image through socket in java. It is very interesting.

client side coding:

GreetingClient.java

import java.net.*;
import java.io.*;
import java.awt.*;
import javax.imageio.*;

public class GreetingClient
{
    Image newimg;
    BufferedImage bimg;
    byte[] bytes;

   public static void main(String [] args)
   {
      String serverName = "localhost";
      int port = 6066;
      try
      {
         System.out.println("Connecting to " + serverName
                             + " on port " + port);
         Socket client = new Socket(serverName, port);

         System.out.println("Just connected to "
                      + client.getRemoteSocketAddress());

        DataInputStream in=new DataInputStream(client.getInputStream());
        System.out.println(in.readUTF());
        System.out.println(in.readUTF());

         DataOutputStream out =
                       new DataOutputStream(client.getOutPutStream());

         out.writeUTF("Hello from "
                      + client.getLocalSocketAddress());
         out.writeUTF("client: hello to server")

         ImageIcon img1=new ImageIcon("Ashish.jpg");
         Image img = img1.getImage();
         Image newimg = img.getScaledInstance(100, 120,  java.awt.Image.SCALE_SMOOTH);
         ImageIcon newIcon = new ImageIcon(newimg);

         bimg = ImageIO.read(new File("D:\adi-siddhi\DSC02503.JPG"));

         ImageIO.write(bimg,"JPG",client.getOutputStream());
         System.out.println("Image sent!!!!");
         client.close();
      }catch(IOException e)
      {
         e.printStackTrace();
      }
   }
}

severside coding:

GreetingSever.java

import java.net.*;
import java.io.*;

public class GreetingServer extends Thread
{
       private ServerSocket serverSocket;
       Socket server;

       public GreetingServer(int port) throws IOException, SQLException, ClassNotFoundException, Exception
       {
          serverSocket = new ServerSocket(port);
          serverSocket.setSoTimeout(180000);
       }

       public void run()
       {
           while(true)
          {
               try
               {
                  server = serverSocket.accept();
                  DataInputStream din=new DataInputStream(server.getInputStream());
                  DataOutputStream dout=new DataOutputStream(server.getOutputStream());

                  dout.writeUTF("server: -i am greeting server");
                  dout.writeUTF("server:- hi! hello client");

                  System.out.println(din.readUTF());
                  System.out.println(din.readUTF());

                  BufferedImage img=ImageIO.read(ImageIO.createImageInputStream(socket.getInputStream()));

                  System.out.println("Image received!!!!");
                  //lblimg.setIcon(img);
              }
             catch(SocketTimeoutException st)
             {
                   System.out.println("Socket timed out!");
                  break;
             }
             catch(IOException e)
             {
                  e.printStackTrace();
                  break;
             }
             catch(Exception ex)
            {
                  System.out.println(ex);
            }
          }
       }
      
       public static void main(String [] args) throws IOException, SQLException, ClassNotFoundException, Exception
       {
              //int port = Integer.parseInt(args[0]);
              Thread t = new GreetingServer(6066);
              t.start();
       }
}

Run the program as it is. first run greetingserver. java,  then greetingclient.java.

http://easywayprogramming.com/Java/sending-image-object-through-socket-in-java-classic-example.aspx?code=6&lan=j 

Follow the important rules given in post

socket programming in java classic example

How To draw image on JFrame through graphics:
Drawing image through graphics in java

drawing image through graphics in java

 easywayprogramming.com drawing image through graphics in java

we are going to see how we can draw a image into frame using graphics

print.java

import java.awt.Canvas;
import java.awt.Dimension;
import java.awt.Graphics;
import java.awt.PrintJob;
import java.awt.Toolkit;
import java.awt.Color;

import javax.swing.JFrame;
import java.util.Properties;

public class print extends JFrame
{
      PrintCanvas my_canvas = new PrintCanvas();

      public print()
      {
        add("Center", my_canvas);
        setSize(500, 500);
        setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
        setTitle("Ashish Wagh");
        setVisible(true);
        String name = "Ashish Wagh";

        Properties properties = new Properties();
        PrintJob pj = Toolkit.getDefaultToolkit().getPrintJob(print.this, name, properties);
        if (pj != null)
        {
              my_canvas.printAll(pj.getGraphics());
              pj.end();
        }
      }

      public static void main(String args[])
      {
        print p= new print();
      }
}

class PrintCanvas extends Canvas
{
  public void paint(Graphics g)
  {
    Dimension size = getSize();
    int width = size.width;
    int height = size.height;
    int x1 = (int) (width * 0.1);
    int x2 = (int) (width * 0.9);
    int y1 = (int) (height * 0.1);
    int y2 = (int) (height * 0.9);

    g.setColor(Color.YELLOW);
    g.fillRect(x1, y1, x2 - x1, y2 - y1);
    g.setColor(Color.GREEN);
    g.drawRect(x1, y1, x2 - x1, y2 - y1);
    g.drawOval(x1, y1, x2 - x1, y2 - y1);
    g.setColor(Color.RED);
    g.drawLine(x1, y1, x2, y2);
    g.drawLine(x2, y1, x1, y2);
    g.setColor(Color.BLACK);
    String text = "Ashish!";
    text += text;
    text += text;
    g.drawString(text, x1, (int) ((y1 + y2) / 2));
    g.drawString("Ashish",(int)(width/2)-(width/20), (int)(y1+(y2/4)));
    g.drawString("Ashish",(int)(width/2)-(width/20), (int)(y1+((3*y2)/4)));

    Image img = new ImageIcon("Ashish_photo.JPG").getImage();    
    Image newimg = img.getScaledInstance(100, 120,  java.awt.Image.SCALE_SMOOTH); 
    ImageIcon newIcon = new ImageIcon(img);    
    g.drawImage(newIcon.getImage(), 250, 70, 100,120, null);
    g.dispose();
  }
}

        In above example we, create a image icon of photo and get image from that photo. Then we create new image from old image by using method getScaledInstance(new Width, new height, java.awt.Image.SCALE_SMOOTH);
        Then we create new image icon from new image, and get image from that ImageIcon.
       now using drawImage(image, position x, position y, new width, new height, null) method in graphics we can draw that image.

how to resize ImageIcon in java

 easywayprogramming.com how to resize imageicon in java

When we apply image icon to any component like button, label or panel, it not apply properly because of size of that image. We can resize that image icon in two ways. 

1. first way: 

Image img = myIcon2.getImage(); Image newimg = img.getScaledInstance(230, 310,  java.awt.Image.SCALE_SMOOTH);  

newIcon = new ImageIcon(newimg); 

2. second way: 

 Image img = myIcon2.getImage();  BufferedImage bi = new BufferedImage(img.getWidth(null), img.getHeight(null), BufferedImage.TYPE_INT_ARGB);  

newIcon = new ImageIcon(bi);

All about arrays in java

•  Arrays are way to store a list of items. Each slot of an array holds an individual element, and you can place into or change the contents of those slots as you need to.
• Arrays can contain any type of element value(primitive types or objects), but you cant store different types in single array. You can have array of integers, or arrays of string.
• To create an array in Java, you use three steps :

1.        Declare a variable to hold the array. 
2.        Create a new array object and  assign it to the array variable.
3.        Store things in that array. 

Declaring array variables:

• The first step in creating an array is creating an variable that will hold the array, just as you would any other variable.
• Array variables indicate the type of object the array will hold and the name of the array, followed by empty square brackets [].
• Following are the examples of Array declarations:

                int values[];
                float cost[];
                String months[];

• There is another way to declare the array allowed in java as shown below:

                String[] names;
                int[] numbers;

Creating array object:
         The second step is to create an array object and assign it to that variable. There are two ways to do this :

• using new
• Directly initializing the contents of that array

The first way is to use the new operator to create new instance of an array:
      int[] values=new values[10];
This will creates anew array of int with size10.

• When you create a new array object using new, you must indicate how many slots that array will hold.
• You can create & initialize array at same time. Instead of using new to create the new array object, enclose the elements of the array inside braces, separated by commas:

                   int[] values={1,2,3,4,5};

• Each of the elements inside the braces must be of the same type as the variable that holds that array.
• An array the size of the number of elements you've included will be automatically created for you.

Accessing array elements:

• Once you have array with an initial values, you can test and change the values in each subscript of that array. To get a value stored within an array, use the array subscript expression:

                      arrayname[subscript];

• The arrayname is the name of array. The subscript is index of array elements stored in array. Array subscript starts with 0. So an array with 10 elements has 10 array elements accessed using subscript 0 to 9.
• Note that all array subscripts are checked to make sure that they are inside the boundaries of the array. Note the following two statements, for example:

                       String[] arr=new String[10];
                       arr[10]="Ashish";

• A program with that last statement in it produces acompiler error at that linewhen you try to compile it. The array stored in arr has size as 10, the element at subscript 10 doesn't exist, and java compiler will check for that.
• If the array subscript calculated  at run-time & ends up outside the boundaries of the array, the java interpreter also produces an error.

Changing array elements:

• To assign a particular value array slot, merely put an assignment statement after the array access expression:

                            values[2]= 45;
                            months[3]="March";

Example of arrays:
//program of sorting of array
class IntSorting
{
         public static void main(String args[])
        {
                  int num[]={55,40,80,65,01,71};
                  int n=num.length;
                  System.out.print("Give list as :");
                  for(int i=0 ; i<n ; i++)
                          System.out.print(" "+num[i]);
                  System.out.println("\n");

                  for(int i=0; i<n ; i++)
                  {
                          for(int j=i+1; j<n; j++)
                          {
                                   if(num[i]>num[j])
                                    {
                                              int temp=num[i];
                                              num[i]=num[j];
                                              num[j]=temp;
                                    }
                          }
                  }

                  System.out.print("Sorted list: ");
                  for(int k=0; k<num.length; k++)
                          System.out.print(" "+num[k]);
                  System.out.println("\n");
        } 
}

Output:
Given list: 55 40 80 65 1 71
Sorted list: 1 40 55 65 71 80

How to print contents of JFrame in java

easywayprogramming.com How to print contents of jframe in java
How to print contents of jframe in java?

Many developers found it difficult to print contents of jframe in java.
Following example shows how to do it.

print.java

import java.awt.Canvas;
import java.awt.Dimension;
import java.awt.Graphics;
import java.awt.PrintJob;
import java.awt.Toolkit;
import java.awt.Color;

import javax.swing.JFrame;
import java.util.Properties;

public class print extends JFrame
{
      PrintCanvas my_canvas = new PrintCanvas();

      public print()
      {
        add("Center", my_canvas);
        setSize(500, 500);
        setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
        setTitle("Ashish Wagh");
        setVisible(true);
        String name = "Ashish Wagh";

        Properties properties = new Properties();
        PrintJob pj = Toolkit.getDefaultToolkit().getPrintJob(print.this, name, properties);
        if (pj != null)
        {
              my_canvas.printAll(pj.getGraphics());
              pj.end();
        }
      }

      public static void main(String args[])
      {
        print p= new print();
      }
}

class PrintCanvas extends Canvas
{
  public void paint(Graphics g)
  {
    Dimension size = getSize();
    int width = size.width;
    int height = size.height;
    int x1 = (int) (width * 0.1);
    int x2 = (int) (width * 0.9);
    int y1 = (int) (height * 0.1);
    int y2 = (int) (height * 0.9);

    g.setColor(Color.YELLOW);
    g.fillRect(x1, y1, x2 - x1, y2 - y1);
    g.setColor(Color.GREEN);
    g.drawRect(x1, y1, x2 - x1, y2 - y1);
    g.drawOval(x1, y1, x2 - x1, y2 - y1);
    g.setColor(Color.RED);
    g.drawLine(x1, y1, x2, y2);
    g.drawLine(x2, y1, x1, y2);
    g.setColor(Color.BLACK);
    String text = "Ashish!";
    text += text;
    text += text;
    g.drawString(text, x1, (int) ((y1 + y2) / 2));
    g.drawString("Ashish",(int)(width/2)-(width/20), (int)(y1+(y2/4)));
    g.drawString("Ashish",(int)(width/2)-(width/20), (int)(y1+((3*y2)/4)));
    g.dispose();
  }
}