Idea JDBC实现插入用户oracle

一、创建pojo

import lombok.Getter;
import lombok.Setter;

@Getter
@Setter
public class User {
    private String id;
    private String userName;
    private String note;
}

二、创建service，orcle创建的用户名springboot，密码springboot

import org.springframework.stereotype.Component;
import org.springframework.stereotype.Service;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
@Component
@Service
public class UserService {
    public int insertUser(User user) {
        UserDao userDao = new UserDao();
        Connection conn = null;
        int result = 0;
        try {
            Class.forName("oracle.jdbc.OracleDriver");
            conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl","springboot","springboot");
            conn.setAutoCommit(false);
            result = userDao.insertUser(conn, user);