配置:jdk1.8,springboot2.1.1
一、创建项目
1.用spring initializr搭建springboot框架
2.包名
3.选择需要的依赖
4.项目名称
二、编写代码
业务顺序:application负责启动项目,controller负责接收前台请求和响应,service负责业务处理,mapper负责和数据库进行交互,bean是实体类。
1.项目结构图
application.properties代码,这里面的地址、用户名、密码按照自己的配置,url中的serverTimezone=UTC&characterEncoding=utf-8是来设置时区和编码方式的,不然会报错
springboot2.0之后设置驱动的语句改为了这样spring.datasource.driver-class-name = com.mysql.cj.jdbc.Driver(以前的貌似也可以用,可是启动的时候会提示你让你改成这样)
spring.datasource.url = jdbc:mysql://localhost:3306/springboot?serverTimezone=UTC&characterEncoding=utf-8
spring.datasource.username = root
spring.datasource.password = 123456
spring.datasource.driver-class-name = com.mysql.cj.jdbc.Driver
#页面热加载
spring.thymeleaf.cache = false
2.controller代码
package com.xiaojian.demo.controller;
import com.xiaojian.demo.service.IRegService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.autoconfigure.EnableAutoConfiguration;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.ResponseBody;
import java.math.BigInteger;
import java.security.MessageDigest;
import java.security.NoSuchAlgorithmException;
@Controller
@EnableAutoConfiguration
public class HelleWorld {
@Autowired
private IRegService regService;
@RequestMapping("/")
String home() {
return "index";
}
@RequestMapping("/reg")
@ResponseBody
Boolean reg(String loginNum, String userId ){
System.out.println(loginNum+" "+userId);
return regService.regUser(userId,loginNum);
}
}
2.service代码(接口和实现类)
①接口
package com.xiaojian.demo.service;
public interface IRegService {
boolean regUser(String uerId,String pwd);
}
②实现类
package com.xiaojian.demo.service;
import com.xiaojian.demo.mapper.UserMapper;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
@Service()
public class RegService implements IRegService{
@Autowired
private UserMapper userMapper;
@Override
public boolean regUser(String uerId, String pwd) {
Boolean flag;
try {
flag = userMapper.insertUsers(uerId,pwd);
}catch (Exception e){
return false;
}
return flag;
}
}
3.mapper代码
package com.xiaojian.demo.mapper;
import com.xiaojian.demo.bean.User;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
@Mapper
public interface UserMapper {
@Select("select * from users where userId = #{userId}")
User findUserByUserid(@Param("userId") String userId);
@Insert("insert into users (userId,pwd) values (#{userId},#{pwd})")
boolean insertUsers (@Param("userId") String userId,@Param("pwd") String pwd);
}
4.bean代码
package com.xiaojian.demo.bean;
public class User {
private String id;
private String userId;
private String pwd;
public String getId() {
return id;
}
public void setId(String id) {
this.id = id;
}
public String getUserId() {
return userId;
}
public void setUserId(String userId) {
this.userId = userId;
}
public String getPwd() {
return pwd;
}
public void setPwd(String pwd) {
this.pwd = pwd;
}
}
4.在templates文件夹下放html代码
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>Title</title>
</head>
<body>
Hello World
</body>
</html>
三、运行
1、浏览器输入localhost:8080,出来的是html页面
2.浏览器输入localhost:8080/reg?loginNum=1111&userId=222页面输出true,说明已经往数据库中插入了一条数据