Exception_06

26.账单查询

select u.name accountName, u.loginName accountLoginName, d.duration, p.basefee

from users u, userservices s , detailyears_2008 d, pricings p

where u.id=s.userid 

and p.id=s.priceid

and d.loginname = s.loginname

and u.name="zw"

and month(d.logouttime)=4;

=======================================================

select s.loginName reckonLoginName, d.duration, d.logouttime logintime, p.basefee, p.ratefee, p.name

from users u, userservices s , detailmonths_4 d, pricings p

where u.id=s.userid 

and p.id=s.priceid

and d.loginname = s.loginname

and u.name="zw"

and year(d.logouttime)=2008;

 

select s.loginName reckonLoginName, d.duration, d.logouttime logintime, p.basefee, p.ratefee, p.name

from users u, userservices s , detailmonths_4 d, pricings p

where u.id=s.userid

and p.id=s.priceid

and d.loginname = s.loginname 

and u.name='zhongwei'  and year(d.logouttime)=2008

 

 

 

27. 

javax.servlet.ServletException: Request[/reckon] does not contain handler parameter named 'method'.

  This may be caused by whitespace in the label text.

 

28.

java.lang.NumberFormatException: For input string: "accountName"

属性名错误

 

29.

分页: 通过一个static 变量保存当前页，和list 效果不一定好

 

30.

java.lang.IndexOutOfBoundsException: Index: 0, Size: 0

PricingsForm pricingsForm = (PricingsForm) form;

String name = pricingsForm.getPricings().getName();

 

<tr>

<td align="right" valign="top">资费名称：</td>

td align="left" valign="top"><input type="text" name="pricings.name" value="" style="WIDTH:170px" οnblur="validate()"></td>

</tr>

通过Javascript 来获得标签的值，在URL上加上一个参数传到Action中

var name = document.getElementById("name").value;

var requestURL = "${pageContext.request.contextPath}/fee/validate.do?name="+name;