SpringBoot构建电商基础秒杀项目

2025-07-29 10:12:57

SpringBoot构建电商基础秒杀项目什么是 spring bootmysql 依赖数据库 ‘连接池’代码语言：javascript代码运行次数：0运行复制 <dependency> <groupId>mysql</groupId> <artifactId>mysql-connecto

SpringBoot构建电商基础秒杀项目

什么是 spring boot

mysql 依赖

数据库 ‘连接池’

代码语言：javascript代码运行次数：0运行复制

        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <scope>runtime</scope>
            <version>8.0.11</version>
        </dependency>
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>druid</artifactId>
            <version>1.1.</version>
        </dependency>

        <dependency>
            <groupId>spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>1..1</version>
        </dependency>

代码语言：javascript代码运行次数：0运行复制

  <plugin>
                <groupId>generator</groupId>
                <artifactId>mybatis-generator-maven-plugin</artifactId>
                <version>1..5</version>
                <dependencies>
                    <dependency>
                        <groupId>generator</groupId>
                        <artifactId>mybatis-generator-core</artifactId>
                        <scope>runtime</scope>
                        <version>1..5</version>
                    </dependency>
                    <dependency>
                        <groupId>mysql</groupId>
                        <artifactId>mysql-connector-java</artifactId>
                        <scope>runtime</scope>
                        <version>8.0.11</version>
                    </dependency>
                </dependencies>

                <executi>
                    <execution>
                        <id>mybatis generator</id>
                        <phase> package</phase>
                        <goals>
                            <goal>generate</goal>
                        </goals>
                    </execution>
                </executi>
            </plugin>

代码语言：javascript代码运行次数：0运行复制

<configuration>
    <verbose>true</verbose>
    <overwrite>true</overwrite>
</configuration>

代码语言：javascript代码运行次数：0运行复制

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE generatorConfiguration
        PUBLIC "-//mybatis//DTD MyBatis Generator Configuration 1.0//E"
        ".dtd">

<generatorConfiguration>
    <!--    <classPathEntry location="/Program Files/IBM/SQLLIB/java/db2java.zip" />-->


    <context id="DB2Tables" targetRuntime="MyBatis">
        <!-- 数据库链接地址账号密码 -->
        <jdbcConnection driverClass="jdbc.Driver"
                        connectionURL="jdbc:mysql://127.0.0.1:06
                        /miaosha"
                        userId="root"
                        password="root">
        </jdbcConnection>


        <!--        <javaTypeResolver >-->
        <!--            <property name="forceBigDecimals" value="false" />-->
        <!--        </javaTypeResolver>-->
        <!-- 生成 DataObject 类存放位置 -->
        <javaModelGenerator targetPackage="demo.dataObject" targetProject="src/main/java">
            <property name="enableSubPackages" value="true" />
            <property name="trimStrings" value="true" />
        </javaModelGenerator>

        <!-- 生成映射文件存放位置 -->
        <sqlMapGenerator targetPackage="mapping"  targetProject="src/main/res
        ources">
            <property name="enableSubPackages" value="true" />
        </sqlMapGenerator>

        <!-- 生成Dao类存放位置 -->
        <javaClientGenerator type="XMLMAPPER" targetPackage="demo.dao"  targetProject="src/main/java">
            <property name="enableSubPackages" value="true" />
        </javaClientGenerator>

        <!-- 生成对应表及其类名 -->
        <table tableame="user_info" domainObjectame="userDo" enableCountByExample="false"
               enableUpdateByExample="false" enableDeleteByExample="false" enableSelectByExample="false"
               selectByExampleQueryId="false">
            <!--            去除复杂操作语句-->
            <!--            enableCountByExample="false"-->
            <!--            enableUpdateByExample="false" -->
            <!--            enableDeleteByExample="false" -->
            <!--            enableSelectByExample="false"-->
            <!--            selectByExampleQueryId="false"-->
        </table>
        <table tableame="user_password" domainObjectame="userPasswordDO" enableCountByExample="false"
               enableUpdateByExample="false" enableDeleteByExample="false" enableSelectByExample="false"
               selectByExampleQueryId="false"></table>

    </context>
</generatorConfiguration>

新建maven 执行mubatis generate 生成文件

Failed to execute goal generator:mybatis-generator-maven-plugin:1..5:generate (default-cli) on project demo: Access denied for user 'root'@'localhost' (using password: YES)

接入mabatis 对应mysql 数据源

什么是 MyBatis？

MyBatis 是一款优秀的持久层框架，它支持自定义 SQL、存储过程以及高级映射。MyBatis 免除了几乎所有的 JDBC 代码以及设置参数和获取结果集的工作。MyBatis 可以通过简单的 XML 或注解来配置和映射原始类型、接口和 Java POJO（Plain Old Java Objects，普通老式 Java 对象）为数据库中的记录。

mybatis-generator.xml代码语言：javascript代码运行次数：0运行复制

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE generatorConfiguration
        PUBLIC "-//mybatis//DTD MyBatis Generator Configuration 1.0//E">

