使用springboot进行增删改查

最新推荐文章于 2023-07-17 15:09:52 发布

xiaojx_

最新推荐文章于 2023-07-17 15:09:52 发布

阅读量202

点赞数

分类专栏： springboot 文章标签： springboot

本文链接：https://blog.csdn.net/xiaojx_/article/details/103051898

版权

springboot 专栏收录该内容

1 篇文章 0 订阅

订阅专栏

场景启动器：

        <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>org.mybatis.spring.boot</groupId>
			<artifactId>mybatis-spring-boot-starter</artifactId>
			<version>2.1.1</version>
		</dependency>
		<dependency>
		  <groupId>com.github.pagehelper</groupId> 
		  <artifactId>pagehelper-spring-boot-starter</artifactId> 
		  <version>1.2.12</version> 
	    </dependency>
		<dependency>
			<groupId>mysql</groupId>
			<artifactId>mysql-connector-java</artifactId>
			<scope>runtime</scope>
		</dependency>

配置：

server.port=8080
server.servlet.context-path=/sboot1113_xjx

#mysql
spring.datasource.url=jdbc:mysql://localhost:3306/ms?serverTimezone=UTC&characterEncoding=utf-8
spring.datasource.username=root
spring.datasource.password=123456
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver


#mybatis
mybatis.type-aliases-package=com.neusoft.sboot1113_xjx.domain
mybatis.mapperlocations=classpath:mybatis/mapper/*Mapper.xml

pagehelper.helper-dialect=mysql
pagehelper.params=count=countSql
pagehelper.reasonable=true
pagehelper.support-methods-arguments=true

实体类

    private Integer id;

    private String name;

    private String sex;

    private String idcard;

    private String emcard;

    private String phone;

    private String post;

    private Integer sal;

    private String bkcard;

mapper.java

public void insertEmployee(Employee employee);

int deleteByPrimaryKey(Integer id);

int updateByPrimaryKey(Employee record);

List<Employee> selectByExample(EmployeeExample example);

Employee selectByPrimaryKey(Integer id);

mapper.java 类注意在类上加 @Mapper 注解

mapper.xml

<insert id="insertEmployee" parameterType="employee">
  	INSERT INTO employee (name,sex,idcard,emcard,phone,post,sal,bkcard) VALUES(#{name},#            
    {sex},#{idcard},#{emcard},#{phone},#{post},#{sal},#{bkcard})
</insert>


<delete id="deleteByPrimaryKey" parameterType="Integer" >
    delete from employee
    where id = #{id,jdbcType=INTEGER}
</delete>

<update id="updateByPrimaryKeySelective" parameterType="com.neusoft.sboot1113_xjx.domain.Employee" >
    update employee
    <set >
      <if test="name != null" >
        name = #{name,jdbcType=VARCHAR},
      </if>
      <if test="sex != null" >
        sex = #{sex,jdbcType=CHAR},
      </if>
      <if test="idcard != null" >
        idcard = #{idcard,jdbcType=VARCHAR},
      </if>
      <if test="emcard != null" >
        emcard = #{emcard,jdbcType=VARCHAR},
      </if>
      <if test="phone != null" >
        phone = #{phone,jdbcType=VARCHAR},
      </if>
      <if test="post != null" >
        post = #{post,jdbcType=VARCHAR},
      </if>
      <if test="sal != null" >
        sal = #{sal,jdbcType=INTEGER},
      </if>
      <if test="bkcard != null" >
        bkcard = #{bkcard,jdbcType=VARCHAR},
      </if>
    </set>
    where id = #{id,jdbcType=INTEGER}</update>

<select id="selectByExample" resultMap="BaseResultMap"     parameterType="com.neusoft.sboot1113_xjx.domain.EmployeeExample" >
    select
    <if test="distinct" >
      distinct
    </if>
    <include refid="Base_Column_List" />
    from employee
    <if test="_parameter != null" >
      <include refid="Example_Where_Clause" />
    </if>
    <if test="orderByClause != null" >
      order by ${orderByClause}
    </if>
</select>

<select id="selectByPrimaryKey" resultMap="BaseResultMap" parameterType="Integer" >
    select 
    <include refid="Base_Column_List" />
    from employee
    where id = #{id,jdbcType=INTEGER}
</select>

service.java

public interface EmployeeService {
	List<Employee> selectByExample(EmployeeExample example);
	
	public void insertEmployee(Employee employee);
	
	Employee selectByPrimaryKey(Integer id);
	
	int updateByPrimaryKeySelective(Employee record);
	
	int deleteByPrimaryKey(Integer id);
}

service实现类

 @Service
public class EmployeeServiceImpl implements EmployeeService{
	@Autowired
	public EmployeeMapper employeeMapper;
	
	@Override
	public List<Employee> selectByExample(EmployeeExample example) {
		// TODO Auto-generated method stub
		return employeeMapper.selectByExample(example);
	}

	@Override
	public void insertEmployee(Employee employee) {
		// TODO Auto-generated method stub
		employeeMapper.insertEmployee(employee);
	}

	@Override
	public Employee selectByPrimaryKey(Integer id) {
		// TODO Auto-generated method stub
		return employeeMapper.selectByPrimaryKey(id);
	}

	@Override
	public int updateByPrimaryKeySelective(Employee record) {
		// TODO Auto-generated method stub
		employeeMapper.updateByPrimaryKeySelective(record);
		return 1;
	}

	@Override
	public int deleteByPrimaryKey(Integer id) {
		// TODO Auto-generated method stub
		employeeMapper.deleteByPrimaryKey(id);
		return 1;
	}

}

controller

@Controller
public class EmployeeController {
	@Autowired
	private EmployeeService employeeService;
	
	@RequestMapping("/list")
	public String list(Model model,@RequestParam(defaultValue = "1",value = "pageNum") Integer pageNum) {
		System.out.println("list():");
		Page page = PageHelper.startPage(pageNum, 5);
		List<Employee> employeeList = employeeService.selectByExample(null);
		PageInfo<Employee> pageInfo = new PageInfo<>(employeeList,5);
		model.addAttribute("pageCount", page.getPages());
		model.addAttribute("pageNum", page.getPageNum());
		model.addAttribute("pageSize", page.getPageSize());
		model.addAttribute("pageInfo",pageInfo);
		return "list";
	}
	
	@RequestMapping("/add")
	public String add() {
		return "add";
	}
	@RequestMapping("/addSeckill")
	public String addProduct(Employee employee) {
		System.out.println("seckill"+employee);
		employeeService.insertEmployee(employee);
		return "redirect:list";
	}
	
	@RequestMapping("/toUpdate")
	public ModelAndView toUpdate(Integer id) {
		System.out.println("update id:"+id);
		ModelAndView mav=new ModelAndView();
		mav.addObject("employee",employeeService.selectByPrimaryKey(id));
		mav.setViewName("update");
		return mav;
	}
	
	@RequestMapping("/update")
	public String update(Employee employee) {
		System.out.println("update id:"+employee);
		employeeService.updateByPrimaryKeySelective(employee);
		return "redirect:list";
	}
	
	@RequestMapping("/delete")
	public String delete(Integer id) {
		System.out.println("delete id:"+id);
		employeeService.deleteByPrimaryKey(id);
		return "redirect:list";
	}
}

list.html

<!DOCTYPE html>
<html xmlns:th="http://www.thymeleaf.org">
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
<table>
<a th:href="@{/add}">添加数据</a>
		<tr>
			<th>id</th>
			<th>name</th>
			<th>sex</th>
			<th>idcard</th>
			<th>emcard</th>
			<th>phone</th>
			<th>post</th>
			<th>sal</th>
			<th>bkcard</th>
		</tr>
		<tr th:each="e:${pageInfo.list}">
			<td th:text="${e.id}"></td>
			<td th:text="${e.name}"></td>
			<td th:text="${e.sex}"></td>
			<td th:text="${e.idcard}"></td>
			<td th:text="${e.emcard}"></td>
			<td th:text="${e.phone}"></td>
			<td th:text="${e.post}"></td>
			<td th:text="${e.sal}"></td>
			<td th:text="${e.bkcard}"></td>
			<td><a th:href="@{/delete(id=${e.id})}">delete</a>||<a th:href="@{/toUpdate(id=${e.id})}">toUpdate</a></td><br/>
		</tr>
		<tr>
			<td colspan="5">总页数<span th:text="${pageCount}"></span>,当前第<span th:text="${pageNum}"></span>页,每页显示<span th:text="${pageSize}"></span>条数据</td>
			<!-- <a th:href="@{/list(pageNum=${pageInfo.hasPreviousPage}?${pageInfo.pages}:1)}">上一页</a> -->
			<th:block th:each="i :${#numbers.sequence(1, pageInfo.pages)}">
	            <a th:href="@{/list(pageNum=${i})}">
	                <span th:class="${pageInfo.pageNum == i}">
	                <th:block th:text="${i}"></th:block>
	            </span>
	            </a>
	        </th:block>
    		<!-- <a th:href="@{/list(pageNum=${pageInfo.hasNextPage}?${pageInfo.nextPage}:${pageInfo.pages})}">下一页</a> -->
   		</tr>
	</table>
</body>
</html>

add.html

<!DOCTYPE html>
<html xmlns:th="http://www.thymeleaf.org">
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
<form th:action="@{/addSeckill}" method="post">
name:<input type="text" name="name"/><br>
sex:<input type="text" name="sex"/><br>
idcard:<input type="text" name="idcard"/><br>
emcard:<input type="text" name="emcard"/><br>
phone:<input type="text" name="phone"/><br>
post:<input type="text" name="post"/><br>
sal:<input type="text" name="sal"/><br>
bkcard:<input type="text" name="bkcard"/><br>
<input type="submit" value="add">
</form>
</body>
</html>

update.html

<!DOCTYPE html>
<html xmlns:th="http://www.thymeleaf.org">
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
<form action="" th:action="@{/update}" method="post" th:object="${employee}">
id：<input type="text" name="" value="" th:field="*{id}"/><br>
name：<input type="text" name="" value="" th:field="*{name}"/><br>
idcard:<input type="text" name="" value="" th:field="*{idcard}"/><br>
emcard:<input type="text" name="" value="" th:field="*{emcard}"/><br>
phone:<input type="text" name="" value="" th:field="*{phone}"/><br>
post:<input type="text" name="" value="" th:field="*{post}"/><br>
sal:<input type="text" name="" value="" th:field="*{sal}"/><br>
bkcard:<input type="text" name="" value="" th:field="*{bkcard}"/><br>
<input type="submit" value="update"/>

</form>
</body>
</html>

xiaojx_

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
使用springboot进行增删改查

场景启动器： <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-thymeleaf</artifactId> </dependency> <depende...
复制链接

扫一扫