搭建Mybatis,实现数据库增删改

pom.xml文件中粘贴下列,加载maven依赖

<?xmlversion="1.0"encoding="UTF-8"?>

<projectxmlns="http://maven.apache.org/POM/4.0.0"

xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

xsi:schemaLocation="http://maven.apache.org/POM/4.0.0http://maven.apache.org/xsd/maven-4.0.0.xsd">

<modelVersion>4.0.0</modelVersion>

<groupId>com.easy</groupId>

<artifactId>EasySpringB</artifactId>

<version>1.0-SNAPSHOT</version>

<properties>

<maven.compiler.source>8</maven.compiler.source>

<maven.compiler.target>8</maven.compiler.target>

<project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>

</properties>

<parent>

<groupId>org.springframework.boot</groupId>

<artifactId>spring-boot-parent</artifactId>

<version>2.6.6</version>

</parent>

<dependencies>

<!--https://mvnrepository.com/artifact/org.springframework.boot/spring-boot-starter-web-->

<dependency>

<groupId>org.springframework.boot</groupId>

<artifactId>spring-boot-starter-web</artifactId>

</dependency>

<dependency>

<groupId>org.springframework.boot</groupId>

<artifactId>spring-boot-starter-thymeleaf</artifactId>

</dependency>

<dependency>

<groupId>org.springframework</groupId>

<artifactId>spring-aspects</artifactId>

<version>5.3.16</version>

</dependency>

<!--Lombok引入-->

<dependency>

<groupId>org.projectlombok</groupId>

<artifactId>lombok</artifactId>

</dependency>

<dependency>

<groupId>org.mybatis.spring.boot</groupId>

<artifactId>mybatis-spring-boot-starter</artifactId>

<version>2.2.2</version>

</dependency>

<dependency>

<groupId>mysql</groupId>

<artifactId>mysql-connector-java</artifactId>

<version>8.0.26</version>

</dependency>

<dependency>

<groupId>org.springframework.boot</groupId>

<artifactId>spring-boot-devtools</artifactId>

<version>2.6.6</version>

</dependency>

<dependency>

<groupId>org.slf4j</groupId>

<artifactId>slf4j-api</artifactId>

<version>1.7.14</version>

</dependency>

</dependencies>

</project>

 

application.yml文件中,添加下列代码

#注释

#yml语法

#配置mybatis的数据源DataSource

spring:

datasource:

username:root

password:123456

driver-class-name:com.mysql.cj.jdbc.Driver

url:jdbc:mysql://localhost:3306/easydata

#配置mapper文件地址

mybatis:

