没有接收到数据


我打印出获取到的root为空
这个是CatalogServlet的list方法
/**
* 查询所有分类
* url="/admin/Catalog/list.do"
*
* @param request
* @param response
* @throws ServletException
* @throws IOException
*/
public void list(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
//调用业务
Catalog root = catalogService.getRoot();
Integer id = root.getId();
Integer pid = root.getPid();
String info = root.getInfo();
root.getChildren();
System.out.println(id + "----" + pid + "---" + info);
//页面跳转
request.setAttribute("root", root);
request.getRequestDispatcher("/WEB-INF/pages/admin/catalog_list.jsp").forward(request, response);
}CatalogService
//获取分类 Catalog getRoot();
CatalogServiceImpl
public Catalog getRoot() {
return catalogDao.select(10000);
}CatalogDao
/**
* 插入数据和批量插入数据
* 直接嵌入脚本
* @param list
*/
@Insert("<script>" +
"insert into catalog (title,pid,info) vales" +
"<foreach collection='list' item='catalog' separator=',' >" +
"(#{catalog.title},#{catalog.pid},#{catalog.info})" +
"</foreach>" +
"</script>")
@Options(useGeneratedKeys = true, keyProperty = "id")
void beachInsert(List<Catalog> list);mybatis-config.xml
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configuration
PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
<properties resource="db.properties"></properties>
<environments default="development">
<environment id="development">
<transactionManager type="JDBC"/>
<dataSource type="POOLED">
<property name="driver" value="${driver}"/>
<property name="url" value="${url}"/>
<property name="username" value="${username}"/>
<property name="password" value="${password}"/>
</dataSource>
</environment>
</environments>
<mappers>
<package name="com.coke.cake.dao"/>
</mappers>
</configuration>5
收起
正在回答
4回答
同学你好,问一下同学数据库中有数据吗?另外在同学的截图中看到有报错,报错是什么呢。建议同学检查一下数据库中的数据,并解决一下报错,或者将报错贴上来,方便我们查看具体报错。
祝:学习愉快~
Wchisper
2019-07-26 13:33:51
/**
* 跟据id查询最高级分类
*
* @param id
* @return
*/
@Select("select * from catalog where id=#{id}")
@Results(id = "all", value = { //all是别名,当多个方法同时用相同的注解时,相当于resultMap
@Result(column = "id", property = "id", id = true), //相当于<resultMap>下面的<result>
@Result(column = "title", property = "title"), //相当于<resultMap>下面的<result>
@Result(column = "pid", property = "pid"),
@Result(column = "info", property = "info"),
@Result(column = "id", property = "children", many = @Many(select = "selectByPid"))
})
Catalog select(int id);相似问题
登录后可查看更多问答,登录/注册
3. Java 数据库开发与实战应用
- 参与学习 人
- 提交作业 357 份
- 解答问题 8016 个
本阶段将带你学习MySQL数据库,JDBC接口,MyBatis框架等,带你掌握的数据的存放和管理。
了解课程
恭喜解决一个难题,获得1积分~
来为老师/同学的回答评分吧
0 星