Nirav Raval's Blog For Java Developer

2013-06-27T09:16:00.002-07:00

Core Java Interview Questions

Hello Friends, Nice to see you again.

After lots of post related to Java Swing, Here, I come with core java part for Question and Answers.
This is not something new that you will see.
But I had always used other websites and blogs to read this stuff.
Now, I think I should also share this with others.
So enjoy this post.

Questions on OOPS Concepts

1. What are the principle concepts of OOPS?

There are four principle concepts upon which object oriented design and
programming rest. They are:

Polymorphism

Inheritance

Encapsulation

(i.e. easily remembered as PIE).

2. What is Encapsulation?

Encapsulation is a technique used for hiding the properties and

behaviors of an object and allowing outside access only as

appropriate. It prevents other objects from directly altering or

accessing the properties or methods of the encapsulated object.

3. What is Inheritance?

Inheritance is the process by which objects of one class acquire

the properties of objects of another class.

A class that is inherited is called a superclass.

The class that does the inheriting is called a subclass.

Inheritance is done by using the keyword extends.

The two most common reasons to use inheritance are:

1. To promote code reuse

2. To use polymorphism

4. What is Polymorphism?

Polymorphism is briefly described as "one interface, many

implementations."

Polymorphism is a characteristic of being able to assign a different

meaning or usage to something in different contexts - specifically,

to allow an entity such as a variable, a function, or an object to

have more than one form.

5. What is run-time polymorphism or dynamic method dispatch?

In Java, run-time polymorphism or dynamic method dispatch is

a process in which a call to an overridden method is resolved

at run-time rather than at compile-time.

In this process, an overridden method is called through the

reference variable of a superclass. The determination of the method

to be called is based on the object being referred to by the reference

variable.

6. What is method overloading?

Method Overloading means to have two or more methods with same
name in the same class with different arguments. The benefit of
method overloading is that it allows you to implement methods
that support the same semantic operation but differ by argument
number or type.
Note:
Overloaded methods MUST change the argument list
Overloaded methods CAN change the return type
Overloaded methods CAN change the access modifier
Overloaded methods CAN declare new or broader checked exceptions
A method can be overloaded in the same class or in a subclass

7. What is method overriding?

Method overriding occurs when sub class declares a method that has

the same type arguments as a method declared by one of its

superclass.

The key benefit of overriding is the ability to define behavior that’s

specific to a particular subclass type.

Note:

* The overriding method cannot have a more restrictive access

modifier than the method being overridden (Ex: You can’t override

a method marked public and make it protected).

* You cannot override a method marked final

* You cannot override a method marked static.

8. Is it possible to override the main method?

No.

String Class

2012-07-20T22:58:00.002-07:00

String Class

Hello Friends, Nice to see you again.

After lots of post related to Java Swing, Here, I come with core java part.

String is the class which is mostly used in every java based applications.

We can say that java applications can not be imagined without the String Class.... :)

Here we will discuss the core feature of String class.

So sit tight for unforgoettable journey of Java String Class....

Strings Are Immutable Objects:

In Java, each character in a string is a 16-bit Unicode character. Because Unicode characters are 16 bits (not the skimpy 7 or 8 bits that ASCII provides), a rich, international set of characters is easily represented in Unicode.

In Java, strings are objects. Just like other objects, you can create an instance of a String with the new keyword, as follows:

String s = new String();

This line of code creates a new object of class String, and assigns it to the reference variable s. So far, String objects seem just like other objects. Now, let's give the String a value:

s = "abcdef";

As you might expect, the String class has about a zillion constructors, so you can use a more efficient shortcut:

String s = new String("abcdef");

And just because you'll use strings all the time, you can even say this:

String s = "abcdef";

What they have in common is that they all create a new String object, with a value of "abcdef", and assign it to a reference variable s. Now let's say that you want a second reference to the String object referred to by s:

String s2 = s; // refer s2 to the same String as s

Here you feel nothing special right..? But the word Immutability! comes here in play

(What the heck is immutability?)....

Once you have assigned a String a value, that value can never change— it's immutable, frozen solid, won't budge, fini, done.

The good part is that though the String object is immutable, its reference variable is not.

Lets understand with the example:

s = "abcdef";

s = s.concat(" more stuff"); // the concat() method 'appends'

// a literal to the end

Here as we said earlier, String is immutable, then what the heck is this --- appending old string..!

This is the tricky part of String Class. Here please pay attention how VM behaves...!

First ,the value s contains was "abcdef", then we append it and now VM add " more stuff" at the end.

Now new String will be ""abcdef more stuff".

Now At this point in our example, we have two String objects: the first one we created, with the value "abcdef", and the second one with the value "abcdef more stuff".

Here ehat happened....we assigned s to s2 earlier then we append s with " more stuff".

If we did not assign s to s2 then after append s the old String "abcdef" would be lost in memory...

Surprise...! This is because when you append the old String object with adding new String at the end of it. It will create another new String with old String + new appended String.

And the older value will be lost in memory without any reference variable.

Look the below image for better understanding of working of String in Memory...

The above figure shows what happens on the heap when you reassign a reference variable. Note that the dashed line indicates a deleted reference.

To review our first example:

String s = "abcdef"; // create a new String object, with value "abcdef", refer s to it

String s2 = s; // create a 2nd reference variable referring to the same String

// create a new String object, with value "abcdef more stuff",

// refer s to it. (Change s's reference from the old String to the new String.)
//( Remember s2 is still referring to the original "abcdef" String.)

// s = s.concat(" more stuff");

So this is how String is really Immutable....

Note: Please do not use String in you code where too much updation and modification in String is required...In thiat case use StringBuilder Class.

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

So I hope this post is helpful in understanding Of String Class.

Feel free to ask me if you have any dought regarding this.

You can also give me suggessions to improve this post.

Leave comments if you like this post...!

Thank you.

Nirav Raval

Import Excel Data into JTable

2012-01-02T07:28:00.001-08:00

Import Excel Data into JTable

Hello Friends,

Nice to see you again. This post is the requirement which is asked from my fellow friends amongst you..

In Previous Sessions we have seen the examples related to JTable with excel and jTable with MySQL database.

Here We will reverse the previous JTable example of export JTable data into Excel sheet..

We will create one Window which will ask from user for import excel file.

After click on Select Excel File button, fileChooser will be opened and User

has to select only Excel file and the excel sheet data will be displayed in JTable.

As there is no such direct method which provide you this facility at once.

So we have to write some sort of code to enable of filling JTable with Data from Excel file.

It is very easy to understand the code for this. When you run the code following will be output:

Here in above window, user will see nothing but one button for asking Excel file. Just click on that button and you will see fpllowing:

Here is the jFilechooser, from this you have to choose excel file having extension ".xls". Otherwise following Error message will be displayed:

Note: If you want to go with MS Office 2007 Excel, you have to customise this code little bit.

Now after select excel file the data in that Excel file will be shown in JTable as below:

OK For this you have to create one class called excelTojTable.java

and paste the below code in it.

And run it....Simple right..?

Note: In this code All the Dynamic Part logic is done in

fillData() method. So focus on that method...

Note: To run this example successfully you have to download and add "jxl.jar" file.

import java.awt.*;
import java.awt.event.*;
import java.io.File;
import java.io.IOException;
import java.util.Vector;
import java.util.logging.Level;
import java.util.logging.Logger;

import javax.swing.*;
import javax.swing.table.DefaultTableModel;
import jxl.Cell;

import jxl.Sheet;
import jxl.Workbook;
import jxl.read.biff.BiffException;

public class excelTojTable extends JFrame {

 static JTable table;
 static JScrollPane scroll;
 // header is Vector contains table Column
 static Vector headers = new Vector();
 // Model is used to construct JTable
 static DefaultTableModel model = null;
 // data is Vector contains Data from Excel File
 static Vector data = new 
   Vector();
 static JButton jbClick;
 static JFileChooser jChooser;
 static int tableWidth = 0; // set the tableWidth
 static int tableHeight = 0; // set the tableHeight

 public excelTojTable() {
  super("Import Excel To JTable");
  setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
  JPanel buttonPanel = new JPanel();
  buttonPanel.setBackground(Color.white);
  jChooser = new JFileChooser();
  jbClick = new JButton("Select Excel File");
  buttonPanel.add(jbClick, BorderLayout.CENTER);
  // Show Button Click Event
  jbClick.addActionListener(new ActionListener() {

   @Override
   public void actionPerformed(ActionEvent arg0) {
    jChooser.showOpenDialog(null);
    
    File file = jChooser.getSelectedFile();
    if(!file.getName().endsWith("xls")){
     JOptionPane.showMessageDialog(null, 
       "Please select only Excel file.",
       "Error",JOptionPane.ERROR_MESSAGE);
    }
    else
    {
     fillData(file);
     model = new DefaultTableModel(data, 
       headers);
     tableWidth = model.getColumnCount() 
       * 150;
     tableHeight = model.getRowCount() 
       * 25;
     table.setPreferredSize(new Dimension(
       tableWidth, tableHeight));
 
     table.setModel(model);
    }
   }
  });

  table = new JTable();
  table.setAutoCreateRowSorter(true);
  model = new DefaultTableModel(data, headers);

  table.setModel(model);
  table.setBackground(Color.pink);

  table.setAutoResizeMode(JTable.AUTO_RESIZE_OFF);
  table.setEnabled(false);
  table.setRowHeight(25);
  table.setRowMargin(4);

  tableWidth = model.getColumnCount() * 150;
  tableHeight = model.getRowCount() * 25;
  table.setPreferredSize(new Dimension(
    tableWidth, tableHeight));

  scroll = new JScrollPane(table);
  scroll.setBackground(Color.pink);
  scroll.setPreferredSize(new Dimension(300, 300));
  scroll.setHorizontalScrollBarPolicy(
    JScrollPane.HORIZONTAL_SCROLLBAR_AS_NEEDED);
  scroll.setVerticalScrollBarPolicy(
    JScrollPane.VERTICAL_SCROLLBAR_AS_NEEDED);
  getContentPane().add(buttonPanel, 
    BorderLayout.NORTH);
  getContentPane().add(scroll, 
    BorderLayout.CENTER);
  setSize(600, 600);
  setResizable(true);
  setVisible(true);
 }

