专注Java教育14年 全国咨询/投诉热线：444-1124-454
赢咖4LOGO图
始于2009，口口相传的Java黄埔军校
首页 hot资讯 SpringMVC增删改查功能的简单介绍

SpringMVC增删改查功能的简单介绍

更新时间：2021-12-09 12:39:20 来源：赢咖4 浏览835次

本节主要介绍SpringMVC简单的增删改查功能。

1.查询

dao中的代码

public List<WeatherPojo> getAllWeather(){         
         String sql="select * from weathertest";
         List<WeatherPojo> pojos=new ArrayList<WeatherPojo>();
         pojos= jdbcTemplate.query(sql,new RowMapper() { 
             @Override
             public Object mapRow(ResultSet rs, int arg1) throws SQLException {
                 // TODO Auto-generated method stub
                 WeatherPojo weather=new WeatherPojo();
                 weather.setName(rs.getString("name"));
                 weather.setPassword(rs.getString("password"));
                 weather.setId(rs.getInt("id"));
                 return weather;
             }
         });
         return pojos;
     }

还可以写service和serviceimpl。需要对jdmctempl添加注解

@Autowired

private JdbcTemplate jdbcTemplate;

在impl中需要对dao添加注解

@Autowired

private WeatherDao weatherDao;

在controller中调用服务

@Autowired
    private WeatherServiceImpl weatherService;
    @RequestMapping(params="method=query")
    public ModelAndView getAllWeather(HttpServletRequest request,HttpServletResponse response){
        List<WeatherPojo> pojos=weatherService.getWeatherList();
        request.setAttribute("weathers", pojos);
        System.out.println(pojos.get(0).getName());
        return new ModelAndView("weatherlist");
    }

通过modelandview返回页面,页面代码如下：

<%@ page language="java" contentType="text/html; charset=utf-8"
     pageEncoding="utf-8"%>
 <%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
     <%String path = request.getContextPath();
 String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
 %>
 <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
 <html>
 <head>
 <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
 <title>Insert title here</title>
 </head>
 <body>
 <div><a href="<%=basePath %>weather.do?method=add">添加</a></div>
 <div>
 <table>
 <thead>
 <tr>
 <th>姓名</th>
 <th>说明</th>
 <th>操作</th>
 </tr>
 </thead>
 <tbody>
 <c:forEach var="item" items="${weathers}">
 <tr>
 <td>${item.name }</td>
 <td>${item.password }</td>
 <td></td>
 <td><a href="<%=basePath %>weather.do?method=edit&id=${item.id}">编辑</a><a href="<%=basePath %>weather.do?method=delete&id=${item.id}">删除</a></td>
 </tr>
 </c:forEach>
 </tbody>
 </table>
 </div>
 </body>
 </html>

2.增加

dao中代码

public void addWeather(WeatherPojo weather){
         String sql="insert into weathertest(id,name,password) values("+weather.getId()+",'"+weather.getName()+"','"+weather.getPassword()+"')";
         jdbcTemplate.execute(sql);
     }

controller代码，get方法是进入新增页面，页面传递空对象。post方法为添加新的记录

@RequestMapping(params="method=add",method=RequestMethod.GET)
    public ModelAndView addWeather(HttpServletRequest request,HttpServletResponse reponse){
        request.setAttribute("weather", new WeatherPojo());
        return new ModelAndView("weatheradd");
    }
    @RequestMapping(params="method=add",method=RequestMethod.POST)
    public ModelAndView addWeather(WeatherPojo weather){
        weatherService.addWeather(weather);
        return new ModelAndView("redirect:/weather.do?method=query");
    }

jsp页面代码

<%@ page language="java" contentType="text/html; charset=utf-8"
    pageEncoding="utf-8"%>
        <%String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>Insert title here</title>
</head>
<body>
<form action="<%=basePath%>weather.do?method=add" method="post">
<label for="id">id</label>
<input name="id"/><br>
<label for="name">name</label>
<input name="name"><br>
<label for="password">password</label>
<input name="password"><br>
<input type="submit" value="提交">
</form>
</body>
</html>

3.修改

dao中代码：

