Featured Post

View Design using Spring Web Flow

Hi Friends ,


Spring  Web MVC code is available here . If you want Full code please send me a mail: srampv@gmail.com  .
Your suggestions will be value added .

SPRING View Design :
---------------------------------
package myapp.contr;


import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import org.springframework.web.servlet.ModelAndView;
import org.springframework.web.servlet.mvc.*;
import org.w3c.dom.views.AbstractView;
import org.apache.commons.logging.*;
import java.util.*;

public class RamLoginController implements Controller {

    protected final Log logger=LogFactory.getLog(getClass());
    @Override
   
    public ModelAndView handleRequest(HttpServletRequest arg0,HttpServletResponse arg1) throws Exception {
        // TODO Auto-generated method stub
        String now=(new Date()).toString();
        logger.info("return ing Hello View with --------->"+now);
        return new ModelAndView("Login","now",now);
    }

   

   

}

Spring DAO :
-----------------
package myapp.dao;

import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.List;

import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
import org.springframework.jdbc.core.PreparedStatementSetter;
import org.springframework.jdbc.core.namedparam.MapSqlParameterSource;
import org.springframework.jdbc.core.simple.ParameterizedRowMapper;
import org.springframework.jdbc.core.simple.SimpleJdbcDaoSupport;
import myapp.domain.*;
public class RamDAO extends SimpleJdbcDaoSupport implements RamDAOTemplate {

   
    protected final Log logger=LogFactory.getLog(getClass());
    @Override
    public List getUsersList() {
        // TODO Auto-generated method stub
        logger.info("getting Users List");       
        List objs=getSimpleJdbcTemplate().query("select firstname,lastname from contact", new ContactMapper());
        return objs;
    }

    @Override
    public void saveUsers(Contact con) {
        // TODO Auto-generated method stub
        logger.info("Saving Contact Information"+con.getFirstName()+"<--------->"+con.getLastName());
        int count=getSimpleJdbcTemplate().update("update contact set firstname=:firstname,lastname=:lastname",new MapSqlParameterSource().addValue("firstname", con.getFirstName()).addValue("lastname", con.getLastName()));
        //int count= getJdbcTemplate().update("insert into contact(firstname,lastname)"+"values(?,?)",new RamPSSetter(con));
        logger.info("Rows effected:-->"+count);
       
    }
    private static class RamPSSetter implements PreparedStatementSetter
    {
         private Contact con;
       
         public RamPSSetter(Contact c)
         {
             this.con=c;
         }
        @Override
        public void setValues(PreparedStatement ps) throws SQLException {
            // TODO Auto-generated method stub
            ps.setString(1,con.getFirstName());
            ps.setString(2,con.getLastName());
           
        }
       
    }
    private static class ContactMapper implements ParameterizedRowMapper
    {
       

        @Override
        public Contact mapRow(ResultSet rs, int rowNum) throws SQLException {
            // TODO Auto-generated method stub
            Contact cont=new Contact();   
            cont.setFirstName(rs.getString("firstname"));
            cont.setLastName(rs.getString("lastname"));
            return cont;
        }
    }

}



Comments

Popular posts from this blog

[Inside AdSense] Understanding your eCPM (effective cost per thousand impress...