var d = new Date();var year = d.getFullYear();//获取当前年份yearJuge ();function yearJuge (){var investAmt = $("#shop-num").val();var useMoney = $(".remianAmt").val();var incomeNum = $(".rate").val()/100;i
按月份查询 SELECT * FROM tbl_order GROUP BY DATE_FORMAT(CreateTime,'%Y-%m'); SELECT sum(money), DATE_FORMAT(CreateTime,'%Y-%m') FROM tbl_order GROUP BY DATE_FORMAT(CreateTime,'%Y-%m'); 按天查询 SELECT *
在JSP页面中设置一个年份选择的下拉框,话不多说,直接上代码。 <select id="myYear"></select> <script language="javascript" type="text/javascript"> window.οnlοad=function(){ //设置年份的选择 var myDate= new Date(); var startYear=myD