String转成 :java date
import java.text.SimpleDateFormat;
import java.util.Date;
public class ZhuanHuan{
public void zhuanHuan(){
String date = "2019-09-00";
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-mm-dd");
try {
Date date1 = sdf.parse(date);
} catch (ParseException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
转载别人的:JAVA 日期转 SQL日期
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.Date;
public class Text {
public static void main(String[] args) {
String joinDate = "2012-3-21 11:7:5";
//开始是String=”2012-3-21 11:7:5“
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
//变成Wed Mar 21 11:07:05 CST 2012
java.util.Date javaDate= null;
try {
javaDate= sdf.parse(joinDate);
} catch (ParseException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
//剩下这个2012-3-21
java.sql.Date sqlDate = new java.sql.Date(javaDate.getTime());
//剩下这个2012-3-21
System.out.println(sqlDate);
//格式化再输出
System.out.println(sdf.format(sqlDate));
}
}
根据查看上述代码自己写的java date 转成 sql date(存入数据库)
public void insertXueSheng(XueShengVO vo) {
String sql = "insert into xuesheng values " + "(?, ?, ?, ?, ?, ?, ? ,? )";
Connection conn = DBManager.getConnection();
PreparedStatement ps = null;
try {
ps = conn.prepareStatement(sql);
ps.setString(1, vo.getXuehao());
ps.setString(2, vo.getXingming());
ps.setString(3, vo.getXingbie());
ps.setDate(4, new java.sql.Date(vo.getChushengriqi().getTime()));
ps.setString(5, vo.getJiguan());
ps.setString(6, vo.getShouji());
ps.setString(7, vo.getQq());
ps.setString(8, vo.getBanjibianhao());
ps.executeUpdate();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} finally {
DBManager.free(conn, ps);
}
}