且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

将日期转换为MYSQL日期格式

更新时间:2023-11-29 12:49:46

首先创建一个

First create a SimpleDateFormat for parsing your input from the UI:

SimpleDateFormat sdf = new SimpleDateFormat("MMM dd, yyyy");

接下来,将输入解析为java.sql.Date(不幸的是,该名称与java.util.Date不同).例如:

Next parse an input into a java.sql.Date (which is unfortunately named and different from java.util.Date). So for example:

java.sql.Date date = new java.sql.Date(sdf.parse(fromDate).getTime());

最后,在进行数据库查询时,使用date传递给JDBC.如:

Finally use the date to pass to JDBC when making your database queries. Such as:

Connection con; // assuming you have a database connection
PreparedStatement ps = con.prepareStatement("SELECT * FROM table WHERE x = ?");
ps.setDate(1, date);
ResultSet resultSet = ps.executeQuery();