12-Spring MVC - Project Work - DAO update and delete operation(Contact App) - By eZeon
This Project Work(Contact App) video is a about DAO implementation and cover UPDATE and DELETE operations along with its testing.
REFERENCE CODE:
@Override
public void update(User u) {
String sql = "UPDATE user "
" SET name=:name,"
" phone=:phone, "
" email=:email,"
" address=:address,"
" role=:role,"
" loginStatus=:loginStatus "
" WHERE userId=:userId";
Map m = new HashMap();
m.put("name", u.getName());
m.put("phone", u.getPhone());
m.put("email", u.getEmail());
m.put("address", u.getAddress());
m.put("role", u.getRole());
m.put("loginStatus", u.getLoginStatus());
m.put("userId", u.getUserId());
getNamedParameterJdbcTemplate().update(sql, m);
}
@Override
public void delete(User u) {
this.delete(u.getUserId());
}
@Override
public void delete(Integer userId) {
String sql="DELETE FROM user WHERE userId=?";
getJdbcTemplate().update(sql, userId);
}
Don't skip or miss any video, just follow step by step video series.
Also check the source code listing in our
blog http://ezeon.in/blog
Don't forget to subscribe my channel.