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)
標(biāo)簽：
prepareStatement
ordernumber
dayofmoney
datetime
上傳時(shí)間：
2013-12-14
上傳用戶：zsjinju
按AN3,依次進(jìn)入鬧鐘功能是否啟用，鬧鐘時(shí),分秒,年,月,日及時(shí)間時(shí),分,秒的設(shè)置,直到退出設(shè)置狀態(tài)
按AN4,調(diào)整是否起用鬧鐘和調(diào)節(jié)鬧鐘時(shí),分,秒,年,月,日,時(shí)間的時(shí),分,秒的數(shù)字
LCD第二排中間顯示小喇叭，表示啟用鬧鐘功能，無則禁止鬧鐘功能（可在調(diào)整狀態(tài)進(jìn)行設(shè)置）
標(biāo)簽：
AN
鬧鐘
上傳時(shí)間：
2016-11-28
上傳用戶：二驅(qū)蚊器
