package com.bean;

import java.sql.Timestamp;

public class StrFormat 
{
	
	public   String formatTime(String time) 
	{
		return ( time == null || time.length() < 14) ? "null" : "TO_TIMESTAMP( '" + time.trim() + "','YYYYMMDDHH24MISS.FF')";
	}
	
	public   Timestamp formateTimeStamp(long time)
	{
		Timestamp timestamp = new Timestamp(time);		
		return timestamp;	
	}
	
	public   String isNull(String str) 
	{
		return ( str == null || str.length() == 0 || str.equals("null")) ? "''" : "'"+str.trim()+"'";
	}
	
	public  int isNumNull(String number) 
	{		
		try
		{
			return  (number == null || number.length() == 0 || number.equals("null")) ? 0 : Integer.valueOf(number).intValue();			
		}
		catch(Exception ex)
		{
			return 0;
		}			
	}
	
	public  float isNumLongNull(String number) 
	{
		float temp = 0;
		try
		{
			return (number == null || number.length() == 0 || number.equals("null")) ? 0  : Float.valueOf(number).floatValue();
		}
		catch(Exception ex)
		{
			return 0 ;
		}		
	}
}