mapper-locations:classpath:mapper/*.xml

logging:

level:

com.easy.dao:debug

com.easy文件夹中创建启动类Easy SpringApplication

package com.easy;

import org.springframework.boot.SpringApplication;

import org.springframework.boot.autoconfigure.SpringBootApplication;

@SpringBootApplication

public class EasySpringApplication{

public static void main(String[]args){

SpringApplication.run(EasySpringApplication.class,args);

}

}

 

创建一个dao包,再包中创建IStaffDao接口

packagecom.easy.dao;

import com.easy.bean.Staff;

import org.apache.ibatis.annotations.Mapper;

@Mapper

public interface IStaffDao{

String getNow();

int addStaff(Staffstaff);

int delStaff(intid)

int editStaff(Staffstaff);

}

 

 

创建一个bean包,创建Staff类写出getset方法

package com.easy.bean;

import java.math.BigDecimal;

public class Staff{

private int id;

private String code;

private String name;

private BigDecimal salary;

private String username;

private String userpass;

public int getId(){

return id;

}

public void setId(int id){

this.id=id;

}

public String getCode(){

return code;

}

public void setCode(String code){

this.code=code;

}

public String getName(){

return name;

}

public void setName(String name){

this.name=name;

}

public BigDecimalgetSalary(){

return salary;

}

public void setSalary(BigDecimal salary){

this.salary=salary;

}

public String getUsername(){

return username;

}

public void setUsername(String username){

this.username=username;

}

public String getUserpass(){

return userpass;

}

public void setUserpass(String userpass){

this.userpass=userpass;

}

}

创建一个controller包,EasyController类

packagecom.easy.controller;

importcom.easy.bean.Department;

importcom.easy.bean.Staff;

importcom.easy.dao.IDepartmentDao;

importcom.easy.dao.IStaffDao;

importorg.springframework.beans.factory.annotation.Autowired;

importorg.springframework.web.bind.annotation.*;

importjava.math.BigDecimal;

@RestController

publicclassEasyController{

@Autowired

IStaffDaodao;

@GetMapping("now")

publicStringnow(){

returndao.getNow();

}

@PostMapping("staff")

publicStringaddStaff(Staffstaff){

dao.addStaff(staff);

return"successstaff";

}

//删除

@DeleteMapping("staff/{id}")

publicStringdelStaff(@PathVariableintid){

dao.delStaff(id);

return"successdelete";

}

@PutMapping("staff")

publicStringeditStaff(Staffstaff){

dao.editStaff(staff);

return"successedit";

}

}

Staff_Mapper.xml中的代码

<?xmlversion="1.0"encoding="UTF-8"?>

<!DOCTYPEmapper

PUBLIC"-//mybatis.org//DTDMapper3.0//EN"

"http://mybatis.org/dtd/mybatis-3-mapper.dtd">

<mappernamespace="com.easy.dao.IDepartmentDao">

<!--在这里写SQL语句-->

<selectid="getNow"resultType="String">

selectnow()

</select>

<insertid="addStaff">

insertintostaff(code,name,salary,username,userpass)

value(#{code},#{name},#{salary},#{username},#{userpass})

</insert>

<deleteid="delStaff">

deletefromstaffwhereid=#{id}

</delete>

<updateid="editStaff">

updatestaffsetname=#{name},salary=#{salary},

username=#{username},userpass=#{userpass}

whereid=#{id}

</update>

</mapper>

最后运行启动类 EasySpringApplication类

  • 13
    点赞
  • 15
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
好的,这个问题我可以回答。首先需要在项目的pom.xml文件中添加mybatismybatis-spring的依赖。 ``` <dependency> <groupId>org.mybatis</groupId> <artifactId>mybatis</artifactId> <version>3.5.6</version> </dependency> <dependency> <groupId>org.mybatis</groupId> <artifactId>mybatis-spring</artifactId> <version>2.0.6</version> </dependency> ``` 接着,在Spring配置文件中配置数据源和SqlSessionFactory,这里以MySQL数据库为例: ``` <!-- 数据源配置 --> <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource"> <property name="driverClassName" value="com.mysql.jdbc.Driver"/> <property name="url" value="jdbc:mysql://localhost:3306/test"/> <property name="username" value="root"/> <property name="password" value="123456"/> </bean> <!-- SqlSessionFactory配置 --> <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean"> <property name="dataSource" ref="dataSource"/> <property name="configLocation" value="classpath:mybatis-config.xml"/> </bean> <!-- MapperScannerConfigurer配置 --> <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer"> <property name="basePackage" value="com.example.mapper"/> </bean> ``` 在上面的配置中,我们指定了数据源的类型和连接信息,然后配置了SqlSessionFactory,同时指定了mybatis的配置文件位置。最后,我们配置了MapperScannerConfigurer,指定了Mapper接口所在的包。 接下来,我们就可以编写Mapper接口和对应的SQL语句了。例如,我们有一个User表,需要实现对该表的增删查操作,那么我们可以先定义一个UserMapper接口: ``` public interface UserMapper { void insert(User user); void deleteById(int id); void update(User user); User findById(int id); } ``` 这里定义了四个方法,分别对应了插入、删除、更新和查询操作。接着,我们需要在mybatis的配置文件中定义这些SQL语句: ``` <mapper namespace="com.example.mapper.UserMapper"> <insert id="insert" parameterType="com.example.entity.User"> insert into user (name, age) values (#{name}, #{age}) </insert> <delete id="deleteById" parameterType="int"> delete from user where id = #{id} </delete> <update id="update" parameterType="com.example.entity.User"> update user set name = #{name}, age = #{age} where id = #{id} </update> <select id="findById" parameterType="int" resultType="com.example.entity.User"> select * from user where id = #{id} </select> </mapper> ``` 在上面的配置中,我们定义了四个SQL语句,分别对应了插入、删除、更新和查询操作。其中,#{name}、#{age}和#{id}都是参数占位符,通过调用Mapper接口的方法,可以将实际参数传递给SQL语句进行执行。 最后,我们就可以在Service层中调用Mapper接口的方法,来完成对数据库增删查操作了。例如,我们有一个UserService类,需要实现对User表的增删查操作,那么我们可以这样定义该类: ``` @Service public class UserService { @Autowired private UserMapper userMapper; public void insert(User user) { userMapper.insert(user); } public void deleteById(int id) { userMapper.deleteById(id); } public void update(User user) { userMapper.update(user); } public User findById(int id) { return userMapper.findById(id); } } ``` 在上面的代码中,我们使用了@Autowired注解,将UserMapper接口注入到UserService中。然后,我们实现了UserService类的四个方法,分别对应了User表的增删查操作。在每个方法中,我们调用了UserMapper接口的方法,来完成实际的数据库操作。 这样,我们就完成了Spring整合Mybatis实现数据库增删查操作。
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值