GATEWAY TO JAVA

Java code to connect mysql Database

public static int getConnection(){
if(driverLoaded==false){
try {
Class.forName("com.mysql.jdbc.Driver");
driverLoaded = true;
} catch (ClassNotFoundException e) {
e.printStackTrace();
return 100;
}
}
try {
if(con==null){
con=DriverManager.getConnection("jdbc:mysql://localhost:3306/dbname","username","password");
}
else if(con.isClosed()) {
con=DriverManager.getConnection("jdbc:mysql://localhost:3306/dbname","username","password");
}
} catch (SQLException e) {
e.printStackTrace();
return 101;
}
return 1;
}



Java code to convert string to date ( in a Reqd. Format)

public static String stringToDate(String adate) throws java.text.ParseException{
String sdate=null;
System.out.println("adate=====>"+adate);
java.util.Date dbdate = new Date();
java.util.Date dtDate = new Date();

SimpleDateFormat sdf = new SimpleDateFormat("yyyy-mm-dd");
SimpleDateFormat sdfAct = new SimpleDateFormat("dd-mm-yyyy");
try
{
dtDate = sdfAct.parse(adate);
sdate=sdf.format(dtDate) ;

}
catch (Exception e)
{
e.printStackTrace();
}
return sdate;
}


Java code to convert Date to String ( in a Reqd. Format)

public static String DateToString(String adate) throws java.text.ParseException{
String sdate=null;
java.util.Date dbdate = new Date();
java.util.Date dtDate = new Date();

SimpleDateFormat sdfAct = new SimpleDateFormat("yyyy-mm-dd");
SimpleDateFormat sdf = new SimpleDateFormat("dd-mm-yyyy");
try
{
dtDate = sdfAct.parse(adate);
sdate=sdf.format(dtDate) ;
}
catch (Exception e)
{
System.out.println("Unable to parse the DateToString");
e.printStackTrace();
}
return sdate;
}