String----->java.util.date------->java.sql.date
String workDate;
SimpleDateFormat format = new SimpleDateFormat("yyyy-MM-dd");
Date d=null;
try{
d=format.parse(workDate);
}catch(Exception e){
e.printStackTrace();
}
java.sql.Date date=new java.sql.Date(d.getTime());
String----->java.sql.time
String sworktime;
String eworktime;
SimpleDateFormat format1 = new SimpleDateFormat("HH:mm");
Date d1=null;
Date d2=null;
try{
d1=format1.parse(sworktime);
d2=format1.parse(eworktime);
}catch(Exception e){
e.printStackTrace();
}
java.sql.Time stime=new java.sql.Time(d1.getTime());
java.sql.Time etime=new java.sql.Time(d2.getTime());