String sql="select distinct xfdate from xiaofei where regname like '%"+userid+"%' order by xfdate";
ResultSet rs = stmt.executeQuery(sql);按以上查询的结果是
2009/9/7
2009/9/10
2009/10/12
2010/1/3
2010/10/23但是我想把它显示成2009/9/
2009/9/
2009/10/
2010/1/
2010/10/请教代码应该怎么写?
ResultSet rs = stmt.executeQuery(sql);按以上查询的结果是
2009/9/7
2009/9/10
2009/10/12
2010/1/3
2010/10/23但是我想把它显示成2009/9/
2009/9/
2009/10/
2010/1/
2010/10/请教代码应该怎么写?
sdf.format(date);
XX.Substring(0,XX.lastIndexOf("/")+1);
request.setCharacterEncoding("gb2312");
String strError = null;
String userid=(String)session.getAttribute("user");
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager.getConnection("jdbc:odbc:goodschaginfo");
Statement stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
String sql="select distinct xfdate from xiaofei where regname like '%"+userid+"%' order by xfdate"; ResultSet rs = stmt.executeQuery(sql);
while(rs.next())
{
xfdate.Substring(0,6); %>
<option value="<%=rs.getString("xfdate")%>"> <%=rs.getString("xfdate")%></option>
<%
}
rs.close();
stmt.close();
con.close();
}
2.是在用ORACLE吗? 很简单.
如果查询出来的是string 直接 sql语句改为 String sql="select distinct to_char(xfdate,'yyyy/mm/') from xiaofei where regname like '%"+userid+"%' order by xfdate";
3.如果查询出来的是date 改为sql语句改为 String sql="select distinct to_date(to_char(xfdate,'yyyy/mm/'),'yyyy/mm/') from xiaofei where regname like '%"+userid+"%' order by xfdate";
4. 其实一般都是输出(yyyy-mm-dd)2010-01-05 这种形式的
String sql="select distinct to_char(xfdate,'yyyy-mm-dd') from xiaofei where regname like '%"+userid+"%' order by xfdate";
-------------------->>>>>>>>
<%
String d = rs.getString("xfdate");
d = d.substring(0,d.lastIndexOf("/")+1);
%>
<option value="<%=d%>"> <%=d%></option>