springboot-第八章 SpringBoot2.x持久化数据方式介绍

java访问数据库的几种方式

1.原生的jdbc

2.Apache dbutils 比原生的jdbc简单点

3.jpa框架spring-daddtda-jpa ，在复杂查询的时候性能不是很好

4.hibernate框架 ORM框架

5.Mybatis框架 互联网行业通常使用mybatis，半ORM

 

https://blog.csdn.net/a532672728/article/details/77857056

 

CREATE TABLE user1 (

        id int NOT NULL ,

        name varchar(128),

        password varchar(16),

        phone varchar(16) ,

        create_time timestamp,

        age int,

        PRIMARY KEY (id)

) 

 

create sequence seq_user1_id

increment by 1

start with 1

maxvalue 999999999;

 

整合完成后运行页面报 ORA-01017: invalid username/password 经过确认是自己写错了：

 

spring.datasource.data-username=test
spring.datasource.data-password=test

 争取如下：

spring.datasource.username=test
spring.datasource.password=test

 

 

启动时警告 oracle.jdbc.driver.OracleDriver not found

将DriverClassName以前的oracle.jdbc. driver.OracleDriver 修改成oracle.jdbc.OracleDriver。

 

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

<dependency>
   <groupId>com.oracle</groupId>
   <artifactId>ojdbc6</artifactId>
   <version>11.2.0.4</version>
</dependency>

 

spring.datasource.driver-class-name=oracle.jdbc.OracleDriver
spring.datasource.url=jdbc:oracle:thin:@127.0.0.1:1521:test
spring.datasource.username=test
spring.datasource.password=test
#开启mybatis的日志
mybatis.configuration.log-impl=org.apache.ibatis.logging.stdout.StdOutImpl

 

@MapperScan("com.kevin.autogenproject.mapper")
public class AutogenprojectApplication{

public interface UserMapper {
    @Insert("insert into user1(id,name,password,age,create_time)values(seq_user1_id.nextval,#{name},#{password},#{age},#{createTime})")
        //@Options(useGeneratedKeys = ture,keyProperty = "id",keyColumn = "user_id") mysql的自增列会用到.user_id指只增列列名
int insert(User user);

    @Select("select * from user1")
    @Results({
            @Result(column = "create_time",property = "createTime")
    })
    List<User> getAll();

    @Select("select * from user1 where id = #{id}")
    @Results({
            @Result(column = "create_time",property = "createTime")
    })
    User findById(int id);

    @Update("update user1 set name=#{name} where id =#{id}")
    void updateUser(User user);

    @Delete("delete from user1 where id = #{id}")
    void deleteUser(User user);
}

@Service
public class UserServiceImpl implements UserService{

    @Autowired
private UserMapper mapper;

    @Override
public int addUser(User user)
    {
        mapper.insert(user);
        return user.getId();
    }
    @Override
    @Transactional(propagation = Propagation.REQUIRED,isolation = Isolation.DEFAULT)
    public int addAccount(User user) {
        mapper.insert(user);
        int i=9/0;
        return 0;
    }
}

 

@RestController
@RequestMapping("/api/v1/user")
public class UserController {

    @Autowired
private UserService servcie;

    @Autowired
private UserMapper mapper;
    @RequestMapping("/add")
    public void addUser()
    {
        User user = new User();
        user.setAge(1);
        user.setName("kevin");
        user.setPassword("123");
        user.setCreateTime(new Date());
        servcie.addUser(user);
    }
    @RequestMapping("/all")
    public Object selectAll()
    {
        return mapper.getAll();
    }
    @RequestMapping("/one")
    public Object selectOne(int id)
    {
        return mapper.findById(id);
    }

    @RequestMapping("/update")
    public void update(int id, String name)
    {
        User user = new User();
        user.setId(id);
        user.setName(name);
        mapper.updateUser(user);
        System.out.println("update success");
    }
    @RequestMapping("/delete")
    public void delete(int id)
    {
        User user = new User();
        user.setId(id);
        mapper.deleteUser(user);
        System.out.println("delete success");
    }
@RequestMapping("/add_account")
    public void addAccount()
    {
        User user = new User();
        user.setAge(1);
        user.setName("kevin");
        user.setPassword("123");
        user.setCreateTime(new Date());
        servcie.addAccount(user);
    }
}

 

事务的隔离级别

四种

read committed 大多数数据库的默认事务级别。

事务的传播机制

REQUIRED 最常用

SUPPORTS

MANDATORY

REQUIRES_NEW

NOT_SUPPORTED

NEVER

SpirngBoot中在Service层的方法上添加事务的传播机制 @Transactional(propagation = Propagation.REQUIRED），一般事务的隔离级别时默认的，默认的值指向了数据库的隔离界别。