Java Stuff: Spring 2 MVC JdbcDaoSupport RowMapper Validator and Layers Demo

Spring 2 MVC JdbcDaoSupport RowMapper Validator and Layers Demo

Create web dynamic project in eclipse with "SpringJDBC"

WEB-INF\web.xml
==================

<?xml version="1.0" encoding="ISO-8859-1"?>

<web-app xmlns="http://java.sun.com/xml/ns/j2ee"
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee
    http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd" version="2.4">



<display-name>Spring Example</display-name>

<servlet>
    <servlet-name>basicspring</servlet-name>
    <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
</servlet>

<servlet-mapping>
    <servlet-name>basicspring</servlet-name>
    <url-pattern>*.obj</url-pattern>
</servlet-mapping>

<welcome-file-list>
    <welcome-file>index.jsp</welcome-file>
</welcome-file-list>

</web-app>

WEB-INF\basicspring-servlet.xml
==============================

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xmlns:aop="http://www.springframework.org/schema/aop"
    xsi:schemaLocation="http://www.springframework.org/schema/beans
    http://www.springframework.org/schema/beans/spring-beans-3.0.xsd">

    <bean id="basicspringController" class="com.web.spring.BasicSpringController" />
    
    <bean id="userValidator" class="com.web.spring.UserValidator" />

    <bean id="userLoginFormController" class="com.web.spring.UserLoginFormController">
        <property name="iUserService"><ref bean="iUserService"/> </property>
        <property name="sessionForm">
            <value>true</value>
        </property>
        <property name="commandName">
            <value>user</value>
        </property>
        <property name="commandClass">
            <value>com.web.spring.User</value>
        </property>
        <property name="validator">
            <ref bean="userValidator" />
        </property>
        <property name="formView">
            <value>login</value>
        </property>
        <property name="successView">
            <value>accountdetails.obj</value>
        </property>
    </bean>

    <bean id="messageSource"
        class="org.springframework.context.support.ResourceBundleMessageSource">
        <property name="basename">
            <value>messages</value>
        </property>
    </bean>

    

    <bean id="urlMapping"
        class="org.springframework.web.servlet.handler.SimpleUrlHandlerMapping">
        
        <property name="mappings">
            <props>
                <prop key="/hello.obj">basicspringController</prop>
                <prop key="/userlogin.obj">userLoginFormController</prop>
                <prop key="/accountdetails.obj">acountDetailsController</prop>
            </props>
        </property>
    </bean>

    <bean id="viewResolver"
        class="org.springframework.web.servlet.view.InternalResourceViewResolver">
        <property name="viewClass">
            <value>org.springframework.web.servlet.view.JstlView</value>
        </property>
        <property name="prefix">
            <value>/</value>
        </property>
        <property name="suffix">
            <value>.jsp</value>
        </property>
    </bean>

    <bean id ="iUserService" class="com.web.spring.user.UserService">
        <property name="iUserDao"><ref bean="iUserJDBCDao"/> </property>
    </bean>
    <bean id ="iUserJDBCDao" class="com.web.spring.dao.UserJDBCDao">
        <property name="dataSource">
            <ref local="dataSource" />
        </property>
    </bean>
    <bean id="dataSource"
        class="org.springframework.jdbc.datasource.DriverManagerDataSource">
        <property name="driverClassName" value="com.mysql.jdbc.Driver" />
        <property name="url" value="jdbc:mysql://localhost:3306/test_db" />
        <property name="username" value="root" />
        <property name="password" value="root" />
    </bean>
    <bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">
        <property name="dataSource">
            <ref local="dataSource" />
        </property>
    </bean>

    <bean id="acountDetailsController" class="com.web.spring.AcountDetailsController">
        <property name="iAccountDetails">
            <ref bean="iAccountDetails" />
        </property>
    </bean>
    <bean id ="iAccountDetails" class="com.web.spring.account.AccountDetails">
        <property name="iAccountDetailsDao"><ref bean="iAccountDetailsDao"/> </property>
    </bean>
    <bean id ="iAccountDetailsDao" class="com.web.spring.dao.AccountDetailsDao">
        <property name="dataSource">
            <ref local="dataSource" />
        </property>
    </bean>
