// Create the prepared statement and use it to
// INSERT the student attributes INTO the Student table.
PreparedStatement pstmt = conn.prepareStatement(
"INSERT INTO Review VALUES (?, ?, ?, ?)");
pstmt.setInt(1, Integer.parseInt(request.getParameter("section_id")));
pstmt.setString(2, request.getParameter("quarter"));
pstmt.setInt(3, Integer.parseInt(request.getParameter("year")));
pstmt.setDate(4, ????)
谁能告诉我如何处理日期类型?
首先,您需要将String解析为java.util.Date
object。
SimpleDateFormat format = new SimpleDateFormat("dd-MMM-yyyy");
Date date = format.parse(request.getParameter("date"));
然后,您可以转换java.util.Date
为java.sql.Date
以便在中使用PreparedStatement
:
java.sql.Date sqlDate = new java.sql.Date(date.getTime());
PreparedStatement pst = connection.prepareStatement(sql);
pst.setDate(4, sqlDate);
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句