pom.xml中添加依赖
<dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> </dependency> <dependency> <groupId>org.projectlombok</groupId> <artifactId>lombok</artifactId> <optional>true</optional> </dependency> <dependency> <groupId>org.mybatis.spring.boot</groupId> <artifactId>mybatis-spring-boot-starter</artifactId> <version>1.1.1</version> </dependency>
说是简单测试版,所有的文件都在Application.java中,不适合正经的开发。
在application.properties中配置数据库信息:
spring.datasource.driver-class-name=com.mysql.jdbc.Driver#根据自己环境配置可连接的数据库信息spring.datasource.url=jdbc:mysql://172.16.14.40:3306/springbootspring.datasource.username=devgroupspring.datasource.password=devgroup
sql语句:
drop table if exists car;create table car ( id int(10) auto_increment not null, username varchar(50) not null, primary key(id))
Application.java
package com.zhu;import java.util.Arrays;import java.util.Collection;import java.util.List;import org.apache.ibatis.annotations.Insert;import org.apache.ibatis.annotations.Mapper;import org.apache.ibatis.annotations.Options;import org.apache.ibatis.annotations.Param;import org.apache.ibatis.annotations.Select;import org.apache.ibatis.annotations.Update;import org.springframework.boot.CommandLineRunner;import org.springframework.boot.SpringApplication;import org.springframework.boot.autoconfigure.SpringBootApplication;import org.springframework.context.annotation.Bean;import lombok.AllArgsConstructor;import lombok.Data;import lombok.Getter;import lombok.NoArgsConstructor;import lombok.Setter;import lombok.ToString;@SpringBootApplicationpublic class DemoApplication { public static void main(String[] args) { SpringApplication.run(DemoApplication.class, args); } @Bean CommandLineRunner demo(CarMapper carMapper) { return args -> { List<Car> cars = Arrays.asList(new Car("zhangsan"), new Car("lisi"), new Car("wangwu")); cars.forEach(car -> { carMapper.insert(car); System.err.println("插入数据:" + car.toString()); }); System.err.println("-----------查询所有的数据-----------------"); carMapper.selectAll().forEach(System.out::println); System.err.println("----------删除数据---------------"); carMapper.RemoveOne(carMapper.selectAll().size()); System.err.println("----------修改数据---------------"); carMapper.UpdateOne(135,"zhaoliu"); }; }}@Mapperinterface CarMapper { @Options(useGeneratedKeys = true) @Insert("insert into car(username) values(#{username})") void insert(Car car); @Update("update car set username = #{username} where id = #{id}") void UpdateOne(@Param("id") int id,@Param("username") String username); @Insert("delete from car where id = #{id}") void RemoveOne(int id); @Select("select * from car") Collection<Car> selectAll();}@Data@AllArgsConstructor@NoArgsConstructorclass Car { public Car(String username) { this.username = username; } public Car(Integer id, String username) { this.id = id; this.username = username; } private int id; private String username; @Override public String toString() { return "Car [id=" + id + ", username=" + username + "]"; }}
点击run Application:
src/main/resources/com/zhu/CarMapper.xml
<?xml version="1.0" encoding="UTF-8" ?><!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd" ><mapper namespace="com.zhu.CarMapper"> <select id="searchOne" resultType="com.zhu.Car"> SELECT * FROM car <where> <if test="username != null"> username = #{username} </if> </where> </select></mapper>
Application.java
package com.zhu;import java.util.Arrays;import java.util.Collection;import java.util.List;import org.apache.ibatis.annotations.Insert;import org.apache.ibatis.annotations.Mapper;import org.apache.ibatis.annotations.Options;import org.apache.ibatis.annotations.Param;import org.apache.ibatis.annotations.Select;import org.apache.ibatis.annotations.Update;import org.springframework.boot.CommandLineRunner;import org.springframework.boot.SpringApplication;import org.springframework.boot.autoconfigure.SpringBootApplication;import org.springframework.context.annotation.Bean;import lombok.AllArgsConstructor;import lombok.Data;import lombok.Getter;import lombok.NoArgsConstructor;import lombok.Setter;import lombok.ToString;@SpringBootApplicationpublic class DemoApplication { public static void main(String[] args) { SpringApplication.run(DemoApplication.class, args); } @Bean CommandLineRunner demo(CarMapper carMapper) { return args -> { List<Car> cars = Arrays.asList(new Car("zhangsan"), new Car("lisi"), new Car("wangwu")); cars.forEach(car -> { carMapper.insert(car); System.err.println("插入数据:" + car.toString()); }); System.err.println("-----------查询所有的数据-----------------"); carMapper.selectAll().forEach(System.out::println); System.err.println("----------删除数据---------------"); carMapper.RemoveOne(carMapper.selectAll().size()); System.err.println("----------修改数据---------------"); carMapper.UpdateOne(135,"zhaoliu"); System.err.println("---------配置文件查询---------------------"); carMapper.searchOne("zhangsan").forEach(System.out::println); }; }}@Mapperinterface CarMapper { @Options(useGeneratedKeys = true) @Insert("insert into car(username) values(#{username})") void insert(Car car); @Update("update car set username = #{username} where id = #{id}") void UpdateOne(@Param("id") int id,@Param("username") String username); @Insert("delete from car where id = #{id}") void RemoveOne(int id); @Select("select * from car") Collection<Car> selectAll(); Collection<Car> searchOne(@Param("username") String username);}@Data@AllArgsConstructor@NoArgsConstructorclass Car { public Car(String username) { this.username = username; } public Car(Integer id, String username) { this.id = id; this.username = username; } private int id; private String username; @Override public String toString() { return "Car [id=" + id + ", username=" + username + "]"; }}
OK
联系客服