</beans>

com\web\spring\UserValidator.java
================================

package com.web.spring;

import org.springframework.validation.*;

/**
* @author Pedababu M
*
*/
public class UserValidator implements Validator {

    public boolean supports(Class someclass) {
        return someclass.equals(User.class);
    }

    public void validate(Object obj, Errors errors) {
        User user = (User) obj;
        if(user.getUsername().length() < 3)
            errors.rejectValue("username","username.invalid","Please enter a valid username");
        if(user.getPassword().length() < 6)
            errors.rejectValue("password","password.invalid","Please enter a valid password");
    }
};

com\web\spring\UserLoginFormController.java
==========================================

package com.web.spring;

import javax.servlet.ServletException;

import org.springframework.web.servlet.ModelAndView;
import org.springframework.web.servlet.mvc.SimpleFormController;
import org.springframework.web.servlet.view.RedirectView;

import com.web.spring.user.IUserService;

/**
* @author Pedababu M
*
*/
public class UserLoginFormController extends SimpleFormController {
private IUserService iUserService;
    /**
* @return the iUserService
*/
public IUserService getiUserService() {
    return iUserService;
}
/**
* @param iUserService the iUserService to set
*/
public void setiUserService(IUserService iUserService) {
    this.iUserService = iUserService;
}
    public ModelAndView onSubmit(Object command) throws ServletException {
        User user = (User) command;
        if(iUserService.isValidUser(user))
            return new ModelAndView(new RedirectView(getSuccessView()));
        else return new ModelAndView("error");
    }
}

com\web\spring\User.java
========================

package com.web.spring;

/**
* @author Pedababu M
*
*/
public class User {

    private String username, password;

    public String getUsername() {
        return username;
    }

    public String getPassword() {
        return password;
    }

    public void setUsername(String username) {
        this.username = username;
    }

    public void setPassword(String password) {
        this.password = password;
    }
};

com\web\spring\BasicSpringController.java
======================================

package com.web.spring;

import org.springframework.web.servlet.mvc.Controller;
import org.springframework.web.servlet.ModelAndView;
import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
/**
* @author Pedababu M
*
*/
public class BasicSpringController implements Controller {

    public ModelAndView handleRequest(HttpServletRequest request, HttpServletResponse response)
        throws ServletException, IOException {
        String now = new java.util.Date().toString();
        return new ModelAndView("hello","now",now);
    }
};

com\web\spring\AcountDetailsController.java
=========================================

package com.web.spring;

import java.io.IOException;
import java.util.HashMap;
import java.util.Map;

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

import org.springframework.web.servlet.ModelAndView;
import org.springframework.web.servlet.mvc.Controller;

import com.web.spring.account.IAccountDetails;

/**
* @author Pedababu M
*
*/
public class AcountDetailsController implements Controller {

    private IAccountDetails iAccountDetails;

    /**
    * @return the iAccountDetails
    */
    public IAccountDetails getiAccountDetails() {
        System.out.println("AcountDetailsController-getiAccountDetails");
        return iAccountDetails;
    }

    /**
    * @param iAccountDetails the iAccountDetails to set
    */
    public void setiAccountDetails(IAccountDetails iAccountDetails) {
        this.iAccountDetails = iAccountDetails;
    }

    public ModelAndView handleRequest(HttpServletRequest request, HttpServletResponse response)
        throws ServletException, IOException {
        String now = new java.util.Date().toString();

        Map myModel = new HashMap();
        myModel.put("now",now);
        myModel.put("accounts",getiAccountDetails().showAccountDetails());
        return new ModelAndView("account","model",myModel);
    }


};

com\web\spring\user\UserService.java
====================================

package com.web.spring.user;

import com.web.spring.User;
import com.web.spring.dao.IUserDao;

/**
* @author Pedababu M
*
*/
public class UserService implements IUserService{

