您的位置:程序门 -> java -> j2ee / ejb / jms



关于jstl使用的疑问请各位指教


[收藏此页] [打印本页]选择字色:背景色:字体:[][][]


关于jstl使用的疑问请各位指教
发表于:2007-09-10 11:35:20 楼主
小第初学jstl语法在做一个小东西,这是一个根据编号查询一条数据的详细信息的也面.我把   支持jstl的两个jar包放在了web-inf/lib下面也没有在web.xml里配置什么,但是服务器报以下错误:
请各位指教!
    谢谢!
在线qq:   6425   0971   5
-------------------------------------------------------
2007-9-10   11:32:09   org.apache.catalina.core.standardwrappervalve   invoke
严重:   servlet.service()   for   servlet   jsp   threw   exception
org.apache.jasper.jasperexception:   /show/showone.jsp(15,5)   according   to   tld   or   attribute   directive   in   tag   file,   attribute   sql   does   not   accept   any   expressions
//------------------------------------------------------
<%@   page   contenttype= "text/html;   charset=gb2312 "   language= "java "   errorpage= " "   %>
<%@   taglib   prefix= "sql "   uri= "http://java.sun.com/jstl/sql "%>
<%@   taglib   prefix= "c "       uri= "http://java.sun.com/jstl/core_rt "   %>  

<html>
    <head>
        <title> 人员详情信息 </title>
    </head>
       
      <body>
        <sql:setdatasource
        driver= "com.microsoft.jdbc.sqlserver.sqlserverdriver "
        url= "jdbc:microsoft:sqlserver://127.0.0.1:1433;databasename=test "   user= "sa "     password= " "/>
 
          <sql:query   sql= "select   *   from   users   where   id=${param.id} "   var= "list "/>
         
          <c:foreach   var= "b "   items= "${list.rows} ">
   

        <table   width= "565 "   border= "1 "   align= "center ">
    <tr>
        <td   height= "24 "   colspan= "3 "   align= "center "> <strong> 详细信息 </strong> </td>
    </tr>
    <tr>
        <td   width= "267 "   align= "center "> 编号 </td>
        <td   colspan= "2 "   align= "center "> <input   name= "id "   type= "text "     height= "20 "/>
      ${b.id}
        </td>
    </tr>
    <tr>
        <td   align= "center "> 姓名 </td>
        <td   colspan= "2 "   align= "center "> <input   name= "username "   type= "text "     height= "20 "/>
  ${b.username}
        </td>
    </tr>
    <tr>
        <td   height= "36 "   align= "center "> 密码 </td>
        <td   colspan= "2 "   align= "center "> <input   name= "password "   type= "text "       height= "20 "/>
        ${b.password}
        </td>
    </tr>
    <tr>
        <td   align= "center "> 年龄 </td>
        <td   colspan= "2 "   align= "center "> <input   name= "age "   type= "text "       height= "20 "/>
        ${b.age}
        </td>
    </tr>
    <tr>
        <td   height= "21 "   align= "center "> <input   type= "button "   name= "submit3 "   value= "返回 "   /> </td>
        <td   width= "140 "   align= "center "> <input   type= "reset "   name= "submit2 "   value= "重置 "   /> </td>
        <td   width= "136 "   align= "center "> <input   type= "submit "   name= "submit "   value= "我要修改信息 "   /> </td>
    </tr>
</table>
       
        </c:foreach>

</body>

</html>
发表于:2007-09-10 12:33:441楼 得分:0
attribute   sql   does   not   accept   any   expressions

属性不接受表达式


换成下边的试试

<sql:query   sql= "select   *   from   users   where   id= <%=request.getpararmeter( "id ")%> "   var= "list "/>
发表于:2007-09-10 12:52:472楼 得分:0
<sql:setdatasource   var= "datasource "   driver= "com.microsoft.jdbc.sqlserver.sqlserverdriver "       url= "jdbc:microsoft:sqlserver://127.0.0.1:1433;databasename=test "   user= "sa "     password= " "/>


<sql:query   var   =   "users "   datasource= "${datasource} ">
select   *   from   users   where   id=${param.id}
</sql:query>


这样不知道可不可以
发表于:2007-09-10 14:12:393楼 得分:0
哈哈哈解决了高手谢谢


快速检索

最新资讯
热门点击