SpringBoot整合thymeleaf简单的CRUD
最近发现之前学习的东西好多都忘记了,这里开始每天记录一点之前学习过的东西,今天就从最简单的CRUD开始吧。
一、老规矩还是先看看相应的目录结构
二、添加相应的pom依赖
<dependencies>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-thymeleaf</artifactId>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-web</artifactId>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.47</version>
<scope>runtime</scope>
</dependency>
<dependency>
<groupId>org.projectlombok</groupId>
<artifactId>lombok</artifactId>
<optional>true</optional>
</dependency>
<!--mybatis-->
<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter</artifactId>
<version>2.1.1</version>
</dependency>
<!--druid-->
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>druid</artifactId>
<version>1.1.21</version>
</dependency>
三、创建对应的实体类
Emp:
@Data
@AllArgsConstructor
@NoArgsConstructor
@ToString
public class Emp {
private String id;
private String name;
private Double salary;
private Integer age;
private Date bir;
}
User:
@Data
@AllArgsConstructor
@NoArgsConstructor
@ToString
public class User {
private String id;
private String username;
private String realname;
private String password;
private String sex;
}
四、创建对应的持久层(即dao层)
EmpDAO:
public interface EmpDAO {
List<Emp> findAll();
void save(Emp emp);
void delete(String id);
Emp find(String id);
void update(Emp emp);
}
五、创建对应的Mapper映射文件
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.xieyunjie.dao.EmpDAO">
<!--更新员工信息-->
<update id="update" parameterType="com.xieyunjie.entity.Emp">
update t_emp set name=#{name},salary=#{salary},age=#{age},bir=#{bir}
where id=#{id}
</update>
<!--根据id查询员工-->
<select id="find" parameterType="String" resultType="com.xieyunjie.entity.Emp">
select id,name,salary,age,bir from t_emp
whereid=#{id}
</select>
<!--删除员工信息-->
<delete id="delete" parameterType="String">
delete from t_emp where id=#{id}
</delete>
<!--保存员工信息-->
<insert id="save" parameterType="com.xieyunjie.entity.Emp">
insert into t_emp values(#{id},#{name},#{salary},#{age},#{bir})
</insert>
<!--查询所有-->
<select id="findAll" resultType="com.xieyunjie.entity.Emp">
select id,name,salary,age,bir from t_emp
</select>
</mapper>
六、创建对应的业务层(即service层)
public interface EmpService {
List<Emp> findAll();
void save(Emp emp);
void delete(String id);
Emp find(String id);
void update(Emp emp);
}
@Service
@Transactional
public class EmpServiceImpl implements EmpService {
@Autowired
private EmpDAO empDAO;
@Override
public void update(Emp emp) {
empDAO.update(emp);
}
@Override
@Transactional(propagation = Propagation.SUPPORTS)
public Emp find(String id) {
return empDAO.find(id);
}
@Override
public void delete(String id) {
empDAO.delete(id);
}
@Override
public void save(Emp emp) {
emp.setId(UUID.randomUUID().toString());
empDAO.save(emp);
}
@Override
@Transactional(propagation = Propagation.SUPPORTS)
public List<Emp> findAll() {
return empDAO.findAll();
}
}
七、创建控制器
@Controller
@RequestMapping("/emp")
public class EmpController {
@Autowired
private EmpService empService;
//更新员工信息方法
@PostMapping("/update")
public String update(Emp emp){
empService.update(emp);
return "redirect:/emp/findAll";
}
//id查询员工
@GetMapping("/find")
public String find(String id, Model model){
Emp emp = empService.find(id);
model.addAttribute("emp",emp);
return "/ems/updateEmp";
}
//删除员工
@GetMapping("/delete")
public String delete(String id){
empService.delete(id);
return "redirect:/emp/findAll";
}
//保存员工
@PostMapping("/save")
public String save(Emp emp){
empService.save(emp);
return "redirect:/emp/findAll";
}
//查询所有
@GetMapping("/findAll")
public String findAll(Model model){
List<Emp> emps=empService.findAll();
model.addAttribute("emps",emps);
return "ems/emplist";
}
}
八、创建生成验证码的工具类
package com.xieyunjie.utils;
import javax.imageio.ImageIO;
import java.awt.*;
import java.awt.image.BufferedImage;
import java.io.FileOutputStream;
import java.io.IOException;
import java.util.Arrays;
import java.util.Random;
public class ValidateImageCodeUtils {
/**
* 验证码难度级别 Simple-数字 Medium-数字和小写字母 Hard-数字和大小写字母
*/
public enum SecurityCodeLevel {
Simple, Medium, Hard
};
/**
* 产生默认验证码,4位中等难度
*
* @return
*/
public static String getSecurityCode() {
return getSecurityCode(4, SecurityCodeLevel.Medium, false);
}
/**
* 产生长度和难度任意的验证码
*
* @param length
* @param level
* @param isCanRepeat
* @return
*/
public static String getSecurityCode(int length, SecurityCodeLevel level, boolean isCanRepeat) {
// 随机抽取len个字符
int len = length;
// 字符集合(--除去易混淆的数字0,1,字母l,o,O)
char[] codes = {
'0', '1', '2', '3', '4', '5', '6', '7', '8', '9',
'a', 'b', 'c', 'd', 'e', 'f', 'g', 'h', 'i', 'j', 'k', 'l', 'm', 'n', 'o', 'p', 'q', 'r', 's', 't', 'u', 'v', 'w', 'x', 'y', 'z',
'A', 'B', 'C', 'D', 'E', 'F', 'G', 'H', 'I', 'J', 'K', 'L', 'M', 'N', 'O', 'P', 'Q', 'R', 'S', 'T', 'U', 'V', 'W', 'X', 'Y', 'Z'
};
// 根据不同难度截取字符串
if (level == SecurityCodeLevel.Simple) {
codes = Arrays.copyOfRange(codes, 0, 10);
} else if (level == SecurityCodeLevel.Medium) {
codes = Arrays.copyOfRange(codes, 0, 36);
}
// 字符集和长度
int n = codes.length;
// 抛出运行时异常
if (len > n && isCanRepeat == false) {
throw new RuntimeException(String.format("调用SecurityCode.getSecurityCode(%1$s,%2$s,%3$s)出现异常," + "当isCanRepeat为%3$s时,传入参数%1$s不能大于%4$s", len, level, isCanRepeat, n));
}
// 存放抽取出来的字符
char[] result = new char[len];
// 判断能否出现重复字符
if (isCanRepeat) {
for (int i = 0; i < result.length; i++) {
// 索引0 and n-1
int r = (int) (Math.random() * n);
// 将result中的第i个元素设置为code[r]存放的数值
result[i] = codes[r];
}
} else {
for (int i = 0; i < result.length; i++) {
// 索引0 and n-1
int r = (int) (Math.random() * n);
// 将result中的第i个元素设置为code[r]存放的数值
result[i] = codes[r];
// 必须确保不会再次抽取到那个字符,这里用数组中最后一个字符改写code[r],并将n-1
codes[r] = codes[n - 1];
n--;
}
}
return String.valueOf(result);
}
/**
* 生成验证码图片
* @param securityCode
* @return
*/
public static BufferedImage createImage(String securityCode){
int codeLength = securityCode.length();//验证码长度
int fontSize = 18;//字体大小
int fontWidth = fontSize+1;
//图片宽高
int width = codeLength*fontWidth+6;
int height = fontSize*2+1;
//图片
BufferedImage image = new BufferedImage(width, height, BufferedImage.TYPE_INT_RGB);
Graphics2D g = image.createGraphics();
g.setColor(Color.WHITE);//设置背景色
g.fillRect(0, 0, width, height);//填充背景
g.setColor(Color.LIGHT_GRAY);//设置边框颜色
g.setFont(new Font("Arial", Font.BOLD, height-2));//边框字体样式
g.drawRect(0, 0, width-1, height-1);//绘制边框
//绘制噪点
Random rand = new Random();
g.setColor(Color.LIGHT_GRAY);
for (int i = 0; i < codeLength*6; i++) {
int x = rand.nextInt(width);
int y = rand.nextInt(height);
g.drawRect(x, y, 1, 1);//绘制1*1大小的矩形
}
//绘制验证码
int codeY = height-10;
g.setColor(new Color(19,148,246));
g.setFont(new Font("Georgia", Font.BOLD, fontSize));
for(int i=0;i<codeLength;i++){
double deg=new Random().nextDouble()*20;
g.rotate(Math.toRadians(deg), i*16+13,codeY-7.5);
g.drawString(String.valueOf(securityCode.charAt(i)), i*16+5, codeY);
g.rotate(Math.toRadians(-deg), i*16+13,codeY-7.5);
}
g.dispose();//关闭资源
return image;
}
public static void main(String[] args) throws IOException {
String securityCode = ValidateImageCodeUtils.getSecurityCode();
System.out.println(securityCode);
BufferedImage image = ValidateImageCodeUtils.createImage(securityCode);
ImageIO.write(image,"png",new FileOutputStream("aa.png"));
}
}
九、创建对应的前端页面(并且引入相应的资源文件)
由于代码量较大,这里就不再进行展示,想要源码的可以留言,加我好友。
十、进行测试
注册界面
登陆进来后(可以进行增删查改)
今天的大概就说到这儿,谢谢大家!