public void editWeather(WeatherPojo weather){
         String sql="update weathertest set name='"+weather.getName()+"',password='"+weather.getPassword()+"' where id="+weather.getId()+"";
         jdbcTemplate.execute(sql);
     }

controller代码

@RequestMapping(params="method=edit",method=RequestMethod.GET)
    public ModelAndView editWeather(HttpServletRequest request,HttpServletResponse response){
        int id=Integer.valueOf(request.getParameter("id"));
        WeatherPojo weather=new WeatherPojo();
        weather=weatherService.getWeatherById(id);
        ModelAndView mav=new ModelAndView("editweather");
        request.setAttribute("weather", weather);
        System.out.println("--------"+weather.getId());
        System.out.println("--------"+weather.getName());
        System.out.println("--------"+weather.getPassword());
        return mav;
    }
    @RequestMapping(params="method=edit",method=RequestMethod.POST)
    public ModelAndView editWeather(WeatherPojo weather){
        weatherService.editWeather(weather);
        return new ModelAndView("redirect:/weather.do?method=query");
    }

jsp页面：

<%@ page language="java" contentType="text/html; charset=utf-8"
    pageEncoding="utf-8"%>
            <%String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>Insert title here</title>
</head>
<body>
<form action="<%=basePath%>weather.do?method=edit" method="post">
<label for="id">id</label>
<input name="id" readonly="true" value="${weather.id }"/><br>
<label for="name">name</label>
<input name="name" value="${weather.name }"><br>
<label for="password" >password</label>
<input name="password" value="${weather.password }"><br>
<input type="submit" value="提交">
</form>
</body>
</html>

4.删除

dao中代码：

//delete
    public void deleteWeather(int id){        
        String sql="delete from weathertest where id="+id;
        jdbcTemplate.execute(sql);
    }

controller代码：

@RequestMapping(params="method=delete",method=RequestMethod.GET)
    public ModelAndView deleteWeather(HttpServletRequest request,HttpServletResponse response){        
        int id=Integer.valueOf(request.getParameter("id"));
        weatherService.deleteWeather(id);
        //页面重定向
        return new ModelAndView("redirect:/weather.do?method=query");
    }

jsp代码：

<%@ page language="java" contentType="text/html; charset=utf-8"
    pageEncoding="utf-8"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
    <%String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>Insert title here</title>
</head>
<body>
<div><a href="<%=basePath %>weather.do?method=add">添加</a></div>
<div>
<table>
<thead>
<tr>
<th>姓名</th>
<th>说明</th>
<th>操作</th>
</tr>
</thead>
<tbody>
<c:forEach var="item" items="${weathers}">
<tr>
<td>${item.name }</td>
<td>${item.password }</td>
<td></td>
<td><a href="<%=basePath %>weather.do?method=edit&id=${item.id}">编辑</a><a href="<%=basePath %>weather.do?method=delete&id=${item.id}">删除</a></td>
</tr>
</c:forEach>
</tbody>
</table>
</div>
</body>
</html>

 

上一篇创建SpringMVC过滤器 下一篇Java软件开发流程

相关阅读

最新文章

  • 男 女

提交申请后，顾问老师会电话与您沟通安排学习

课程大纲 学习路线 毕业设计 开发工具
免费课程推荐 >>
技术文档推荐 >>
  • 赢咖4注册班
  • 热点话题
  • 城市分站
  • 资源广场
  • 热门专题
赢咖4注册实验班 赢咖4注册就业班 赢咖4注册夜校班 赢咖4注册在职加薪班 赢咖4注册架构师班 赢咖4注册课程
赢咖4注册动态 零基础学Java Java职场就业
北京赢咖4注册 广州赢咖4注册 深圳赢咖4注册 上海赢咖4注册 武汉赢咖4注册 成都赢咖4注册 西安赢咖4注册 郑州赢咖4注册 南京赢咖4注册 长沙赢咖4注册
Java书籍 Java视频教程 Java毕业设计 Java面试题 Java API文档 Java开发工具 Java赢咖4在线学习
上海java培训 北京java培训 深圳java培训 广州java培训 武汉java培训 成都java培训 西安java培训 郑州java培训 南京java培训 长沙java培训 java线上培训班
更新时间：2024-04-24 20:06:50 免费电话：444-1124-454 备案号：京ICP备09027468号