Eliminate invisible new line or blank charecters in a string using java

Some times when we process string output from different other sources we will end up having invisible blank or new line or some tabbed characters which will annoy us from parsing that string for a particular thing. In that case while using Java we can use Trim method which helps a lot on this situation.

Another great quality of this trim method is , it can remove blank like characters from both sides of strings .
This method removes the blank spaces from both ends of the given string (Front and End).

A Simple example below might be helpful to use this
import 
java.lang.*;

public class StringTrim{
  public static void main(String[] args) {
  System.out.println("String trim example!");
  String str = " [RoseIndia, hi, hello]   ";
  System.out.println("Given String :" + str);
  System.out.println("After trim :" +str.trim());
  }
}


OutPut :
Given String : [RoseIndia, hi, hello]   
After trim :[RoseIndia, hi, hello]

Read more


DB2 10 JDBC Strings to use in JAVA code

Below is a simple example of java method which will return true if given database contains any table by name DB_VERSION. Else it returns false.

 /*
     * isRegistryDBConfigured()    method returns true if provided Database
     * contains table DB_VERSION. Returns false if it doesn't contain
     * that table.
     */
    public boolean isRegistryDBConfigured(String dbName, String portNumber,String userName, String password) {
        try {
          String hostName = InetAddress.getLocalHost().getCanonicalHostName();
            Class.forName("com.ibm.db2.jcc.DB2Driver");
            StringBuffer dbConnectionURL = new StringBuffer("jdbc:db2://");
            dbConnectionURL.append(hostName + ":" + portNumber + "/" + dbName);
            Connection db2Conn = DriverManager.getConnection(
                    dbConnectionURL.toString(), userName, password);
//Connection db2Conn = DriverManager.getConnection("jdbc:db2j:net://localhost:50000/frsdb","db2admin","db2admin");          
 // Connection db2Conn =  DriverManager.getConnection("jdbc:db2://localhost:50000/test","db2admin","db2admin");
            Statement st = db2Conn.createStatement();
            String myQuery = "SELECT TABNAME FROM SYSCAT.TABLES WHERE TABNAME ='DB_VERSION'";
            ResultSet resultSet = st.executeQuery(myQuery);
            while (resultSet.next()) {
                String name = resultSet.getString("TABNAME");
                if (name.equals("DB_VERSION")) {
                    System.out.println("Tablename:" + name);
                    return true;
                }
            }
            resultSet.close();
            st.close();
            db2Conn.close();
           
        } catch (Exception e) {
            System.out.println("EXCEPTION::" + e);
        }
        return false;
    }

Read more


Select particular table name from given database in db2

Here is a simple DB2 - SQL  command to find a particular table name exists in given database name.

SELECT TABNAME FROM SYSCAT.TABLES WHERE TABNAME =''

Example :
Database name : FRSDB
Table Name : DB_VERSION


C:\Users\ADMIN>db2 connect to frsdb

   Database Connection Information

 Database server        = DB2/NT64 10.1.0
 SQL authorization ID   = KRISHNA
 Local database alias   = FRSDB


C:\Users\ADMIN>db2 SELECT TABNAME FROM SYSCAT.TABLES WHERE TABNAME ='DB_VERSION'

TABNAME
--------------------------------------------------------------------------------------------------------------------------------
DB_VERSION

  1 record(s) selected.


C:\Users\ADMIN>

Read more

Translate

Enter your email address:

Buffs ...

Visitors


hits counter
View My StatsCheck Google Page Rank

Add to Google Reader or Homepage

Bookmark and Share

Tags


Powered by WidgetsForFree