本文內(nèi)容屉佳，基于前面文章基礎(chǔ)之上編寫，如果搭建環(huán)境這些不知道，可以查看前面的惠窄。
1 springboot入門之 Hello World
2 springboot入門之 整合thymeleaf
添加pom依賴
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-jdbc</artifactId>
</dependency>
properties中配置DataSource
spring.datasource.url=jdbc:mysql://localhost:3306/test01?autoReconnect=true&useUnicode=true&characterEncoding=utf-8&useSSL=false
spring.datasource.username=root
spring.datasource.password=root
spring.datasource.driver-class-name=com.mysql.jdbc.Driver
編寫dao層，service層漾橙。
- dao接口
public interface UserDao {
Integer addUser(String name, Integer age);
}
- dao 實(shí)現(xiàn)類
@Repository
public class UserDaoImpl implements UserDao {
@Autowired
private JdbcTemplate jdbcTemplate;
@Override
public Integer addUser(String name, Integer age) {
return jdbcTemplate.update("INSERT INTO USER VALUES (null,?,?);", name, age);
}
}
- service接口
public interface UserService {
int addUser(String name, Integer age);
}
- service實(shí)現(xiàn)類
@Service
@Transactional(rollbackFor = Exception.class)
public class UserServiceImpl implements UserService {
@Autowired
private UserDao userDao;
@Override
public int addUser(String name, Integer age) {
try {
return userDao.addUser(name,age);
}catch (Exception e){
e.printStackTrace();
return 0;
}
}
}
創(chuàng)建mysql數(shù)據(jù)庫(kù)和表
-- 創(chuàng)建數(shù)據(jù)庫(kù)
CREATE DATABASE test01 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
-- 創(chuàng)建用戶表
CREATE TABLE user(
id INT PRIMARY KEY AUTO_INCREMENT,
name VARCHAR(30),
age INT
);
完成controller和頁(yè)面
UserController.java
@Controller
@RequestMapping("/user")
public class UserController {
@Autowired
UserService userService;
@RequestMapping(value = "/")
public String user() {
return "/user";
}
@ResponseBody
@RequestMapping(value = "/addUser")
public Map<String, Object> addUser(@RequestParam(name = "uname") String name, @RequestParam(name = "age") Integer age) {
Map<String, Object> map = new HashMap<>();
int count = userService.addUser(name, age);
map.put("name", name);
map.put("age", age);
map.put("msg", "操作" + (count > 0 ? "成功" : "失敗"));
return map;
}
}
user.html
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>用戶界面</title>
</head>
<body>
<h2>添加用戶</h2>
<form method="post" action="./addUser">
<label>用戶名:</label><input type="text" name="uname">
<label>年齡:</label><input type="number" name="age">
<input type="submit" value="添加"/>
</form>
</body>
</html>
運(yùn)行杆融，添加數(shù)據(jù)，查看mysql數(shù)據(jù)庫(kù)
填寫數(shù)據(jù).png
執(zhí)行添加結(jié)果.png
mysql數(shù)據(jù)庫(kù)記錄.png
