老师这是怎末回事呀,一脸懵,请指点一下

来源:4-13 前后端联调验证整体模块功能

慕仔1187219

2020-04-07

图片描述
图片描述
图片描述
老师后端显示如下:

信息: Initializing c3p0 pool... com.mchange.v2.c3p0.ComboPooledDataSource [ acquireIncrement -> 3, acquireRetryAttempts -> 2, acquireRetryDelay -> 1000, autoCommitOnClose -> false, automaticTestTable -> null, breakAfterAcquireFailure -> false, checkoutTimeout -> 10000, connectionCustomizerClassName -> null, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, dataSourceName -> 1hge5tta9mvb9071hemm8k|6bcecd8c, debugUnreturnedConnectionStackTraces -> false, description -> null, driverClass -> com.mysql.jdbc.Driver, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, identityToken -> 1hge5tta9mvb9071hemm8k|6bcecd8c, idleConnectionTestPeriod -> 0, initialPoolSize -> 3, jdbcUrl -> jdbc:mysql://localhost:3306/o2o?useUnicode=true&characterEncoding=utf8, maxAdministrativeTaskTime -> 0, maxConnectionAge -> 0, maxIdleTime -> 0, maxIdleTimeExcessConnections -> 0, maxPoolSize -> 30, maxStatements -> 0, maxStatementsPerConnection -> 0, minPoolSize -> 10, numHelperThreads -> 3, numThreadsAwaitingCheckoutDefaultUser -> 0, preferredTestQuery -> null, properties -> {user=******, password=******}, propertyCycle -> 0, testConnectionOnCheckin -> false, testConnectionOnCheckout -> false, unreturnedConnectionTimeout -> 0, usesTraditionalReflectiveProxies -> false ]
2020-04-07 10:16:25.048 [http-nio-8080-exec-5] 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-04-07 10:16:25.109 [http-nio-8080-exec-5] DEBUG com.chj.o2o.dao.ShopDao.queryShopList - ==> Parameters: 0(Integer), 100(Integer)
2020-04-07 10:16:25.258 [http-nio-8080-exec-5] DEBUG com.chj.o2o.dao.ShopDao.queryShopList - <==      Total: 18
2020-04-07 10:16:25.272 [http-nio-8080-exec-5] 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-04-07 10:16:25.273 [http-nio-8080-exec-5] DEBUG com.chj.o2o.dao.ShopDao.queryShopCount - ==> Parameters: 
2020-04-07 10:16:25.275 [http-nio-8080-exec-5] DEBUG com.chj.o2o.dao.ShopDao.queryShopCount - <==      Total: 1
2020-04-07 10:16:27.305 [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 ORDER BY priority DESC 
2020-04-07 10:16:27.306 [http-nio-8080-exec-10] DEBUG com.chj.o2o.dao.ShopCategoryDao.queryShopCategory - ==> Parameters: 
2020-04-07 10:16:27.315 [http-nio-8080-exec-10] DEBUG com.chj.o2o.dao.ShopCategoryDao.queryShopCategory - <==      Total: 10
2020-04-07 10:16:27.324 [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-04-07 10:16:27.326 [http-nio-8080-exec-10] DEBUG com.chj.o2o.dao.AreaDao.queryArea - ==> Parameters: 
2020-04-07 10:16:27.328 [http-nio-8080-exec-10] DEBUG com.chj.o2o.dao.AreaDao.queryArea - <==      Total: 3
2020-04-07 10:17:09.677 [http-nio-8080-exec-5] DEBUG com.chj.o2o.dao.ShopDao.insertShop - ==>  Preparing: INSERT INTO tb_shop(owner_id,area_id,shop_category_id,shop_name,shop_desc,shop_addr, phone,shop_img,priority,create_time,last_edit_time,enable_status,advice) VALUES (?,?,?,?, ?,?,?,?,?,?, ?,?,?) 
2020-04-07 10:17:09.682 [http-nio-8080-exec-5] DEBUG com.chj.o2o.dao.ShopDao.insertShop - ==> Parameters: null, 3(Integer), 17(Long), 程式烧烤(String), hello(String), 西苑134号(String), 456789(String), null, null, 2020-04-07 10:17:09.674(Timestamp), 2020-04-07 10:17:09.674(Timestamp), 0(Integer), null
四月 07, 2020 10:17:09 上午 org.springframework.beans.factory.xml.XmlBeanDefinitionReader loadBeanDefinitions
信息: Loading XML bean definitions from class path resource [org/springframework/jdbc/support/sql-error-codes.xml]
四月 07, 2020 10:17:09 上午 org.springframework.jdbc.support.SQLErrorCodesFactory <init>
信息: SQLErrorCodes loaded: [DB2, Derby, H2, HSQL, Informix, MS-SQL, MySQL, Oracle, PostgreSQL, Sybase, Hana]
2020-04-07 10:17:31.181 [http-nio-8080-exec-1] DEBUG com.chj.o2o.dao.ShopDao.insertShop - ==>  Preparing: INSERT INTO tb_shop(owner_id,area_id,shop_category_id,shop_name,shop_desc,shop_addr, phone,shop_img,priority,create_time,last_edit_time,enable_status,advice) VALUES (?,?,?,?, ?,?,?,?,?,?, ?,?,?) 
2020-04-07 10:17:31.182 [http-nio-8080-exec-1] DEBUG com.chj.o2o.dao.ShopDao.insertShop - ==> Parameters: null, 3(Integer), 17(Long), 程式烧烤(String), hello(String), 西苑134号(String), 456789(String), null, null, 2020-04-07 10:17:31.18(Timestamp), 2020-04-07 10:17:31.18(Timestamp), 0(Integer), null
2020-04-07 10:18:11.120 [http-nio-8080-exec-5] DEBUG com.chj.o2o.dao.ShopDao.insertShop - ==>  Preparing: INSERT INTO tb_shop(owner_id,area_id,shop_category_id,shop_name,shop_desc,shop_addr, phone,shop_img,priority,create_time,last_edit_time,enable_status,advice) VALUES (?,?,?,?, ?,?,?,?,?,?, ?,?,?) 
2020-04-07 10:18:11.121 [http-nio-8080-exec-5] DEBUG com.chj.o2o.dao.ShopDao.insertShop - ==> Parameters: null, 3(Integer), 17(Long), 程式烧烤(String), hello(String), 西苑134号(String), 456789(String), null, null, 2020-04-07 10:18:11.12(Timestamp), 2020-04-07 10:18:11.12(Timestamp), 0(Integer), null

写回答

1回答

翔仔

2020-04-08

同学好,得确保你添加的owner_id和tb_person_info表里的某个user_id相等,并且不能为空,因为要表明这是属于哪个店家的店铺。。。在没实现微信登录之前,咱们这里的owner_id是写死tb_person_info表里的一个userid值的

0
4
翔仔
回复
慕工程7333153
同学好,在没有实现微信登录之前,直接给Shop的owner属性设置写死一个user_id即可,前提是这个user_id在tb_person_info里存在
2020-04-17
共4条回复

Java双版本(SSM到SpringBoot)校园商铺全栈开发

SSM商铺V1.0,解决毕设痛点;SpringBoot商铺V2.0,满足工作刚需

5113 学习 · 8144 问题

查看课程