SpringMVC框架怎么搭建idea操作数据库

这篇文章主要介绍"SpringMVC框架怎么搭建idea操作数据库"，在日常操作中，相信很多人在SpringMVC框架怎么搭建idea操作数据库问题上存在疑惑，小编查阅了各式资料，整理出简单好用的操作方法，希望对大家解答"SpringMVC框架怎么搭建idea操作数据库"的疑惑有所帮助！接下来，请跟着小编一起来学习吧！

1.目录

2.PersonController

package com.sk.controller;import com.sk.entity.Person;import com.sk.service.PersonService;import org.springframework.beans.factory.annotation.Autowired;import org.springframework.stereotype.Controller;import org.springframework.web.bind.annotation.RequestMapping;import org.springframework.web.bind.annotation.ResponseBody;/** * @Author 松柯 * @Date 2022/3/31 17:36 * @Version 1.0 */@Controller@RequestMapping("/com/sk/Person")public class PersonController {    @Autowired   private PersonService personService;    @RequestMapping("/getPersonById")    @ResponseBody    public Object getPersonById(Integer id){        return personService.getById(id);    }    @RequestMapping("/savePerson")    @ResponseBody    public Boolean savePerson(Person person){        return personService.save(person);    }    @RequestMapping("/getPersonList")    @ResponseBody    public Object getPersonList(){        return personService.list();    }}

3.PersonMapper

package com.sk.dao;import com.baomidou.mybatisplus.core.mapper.BaseMapper;import com.sk.entity.Person;/** * @Author 松柯 * @Date 2022/3/31 17:36 * @Version 1.0 */public interface PersonMapper extends BaseMapper {}

4.Person

package com.sk.entity;import com.baomidou.mybatisplus.annotation.IdType;import com.baomidou.mybatisplus.annotation.TableId;import lombok.Data;/** * @Author 松柯 * @Date 2022/3/31 17:30 * @Version 1.0 */@Datapublic class Person {    /**     * personID     */    @TableId(type = IdType.ASSIGN_ID)    private String personId;     * 人名    private String personName;     * 年龄    private Integer personAge;}

5.PersonServiceImpl

package com.sk.service.Impl;import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;import com.sk.dao.PersonMapper;import com.sk.entity.Person;import com.sk.service.PersonService;import org.springframework.stereotype.Service;/** * @Author 松柯 * @Date 2022/3/31 17:35 * @Version 1.0 */@Servicepublic class PersonServiceImpl extends ServiceImpl implements PersonService {}

6.PersonService

package com.sk.service;import com.baomidou.mybatisplus.extension.service.IService;import com.sk.entity.Person;import org.apache.ibatis.annotations.Mapper;/** * @Author 松柯 * @Date 2022/3/31 17:35 * @Version 1.0 */public interface PersonService extends IService {}

7.jdbc.properties

jdbc.driver=com.mysql.cj.jdbc.Driverjdbc.url=jdbc:mysql://localhost:3306/test?serverTimezone=GMT%2B8jdbc.username=rootjdbc.password=123456

8.springmvc-servlet.xml

9.sql

-------------person----------------CREATE TABLE `test` (  `person_id` int NOT NULL AUTO_INCREMENT COMMENT '主键id',  `person_name` varchar(255) NULL COMMENT '人名',  `person_age` int NULL COMMENT '年龄',  PRIMARY KEY (`person_id`));-------------------------------------

10.pom

    4.0.0    org.example    spring-mvc    1.0-SNAPSHOT            11        11                                    org.springframework            spring-core            5.3.16                    spring-web            spring-webmvc            5.3.17            spring-aop                            org.webjars.bower            jquery            3.6.0                    org.projectlombok            lombok            1.18.20                    com.baomidou            mybatis-plus            3.3.1                            mysql            mysql-connector-java            8.0.28                    com.alibaba            druid            1.1.9                    com.microsoft.sqlserver            mssql-jdbc            8.4.1.jre8                    spring-context                    spring-expression                    spring-tx            4.3.22.RELEASE            com.fasterxml.jackson.core            jackson-annotations            2.9.3                    jackson-core                    jackson-databind            spring-jdbc    

到此，关于"SpringMVC框架怎么搭建idea操作数据库"的学习就结束了，希望能够解决大家的疑惑。理论与实践的搭配能更好的帮助大家学习，快去试试吧！若想继续学习更多相关知识，请继续关注网站，小编会继续努力为大家带来更多实用的文章！