亚洲欧美第一页_禁久久精品乱码_粉嫩av一区二区三区免费野_久草精品视频

蟲蟲首頁| 資源下載| 資源專輯| 精品軟件
登錄| 注冊

prepareStatement

  • pstmt = conn.prepareStatement("select ordernumber,datetime,price,dayofmoney from zujie where ordernu

    pstmt = conn.prepareStatement("select ordernumber,datetime,price,dayofmoney from zujie where ordernumber= "+ cdName + " ") rs=pstmt.executeQuery() if(rs!=null && rs.next()){ String datetime = rs.getString(2) java.text.SimpleDateFormat formatter = new java.text.SimpleDateFormat ("yyyy-MM-dd") Date date = new Date() String date1=formatter.format(date) ParsePosition pos = new ParsePosition(0) ParsePosition pos1 = new ParsePosition(0) Date dt1=formatter.parse(datetime,pos) Date dt2=formatter.parse(date1,pos1) Long l = (dt2.getTime()-dt1.getTime())/(3600*24*1000)+1 double price = rs.getDouble(3) double dayofmoney=rs.getDouble(4) double dayofmoneybuy=dayofmoney*l double otherMoney = price-dayofmoneybuy request.setAttribute("price", price) request.setAttribute("l", l) request.setAttribute("dayofmoney", dayofmoneybuy) request.setAttribute("otherMoney", otherMoney)

    標簽: prepareStatement ordernumber dayofmoney datetime

    上傳時間: 2013-12-14

    上傳用戶:zsjinju

主站蜘蛛池模板: 高安市| 色达县| 大名县| 阿鲁科尔沁旗| 临泉县| 盐亭县| 碌曲县| 敦化市| 五寨县| 东山县| 广饶县| 丰都县| 九江市| 和田县| 波密县| 贵溪市| 仁布县| 洪泽县| 甘谷县| 辉县市| 湘阴县| 邯郸县| 桦川县| 泗阳县| 凯里市| 道真| 桂平市| 沅江市| 武义县| 页游| 绥宁县| 进贤县| 奎屯市| 靖宇县| 沂水县| 读书| 北海市| 襄垣县| 微博| 乐陵市| 车致|