Tag:Commodity information

  • Mybatis knowledge points sorting


    Basics: 1. Concept: a persistence layer framework in Java.2. Features and advantages:(1) Java code and SQL code are completely separated.(2) Good support for complex object mapping (input mapping, output mapping)(3) Using dynamic SQL, you can prevent SQL injection.3. Principle:(1) Create the mybatis-config.xml configuration file(2) Create sqlsessionfactory(3) Write the entity class corresponding to the database table(4) […]

  • Auction system design (second kill system knowledge transfer)


    Since the last time I sorted out the articles on seckill system (PHP + golang commodity seckill), a new project of knowledge migration, commodity auction. Technology: PHP, mysql, redis, laravel Business object: commodity, session, order Bidding process: 1、 Crud of commodities, auction sessions and orders;2、 Regularly write the second kill times, commodities, inventory and other […]

  • Spring, mybatis, springboot, and crud operation are integrated with spring MVC design idea


    Business description Based on spring, mybatis, springboot and thymeleaf technologies, the addition, deletion, modification and query of commodity modules are realized. Project environment initialization preparation 1. MySQL(5.7) 2. JDK (1.8) 3. Maven (3.6.3) 4. STS(4.7.1) database initialized Open the MySQL console, and then execute the goods.sql file as follows.Step 1: log in to MySQL. mysql –uroot […]

  • Analysis and implementation of commodity subsystem under springboot project


    1. Business description:Query the commodity information in the database from the database, and then delete, modify, add and other operations. 2. Technical architecture design: the whole is still based on the design idea of “divide and rule”, and MVC is used to realize the business technology in layers. 3. Technology selection based on specific architecture:1) […]

  • Curd summary of node and MySQL


    Introduction: I’ve done a small project before, in which node and MySQL are used. Now I’ll make a summary of the operation combined with the two. Curd is an abbreviation in database technology, representing create, update, retrieve and delete operations, which are used to process data and other operations. catalogue preparation in advance Actual combat […]

  • High concurrency database sub database and sub table


    What are sub databases and sub tables The following is an example of the e-commerce system. The following figure shows the table structure of the seller module of the e-commerce system:Store information and geographic area information related to goods can be obtained through the following SQL: `Select P. *, R. [geographical area name], S. [store […]

  • Using spring boot, we can add, delete, modify and check the commodity information


    1、 Query product information 1) Query sequence diagram! [image] (/ img / bvbmgg6) 2、 Delete commodity information based on commodity ID 1) Delete sequence diagram @RequestMapping(“doDeleteById/{id}”)

  • 07 springboot + mybatis + spring technology integration to realize crud operation of commodity module


    Business description Based on the technology of spring, mybatis, springboot and thymeleaf, the operation of adding, deleting, modifying and checking commodity modules is realized. database initialized Open the MySQL console and follow the steps below goods.sql Documents.Step 1: log in to MySQL. mysql –uroot –proot Step 2: set the console encoding mode. set names utf8; Step 3: Execution […]

  • Ultra simple integration of HMS scan kit code scanning SDK, easy to realize scanning code purchase


    preface In the previous article, we introduced the rapid integration method of HMS scan kit and the comparative analysis of competitiveness between HMS scan kit and other open source code scanning tools. If you don’t see it, it doesn’t matter. There is an entry to the article in the previous links at the bottom of […]

  • MySQL – optimistic lock and pessimistic lock


    Introduction to pessimistic lock (Encyclopedia) Pessimistic lock, as its name implies, is a conservative attitude towards the modification of data by the outside world (including other current transactions of the system, as well as transactions from external systems). Therefore, during the whole data processing process, the data is locked. The implementation of pessimistic lock often […]

  • Simple addition, deletion, modification and query of spring boot


    stay pom.xml Add the corresponding dependency <dependencies> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter</artifactId> </dependency> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-jdbc</artifactId> </dependency> <dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> <scope>runtime</scope> </dependency> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-test</artifactId> <scope>test</scope> <exclusions> <exclusion> <groupId>org.junit.vintage</groupId> <artifactId>junit-vintage-engine</artifactId> </exclusion> </exclusions> </dependency> <dependency> <groupId>org.mybatis.spring.boot</groupId> <artifactId>mybatis-spring-boot-starter</artifactId> <version>2.1.3</version> </dependency> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-web</artifactId> </dependency> <! — the front end uses thymeleaf instead of JSP — > <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-thymeleaf</artifactId> […]

  • Tp5.1 batch deletion of goods


    Select the goods to be deleted and click batch delete     First, use SQL statement in the controller to find out the goods information Then use the good variable in the HTML source code.   {foreach $goods as $item} 123 2324 {/foreach}     Button source code Datadel() “class = BTN BTN danger radius” […]