    IUserDao iUserDao;
    /**
    * @return the iUserDao
    */
    public IUserDao getiUserDao() {
        return iUserDao;
    }
    /**
    * @param iUserDao the iUserDao to set
    */
    public void setiUserDao(IUserDao iUserDao) {
        this.iUserDao = iUserDao;
    }
    public boolean isValidUser(User user) {
        return iUserDao.isValidUser(user);

    }

}

com\web\spring\user\IUserService.java
=====================================
package com.web.spring.user;

import com.web.spring.User;

/**
* @author Pedababu M
*
*/
public interface IUserService {
    public boolean isValidUser(User user);
}

com\web\spring\dao\UserJDBCDao.java
=====================================
package com.web.spring.dao;

import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.jdbc.core.support.JdbcDaoSupport;

import com.web.spring.User;

/**
* @author Pedababu M
*
*/
public class UserJDBCDao extends JdbcDaoSupport implements IUserDao {

    public boolean isValidUser(User user) {
        JdbcTemplate jt = getJdbcTemplate();
        int count = jt
                .queryForInt("select count(*) from User_800890 where user_name = '"
                        + user.getUsername()
                        + "' and user_password='"
                        + user.getPassword() + "'");
        System.out.println("count::::::::::" + count);
        if (count>0) return true;
        else return false;
    }
}

com\web\spring\dao\IUserDao.java
=================================
package com.web.spring.dao;

import com.web.spring.User;

/**
* @author Pedababu M
*
*/
public interface IUserDao{
    public boolean isValidUser(User user);
}

com\web\spring\dao\IAccountDetailsDao.java
=========================================
package com.web.spring.dao;

import java.util.List;

/**
* @author Pedababu M
*
*/
public interface IAccountDetailsDao {
    public List showAccountDetails();
}

com\web\spring\dao\AccountDetailsDao.java
============================================

package com.web.spring.dao;

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

import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.jdbc.core.RowMapper;
import org.springframework.jdbc.core.support.JdbcDaoSupport;

import com.web.spring.account.Account;

/**
* @author Pedababu M
*
*/
public class AccountDetailsDao extends JdbcDaoSupport implements IAccountDetailsDao{
    public List showAccountDetails() {
        System.out.println("AccountDetailsDao--showAccountDetails");
        JdbcTemplate jt = getJdbcTemplate();
        return jt.query ( "select * from account_800890"
                        , new AccountRowMapper()
                        );
    }
    class AccountRowMapper implements RowMapper {
          public Object mapRow(ResultSet rs, int index) throws SQLException {
            Account account = new Account();
            account.setAccountName(rs.getString(2));
            account.setAccountType(rs.getString(3));
            account.setAccountID(rs.getString(4));
            account.setAccountBlance(rs.getInt(5));
            System.out.println(rs.getString(1) + " " + rs.getString(2) + " " + rs.getString(3) + rs.getInt(4));
            return account;
          }
        }//class EmployeeRowMapper
}

com\web\spring\account\IAccountDetails.java
=========================================
package com.web.spring.account;

import java.util.List;

/**
* @author Pedababu M
*
*/
public interface IAccountDetails {
    public List showAccountDetails();
}

com\web\spring\account\AccountDetails.java
=========================================
package com.web.spring.account;

import java.util.List;

import com.web.spring.dao.IAccountDetailsDao;

/**
* @author Pedababu M
*
*/
public class AccountDetails implements IAccountDetails{
    private IAccountDetailsDao iAccountDetailsDao;
    /**
    * @return the iAccountDetailsDao
    */
    public IAccountDetailsDao getiAccountDetailsDao() {
        System.out.println("AccountDetails-getiAccountDetailsDao");
        return iAccountDetailsDao;
    }
    /**
    * @param iAccountDetailsDao the iAccountDetailsDao to set
    */
    public void setiAccountDetailsDao(IAccountDetailsDao iAccountDetailsDao) {
        this.iAccountDetailsDao = iAccountDetailsDao;
    }
    public List showAccountDetails() {
        System.out.println("AccountDetails--showAccountDetails");
        return iAccountDetailsDao.showAccountDetails();
    }
}

com\web\spring\account\Account.java
===================================

