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

Question

老师后端显示如下：

信息: 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

Answer 1

翔仔 2020-04-08 00:32:52

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

• 提问者 慕仔1187219 #1

  非常感谢！

• 慕工程7333153 回复 提问者 慕仔1187219 #2

  同学你之后怎么做的呀

• 慕工程7333153 #3

  翔仔，通过前端添加信息时对应的owner_id从哪里体现呀

点开查看后面1条评论