我想在一个页面多项查询,先试下两项的就出错了,列位看看怎回事?谁能给个好用的例子,
用来将页面上的多项做不定项的选择,多谢
此中name是char类型,name是int型。报错为:
';' expected
{ }else{sql+= " objectname = '"name"'";}
^
1 error
下是部分代码:
String name =request.getParameter("objectN");
String name1 =request.getParameter("arcmin");
String sql="select * from compcacu where";
if(name.equals(" "))
{ }else{sql+= " objectname = '"name"'";}
if(name1.equals("")){ }
else{
int nn = Integer.parseInt(name1);
sql+="and arcmin = nn";}
ResultSet rs=stmt.executeQuery(sql);
另:nn能传出值么?
用来将页面上的多项做不定项的选择,多谢
此中name是char类型,name是int型。报错为:
';' expected
{ }else{sql+= " objectname = '"name"'";}
^
1 error
下是部分代码:
String name =request.getParameter("objectN");
String name1 =request.getParameter("arcmin");
String sql="select * from compcacu where";
if(name.equals(" "))
{ }else{sql+= " objectname = '"name"'";}
if(name1.equals("")){ }
else{
int nn = Integer.parseInt(name1);
sql+="and arcmin = nn";}
ResultSet rs=stmt.executeQuery(sql);
另:nn能传出值么?
解决方案 »
- 初学者新手小菜求大神帮忙啊。。。。。。
- Java 开发一套OA 系统使用什么框架好?
- windows 2003无法访问windows xp
- java+jsp。注册时填写邮箱的验证码
- struts 的validate问题,在线等。问题解决马上揭贴。
- struts跳转 :<a href="/searchNewBook.do"> 找书</a>
- jsp能够包含一个不在web站点内,但在本台服务器上的另外一个jsp文件?php是可以的。
- struts1.2与1.1
- 谁有hibernate数据库删除的简单代码,添加我会了,删除怎么做呢?
- <input type="file" >框中如何放入一个缺省值???
- struts web.xml index.jsp显示不出来?
- 关于birt生成的pdf编码的问题。
variable name location: class _jsp._mycode._ch1._snnshow__jsp
if(name.equals(" "))
^
/mycode/ch1/SNNshow.jsp:26: cannot resolve symbol
symbol : variable name
location: class _jsp._mycode._ch1._snnshow__jsp
{ }else{sql+= " objectname = '"+name+"'";}
^
/mycode/ch1/SNNshow.jsp:34: rs is already defined in _jspService(javax.servlet.http.HttpServletRequest,javax.servlet.http.HttpServletResponse)
ResultSet rs=stmt.executeQuery(sql);
int nn = Integer.parseInt(name1);
sql+="and arcmin = nn";} ---> sql+=" and arcmin = " + nn;
建议倒过来写:"".equals(name)
String name =request.getParameter("objectN");
String name1 =request.getParameter("arcmin");
String sql="select * from compcacu where";
if(!name.equals(""))
{sql+= " objectname = '"+name+"'";}
if(!name1.equals(""))
{
int nn = Integer.parseInt(name1);
sql+="and arcmin =
"+nn;}
ResultSet rs=stmt.executeQuery(sql);
我一般不会把int 直接加到String后边
String name1 =request.getParameter("arcmin");
String sql="select * from compcacu where";
if(name0!=null&&name0.equals(""))
{sql+= " objectname = '"+name0+"'";}
int arcmin0 = Integer.parseInt(name1);
if(arcmin0>0)
{
sql+=" and arcmin = "+arcmin0;
}
ResultSet rs=stmt.executeQuery(sql);