 /**
  * Fill JTable with Excel file data.
  * 
  * @param file
  * file :contains xls file to display in jTable
  */
 void fillData(File file) {

  Workbook workbook = null;
  try {
   try {
    workbook = Workbook.getWorkbook(file);
   } catch (IOException ex) {
    Logger.getLogger(
      excelTojTable.class.
      getName()).log(Level.SEVERE, 
        null, ex);
   }
   Sheet sheet = workbook.getSheet(0);
   
   headers.clear();
   for (int i = 0; i < sheet.getColumns(); i++) {
    Cell cell1 = sheet.getCell(i, 0);
    headers.add(cell1.getContents());
   }

   data.clear();
   for (int j = 1; j < sheet.getRows(); j++) {
    Vector d = new Vector();
    for (int i = 0; i < sheet.getColumns(); i++) {

     Cell cell = sheet.getCell(i, j);
     
     d.add(cell.getContents());

    }
    d.add("\n");
    data.add(d);
   }
  } catch (BiffException e) {
   e.printStackTrace();
  }
 }

 public static void main(String[] args) {

  new excelTojTable();
 }
}

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

So I hope this code is helpful in understanding Of Import Excel Data in JTable.

Feel free to ask me if you have any dought regarding this.

You can also give me suggessions to improve this tutorial.

Leave comments if you like this post...!

Thank you.

Nirav Raval

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

Follow Other Java Swing Tricks....

< < Import Excel Data in JTable> >
< < MySQL Dynamic Data in JTable Tutorial> >

< < MySQL Data In JTable Tutorial> >

< < UnDo/ReDo in JTextArea Tutorial> >

< < JScrollPane Tutorial> >

< < Infinite JProgressBar Tutorial> >

< < JProgressBar Tutorial> >

< < JTabbedPane Tutorial> >

< < GridBag Layout Tutorial> >

< < Image Preview In JFilechooser> >

< < Resize JTable Columns > >

< < Create Animated Notify Window > >

< < Create Vibrating JDialog > >

< < Export JTable To Excel File > >

< < Create Image JButton > >

< < Create Image JPanel > >

MySQL Dynamic Data in JTable Tutorial

2011-06-17T07:32:00.001-07:00

MySQL Data in JTable Tutorial

Hello Friends,

Nice to see you again.

In Previous Sessions we have seen lots of Java Swing

Components Demo. And learn how they work.

Today, we will see the example of showing data from

MySql Database into JTable of Java Swing.

Normally we have to develop application which have requirement

to show Reports depends on database.

In this type of situations, We can use JTable with showing

data from Database in it.

As there is no such direct method which provide you this facility at

once. So we have to write some sort of code to enable of filling JTable with

Data from Database.

It is very easy to understand the code for this.

First remember that to fill JTable with any data, we required to

create one Model which holds actual Data and the Headers

of Columns.

So we here create one Default Table Model model and add two

parameters data and header in it.

Now these both parameters (Data,Header) must be in int or

Object or in Vector Format only.

Here I choose Vector as it is easy to fill it with Data from Database.

Now simply pass that Vectors in Constructor of DefaultTableModel,

and apply that model to your JTable. Thats it...

Here I have used MySQl database called 'test' and a table called 'one' as

shown below.

So be ready to learn this simple exmaple of MySQl Data in JTable.

After apply this code in action, you will be capable of using MySql

Database in your JTable based Swing Applications.

Output will be like this:

OK For this you have to create one class called dataInJTable.java and paste

the below code in it.

And run it....Simple right..?

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

import java.awt.BorderLayout;

import java.awt.Dimension;

import java.sql.DriverManager;

import java.sql.SQLException;

import java.sql.Statement;

import java.sql.Connection;

import java.sql.ResultSet;

import java.util.Vector;

import javax.swing.JFrame;

import javax.swing.JLabel;

import javax.swing.JPanel;

import javax.swing.JScrollPane;

import javax.swing.JTable;

import javax.swing.table.DefaultTableModel;

import javax.swing.table.TableColumn;

public class dataInJTable extends JFrame{

//This Vector Of A String Vector will be used to hold data from

// database table to display in JTable.

static Vector<Vector<String>> data=new Vector<Vector<String>>();

static JTable table;

public dataInJTable()

{

super("JTabe with MySql Database");

setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);

JPanel topPanel=new JPanel();

JLabel label1=new JLabel("MySQL Database Name : test");

label1.setPreferredSize(new Dimension(200,30));

JLabel label2=new JLabel("MySQL Table Name : One");

label2.setPreferredSize(new Dimension(200,30));

topPanel.add(label1);

topPanel.add(label2);

getContentPane().add(topPanel,BorderLayout.NORTH);

Vector<String> headers=new Vector<String>();

headers.add("id");

headers.add("Name");

getData();

//this is the model which contain actual body of JTable

DefaultTableModel model = new DefaultTableModel(data, headers);

table=new JTable(model);

table.setAutoResizeMode(JTable.AUTO_RESIZE_OFF);

header_size();

JScrollPane scroll = new JScrollPane(table);

scroll.setHorizontalScrollBarPolicy(

JScrollPane.HORIZONTAL_SCROLLBAR_AS_NEEDED);

scroll.setVerticalScrollBarPolicy(

JScrollPane.VERTICAL_SCROLLBAR_AS_NEEDED);

getContentPane().add(scroll,BorderLayout.SOUTH);

pack();

setResizable(false);

setVisible(true);

}