<generatorConfiguration>
    <!--    <classPathEntry location="/Program Files/IBM/SQLLIB/java/db2java.zip" />-->


    <context id="DB2Tables" targetRuntime="MyBatis">
        <!-- 数据库链接地址账号密码 -->
        <jdbcConnection driverClass="jdbc.Driver"
                        connectionURL="jdbc:mysql://127.0.0.1:06/miaosha?serverTimezone=Asia/Shanghai"

                        userId="root"
                        password="12456">
        </jdbcConnection>


        <!--        <javaTypeResolver >-->
        <!--            <property name="forceBigDecimals" value="false" />-->
        <!--        </javaTypeResolver>-->
        <!-- 生成 DataObject 类存放位置 -->
        <javaModelGenerator targetPackage="demo.dataObject" targetProject="src/main/java">
            <property name="enableSubPackages" value="true" />
            <property name="trimStrings" value="true" />
        </javaModelGenerator>

        <!-- 生成映射文件存放位置 -->
        <sqlMapGenerator targetPackage="mapping"  targetProject="src/main/resources">
            <property name="enableSubPackages" value="true" />
        </sqlMapGenerator>

        <!-- 生成Dao类存放位置 -->
        <javaClientGenerator type="XMLMAPPER" targetPackage="demo.dao"  targetProject="src/main/java">
            <property name="enableSubPackages" value="true" />
        </javaClientGenerator>

        <!-- 生成对应表及其类名 -->
        <table tableame="user_info" domainObjectame="userDo" enableCountByExample="false"
               enableUpdateByExample="false" enableDeleteByExample="false" enableSelectByExample="false"
               selectByExampleQueryId="false">
            <!--            去除复杂操作语句-->
            <!--            enableCountByExample="false"-->
            <!--            enableUpdateByExample="false" -->
            <!--            enableDeleteByExample="false" -->
            <!--            enableSelectByExample="false"-->
            <!--            selectByExampleQueryId="false"-->
        </table>
        <table tableame="user_password" domainObjectame="userPasswordDO" enableCountByExample="false"
               enableUpdateByExample="false" enableDeleteByExample="false" enableSelectByExample="false"
               selectByExampleQueryId="false"></table>

    </context>
</generatorConfiguration>

pom.xml代码语言：javascript代码运行次数：0运行复制

<?xml version="1.0" encoding="UTF-8"?>
<project xmlns=".0.0" xmlns:xsi=";
         xsi:schemaLocation=".0.0 .0.0.xsd">
    <modelVersion>4.0.0</modelVersion>
    <parent>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-parent</artifactId>
        <version>2.5.1</version>
        <relativePath/> <!-- lookup parent from repository -->
    </parent>
    <groupId></groupId>
    <artifactId>demo</artifactId>
    <version>0.0.1-SAPSHOT</version>
    <name>demo</name>
    <description>Demo project for Spring Boot</description>
    <properties>
        <java.version>11</java.version>
        <spring-cloud.version>2020.0.</spring-cloud.version>
    </properties>
    <dependencies>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>


        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <scope>runtime</scope>
            <version>8.0.25</version>
        </dependency>
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>druid</artifactId>
            <version>1.1.</version>
        </dependency>

        <dependency>
            <groupId>spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>1..1</version>
        </dependency>

        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-test</artifactId>
            <scope>test</scope>
        </dependency>
    </dependencies>

    <dependencyManagement>
        <dependencies>
            <dependency>
                <groupId>org.</groupId>
                <artifactId>spring-cloud-dependencies</artifactId>
                <version>${spring-cloud.version}</version>
                <type>pom</type>
                <scope>import</scope>
            </dependency>
        </dependencies>
    </dependencyManagement>

    <build>
        <plugins>
            <plugin>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-maven-plugin</artifactId>
            </plugin>

            <plugin>
                <groupId>generator</groupId>
                <artifactId>mybatis-generator-maven-plugin</artifactId>
                <version>1..5</version>
                <dependencies>

                    <dependency>
                        <groupId>generator</groupId>
                        <artifactId>mybatis-generator-core</artifactId>
                        <scope>runtime</scope>
                        <version>1..5</version>
                    </dependency>
                    <dependency>
                        <groupId>mysql</groupId>
                        <artifactId>mysql-connector-java</artifactId>
                        <scope>runtime</scope>
                        <version>8.0.25</version>
                    </dependency>
                </dependencies>

                <executi>
                    <execution>v
                        <id>mybatis generator</id>
                        <phase> package</phase>
                        <goals>
                            <goal>generate</goal>
                        </goals>
                    </execution>

                </executi>
                <configuration>
                    <verbose>true</verbose>
                    <overwrite>true</overwrite>
                    <configurationFile>src/main/resources/mybatis-generator.xml</configurationFile>
                </configuration>
            </plugin>
        </plugins>
    </build>

</project>

application.properties 代码语言：javascript代码运行次数：0运行复制