package com.web.spring.account;

/**
* @author Pedababu M
*
*/
public class Account {
    private String accountName;
    private String accountType;
    /**
    * @return the accountName
    */
    public String getAccountName() {
        return accountName;
    }
    /**
    * @param accountName the accountName to set
    */
    public void setAccountName(String accountName) {
        this.accountName = accountName;
    }
    /**
    * @return the accountType
    */
    public String getAccountType() {
        return accountType;
    }
    /**
    * @param accountType the accountType to set
    */
    public void setAccountType(String accountType) {
        this.accountType = accountType;
    }
    /**
    * @return the accountID
    */
    public String getAccountID() {
        return accountID;
    }
    /**
    * @param accountID the accountID to set
    */
    public void setAccountID(String accountID) {
        this.accountID = accountID;
    }
    /**
    * @return the accountBlance
    */
    public int getAccountBlance() {
        return accountBlance;
    }
    /**
    * @param accountBlance the accountBlance to set
    */
    public void setAccountBlance(int accountBlance) {
        this.accountBlance = accountBlance;
    }
    private String accountID;
    private int accountBlance;
}

account.jsp
==============================

<%@ include file="include.jsp"%>
<html>
<head>
<title>Account Details</title>
</head>
<body>
    <h3>Account Details</h3>
    <table>
        <tr>
            <th>Account Name</th>
            <th>Account Type</th>
            <th>Account ID</th>
            <th>Account Blance</th>
        </tr>
        <c:forEach items="${model.accounts}" var="account">
            <tr>
                <td><c:out value="${account.accountName}" /></td>
                <td><c:out value="${account.accountType}" /></td>
                <td><c:out value="${account.accountID}" /></td>
                <td><c:out value="${account.accountBlance}" /><td>
            </tr>
        </c:forEach>
    </table>
    Click Here to <a href="/SpringJDBC/userlogin.obj">Logout</a>
</body>
</html>

hello.jsp
=======================
<%@ include file="include.jsp" %>
<html>
<body>
<h1>Welcome to Spring!!</h1>
Click Here to <a href="/SpringJDBC/userlogin.obj">Login</a>
</body>
</html>

include.jsp
========================
<%@ page session="false" %>
<%@ taglib uri="/WEB-INF/c.tld" prefix="c" %>
<%@ taglib uri="/WEB-INF/fmt.tld" prefix="fmt" %>

error.jsp
==================================
<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
    pageEncoding="ISO-8859-1"%>
<!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=ISO-8859-1">
<title>Insert title here</title>
</head>
<body>
Invalid user details
</body>
</html>

index.jsp
================================
<%@ include file="include.jsp" %>

<c:redirect url="hello.obj" />

login.jsp
=================================
<%@ include file="include.jsp" %>
<%@ taglib uri="/WEB-INF/spring.tld" prefix="spring" %>
<html>
<body>
<form method="post">

<br>Enter username:
<spring:bind path="user.username">
<input type="text" name="username" value="<c:out value="${status.value}"/>">
<i><c:out value="${status.errorMessage}"/></i>
</spring:bind>

<br>Enter password:
<spring:bind path="user.password">
<input type="text" name="password" value="<c:out value="${status.value}"/>">
<i><c:out value="${status.errorMessage}"/></i>
</spring:bind>
<br>
<input type="submit" value="Login">
</form>
</body>
</html>

sql script
===================================================================
create table user_800890(user_id int,user_name varchar, user_password varchar)
insert into user_800890 values (1,'testuser', 'testuser')

create table account_800890(account_id int,account_name varchar, account_type varchar, account_number varchar,
account_balance integer)
insert into account_800890 values (1,'Bob Checking', 'Checking', '111223333-C33',60000)
insert into account_800890 values (2,'Bob Savings', 'Savings', '111223333-C33',60000)
insert into account_800890 values (3,'Bob Current', 'Current', '111223333-C33',60000)

Java Stuff

Search This Blog

Wednesday 24 July 2013

Spring 2 MVC JdbcDaoSupport RowMapper Validator and Layers Demo

No comments:

Post a Comment