大战熟女丰满人妻av-荡女精品导航-岛国aaaa级午夜福利片-岛国av动作片在线观看-岛国av无码免费无禁网站-岛国大片激情做爰视频

專注Java教育14年 全國咨詢/投訴熱線：400-8080-105
動力節點LOGO圖
始于2009，口口相傳的Java黃埔軍校
首頁 hot資訊 SpringMVC增刪改查功能的簡單介紹

SpringMVC增刪改查功能的簡單介紹

更新時間：2021-12-09 12:39:20 來源：動力節點 瀏覽1086次

本節主要介紹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>

 

  • 男 女

提交申請后，顧問老師會電話與您溝通安排學習

免費課程推薦 >>
技術文檔推薦 >>
主站蜘蛛池模板： 操操操网站 | 色综合天天色综合 | 国产高清一级视频在线观看 | 久久夜色精品国产噜噜小说 | 亚洲国产精品人久久 | 色婷婷激婷婷深爱五月小蛇 | 天天操夜夜操免费视频 | 日本精品夜色视频一区二区 | 成人毛片免费在线观看 | 国产一区二区高清在线 | 99热久久国产精品一区 | 欧美精品一区二区三区视频 | 国产国语对白一级毛片 | 国产日韩精品一区二区在线观看 | 成人看片黄a免费 | 久久免费视频观看 | 97影院97伦里片 | 国产精品第1页 | 欧美精品观看 | 97人人看| 鲁丝丝国产一区二区 | 亚洲精品国产综合99久久一区 | a视频在线看 | 国产精品模特hd在线 | 国产精品欧美亚洲 | 国产99在线播放免费 | 97av视频在线播放 | 精品国产乱码一区二区三区 | 精品日韩在线观看 | 毛片大全免费观看 | 久久99精品久久久66 | 色站综合 | 亚洲性一级理论片在线观看 | 欧美成人天天综合在线视色 | 99日韩| 欧美一级免费观看 | 男女羞羞视频免费观看 | 在线 色 | 伊人影院视频 | 中文字幕精品一区二区日本大胸 | 女人十八毛片免费特黄 |