java_springboot:day02

整合spring_jdbc操作数据库

pom.xml添加依赖

<!-- JDBC -->
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-jdbc</artifactId>
        </dependency>
        <!-- 数据库驱动 -->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-test</artifactId>
            <scope>test</scope>
        </dependency>

application.properties进行数据库配置

#数据库配置
spring.datasource.driver-class-name=com.mysql.jdbc.Driver
spring.datasource.username=root
spring.datasource.password=123456
spring.datasource.url=jdbc:mysql://localhost:3306/spring_day04

@Controller
@EnableAutoConfiguration
@RequestMapping("/user")
public class User01Controller {

    @Autowired
    private UserService us;

    @ResponseBody
    @RequestMapping("/register")
    public String register(){
        us.register("hetl09","qwertyuiop",0);
        return "success";
    }
}

@Service
public class UserServiceImpl implements UserService {

    @Autowired
    private JdbcTemplate jt;
    @Override
    public void register(String username, String password, int isManager) {
        String sql = "insert into t_user(username,password,isManager) value(?,?,?)";

        jt.update(sql,username,password,isManager);
    }
}


public interface UserService {
    void register(String username,String password, int isManager );

}


@ComponentScan(basePackages = {"com.hetl.day02.controller","com.hetl.day02.service"})
@EnableAutoConfiguration
public class App01 {
    public static void main(String[] args) {
        SpringApplication.run(App01.class,args);
    }
}

整合mybatis操作数据库

pom.xml

<!-- mybaties -->
        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>1.1.1</version>
        </dependency>
        <!-- 数据库驱动 -->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-test</artifactId>
            <scope>test</scope>
        </dependency>

application.properties

spring.datasource.driver-class-name=com.mysql.jdbc.Driver
spring.datasource.username=root
spring.datasource.password=123456
spring.datasource.url=jdbc:mysql://localhost:3306/spring_day04

@Controller
@EnableAutoConfiguration
@RequestMapping("/user")
public class User01Controller {

    @Autowired
    private UserService us;

    @ResponseBody
    @RequestMapping("/register")
    public String register(){
        us.register("hetl09","qwertyuiop",0);
        return "success";
    }
}

public interface UserMapper {
    @Insert("insert into t_user(username,password,isManager) value(#{username},#{password},#{isManager})")
    int save(@Param("username") String username, @Param("password") String password,@Param("isManager") int isManager);
}

@Service
public class UserServiceImpl implements UserService {

    @Autowired
    private UserMapper um;
    //private JdbcTemplate jt;
    @Override
    public void register(String username, String password, int isManager) {

        um.save(username,password,isManager);
    }
}

public interface UserService {
    void register(String username,String password, int isManager );

}

@ComponentScan(basePackages = {"com.hetl.day02.controller","com.hetl.day02.service"})
@EnableAutoConfiguration
@MapperScan(basePackages = "com.hetl.day02.mapper")
public class App01 {
    public static void main(String[] args) {
        SpringApplication.run(App01.class,args);
    }
}

使用事务