使用springboot进行增删改查

以你之姓@ 2023-06-13 03:27 3阅读 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>
    			
    			<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>
        		
       		</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>