server.port=8090
=classpath:mapping/*.xml

spring.=miaosha
spring.datasource.url=jdbc:mysql://127.0.0.1:06/miaosha?serverTimezone=Asia/Shanghai
spring.datasource.username=root
spring.datasource.password=12456


spring.=com.alibaba.druid.pool.DruidDataSource
spring.datasource.driverClassame=cj.jdbc.Driver

MyBatis 映射展示

代码语言：javascript代码运行次数：0运行复制

@SpringBootApplication(scanBasePackages = {"demo"})
@RestController
@MapperScan("demo.dao")
public class DemoApplication {
    @Autowired
    private userDoMapper userDoMapper;

    @RequestMapping("/")
    public String home(){

        userDo userDo1=userDoMapper.selectByPrimaryKey(1);
        if (userDo1!=null){
            return userDo1.getame();
        }else {
            return "buxunzai ";
        }
    }

    public static void main(String[] args) {
        println("12");
        SpringApplication.run(, args);
    }

}

Autowired作用

下面图中的userService 我们没有实例化

用户层（显示一般信息（不包括敏感信息（密码）））。后台逻辑层（显示全部信息（敏感信息））。数据库一一对应层

本文参与腾讯云自媒体同步曝光计划，分享自作者个人站点/博客。原始发表：2024-12-16，如有侵权请联系 cloudcommunity@tencent 删除数据库电商mybatisversion基础

#感谢您对电脑配置推荐网 - 最新i3 i5 i7组装电脑配置单推荐报价格的认可，转载请说明来源于"电脑配置推荐网 - 最新i3 i5 i7组装电脑配置单推荐报价格

本文地址：http://www.dnpztj.cn/biancheng/1258522.html

本站网友维拉	21分钟前发表
//127.0.0.1
本站网友上海办理美国签证	0秒前发表
分享自作者个人站点/博客
本站网友邢台技术学院	10分钟前发表
mysql
本站网友徐州租房网	10分钟前发表
接口和 Java POJO（Plain Old Java Objects
本站网友中国商标专利	15分钟前发表
1..5
本站网友爱儿教育网	19分钟前发表
06/miaosha?serverTimezone=Asia/Shanghai spring.datasource.username=root spring.datasource.password=12456 spring.=com.alibaba.druid.pool.DruidDataSource spring.datasource.driverClassame=cj.jdbc.DriverMyBatis 映射展示代码语言：javascript代码运行次数：0运行复制@SpringBootApplication(scanBasePackages = {"demo"}) @RestController @MapperScan("demo.dao") public class DemoApplication { @Autowired private userDoMapper userDoMapper; @RequestMapping("/") public String home(){ userDo userDo1=userDoMapper.selectByPrimaryKey(1); if (userDo1!=null){ return userDo1.getame(); }else { return "buxunzai "; } } public static void main(String[] args) { println("12"); SpringApplication.run(
本站网友徐州男科医院哪家好	12分钟前发表
原始发表：2024-12-16
本站网友中和租房	5分钟前发表
普通老式 Java 对象）为数据库中的记录
本站网友唐长红	9分钟前发表
06/miaosha?serverTimezone=Asia/Shanghai" userId="root" password="12456"> </jdbcConnection> <!-- <javaTypeResolver >--> <!-- <property name="forceBigDecimals" value="false" />--> <!-- </javaTypeResolver>--> <!-- 生成 DataObject 类存放位置 --> <javaModelGenerator targetPackage="demo.dataObject" targetProject="src/main/java"> <property name="enableSubPackages" value="true" /> <property name="trimStrings" value="true" /> </javaModelGenerator> <!-- 生成映射文件存放位置 --> <sqlMapGenerator targetPackage="mapping" targetProject="src/main/resources"> <property name="enableSubPackages" value="true" /> </sqlMapGenerator> <!-- 生成Dao类存放位置 --> <javaClientGenerator type="XMLMAPPER" targetPackage="demo.dao" targetProject="src/main/java"> <property name="enableSubPackages" value="true" /> </javaClientGenerator> <!-- 生成对应表及其类名 --> <table tableame="user_info" domainObjectame="userDo" enableCountByExample="false" enableUpdateByExample="false" enableDeleteByExample="false" enableSelectByExample="false" selectByExampleQueryId="false"> <!-- 去除复杂操作语句--> <!-- enableCountByExample="false"--> <!-- enableUpdateByExample="false" --> <!-- enableDeleteByExample="false" --> <!-- enableSelectByExample="false"--> <!-- selectByExampleQueryId="false"--> </table> <table tableame="user_password" domainObjectame="userPasswordDO" enableCountByExample="false" enableUpdateByExample="false" enableDeleteByExample="false" enableSelectByExample="false" selectByExampleQueryId="false"></table> </context> </generatorConfiguration>pom.xml代码语言：javascript代码运行次数：0运行复制<?xml version="1.0" encoding="UTF-8"?> <project xmlns=".0.0" xmlns
本站网友奥体二手房	3分钟前发表
YES)接入mabatis 对应mysql 数据源什么是 MyBatis？MyBatis 是一款优秀的持久层框架
本站网友 fxcm福汇	6分钟前发表
mybatis-generator-maven-plugin
本站网友 discuz论坛模板	25分钟前发表
mybatis-generator-maven-plugin

SpringBoot构建电商基础秒杀项目