我在jsp日期格式方面遇到问题,我希望复选框像dd/mm/yyyy
而不是dd/mm/yyyy hh:mi:ss
,有什么解决方案吗?这是我的代码:
String sql1= "SELECT * from ajout_train";
PreparedStatement st1 = cnx.prepareStatement(sql1);
<tbody style="width: 105px">
<tr>
<td><label for="datedept">Départ le:</label></td>
<td> <select name="datedept" id="datedept"><%
if (st1.execute()) {
ResultSet rs1 = st1.getResultSet();
ResultSetMetaData rsmd = rs1.getMetaData();
while(rs1.next()) {
if (rs1.getObject(4) != null){
out.println("<option>"+rs1.getObject(4).toString()+"</option>");
}
}
}
%></select><%
%></td>
</tr>
java中有一个内置类来格式化日期使用此代码段。有关的详细信息,可以参考此链接SimpleDateFormat
if (rs1.getObject(4) != null){
SimpleDateFormat inputdate = new SimpleDateFormat("dd/mm/yyyy hh:mm:ss");
SimpleDateFormat outputdate = new SimpleDateFormat("dd/mm/yyyy");
try {
String result = outputdate.format(inputdate.parse(rs1.getObject(4).toString()));
}
catch (Exception e) {
out.println(e);
}
out.println("<option>"+result+"</option>");
}
使用子字符串解决了问题
enter code here
Départ le:<%if(st1.execute()){结果集rs1=st1.getResultSet();ResultSetMetaData rsmd=rs1.getMetaData();
while(rs1.next())
{
if (rs1.getObject(4) != null){
String result=(String)(rs1.getObject(4).toString());
result=result.substring(0,10);
out.println("<option>"+result+"</option>");
}
}
}
%></select><%
%></td>
</tr>