Use Column Methods

import java.sql.*;

public class jdbcConn

   public static void main(String[] args) throws Exception

      Class.forName("org.apache.derby.jdbc.ClientDriver");

      Connection con = DriverManager.getConnection

      ("jdbc:derby://localhost:1527/testDb","name","pass");

      Statement stmt = con.createStatement();

      String query = "select * from emp order by name";

      ResultSet rs = stmt.executeQuery(query);

      ResultSetMetaData rsmd = rs.getMetaData();

      System.out.println("no of columns in the table= "+

      rsmd.getColumnCount());

      System.out.println("Name of the first column "+

      rsmd.getColumnName(1));

      System.out.println("Type of the second column "+

      rsmd.getColumnTypeName(2));

      System.out.println("No of characters in 3rd column "+

      rsmd.getColumnDisplaySize(2));

Splitting a String

import java.util.regex.Matcher;

import java.util.regex.Pattern;

public class Resetting

   public static void main(String[] args) throws Exception

      Matcher m = Pattern.compile("[frb][aiu][gx]").

      matcher("fix the rug with bags");

      while (m.find())

         System.out.println(m.group());

      m.reset("fix the rig with rags");

      while (m.find())

         System.out.println(m.group());