JSP自定义标签查询数据

1.写一个Dao层方法 查询数据

方法要写成静态 以便直接调用

public class CategoryDao {
    public  static List<Category> findAllCategory() throws SQLException{
        String sql="select * from Category";
        QueryRunner qr=new QueryRunner(DataSourceUtils.getDataSource());
        return qr.query(sql,new BeanListHandler<Category>(Category.class));
    }
}

2.创建一个.tld文件

<?xml version="1.0" encoding="UTF-8" ?>

<taglib xmlns="http://java.sun.com/xml/ns/j2ee" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee http://java.sun.com/xml/ns/j2ee/web-jsptaglibrary_2_0.xsd"
    version="2.0">

    <description>JSTL 1.1 functions library</description>
    <display-name>JSTL functions</display-name>
    <tlib-version>1.1</tlib-version>
    <short-name>myfn</short-name>
    <uri>http://www.yinheedu.com</uri><!-- 找不到文件时所访问的路径 -->

    <function>
        <description>
            select all categories
        </description>
        <name>findAllCategory</name>
        <function-class>com.dao.CategoryDao</function-class> <!-- 方法所在的类 -->
        <function-signature>java.util.List findAllCategory()</function-signature> <!-- 返回值类型与方法名 -->
    </function>

</taglib>

3.在前台用c标签 循环出来所有数据

<select name="categorySecond.csid">
                            <c:forEach items="${myfn:findAllCategory() }" var="c">
                            <option value="${c.cid }">${c.cname }</option>
                            </c:forEach>
                        </select>