Convert Date object to Mysql Date Format 


 public static String toMysqlDateStr(Date date){
  if (date==null) return "NULL";
  SimpleDateFormat sdf =new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
  return sqlValueWithQuotas(sdf.format(date));
 }

 public static String sqlValueWithQuotas(Object obj){
  if ( obj == null ) return "NULL";
  
  String str = obj.toString();
  str.replaceAll("'", "\\'");
  str = '\''+str+'\'';
  
  return str;
  
 }

Comments

Anonymous said…
Thank you, this is really what I need for this moment :P
March 25, 2010 at 9:51 AM
Post a Comment

Popular posts from this blog

Connect via SSH without a password from MacOS to Linux with an SSHKEY

Don't panic , it is really easy. Your Steps will be: 1. Create a key on your Mac 2. Define your key on remote Linux 3. Connect via ssh. 1.  Create the key on your Mac Open the terminal :) First make a directory named .ssh on your home directory ( mkdir .ssh ) If it exist , no problem. Go to the newly created .ssh directory with command cd .ssh Then, you need to create a ssh key on your MAC. There will be 2 files for key. If you dont want any passwords , just press enter when passphrase asked. Filename will be default id_rsa if you just hit enter. But if it already exists , you may want to choose another name. Hakos-MacBook-Pro:.ssh hakan$ ssh-keygen -t rsa -C "your@email.com" Generating public/private rsa key pair. Enter file in which to save the key (/Users/hako/.ssh/id_rsa): Enter passphrase (empty for no passphrase): Enter same passphrase again: Your identification has been saved in /Users/hako/.ssh/id_rsa. Your public key has been saved in /...
Read more

Escape HTML and XML in Java

HTML and XML escape format is widely used in web and XML transactions. There is a great utility for this purpose in Java world : Lang package in apache commons project Download commons-lang and put the commons-lang-xxx.jar file in your classpath or in your project. The StringEscapeUtils class is your key class here. Use static escapeXml() , escapeHtml() , unescapeXml() , unescapeHtml() methods. String escaped = StringEscapeUtils.escapeXml(" "); Great & Lifesaving , thanks apache again !
Read more

Sort a HashMap based on Keys or Values

Sort based on keys is simple , just dump the map into TreeMap (TreeMap is sorted by nature) Map myMap = new HashMap(); // put keys and values... ..... Map sortedMap = new TreeMap(myMap); If you want to sort your HashMap based on values : HashMap map1 = new HashMap(); map1.put("cat",5); map1.put("cow",4); map1.put("dog",3); map1.put("horse",2); List mpKeys = new ArrayList(map1.keySet()); List mpValues = new ArrayList(map1.values()); HashMap map = new LinkedHashMap(); TreeSet sortedSet = new TreeSet(mapValues); Object[] sortedArray = sortedSet.toArray(); int size = sortedArray.length; // descending for (int i=size-1; i>=0; i--) System.out.println(mpKeys.get(mpValues.indexOf(sortedArray[i]))+" "+sortedArray[i]); Any discussions will be appreciated.
Read more