/** 
  * @param 返回java.sql.Date格式的 
  * */ 
 public java.sql.Date strToDate(String strDate) { 
  String str = strDate; 
  SimpleDateFormat format = new SimpleDateFormat("yyyy-MM-dd"); 
  java.util.Date d = null; 
  try { 
   d = format.parse(str); 
  } catch (Exception e) { 
   e.printStackTrace(); 
  } 
  java.sql.Date date = new java.sql.Date(d.getTime()); 
  return date; 
 }

 /** 
  * @param 返回java.sql.Time格式的 
  * */ 
 public java.sql.Time strToDate(String strDate) { 
  String str = strDate; 
  SimpleDateFormat format = new SimpleDateFormat("hh:mm:ss"); 
  java.util.Date d = null; 
  try { 
   d = format.parse(str); 
  } catch (Exception e) { 
   e.printStackTrace(); 
  } 
  java.sql.Date date = new java.sql.Time(d.getTime()); 
  return date; 
 }