Convert Java Date to Mysql Date

Normal 0 21 false false false MicrosoftInternetExplorer4

public static String toMysqlDateStr(Date date){

if (date==null)

return "NULL";

SimpleDateFormat sdf =new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");

return '\''+sdf.format(date)+'\'';

}

Comments

Post a Comment

Popular posts from this blog

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

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

Read and Write Files in Java

Here is a sample code I just wrote. This class copies one file to another. By understanding this code below , you will comphrend both reading from and writing to file concepts in java. I used FileInputStream and FileOutputStream in this code. package javacream; import java.io.File; import java.io.FileInputStream; import java.io.FileOutputStream; import java.io.IOException; public class FileUtil { public static void copyFile(String strInputFileName , String strOutputFileName) throws IOException { //Prepare file objects File fInputFile = new File(strInputFileName); File fOutputFile = new File(strOutputFileName); //Prepare read write streams from file objects FileInputStream fis = new FileInputStream(fInputFile); FileOutputStream fos = new FileOutputStream(fOutputFile); int c; // read from the input file and write to the output file while ((c = fis.read()) != -1) { ...
Read more