/**

* Setting the particular Column Size in JTable

public static void header_size() {

TableColumn column = table.getColumnModel().getColumn(0);

column.setPreferredWidth(100);

column = table.getColumnModel().getColumn(1);

column.setPreferredWidth(350);

}

/**

* Fetching Data From MySql Database

* and storing in a Vector of a Vector

* to Display in JTable

private static void getData()

{

// Enter Your MySQL Database Table name in below Select Query.

String str="select * from one";

Connection cn;

ResultSet rs;

Statement st;

try {

// Change the database name, hosty name,

// port and password as per MySQL installed in your PC.

cn=DriverManager.getConnection("jdbc:mysql://" +

"localhost:3306/test","root","root");

st=cn.createStatement();

rs=st.executeQuery(str);

while(rs.next())

{

Vector <String> d=new Vector<String>();

d.add(rs.getString("id"));

d.add(rs.getString("name"));

d.add("\n\n\n\n\n\n\n");

data.add(d);

}

} catch (SQLException e) {

e.printStackTrace();

}

public static void main(String[] args) {

new dataInJTable();

}

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

So I hope this code is helpful in understanding the working of JTable

with data from MySql Database.

Feel free to ask me if you have any dought regarding this.

You can also give me suggessions to improve this tutorial.

Leave comments if you like this post...!

Thank you.

Nirav Raval

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

Follow Other Java Swing Tricks....

< < MySQL Dynamic Data in JTable Tutorial> >

< < MySQL Data In JTable Tutorial> >

< < UnDo/ReDo in JTextArea Tutorial> >

< < JScrollPane Tutorial> >

< < Infinite JProgressBar Tutorial> >

< < JProgressBar Tutorial> >

< < JTabbedPane Tutorial> >

< < GridBag Layout Tutorial> >

< < Image Preview In JFilechooser> >

< < Resize JTable Columns > >

< < Create Animated Notify Window > >

< < Create Vibrating JDialog > >

< < Export JTable To Excel File > >

< < Create Image JButton > >

< < Create Image JPanel > >

MySQL Data in JTable Tutorial

2011-06-06T09:19:00.001-07:00

MySQL Data in JTable Tutorial

Hello Friends,

Nice to see you again.

In Previous Sessions we have seen lots of Java Swing

Components Demo. And learn how they work.

Today, we will see the example of showing data from

MySql Database into JTable of Java Swing.

Normally we have to develop application which have requirement

to show Reports depends on database.

In this type of situations, We can use JTable with showing

data from Database in it.

As there is no such direct method which provide you this facility at

once. So we have to write some sort of code to enable of filling JTable with

Data from Database.

It is very easy to understand the code for this.

First remember that to fill JTable with any data, we required to

create one Model which holds actual Data and the Headers

of Columns.

So we here create one Default Table Model model and add two

parameters data and header in it.

Now these both parameters (Data,Header) must be in int or

Object or in Vector Format only.

Here I choose Vector as it is easy to fill it with Data from Database.

Now simply pass that Vectors in Constructor of DefaultTableModel,

and apply that model to your JTable. Thats it...

Here I have used MySQl database called 'test' and a table called 'one' as

shown below.

So be ready to learn this simple exmaple of MySQl Data in JTable.

After apply this code in action, you will be capable of using MySql

Database in your JTable based Swing Applications.

Output will be like this:

OK For this you have to create one class called dataInJTable.java and paste

the below code in it.

And run it....Simple right..?

<?xml version="1.0" encoding="UTF-8"?>

<beans xmlns="http://www.springframework.org/schema/beans"

xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

xsi:schemaLocation="http://www.springframework.org/schema/beans

http://www.springframework.org/schema/beans/spring-beans.xsd">

</bean>

</beans>

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

import java.awt.BorderLayout;

import java.awt.Dimension;

import java.sql.DriverManager;

import java.sql.SQLException;

import java.sql.Statement;

import java.sql.Connection;

import java.sql.ResultSet;

import java.util.Vector;

import javax.swing.JFrame;

import javax.swing.JLabel;

import javax.swing.JPanel;

import javax.swing.JScrollPane;

import javax.swing.JTable;

import javax.swing.table.DefaultTableModel;

import javax.swing.table.TableColumn;

public class dataInJTable extends JFrame{

//This Vector Of A String Vector will be used to hold data from

// database table to display in JTable.

static Vector<Vector<String>> data=new Vector<Vector<String>>();

static JTable table;

public dataInJTable()

{

super("JTabe with MySql Database");

setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);

JPanel topPanel=new JPanel();

JLabel label1=new JLabel("MySQL Database Name : test");

label1.setPreferredSize(new Dimension(200,30));

JLabel label2=new JLabel("MySQL Table Name : One");

label2.setPreferredSize(new Dimension(200,30));

topPanel.add(label1);

topPanel.add(label2);

getContentPane().add(topPanel,BorderLayout.NORTH);

Vector<String> headers=new Vector<String>();

headers.add("id");

headers.add("Name");

getData();

//this is the model which contain actual body of JTable

DefaultTableModel model = new DefaultTableModel(data, headers);

table=new JTable(model);

table.setAutoResizeMode(JTable.AUTO_RESIZE_OFF);

header_size();

JScrollPane scroll = new JScrollPane(table);

scroll.setHorizontalScrollBarPolicy(

JScrollPane.HORIZONTAL_SCROLLBAR_AS_NEEDED);

scroll.setVerticalScrollBarPolicy(

JScrollPane.VERTICAL_SCROLLBAR_AS_NEEDED);

getContentPane().add(scroll,BorderLayout.SOUTH);

pack();

setResizable(false);

setVisible(true);

}

/**

* Setting the particular Column Size in JTable

public static void header_size() {

TableColumn column = table.getColumnModel().getColumn(0);

column.setPreferredWidth(100);

column = table.getColumnModel().getColumn(1);

column.setPreferredWidth(350);

}

/**

* Fetching Data From MySql Database

* and storing in a Vector of a Vector

* to Display in JTable

private static void getData()

{

// Enter Your MySQL Database Table name in below Select Query.

String str="select * from one";

Connection cn;

ResultSet rs;

Statement st;

try {

// Change the database name, hosty name,

// port and password as per MySQL installed in your PC.

cn=DriverManager.getConnection("jdbc:mysql://" +

"localhost:3306/test","root","root");

st=cn.createStatement();

rs=st.executeQuery(str);

while(rs.next())

{

Vector <String> d=new Vector<String>();

d.add(rs.getString("id"));

d.add(rs.getString("name"));

d.add("\n\n\n\n\n\n\n");

data.add(d);

}

} catch (SQLException e) {

e.printStackTrace();

}

public static void main(String[] args) {

new dataInJTable();

}

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

So I hope this code is helpful in understanding the working of JTable

with data from MySql Database.

Feel free to ask me if you have any dought regarding this.

You can also give me suggessions to improve this tutorial.

Leave comments if you like this post...!

Thank you.

Nirav Raval

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

Follow Other Java Swing Tricks....

< < MySQL Dynamic Data in JTable Tutorial> >

< < MySQL Data In JTable Tutorial> >

< < UnDo/ReDo in JTextArea Tutorial> >

< < JScrollPane Tutorial> >

< < Infinite JProgressBar Tutorial> >

< < JProgressBar Tutorial> >

< < JTabbedPane Tutorial> >

< < GridBag Layout Tutorial> >

< < Image Preview In JFilechooser> >

< < Resize JTable Columns > >

< < Create Animated Notify Window > >

< < Create Vibrating JDialog > >

< < Export JTable To Excel File > >

< < Create Image JButton > >

< < Create Image JPanel > >

UnDo/ReDo in JTextArea Tutorial

2011-06-01T07:10:00.001-07:00

UnDo/ReDo in JTextArea Tutorial

Hello Friends,

Nice to see you again.

In Previous Sessions we have seen lots of Java Swing Components Demo.

And learn how they work.

Today, we will see the example of enabling the Undo/Redo Capacity in JTextArea component of Java Swing.

Normally if you see in any operating system, the Undo, Redo functionality is given in Text Components.

So based on this concept, If we want to develop Java Swing Application which also provide Undo, Redo

facility for its Text Component than what will we do..?

As there is no such direct method which provide you this facility at once.

So we have to write some sort of code to enable this undo-redo facility.

It is very easy to understand the code for undo-redo functionality in JTextArea or JTextField.

So be ready to learn this simple exmaple of Undo-Redo in JTextArea.

After apply this code in action, you will be capable of using Undo-Redo in your Swing Applications.

Note: This code is working in Window and Mac. Operating System.

But I am not sure that it runs in other OS or not. So Just check

it and tell me.

Output will be like this:

Note: Here I have applied this code on JTextArea. But if you want to enable Undo-Redo in JTextField than please only replace JTextField in place of JTextArea. And run the code.

OK For this you have to create one class called UndoRedoTextApp.java and paste the below code in it.

And run it....Simple right..?

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

import java.awt.BorderLayout;

import java.awt.Color;

import java.awt.Dimension;

import java.awt.Font;

import java.awt.Toolkit;

import java.awt.event.*;

import javax.swing.*;

import javax.swing.text.Document;

import javax.swing.undo.*;

import javax.swing.event.*;

public class UndoRedoTextApp extends JFrame {

public UndoRedoTextApp() {

super("Undo/Redo Demo");

Font font = new Font("", 1, 18);

JLabel label = new JLabel("Type Something And Press Ctrl+z" +

" or Ctrl+y For Undo & Redo");

label.setForeground(Color.RED);

label.setFont(font);

getContentPane().add(label, BorderLayout.NORTH);

// Replace Below Two lines of JTextArea with

// JTextField textcomp = new JTextField();

// textcomp.setPreferredSize(new Dimension(50, 50));

//it will change JTextArea with JTextField

JTextArea textcomp = new JTextArea();

textcomp.setPreferredSize(new Dimension(600,300));

final UndoManager undo = new UndoManager();

Document doc = textcomp.getDocument();

// Listen for undo and redo events

doc.addUndoableEditListener(new UndoableEditListener() {

public void undoableEditHappened(UndoableEditEvent evt) {

undo.addEdit(evt.getEdit());

}

});

// Create an undo action and add it to the text component

textcomp.getActionMap().put("Undo", new AbstractAction("Undo") {

public void actionPerformed(ActionEvent evt) {

try {

if (undo.canUndo()) {

undo.undo();

}

} catch (CannotUndoException e) {

}

});

// Bind the undo action to ctl-Z (or command-Z on mac)

textcomp.getInputMap().put(

KeyStroke.getKeyStroke(KeyEvent.VK_Z, Toolkit

.getDefaultToolkit().getMenuShortcutKeyMask()), "Undo");

// Create a redo action and add it to the text component

textcomp.getActionMap().put("Redo", new AbstractAction("Redo") {

public void actionPerformed(ActionEvent evt) {

try {

if (undo.canRedo()) {

undo.redo();

}

} catch (CannotRedoException e) {

}

});

// Bind the redo action to ctl-Y (or command-Y on mac)

textcomp.getInputMap().put(

KeyStroke.getKeyStroke(KeyEvent.VK_Y,

Toolkit.getDefaultToolkit().getMenuShortcutKeyMask()),

"Redo");

getContentPane().add(textcomp, BorderLayout.CENTER);

pack();

setVisible(true);

setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);

}

public static void main(String argv[]) {

new UndoRedoTextApp();

}

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

So I hope this code is helpful in understanding the working of Undo-Redo

functionality in JTextArea & JTextField.

Feel free to ask me if you have any dought regarding this.

You can also give me suggessions to improve this tutorial.

Leave comments if you like this post...!

Thank you.

Nirav Raval

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

Follow Other Java Swing Tricks....

< < MySQL Dynamic Data in JTable Tutorial> >

< < MySQL Data In JTable Tutorial> >

< < UnDo/ReDo in JTextArea Tutorial> >

< < JScrollPane Tutorial> >

< < Infinite JProgressBar Tutorial> >

< < JProgressBar Tutorial> >

< < JTabbedPane Tutorial> >

< < GridBag Layout Tutorial> >

< < Image Preview In JFilechooser> >

< < Resize JTable Columns > >

< < Create Animated Notify Window > >

< < Create Vibrating JDialog > >

< < Export JTable To Excel File > >

< < Create Image JButton > >

< < Create Image JPanel > >

JScrollPane Tutorial

2011-05-29T21:28:00.001-07:00

JScrollPane Tutorial

Hello Friends,

Nice to see you again.
In Previous Sessions we have seen lots of Java Swing Components Demo. And learn how they work.
Today, we will see the example of JScrollPane component of Java Swing.

Threre are some situation where we can not adjust the space of our JFrame or JPanel to hold the
items in it. Because the items are too many to adjust in a small JFrame.
In this type of situation, JScrollPane is there to help you.

It is very easy to use JScrollPane.
We only have to create object of JScrollPane and in its constructor pass the component which you want to put in JScrollPane. And thats all. Now that component will shown in JScrollPane. Now no-matter how
big that component in size, JScrollPane will take care of it.

So be ready to learn this simple exmaple of JScrollPane.
After apply this code in action, you will be capable of using JScrollPane in your Swing Applications.

Output will be like this:

OK For this you have to create one class called JScrollPaneDemo.java and paste the below code in it.
And run it....Simple right..?

import javax.swing.ImageIcon;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JScrollPane;

public class JScrollPaneDemo extends JFrame {

public JScrollPaneDemo() {

super("JScrollPane Demo");

ImageIcon icon=new ImageIcon("Sunset.jpg");
JLabel label = new JLabel(icon);
JScrollPane scrollPane = new JScrollPane(label);

getContentPane().add(scrollPane);
setSize(500, 500);
setVisible(true);
setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
}

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

So I hope this code is helpful in understanding the working of JScrollPane.

Feel free to ask me if you have any doughts regarding this.
You can also give me suggessions to improve this tutorial.

Leave comments if you like this post...!

Thank you.
Nirav Raval

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

Follow Other Java Swing Tricks....

< < MySQL Dynamic Data in JTable Tutorial> >

< < MySQL Data In JTable Tutorial> >

< < UnDo/ReDo in JTextArea Tutorial> >

< < JScrollPane Tutorial> >

< < Infinite JProgressBar Tutorial> >

< < JProgressBar Tutorial> >

< < JTabbedPane Tutorial> >

< < GridBag Layout Tutorial> >

< < Image Preview In JFilechooser> >

< < Resize JTable Columns > >

< < Create Animated Notify Window > >

< < Create Vibrating JDialog > >

< < Export JTable To Excel File > >

< < Create Image JButton > >

< < Create Image JPanel > >

Infinite JProgressBar Tutorial

2011-05-24T04:18:00.001-07:00

Infinite JProgressBar Tutorial

Hello Friends,

Nice to see you again.

In Previous Session we have seen JProgressBar Tutorial. In which We created a class which shows JProgressBar

with painted String on it. That type of JProgressBar is used in some sort of situation where we know how much time user have to wait for some process to be completed.

But there can be some circumstances where we dont know how much time user will have to wait for some process to be completed,

in this type of situation we have to use Infinite JProgressBar or say Indeterminant JProgressBar.

So, Today we will learn Infinite JProgressBar in Java Swing.

So be ready to learn this simple exmaple of Infinite JProgressBar .

After apply this code in action, you will be capable of using Infinite JProgressBar in your Swing Applications.

Output will be like this:

OK For this you have to create one class called InfiniteProgressBar.java and paste the below code in it.
And run it....Simple right..?

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

import java.awt.Dimension;
import javax.swing.*;

public class InfiniteProgressBar {
public static void main(String[] args) {

JFrame f = new JFrame("Progress");
JProgressBar p = new JProgressBar();

p.setIndeterminate(true);
p.setPreferredSize(new Dimension(300,30));
f.getContentPane().add(p);

f.pack();
f.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
f.setVisible(true);

}
}
--------------------------------------------------------------------

So I hope this code is helpful in understanding the working of Infinite JProgressBar.

Feel free to ask me if you have any dought regarding this.
You can also give me suggessions to improve this tutorial.

Leave comments if you like this post...!

Thank you.
Nirav Raval

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

Follow Other Java Swing Tricks....

< < MySQL Dynamic Data in JTable Tutorial> >

< < MySQL Data In JTable Tutorial> >

< < UnDo/ReDo in JTextArea Tutorial> >

< < JScrollPane Tutorial> >

< < Infinite JProgressBar Tutorial> >

< < JProgressBar Tutorial> >

< < JTabbedPane Tutorial> >

< < GridBag Layout Tutorial> >

< < Image Preview In JFilechooser> >

< < Resize JTable Columns > >

< < Create Animated Notify Window > >

< < Create Vibrating JDialog > >

< < Export JTable To Excel File > >

< < Create Image JButton > >

< < Create Image JPanel > >

JProgressBar Tutorial

2011-05-23T23:52:00.001-07:00

JProgressBar Tutorial

Hello Friends,

Nice to see you again.

Today we will learn JProgressBar in Java Swing.

JProgressBar is very important Swing Component.We can use it in our

Swing Application when we have to wait User For some Process To be competed.

In these type of situation , we can display JProgressBar in JFrame.

So be ready to learn this simple exmaple of JProgressBar .After apply

this code in action, you will be capable of using JProgressBar in your

Swing Applications.

This simple example of JProgressBar gives you the basic idea of

JProgressBar and you will be familiar for using JProgressBar .

Output will be like this:

OK For this you have to create one class called PaintedProgressBarDemo.java and paste the below code in it.

And run it....Simple right..?

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

import java.awt.BorderLayout;
import java.awt.Color;
import java.awt.Cursor;
import java.awt.Dimension;
import java.awt.Font;
import java.awt.GridBagConstraints;
import java.awt.GridBagLayout;
import java.awt.Insets;
import javax.swing.BorderFactory;
import javax.swing.JFrame;
import javax.swing.JPanel;
import javax.swing.JProgressBar;
import javax.swing.JTextArea;

public class PaintedProgressBarDemo extends JFrame{
final JTextArea textArea = new JTextArea();
final JProgressBar progress = new JProgressBar();

public PaintedProgressBarDemo() {
super("Painted Progress Bar Demo");
setLayout(new GridBagLayout());
GridBagConstraints cn = new GridBagConstraints();
cn.insets = new Insets(5, 5, 5, 5);
cn.gridx = 0;
cn.gridy = 0;

JPanel panel = new JPanel();
panel.setLayout(new BorderLayout());

Font font=new Font("", Font.BOLD, 14);

textArea.setPreferredSize(new Dimension(500, 150));
textArea.setBackground(Color.pink);
textArea.setBorder(BorderFactory.createBevelBorder(1));
// Here We apply font from normal to bold and
// increase size to 14
textArea.setFont(font);
panel.add(textArea, BorderLayout.NORTH);

setVisible(true);
setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
setResizable(false);

progress.setMaximum(100);
progress.setStringPainted(true);
progress.setBackground(Color.white);
progress.setForeground(Color.blue);
progress.setPreferredSize(new Dimension(150, 20));
progress.setVisible(true);
progress.setValue(0);
panel.add(progress, BorderLayout.SOUTH);

add(panel, cn);
pack();

//Setting JTextArea Cursor In Wait Condition To
// Complete The Process
textArea.setCursor(Cursor.getPredefinedCursor
(Cursor.WAIT_CURSOR));
perform();

//Setting JTextArea Cursor In Default Condition
textArea.setCursor(Cursor.getPredefinedCursor
(Cursor.DEFAULT_CURSOR));
}

public void iterate() {
int num = 40;
while (num <= 100) {

progress.setValue(num);
try {
Thread.sleep(1000);
} catch (InterruptedException e) {

}
num += 20;
}
}

public void perform() {
String data = "Nice To See You....This is Painted" +
" JProgressBar Demo.!";
try {
Thread.sleep(2000);
iterate();

textArea.setText(data);
} catch (InterruptedException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}

}

public static void main(String s[]) {

PaintedProgressBarDemo dd=new PaintedProgressBarDemo();
}

}
--------------------------------------------------------------------

So I hope this code is helpful in understanding the working of JProgressBar.

Feel free to ask me if you have any dought regarding this.
You can also give me suggessions to improve this tutorial.

Leave comments if you like this post...!

Thank you.
Nirav Raval

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

Follow Other Java Swing Tricks....

< < MySQL Dynamic Data in JTable Tutorial> >

< < MySQL Data In JTable Tutorial> >

< < UnDo/ReDo in JTextArea Tutorial> >

< < JScrollPane Tutorial> >

< < Infinite JProgressBar Tutorial> >

< < JProgressBar Tutorial> >

< < JTabbedPane Tutorial> >

< < GridBag Layout Tutorial> >

< < Image Preview In JFilechooser> >

< < Resize JTable Columns > >

< < Create Animated Notify Window > >

< < Create Vibrating JDialog > >

< < Export JTable To Excel File > >

< < Create Image JButton > >

< < Create Image JPanel > >

JTabbedPane Tutorial

2011-05-19T22:30:00.001-07:00

JTabbedPane Tutorial

Hello Friends,

Nice to see you again.

Today we will learn JTabbed Pane in Java Swing.

JTabbedPane is very important Swing Component.

We can use it in our Swing Application when we have less space to display much items in it. In these type of situation rather than use any simple JPanel , we can display in one JTabbedPane with many tab in it.

So be ready to learn this simple exmaple of JTabbedPane.

After apply this code in action, you will be capable of using JTabbedPane in your Swing Applications.

This simple example of JTabbedPane gives you the basic idea of JTabbedPane and you will be familiar for using JTabbedPane.

Output will be like this:

OK For this you have to create one class called JTabbedPaneDemo.java and paste the below code in it.

And run it....Simple right..?

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

import java.awt.BorderLayout;

import java.awt.Dimension;

import javax.swing.*;

public class JTabbedPaneDemo extends JFrame{

public JTabbedPaneDemo()

{

super("JTabbedPane Demo");

setLayout(new BorderLayout());

// This panel will contain all components

// and then it will add in JFrame to show.

JPanel mainPanel = new JPanel();

// Different Panel for display in

// all Tab in JTabbedPane.

JPanel panelOne=new JPanel();

JPanel panelTwo=new JPanel();

JPanel panelThree=new JPanel();

JTabbedPane tab=new JTabbedPane();

JLabel lblOne=new JLabel("This is First Tab");

JLabel lblTwo=new JLabel("This is Second Tab");

JLabel lblThree=new JLabel("This is Third Tab");

Dimension lblSize=new Dimension(300, 300);

lblOne.setPreferredSize(lblSize);

lblTwo.setPreferredSize(lblSize);

lblThree.setPreferredSize(lblSize);

panelOne.add(lblOne);

panelTwo.add(lblTwo);

panelThree.add(lblThree);

// Here all panel will add in JTabbedPane with title.

tab.add("Tab 1",panelOne);

tab.add("Tab 2",panelTwo);

tab.add("Tab 3",panelThree);

// Adding JtabbedPane in mainPanel.

mainPanel.add(tab);

// Adding Main Panel to JFrame.

add(mainPanel);

setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);

setVisible(true);

pack();

}

public static void main(String s[])

{

new JTabbedPaneDemo();

}

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

So I hope this code is helpful in understanding the working of JTabbedPane.

Feel free to ask me if you have any dought regarding this.

You can also give me suggessions to improve this tutorial.

Leave comments if you like this post...!

Thank you.

Nirav Raval

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

Follow Other Java Swing Tricks....

< < MySQL Dynamic Data in JTable Tutorial> >

< < MySQL Data In JTable Tutorial> >

< < UnDo/ReDo in JTextArea Tutorial> >

< < JScrollPane Tutorial> >

< < Infinite JProgressBar Tutorial> >

< < JProgressBar Tutorial> >

< < JTabbedPane Tutorial> >

< < GridBag Layout Tutorial> >

< < Image Preview In JFilechooser> >

< < Resize JTable Columns > >

< < Create Animated Notify Window > >

< < Create Vibrating JDialog > >

< < Export JTable To Excel File > >

< < Create Image JButton > >

< < Create Image JPanel > >

Image Preview In JFileChooser

2011-05-19T01:57:00.001-07:00

Image Preview In JFileChooser

Hello Friends,

Nice to meet you again.

Today we will learn Image Priview In JFileChooser.

here I am giving simple example that will help you to learn to apply Image Priview Facility In JFileChooser.

The output will be:

Now create one class ImagePreviewFileChooser.java and pate the below code in it and run it.

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

import java.awt.*;

import java.beans.PropertyChangeEvent;

import java.beans.PropertyChangeListener;

import java.io.*;

import javax.imageio.ImageIO;

import javax.swing.*;

public class ImagePreviewFileChooser extends JPanel implements PropertyChangeListener {

private JFileChooser jfc;

private Image img;

public ImagePreviewFileChooser(JFileChooser jfc) {

this.jfc = jfc;

Dimension sz = new Dimension(200, 200);

setPreferredSize(sz);

}

public void propertyChange(PropertyChangeEvent evt) {

try {

System.out.println("updating");

File file = jfc.getSelectedFile();

updateImage(file);

} catch (IOException ex) {

System.out.println(ex.getMessage());

ex.printStackTrace();

}

public void updateImage(File file) throws IOException {

if (file == null) {

return;

}

img = ImageIO.read(file);

repaint();

}

public void paintComponent(Graphics g) {

// fill the background

g.setColor(Color.gray);

g.fillRect(0, 0, getWidth(), getHeight());

if (img != null) {

// calculate the scaling factor

int w = img.getWidth(null);

int h = img.getHeight(null);

int side = Math.max(w, h);

double scale = 200.0 / (double) side;

w = (int) (scale * (double) w);

h = (int) (scale * (double) h);

// draw the image

g.drawImage(img, 0, 0, w, h, null);

// draw the image dimensions

String dim = w + " x " + h;

g.setColor(Color.black);

g.drawString(dim, 31, 196);

g.setColor(Color.white);

g.drawString(dim, 30, 195);

} else {

// print a message

g.setColor(Color.black);

g.drawString("Not an image", 30, 100);

}

public static void main(String[] args) {

JFileChooser jfc = new JFileChooser();

ImagePreviewFileChooser preview = new ImagePreviewFileChooser(jfc);

jfc.addPropertyChangeListener(preview);

jfc.setAccessory(preview);

jfc.showOpenDialog(null);

}

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

Here I am using one Panel in JFilechooser which displays selected Image File.

Every time user selects Image File that Image will be painted on that Panel with paintComponent method.

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

Try this code and feel free to ask any dought or give any suggessions.

I always invite your valuable suggessions.

Thank you.

Nirav Raval

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

Follow Other Java Swing Tricks....

< < MySQL Dynamic Data in JTable Tutorial> >

< < MySQL Data In JTable Tutorial> >

< < UnDo/ReDo in JTextArea Tutorial> >

< < JScrollPane Tutorial> >

< < Infinite JProgressBar Tutorial> >

< < JProgressBar Tutorial> >

< < JTabbedPane Tutorial> >

< < GridBag Layout Tutorial> >

< < Image Preview In JFilechooser> >

< < Resize JTable Columns > >

< < Create Animated Notify Window > >

< < Create Vibrating JDialog > >

< < Export JTable To Excel File > >

< < Create Image JButton > >

< < Create Image JPanel > >

GridBag Layout Tutorial

2011-05-19T01:39:00.001-07:00

GridBag Layout Tutorial

Hello Friends,
Nice to meet you again.

Today we will learn GridBag Layout.
GridBag Layout is one of the most complex layout of Java Swing.
But here I am giving simple example that will help you to learn to apply basic GridBag Layout.

The output will be:

Now create one class GridBagDemo.java and pate the below code in it and run it.
-------------------------------------------------------------------------------------------------------------

import java.awt.Insets;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;

import javax.swing.*;
import javax.swing.border.EmptyBorder;

public class GridBagDemo extends JFrame{

public GridBagDemo()
{
super("GridBag Layout");
new EmptyBorder(15, 15, 15, 15);
Dimension labSize=new Dimension(80, 20);

JPanel panel=new JPanel();
panel.setLayout(new GridBagLayout());
GridBagConstraints cn=new GridBagConstraints();
panel.setBackground(Color.pink);

cn.insets=new Insets(5, 5, 5, 5);
cn.gridx=0;
cn.gridy=0;

JLabel labName=new JLabel("Name");
labName.setPreferredSize(labSize);
panel.add(labName);

cn.gridx=1;
cn.gridy=0;
cn.gridwidth=2;
cn.anchor=GridBagConstraints.WEST;
JTextField textName=new JTextField();
textName.setPreferredSize(new Dimension(240, 20));
panel.add(textName,cn);

cn.gridx=0;
cn.gridy=1;
cn.gridwidth=1;
cn.anchor=GridBagConstraints.NORTH;
JLabel labAddress=new JLabel("Address");
labAddress.setPreferredSize(labSize);
panel.add(labAddress,cn);

cn.gridx=1;
cn.gridy=1;
cn.gridwidth=2;
JTextArea textAddress=new JTextArea();
textAddress.setPreferredSize(new Dimension(240,80));
panel.add(textAddress,cn);

cn.gridx=1;
cn.gridy=2;
cn.gridwidth=1;
JButton butOK=new JButton("Submit");
panel.add(butOK,cn);

cn.gridx=2;
cn.gridy=2;
JButton butCANCEL=new JButton("CANCEL");
panel.add(butCANCEL,cn);
add(panel);
pack();

butOK.addActionListener(new ActionListener() {

@Override
public void actionPerformed(ActionEvent arg0) {
// TODO Auto-generated method stub
JOptionPane.showMessageDialog(null, "This is the simple Gridbag " +
"Layout Demo.","Helloooo!",JOptionPane.INFORMATION_MESSAGE);
}
});

setResizable(false);
setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
setVisible(true);
}

public static void main(String s[])
{
new GridBagDemo();
}
}
-------------------------------------------------------------------------------------------------------------

So here we have used some strange words like GridBagConstraints, gridx, gridy, gridwidth etc.
Ok so lets first understand these words and its use in GridBag Layout.

1) GridBagConstraints:

Normally if do not use this GridBagConstraints than by default in Grid Bag Layout the components will be placed in a single row from left to right .Try after removing cn from panel.add line for each components and you will see all components are placed in a row from left to right. So GridBagConstraints is used to make changes in position of a component in a Grid Bag Layout. For this we have to use different methods of GridBagConstraints like gridx, gridy, gridwidth etc. So this GridBagConstraints will binds and packs all components in a way we want.

2) insets (top, left, bottom, right):

insets is a method of GridBag Layout to leave empty spaces around the components. By default insets value is ( 0, 0, 0, 0 ). But we can set it as per our needs. insets has 4 parameters ( top, left, bottom, right ). All are in int. So if For Example you write insets ( 5,5,5,5 ) that means 5 pixels from Top, Left, Bottom And Right will be left and then the components will be placed.

3) gridx:

gridx is refers to the column in the GridBagLayout. By default it is zero. i.e. the first column. You can set it as per your need to place the component in particular column.

4) gridy:

gridy is refers to the row in the GridBagLayout. By default it is zero. i.e. the first row. You can set it as per your need to place the component in particular row.

5) gridwidth:

gridwidth is refers to the width of a cell in a GridBagLayout. By default it is zero. the component will have width of 1 cell..

You can set it as per your need to place the component in particular row. For example, If you want to place a component which should cover two cell than set gridwidth=2.

-------------------------------------------------------------------------------------------------------------
At first glance, you will find this very complex to use.
But after some playing with this code you will find that it is very comfortable and a good layout to use.
This is the only Layout which gives us the full freedom to place Swing Components anywhere as we want.
Because we can put any components at any place through this GridBag Layout.

Try this code and feel free to ask any dought or giving any suggession.
I always invite your valuable suggessions.

Thank you.
Nirav Raval

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

Follow Other Java Swing Tricks....

< < MySQL Dynamic Data in JTable Tutorial> >

< < MySQL Data In JTable Tutorial> >

< < UnDo/ReDo in JTextArea Tutorial> >

< < JScrollPane Tutorial> >

< < Infinite JProgressBar Tutorial> >

< < JProgressBar Tutorial> >

< < JTabbedPane Tutorial> >

< < GridBag Layout Tutorial> >

< < Image Preview In JFilechooser> >

< < Resize JTable Columns > >

< < Create Animated Notify Window > >

< < Create Vibrating JDialog > >

< < Export JTable To Excel File > >

< < Create Image JButton > >

< < Create Image JPanel > >

Resize JTable Columns

2011-05-13T22:39:00.001-07:00

Resize JTable Columns

Now Let's doing another nice and useful trick with Java Swing,

Here we will create one JTable. And when we will run it, it will adjust its column size as per its contents..!

Want to know how can it be done....then stick with me friends.

Output will be:

1. Normal Default JTable

2. Resized JTable.

Copy the Below code And paste in your Java Editor and simply run it...

1. Create class ColumnResizer .java this contains the logic of resize the columns of

any JTable.

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

import java.awt.Component;

import javax.swing.JTable;

import javax.swing.table.*;

public class ColumnResizer {

public static void adjustColumnPreferredWidths(JTable table) {

// strategy - get max width for cells in column and

// make that the preferred width

TableColumnModel columnModel = table.getColumnModel();

for (int col = 0; col < table.getColumnCount(); col++) {

int maxwidth = 0;

for (int row = 0; row < table.getRowCount(); row++) {

TableCellRenderer rend = table.getCellRenderer(row, col);

Object value = table.getValueAt(row, col);

Component comp = rend.getTableCellRendererComponent(table,

value, false, false, row, col);

maxwidth = Math.max(comp.getPreferredSize().width, maxwidth);

}

TableColumn column = columnModel.getColumn(col);

column.setPreferredWidth(maxwidth);

}

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

2. Create Second class TestColumnResizer.java this contains the JTable which we

want to resize.

import javax.swing.*;

import javax.swing.table.DefaultTableModel;

public class TestColumnResizer {

final static Object[][] TABLE_DATA = {

{ new Integer(1), "Nirav Raval", "http://www.niravjavadeveloper.blogspot.com/" },

{ new Integer(2), "Java Web", "http://www.java2s.com/" },

{ new Integer(3), "Java 2d Effects","http://www.daniweb.com/" },

{ new Integer(4), "Java Swing", "http://www.onjava.com/"},

{ new Integer(5), "QTJ book", "http://www.oreilly.com/catalog/" } } ;

final static String[] COLUMN_NAMES = { "Count", "Name", "URL" };

public static void main(String[] args) {

DefaultTableModel mod = new DefaultTableModel(TABLE_DATA, COLUMN_NAMES);

JTable table = new JTable(mod);

JScrollPane pane = new JScrollPane(table,

ScrollPaneConstants.VERTICAL_SCROLLBAR_AS_NEEDED,

ScrollPaneConstants.HORIZONTAL_SCROLLBAR_NEVER);

JFrame frame = new JFrame("JTable Column Widths");

frame.setSize(500, 400);

frame.getContentPane().add(pane);

frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);

frame.setVisible(true);

//Waiting For 3 Seconds and then adjust the width of Columns....

// You can delete this try...catch block if you wish to.

try {

Thread.sleep(3000);

} catch (Exception e) {

e.printStackTrace();

}

// setting of columns widths done here

final JTable fTable = table;

SwingUtilities.invokeLater(new Runnable() {

public void run() {

ColumnResizer.adjustColumnPreferredWidths(fTable);

fTable.revalidate();

}

});

}

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

I hope you enjoyed this new trick,...!

Always inviting your comments.....! Thank you.

Yours Friend,

Nirav Raval

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

Follow Other Java Swing Tricks....

< < MySQL Dynamic Data in JTable Tutorial> >

< < MySQL Data In JTable Tutorial> >

< < UnDo/ReDo in JTextArea Tutorial> >

< < JScrollPane Tutorial> >

< < Infinite JProgressBar Tutorial> >

< < JProgressBar Tutorial> >

< < JTabbedPane Tutorial> >

< < GridBag Layout Tutorial> >

< < Image Preview In JFilechooser> >

< < Resize JTable Columns > >

< < Create Animated Notify Window > >

< < Create Vibrating JDialog > >

< < Export JTable To Excel File > >

< < Create Image JButton > >

< < Create Image JPanel > >

JPanel Animated Trick

2011-05-13T22:35:00.001-07:00

Create Animated Notify Window

Hello Friends,

Today we will do one nice Swing trick.

Normally we develop window application in Swing with our custome JFrame or Jpanel or JDialog.

But here we will go further and do some animation in our code and develop one window with one error message for user.

Output will like:

when you run it will open from taskbar.....like..

And when complete it will look like....

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

For this we will first develop one class NotifySlider.java

This class do all the magic to give the output.

import javax.swing.*;

import java.awt.*;

import java.awt.event.*;

import java.awt.image.*;

public class NotifySlider extends Object {

protected static final int ANIMATION_TIME = 500;

protected static final float ANIMATION_TIME_F = (float) ANIMATION_TIME;

protected static final int ANIMATION_DELAY = 50;

JWindow window;

JComponent contents;

AnimatingSheet animatingSheet;

Rectangle desktopBounds;

Dimension tempWindowSize;

Timer animationTimer;

int showX, startY;

long animationStart;

public NotifySlider() {

initDesktopBounds();

}

public NotifySlider(JComponent contents) {

this();

setContents(contents);

}

protected void initDesktopBounds() {

GraphicsEnvironment env = GraphicsEnvironment

.getLocalGraphicsEnvironment();

desktopBounds = env.getMaximumWindowBounds();

System.out.println("max window bounds = " + desktopBounds);

}

public void setContents(JComponent contents) {

this.contents = contents;

JWindow tempWindow = new JWindow();

tempWindow.getContentPane().add(contents);

tempWindow.pack();

tempWindowSize = tempWindow.getSize();

tempWindow.getContentPane().removeAll();

window = new JWindow();

animatingSheet = new AnimatingSheet();

animatingSheet.setSource(contents);

window.getContentPane().add(animatingSheet);

}

public void showAt(int x) {

// create a window with an animating sheet

// copy over its contents from the temp window

// animate it

// when done, remove animating sheet and add real contents

showX = x;

startY = desktopBounds.y + desktopBounds.height;

ActionListener animationLogic = new ActionListener() {

public void actionPerformed(ActionEvent e) {

long elapsed = System.currentTimeMillis() - animationStart;

if (elapsed > ANIMATION_TIME) {

// put real contents in window and show

window.getContentPane().removeAll();

window.getContentPane().add(contents);

window.pack();

window.setLocation(showX, startY - window.getSize().height);

window.setVisible(true);

window.repaint();

animationTimer.stop();

animationTimer = null;

} else {

// calculate % done

float progress = (float) elapsed / ANIMATION_TIME_F;

// get height to show

int animatingHeight = (int) (progress * tempWindowSize

.getHeight());

animatingHeight = Math.max(animatingHeight, 1);

animatingSheet.setAnimatingHeight(animatingHeight);

window.pack();

window.setLocation(showX, startY - window.getHeight());

window.setVisible(true);

window.repaint();

}

};

animationTimer = new Timer(ANIMATION_DELAY, animationLogic);

animationStart = System.currentTimeMillis();

animationTimer.start();

}

// AnimatingSheet inner class listed below

class AnimatingSheet extends JPanel {

Dimension animatingSize = new Dimension(0, 1);

JComponent source;

BufferedImage offscreenImage;

public AnimatingSheet() {

super();

setOpaque(true);

}

public void setSource(JComponent source) {

this.source = source;

animatingSize.width = source.getWidth();

makeOffscreenImage(source);

}

public void setAnimatingHeight(int height) {

animatingSize.height = height;

setSize(animatingSize);

}

private void makeOffscreenImage(JComponent source) {

GraphicsEnvironment ge = GraphicsEnvironment

.getLocalGraphicsEnvironment();

GraphicsConfiguration gfxConfig = ge.getDefaultScreenDevice()

.getDefaultConfiguration();

offscreenImage = gfxConfig.createCompatibleImage(source.getWidth(),

source.getHeight());

Graphics2D offscreenGraphics = (Graphics2D) offscreenImage

.getGraphics();

// windows workaround

offscreenGraphics.setColor(source.getBackground());

offscreenGraphics.fillRect(0, 0, source.getWidth(),

source.getHeight());

// paint from source to offscreen buffer

source.paint(offscreenGraphics);

}

public Dimension getPreferredSize() {

return animatingSize;

}

public Dimension getMinimumSize() {

return animatingSize;

}

public Dimension getMaximumSize() {

return animatingSize;

}

public void update(Graphics g) {

// override to eliminate flicker from

// unnecessary clear

paint(g);

}

public void paint(Graphics g) {

// get the top-most n pixels of source and

// paint them into g, where n is height

// (different from sheet example, which used bottom-most)

BufferedImage fragment = offscreenImage.getSubimage(0, 0,

source.getWidth(), animatingSize.height);

g.drawImage(fragment, 0, 0, this);

}

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

Now we will create another class TestNotifySlider.java

import java.awt.Color;

import java.awt.Dimension;

import java.awt.GridBagConstraints;

import java.awt.GridBagLayout;

import java.awt.Toolkit;

import java.awt.event.ActionEvent;

import java.awt.event.ActionListener;

import javax.swing.*;

public class TestNotifySlider {

public static void main (String[] args) {

JPanel panelWarning=new JPanel();

panelWarning.setPreferredSize(new Dimension(250, 100));

panelWarning.setBackground(Color.pink);

panelWarning.setLayout(new GridBagLayout());

Icon errorIcon = UIManager.getIcon ("OptionPane.errorIcon");

JLabel label = new JLabel ("<HTML>Sorry....! Wrong Action By You!" +

" <BR> &nbsp&nbsp&nbsp Bye....! " +

"</HTML>", errorIcon, SwingConstants.CENTER);

JButton ok =new JButton("OK");

GridBagConstraints c=new GridBagConstraints();

c.gridx=0;

c.gridy=0;

c.gridwidth=2;

panelWarning.add(label,c);

c.gridx=1;

c.gridy=1;

panelWarning.add(ok,c);

NotifySlider slider = new NotifySlider (panelWarning);

Dimension dim = Toolkit.getDefaultToolkit().getScreenSize();

int screenMiddlePoint=dim.width/2;

// Change in below line 40 to any int to adjust in middle of screen.

slider.showAt (screenMiddlePoint - 40);

ok.addActionListener(new ActionListener() {

@Override

public void actionPerformed(ActionEvent arg0) {

// TODO Auto-generated method stub

System.exit(0);

}

});

}

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

I hope you enjoyed this new trick,...!

Always inviting your comments.....! Thank you.

Yours Friend,

Nirav Raval

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

Follow Other Java Swing Tricks....

< < MySQL Dynamic Data in JTable Tutorial> >

< < MySQL Data In JTable Tutorial> >

< < UnDo/ReDo in JTextArea Tutorial> >

< < JScrollPane Tutorial> >

< < Infinite JProgressBar Tutorial> >

< < JProgressBar Tutorial> >

< < JTabbedPane Tutorial> >

< < GridBag Layout Tutorial> >

< < Image Preview In JFilechooser> >

< < Resize JTable Columns > >

< < Create Animated Notify Window > >

< < Create Vibrating JDialog > >

< < Export JTable To Excel File > >

< < Create Image JButton > >

< < Create Image JPanel > >

Java Swing - Vibrating JDialog

2011-05-10T03:07:00.001-07:00

Java Swing - Vibrating JDialog

Now Let's doing some fun with Java Swing,

Here we will create one JDialog. And when we will run it, it will vibrate or shake.

Want to know how can it be done....then stick with me friends.

Output will be:

1. Normal JDialog 2. Vibrantingg JDialogggg

It's simple as Java Swing provides lots of customization to its components as we need.

So here we do nothing but customise the JDialog code with adding a bit of animation cycles with the help of Timer class.

Just copy the below code of VibrantDialog.java and paste it in your Java Editor and run it...

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

import java.awt.*;

import java.awt.event.ActionEvent;

import java.awt.event.ActionListener;

import javax.swing.*;

public class VibrantDialog extends Object {

public static final int SHAKE_DISTANCE = 10;

public static final double SHAKE_CYCLE = 50;

public static final int SHAKE_DURATION = 1000;

public static final int SHAKE_UPDATE = 5;

private JDialog dialog;

private Point naturalLocation;

private long startTime;

private Timer shakeTimer;

private final double TWO_PI = Math.PI * 2.0;

public VibrantDialog (JDialog d) {

dialog = d;

}

public void startShake() {

naturalLocation = dialog.getLocation();

startTime = System.currentTimeMillis();

shakeTimer = new Timer(SHAKE_UPDATE,

new ActionListener( ) {

@Override

public void actionPerformed (ActionEvent e) {

// calculate elapsed time

long elapsed = System.currentTimeMillis()-

startTime;

// use sin to calculate an x-offset

double waveOffset = (elapsed % SHAKE_CYCLE) /

SHAKE_CYCLE;

double angle = waveOffset * TWO_PI;

// offset the x-location by an amount

// proportional to the sine, up to

// shake_distance

int shakenX = (int) ((Math.sin (angle) *

SHAKE_DISTANCE) +

naturalLocation.x);

dialog.setLocation (shakenX, naturalLocation.y);

dialog.repaint( );

// should we stop timer?

if (elapsed >= SHAKE_DURATION)

stopShake();

}

);

shakeTimer.start( );

}

public void stopShake( ) {

shakeTimer.stop( );

dialog.setLocation (naturalLocation);

dialog.repaint( );

}

public static void main (String[] args) {

JOptionPane pane =

new JOptionPane ("You've totally screwed up your login\n" +

"Go back and do it again… and do you think\n" +

"you could remember your password this time?",

JOptionPane.ERROR_MESSAGE, JOptionPane.OK_OPTION);

JDialog d = pane.createDialog (null, "Shakin'!");

VibrantDialog dec = new VibrantDialog (d);

d.pack( );

d.setModal (false);

d.setVisible(true);

dec.startShake( );

// wait (forever) for a non-null click and then quit

while (pane.getValue( ) == JOptionPane.UNINITIALIZED_VALUE ) {

try { Thread.sleep(100); }

catch (InterruptedException ie) {}

}

System.exit(0);

}

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

Here we are using Timer class constructor.

In Timer Constructor we pass 2 parameters.

1) Shake Update Time: This is the shaking updating time in milli seconds. After what millis, the

vibrating happens..

2) Action Listener() : The second parameter is the action listener we have created for

Vibrating action happens.

All the magic works here. Here we are doing some maths for

calculating the x and y positions of JDialog at the time of shaking. And

when time over the shaking is stopped by stoping the timer.

Where To Use:

This is very useful in login based application. When user provide wrong username or password, instead of notify error through JOptionPane use this VibrantDialog.

Also useful when user do some serious error and you want to notify him/her for that error.

So, this is all the fun with Vibrant JDialog.....

I hope you enjoyed this new trick,...!

Always inviting your comments.....! Thank you.

Yours Friend,

Nirav Raval

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

Follow Other Java Swing Tricks....

< < MySQL Dynamic Data in JTable Tutorial> >

< < MySQL Data In JTable Tutorial> >

< < UnDo/ReDo in JTextArea Tutorial> >

< < JScrollPane Tutorial> >

< < Infinite JProgressBar Tutorial> >

< < JProgressBar Tutorial> >

< < JTabbedPane Tutorial> >

< < GridBag Layout Tutorial> >

< < Image Preview In JFilechooser> >

< < Resize JTable Columns > >

< < Create Animated Notify Window > >

< < Create Vibrating JDialog > >

< < Export JTable To Excel File > >

< < Create Image JButton > >

< < Create Image JPanel > >

Java Swing -Export JTable To Excel File

2011-05-09T22:37:00.001-07:00

Java Swing - Export JTable To Excel File

Run The Code and you get this JFrame.

Output In Exported Spreadsheet File

______________________________________________________________

Write ExcelExporter Class:-

import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.io.File;

import javax.swing.*;
import javax.swing.table.*;

import jxl.*;
import jxl.write.*;

public class ExcelExporter {

    void fillData(JTable table, File file) {

        try {

            WritableWorkbook workbook1 = Workbook.createWorkbook(file);
            WritableSheet sheet1 = workbook1.createSheet("First Sheet", 0);
            TableModel model = table.getModel();

            for (int i = 0; i < model.getColumnCount(); i++) {
                Label column = new Label(i, 0, model.getColumnName(i));
                sheet1.addCell(column);
            }
            int j = 0;
            for (int i = 0; i < model.getRowCount(); i++) {
                for (j = 0; j < model.getColumnCount(); j++) {
                    Label row = new Label(j, i + 1,
                            model.getValueAt(i, j).toString());
                    sheet1.addCell(row);
                }
            }
            workbook1.write();
            workbook1.close();
        } catch (Exception ex) {
            ex.printStackTrace();
        }
    }

    public static void main(String[] args) {
        String[][] data = {{"Housewares", "Rs.1275.00"},
            {"Pets", "Rs.125.00"}, {"Electronics", "Rs.2533.00"},
            {"Menswear", "Rs.497.00"}
        };
        String[] headers = {"Department", "Daily Revenue"};

        JFrame frame = new JFrame("JTable to Excel");
        DefaultTableModel model = new DefaultTableModel(data, headers);
        final JTable table = new JTable(model);
        JScrollPane scroll = new JScrollPane(table);

        JButton export = new JButton("Export");
        export.addActionListener(new ActionListener() {

            @Override
            public void actionPerformed(ActionEvent evt) {

                try {
                    ExcelExporter exp = new ExcelExporter();
                    exp.fillData(table, new File("C:\\result.xls"));
                    JOptionPane.showMessageDialog(null, "Data saved at " +
                            "'C: \\ result.xls' successfully", "Message",
                            JOptionPane.INFORMATION_MESSAGE);
                } catch (Exception ex) {
                    ex.printStackTrace();
                }
            }
        });

        frame.getContentPane().add("Center", scroll);
        frame.getContentPane().add("South", export);
        frame.pack();
        frame.setVisible(true);
        frame.setDefaultCloseOperation(frame.EXIT_ON_CLOSE);
    }
}

______________________________________________________________

Here When you Click on Export Button then whole JTable Data will be transfered to result.xls file in your C Drive.....

So try & Enjoy.........

Leave Comments if you like.....

Thank you....

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

Follow Other Java Swing Tricks....

< < MySQL Dynamic Data in JTable Tutorial> >

< < MySQL Data In JTable Tutorial> >

< < UnDo/ReDo in JTextArea Tutorial> >

< < JScrollPane Tutorial> >

< < Infinite JProgressBar Tutorial> >

< < JProgressBar Tutorial> >

< < JTabbedPane Tutorial> >

< < GridBag Layout Tutorial> >

< < Image Preview In JFilechooser> >

< < Resize JTable Columns > >

< < Create Animated Notify Window > >

< < Create Vibrating JDialog > >

< < Export JTable To Excel File > >

< < Create Image JButton > >

< < Create Image JPanel > >

Java Swing - Create Image JButton

2011-05-08T22:17:00.001-07:00

Java Swing - Create Image JButton

First Create Image Panel Class:-

First Create a class called ImagePanel.java. Then write the code in it.

This is the class we have developed in last post. You can check it here --

Java Swing - Create Image JPanel

After doing that work do as shown below...

We will use following images for JButton.

Use For JButton when application starts

Use For Selected and Disabled JButton

Use For JButton Roll Over

Use For JButton Pressed

Add These images to your projects. And write Below code.

Now Create ImageButton.java Class:-

This class is for create Jbutton and we can use it in any class later after to use the image JButton.

So this class is the skeleton for JButton. Now when we want to add JButoon in our class then just create the instance of ImageButton.java class and pass any image you want to use as JButton in its Constructor...and you will see the magic of Java Swing....

Write Below code for create JButton in your JFrame...

import javax.swing.*;

public class ImageCheck {

    public static void main(String s[])
    {
        ImagePanel panel = new ImagePanel(new
            ImageIcon("aa.jpg").getImage());

        JFrame frame = new JFrame("Create Image-" +
                        "Themed Components");

        frame.getContentPane().add(panel);

        final ImageButton button = new ImageButton(
            new ImageIcon("Warehouse.png"));

        button.setPressedIcon(new ImageIcon("" +
                        "ButtonPressed.png"));
        button.setRolloverIcon(new ImageIcon("" +
                        "ButtonRollover.png"));
        button.setSelectedIcon(new ImageIcon("" +
                        "Selected&Disabled.png"));
        button.setDisabledIcon(new ImageIcon("" +
                        "Selected&Disabled.png"));

        button.setLocation(150,30);
        panel.add(button);

        frame.pack();
        frame.setDefaultCloseOperation(2);
        frame.setVisible(true);
    }
}

The output of this will look like....

Here you can see the button is a round image. When you will move mouse on it, the image will change as per our code..and look like a web application button in your window application....So try & Enjoy.........

Leave Comments if you like.....

Thank you....
Nirav Raval

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

Follow Other Java Swing Tricks....

< < MySQL Dynamic Data in JTable Tutorial> >

< < MySQL Data In JTable Tutorial> >

< < UnDo/ReDo in JTextArea Tutorial> >

< < JScrollPane Tutorial> >

< < Infinite JProgressBar Tutorial> >

< < JProgressBar Tutorial> >

< < JTabbedPane Tutorial> >

< < GridBag Layout Tutorial> >

< < Image Preview In JFilechooser> >

< < Resize JTable Columns > >

< < Create Animated Notify Window > >

< < Create Vibrating JDialog > >

< < Export JTable To Excel File > >

< < Create Image JButton > >

< < Create Image JPanel > >

Java Swing - Create Image Panel

2011-05-06T04:47:00.001-07:00

Java Swing - Create Image Panel

Create Image Panel Class:-

First Create a class called ImagePanel.java. Then write the following code in it.

In This Code:

We have used Image as parameter in Constructor of ImagePanel class. This is the image which will set as background Image of JPanel. I have used following Image.

This code will create one customized JPanel class which you can call by instance of this class and it will create a JPanel with an Image as background.

Now We will create another class called ImageCheck.java which call the ImagePanel class and create a JFrame having a Jpanel with above Image.

class ImageTest.java:

Write Code as below.

_______________________________________________________________

Run The Code Code And Get Output like this..

This is the JFrame created with JPanel we created in ImagePanel.java Class with background Image we have used.

Thanks & Enjoy....

Write Comments if you like....

Nirav Raval

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

Follow Other Java Swing Tricks....

< < MySQL Dynamic Data in JTable Tutorial> >

< < MySQL Data In JTable Tutorial> >

< < UnDo/ReDo in JTextArea Tutorial> >

< < JScrollPane Tutorial> >

< < Infinite JProgressBar Tutorial> >

< < JProgressBar Tutorial> >

< < JTabbedPane Tutorial> >

< < GridBag Layout Tutorial> >

< < Image Preview In JFilechooser> >

< < Resize JTable Columns > >

< < Create Animated Notify Window > >

< < Create Vibrating JDialog > >

< < Export JTable To Excel File > >

< < Create Image JButton > >

< < Create Image JPanel > >

My SQL Trigger Tutorial

2011-04-30T03:33:00.001-07:00

My SQL Trigger Tutorial

TRIGGERS:-

A Trigger is a named database object which defines some action that the database should take when some databases related event occurs. Triggers are executed when you issues a data manipulation command like INSERT, DELETE, UPDATE on a table for which the trigger has been created. They are automatically executed and also transparent to the user. But for creating the trigger the user must have the CREATE TRIGGER privilege. In this section I will describe you example of create and drop the triggers.

So Stick with me...

1. CREATE TABLE IN MySQL:-

First We create a table on which We will create TRIGGER.

We create a table called "one" as shown below.

Create Table "one"

2. CREATE TRIGGER IN MySQL:-

Now We will create a BEFORE UPDATE TRIGGER on table "one" Which We earlier created.

Create update TIGGER On Table "one"

3. TEST TRIGGER IN MySQL:-

Now We will Test a BEFORE UPDATE TRIGGER Which We earlier created on table "one".

Test BEFORE UPDATE TRIGGER on TABLE one.

Here, you can see If Anyone try to update any name with "NIRAV" in table "one", the BEFORE UPDATE TRIGGER will fired automatically by MySQL and it will changed name "NIRAV" to "ABCD" as per defined in TRIGGER updTriggerOne.

I hope it will be helpful to you in Understanding TRIGGER in MySQL.

Thank You.!

Please Leave Comments If this found helpful to you.

Thanks.....& Enjoy...

hostgator coupon code

MySQL Stored Function Tutorial 2

2011-04-29T04:50:00.001-07:00

MySQL Stored Function Tutorial 2

1. Create Another Stored Function In MySQL
(Here I am using MySQl Query Browser)

DELIMITER $$

DROP FUNCTION IF EXISTS `test`.`updateOneFunction` $$
CREATE FUNCTION `test`.`updateOneFunction` (tname VARCHAR(30),
tid INT) RETURNS INT
BEGIN

UPDATE ONE SET name=tname WHERE ID=tid;

RETURN 1;
END $$

DELIMITER ;

_____________________________________________________________________________

2. Now Write Java Code To Call It in Your Application

try

{

cn=DriverManager.getConnection("jdbc:mysql://localhost:3306/" +

"test","root","root");

st=cn.createStatement();

st.executeUpdate("SELECT updateOneFunction('"+name+"','"+id+"')");

rs=st.executeQuery("select * from one WHERE id='"+id+"'");

rs.next();

System.out.println("Updated Name = "+rs.getString(2));

}catch(Exception e){

e.printStackTrace();

}

____________________________________________________________________

Thank You...

MySQL Stored Function 1

2011-04-29T04:30:00.002-07:00

MySQL Stored Function Tutorial 1

1. Create The Below Stored Function In MySQL
(Here I am using MySQl Query Browser)

DELIMITER $$

DROP FUNCTION IF EXISTS `test`.`updateOneFunction` $$

CREATE FUNCTION `test`.`updateOneFunction` (tname VARCHAR(30), tid INT)
RETURNS INT
BEGIN

UPDATE ONE SET name=tname WHERE ID=tid;

RETURN 1;
END $$

DELIMITER ;

1. Now Write Java Code To Call It in Your Application

try

{

cn=DriverManager.getConnection("jdbc:mysql://localhost:3306/" +

"test","root","root");

st=cn.createStatement();

st.executeUpdate("SELECT updateOneFunction('"+name+"','"+id+"')");

rs=st.executeQuery("select * from one WHERE id='"+id+"'");

rs.next();

System.out.println("Updated Name = "+rs.getString(2));

}catch(Exception e){

e.printStackTrace();

}

MySQL Stored Procedure Tutorial 1

2011-04-28T07:19:00.001-07:00

MySQL Stored Procedure Tutorial

1. Create Procedure in MySQL As Below: (Here I am

using MySQL Query Browser).

Procedure In MySQL 'getData' on table 'one' of database

'test' with structer (id int, surname varchar(30))

_______________________________________________________________________________

DELIMITER $$

DROP PROCEDURE IF EXISTS `test`.`getData` $$

CREATE DEFINER=`root`@`localhost` PROCEDURE `getData`(IN tname VARCHAR(25))

BEGIN

SELECT * FROM one WHERE name=tname;

END $$

DELIMITER ;

_________________________________________________________________________________

So This was the code of procedure creation.. Now we will call it from java code...

2. Following is the java code to call Procedure From

MySQL Database.

import java.sql.CallableStatement;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.Statement;

public class testProcedure {

public static void main(String s[])

{

Connection cn;

Statement st;

try

{

cn=DriverManager.getConnection("jdbc:mysql://localhost:3306/" +

"test","root", "root");

st=cn.createStatement();

st.execute("call getData('Ankit')");

ResultSet rs=st.getResultSet();

while(rs.next())

{

System.out.println("id= "+rs.getString(1));

System.out.println("surname= "+rs.getString(2));

}

}catch(Exception e){

e.printStackTrace();

}

My SQL Procedure Call Tutorial In Java

2011-04-28T03:00:00.000-07:00

MySQL Stored Procedure Tutorial

1. Create Procedure in MySQL As Below: (Here I am

using MySQL Query Browser).

Procedure In MySQL 'getData' on table 'one' of database

'test' with structer (id int, surname varchar(30))

_______________________________________________________________________________
DELIMITER $$

DROP PROCEDURE IF EXISTS `test`.`getData` $$
CREATE DEFINER=`root`@`localhost` PROCEDURE `getData`(IN tname VARCHAR(25))
BEGIN
SELECT * FROM one WHERE name=tname;
END $$

DELIMITER ;
_________________________________________________________________________________

So This was the code of procedure creation.. Now we will call it from java code...

2. Following is the java code to call Procedure From
MySQL Database.

import java.sql.CallableStatement;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

public class testProcedure {

public static void main(String s[])
{
Connection cn;
Statement st;

try
{
cn=DriverManager.getConnection("jdbc:mysql://localhost:3306/" +
"test","root", "root");
st=cn.createStatement();
st.execute("call getData('Ankit')");

ResultSet rs=st.getResultSet();

while(rs.next())
{
System.out.println("id= "+rs.getString(1));
System.out.println("surname= "+rs.getString(2));
}
}catch(Exception e){
e.printStackTrace();
}

}

My Site Development

2011-03-03T19:53:00.001-08:00

Hello Friends, I am Nirav Raval Developed Web Sites For Your Business Work
Below is the wesite I made for one of my clients.

http://www.annpurnacaterers.com/

Annpurna Caterers, Baroda, Gujarat, India