整合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);
}
}
使用事务