老师我又试了一下还是不行，显示用户名和密码为空，指点一下

Question

2020-03-31 21:41:34.950 [http-nio-8080-exec-5] DEBUG com.chj.o2o.dao.ShopCategoryDao.queryShopCategory - ==>  Preparing: SELECT shop_category_id, shop_category_name, shop_category_desc, shop_category_img, priority, create_time, last_edit_time, parent_id FROM tb_shop_category WHERE parent_id is null ORDER BY priority DESC 
2020-03-31 21:41:35.003 [http-nio-8080-exec-5] DEBUG com.chj.o2o.dao.ShopCategoryDao.queryShopCategory - ==> Parameters: 
2020-03-31 21:41:35.043 [http-nio-8080-exec-5] DEBUG com.chj.o2o.dao.ShopCategoryDao.queryShopCategory - <==      Total: 6
2020-03-31 21:41:35.074 [http-nio-8080-exec-5] DEBUG com.chj.o2o.dao.HeadLineDao.queryHeadLine - ==>  Preparing: SELECT line_id, line_name, line_link, line_img, priority, enable_status, create_time, last_edit_time FROM tb_head_line WHERE enable_status = ? ORDER BY priority DESC 
2020-03-31 21:41:35.075 [http-nio-8080-exec-5] DEBUG com.chj.o2o.dao.HeadLineDao.queryHeadLine - ==> Parameters: 1(Integer)
2020-03-31 21:41:35.080 [http-nio-8080-exec-5] DEBUG com.chj.o2o.dao.HeadLineDao.queryHeadLine - <==      Total: 4
2020-03-31 21:41:39.807 [http-nio-8080-exec-10] DEBUG com.chj.o2o.dao.ShopCategoryDao.queryShopCategory - ==>  Preparing: SELECT shop_category_id, shop_category_name, shop_category_desc, shop_category_img, priority, create_time, last_edit_time, parent_id FROM tb_shop_category WHERE parent_id is not null and parent_id = ? ORDER BY priority DESC 
2020-03-31 21:41:39.807 [http-nio-8080-exec-10] DEBUG com.chj.o2o.dao.ShopCategoryDao.queryShopCategory - ==> Parameters: 14(Long)
2020-03-31 21:41:39.814 [http-nio-8080-exec-10] DEBUG com.chj.o2o.dao.ShopCategoryDao.queryShopCategory - <==      Total: 3
2020-03-31 21:41:39.815 [http-nio-8080-exec-10] DEBUG com.chj.o2o.dao.AreaDao.queryArea - ==>  Preparing: SELECT area_id,area_name,priority,create_time,last_edit_time FROM tb_area ORDER BY priority DESC 
2020-03-31 21:41:39.816 [http-nio-8080-exec-10] DEBUG com.chj.o2o.dao.AreaDao.queryArea - ==> Parameters: 
2020-03-31 21:41:39.818 [http-nio-8080-exec-10] DEBUG com.chj.o2o.dao.AreaDao.queryArea - <==      Total: 2
2020-03-31 21:41:39.837 [http-nio-8080-exec-9] DEBUG com.chj.o2o.dao.ShopDao.queryShopList - ==>  Preparing: SELECT s.shop_id, s.shop_name, s.shop_desc, s.shop_addr, s.phone, s.shop_img, s.priority, s.create_time, s.last_edit_time, s.enable_status, s.advice, a.area_id, a.area_name, sc.shop_category_id, sc.shop_category_name FROM tb_shop s, tb_area a, tb_shop_category sc WHERE s.shop_category_id in (select shop_category_id from tb_shop_category WHERE parent_id = ?) and s.enable_status = ? AND s.area_id=a.area_id AND s.shop_category_id = sc.shop_category_id ORDER BY s.priority DESC LIMIT ?,?; 
2020-03-31 21:41:39.838 [http-nio-8080-exec-9] DEBUG com.chj.o2o.dao.ShopDao.queryShopList - ==> Parameters: 14(Long), 1(Integer), 0(Integer), 3(Integer)
2020-03-31 21:41:39.850 [http-nio-8080-exec-9] DEBUG com.chj.o2o.dao.ShopDao.queryShopList - <==      Total: 3
2020-03-31 21:41:39.852 [http-nio-8080-exec-9] DEBUG com.chj.o2o.dao.ShopDao.queryShopCount - ==>  Preparing: SELECT count(1) FROM tb_shop s, tb_area a, tb_shop_category sc WHERE s.shop_category_id in (select shop_category_id from tb_shop_category WHERE parent_id = ?) and s.enable_status = ? AND s.area_id=a.area_id AND s.shop_category_id = sc.shop_category_id 
2020-03-31 21:41:39.853 [http-nio-8080-exec-9] DEBUG com.chj.o2o.dao.ShopDao.queryShopCount - ==> Parameters: 14(Long), 1(Integer)
2020-03-31 21:41:39.858 [http-nio-8080-exec-9] DEBUG com.chj.o2o.dao.ShopDao.queryShopCount - <==      Total: 1
2020-03-31 21:41:47.340 [http-nio-8080-exec-8] DEBUG com.chj.o2o.dao.ShopDao.queryShopList - ==>  Preparing: SELECT s.shop_id, s.shop_name, s.shop_desc, s.shop_addr, s.phone, s.shop_img, s.priority, s.create_time, s.last_edit_time, s.enable_status, s.advice, a.area_id, a.area_name, sc.shop_category_id, sc.shop_category_name FROM tb_shop s, tb_area a, tb_shop_category sc WHERE s.area_id=a.area_id AND s.shop_category_id = sc.shop_category_id ORDER BY s.priority DESC LIMIT ?,?; 
2020-03-31 21:41:47.341 [http-nio-8080-exec-8] DEBUG com.chj.o2o.dao.ShopDao.queryShopList - ==> Parameters: 0(Integer), 100(Integer)
2020-03-31 21:41:47.378 [http-nio-8080-exec-8] DEBUG com.chj.o2o.dao.ShopDao.queryShopList - <==      Total: 17
2020-03-31 21:41:47.379 [http-nio-8080-exec-8] DEBUG com.chj.o2o.dao.ShopDao.queryShopCount - ==>  Preparing: SELECT count(1) FROM tb_shop s, tb_area a, tb_shop_category sc WHERE s.area_id=a.area_id AND s.shop_category_id = sc.shop_category_id 
2020-03-31 21:41:47.379 [http-nio-8080-exec-8] DEBUG com.chj.o2o.dao.ShopDao.queryShopCount - ==> Parameters: 
2020-03-31 21:41:47.380 [http-nio-8080-exec-8] DEBUG com.chj.o2o.dao.ShopDao.queryShopCount - <==      Total: 1

显示图

数据库图片



纠结好久了

Answer 1

慕慕65597133 2020-03-31 21:50:12

我觉得是你代码的问题，把你微信登录的你个代码贴出来看一看，或者从老师的git上面把代码拉下来对比，既然没有报异常，那应该是你的代码逻辑问题

• 提问者 慕仔1187219 #1

  同学，我代码应该没问题呀，我用的老师的代码还是不行，还是一样的错误，数据库调试显示无法获得用户名和密码，感觉时数据库不正确，大佬能帮忙看一下是我数据库信息弄错了吗？

• 慕慕65597133 回复 提问者 慕仔1187219 #2

  把代码贴出来看一下，光是看数据库截图我也不知道怎么回事

• 翔仔 回复 提问者 慕仔1187219 #3

  同学好，还是微信的问题？微信需要部署，有公网ip，配置好了之后才能登录呀。。