Spring Struts implementation for Database conncetion problem in Login module

[sumanta panda]

Dear All,
I am a beginner of using spring concept. I am writing a small Login program using Struts and spring.I am just hard coded the string if the login id and Password is matching then it will go to welcome.jsp.It is working fine.

With this logic in BusinessDelegate.java it is working properly.
public String validateUser(String userName, String password) {
String data=null;


if(userName.equals("admin") && password.equals("123")) {
return "success";
}


return "failure";
}
I am calling validateUser() in LoginAction.java file.

target = businessDelegate.validateUser(loginForm.getUserName(),loginForm.getPassword());

But I want it should check with database level and if the login id and password matching then it will go to welcome page.

How can I write the syntax in BusinessDelegate.java so that it should work.
Like

private JdbcTemplate jdbcTemplate;

public void setDataSource(DataSource dataSource) {
this.jdbcTemplate = new JdbcTemplate(dataSource);
}
public String validateUser(String userName, String password) {


jdbcTemplate.queryForList("select login_name,password from ABC_USER where login_name='"+userName+"',password='"+password+"'");


if(rs.next())
{
return “success’;
}
Else
return “failure”;
}

[b]ApplicationContext.xml
<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource"
destroy-method="close">
<!-- <property name="driverClassName" value="com.mysql.jdbc.Driver"/>-->
<!-- <property name="url" value="jdbc:mysql://192.168.10.75:3306/komal"/>-->
<property name="driverClassName" value="com.jnetdirect.jsql.JSQLDriver"/>
<property name="url" value="jdbc:JSQLConnect://192.188.48.28/database=ABC_TEST"/>
<property name="username" value="test"/>
<property name="password" value="test"/>
</bean>
<bean id="lobHandler" class="org.springframework.jdbc.support.lob.OracleLobHandler">
<property name="nativeJdbcExtractor" ref="nativeJdbcExtractor"/>
</bean>
<bean id="nativeJdbcExtractor"
class="org.springframework.jdbc.support.nativejdbc.CommonsDbcpNativeJdbcExtractor"/>
<bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">
<property name="dataSource" ref="dataSource"/>
</bean>

[b]

This is the complete program which works fine with the hardcode string for login program.

Please suggest/rectify my code how it should work with checking the value in database level and if successful login then goto welcome page.
LoginForm.java

package struts.helloworld.form;

import javax.servlet.http.HttpServletRequest;

import org.apache.struts.action.ActionErrors;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionMapping;
import org.apache.struts.action.ActionMessage;

public class LoginForm extends ActionForm {

	private String userName;
	private String password;
	
	@Override
	public ActionErrors validate(ActionMapping mapping,
			HttpServletRequest request) {
	
		ActionErrors actionErrors = new ActionErrors();
		
		if(userName == null || userName.trim().equals("")) {
			actionErrors.add("userNName", new ActionMessage("error.username"));
		}
		try {
		if(password == null || password.trim().equals("")) {
			System.out.println("pass error");
			actionErrors.add("passwordd", new ActionMessage("error.password"));
		}
		}catch(Exception e) {
			e.printStackTrace();
		}
		return actionErrors ;
	}

LoginAction.java

package struts.helloworld.action;

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

import net.viralpatel.struts.helloworld.business.BusinessDelegate;
import net.viralpatel.struts.helloworld.form.LoginForm;

import org.apache.struts.action.Action;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;

public class LoginAction extends Action {
	
	private BusinessDelegate businessDelegate;
	
	public BusinessDelegate getBusinessDeletage() {
		return businessDelegate;
	}

	public void setBusinessDelegate(BusinessDelegate businessDeletage) {
		this.businessDelegate = businessDeletage;
	}

	public ActionForward execute(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response)
			throws Exception {
	
		String target = null;
		LoginForm loginForm = (LoginForm)form; 
		    
		target = businessDelegate.validateUser(loginForm.getUserName(), 
												loginForm.getPassword());
		
		return mapping.findForward(target);
	}

}

BusinessDelegate.java

[b]package struts.helloworld.business;
public class BusinessDelegate 
{
	
	public String validateUser(String userName, String password) {
	    String data=null;
	    
	  
		if(userName.equals("admin") && password.equals("123")) {
			return "success";
		}
		
		
		return "failure";
}
	
}[/b]

ApplicationContext.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:util="http://www.springframework.org/schema/util"
       xmlns:tx="http://www.springframework.org/schema/tx"
       xmlns:aop="http://www.springframework.org/schema/aop"
       xmlns:lang="http://www.springframework.org/schema/lang"
       xsi:schemaLocation="http://www.springframework.org/schema/beans 
       http://www.springframework.org/schema/beans/spring-beans-2.0.xsd
       http://www.springframework.org/schema/util 
       http://www.springframework.org/schema/util/spring-util-2.0.xsd
       http://www.springframework.org/schema/tx 
       http://www.springframework.org/schema/tx/spring-tx-2.0.xsd
       http://www.springframework.org/schema/aop 
       http://www.springframework.org/schema/aop/spring-aop-2.0.xsd
       http://www.springframework.org/schema/lang 
       http://www.springframework.org/schema/lang/spring-lang-2.0.xsd">
	
	
	
	<!-- Business Objects -->
	<bean id="businessDelegate" 
			class=" struts.helloworld.business.BusinessDelegate">
	</bean>

	<!-- Actions Classes -->    
	<bean name="/login" class=" struts.helloworld.action.LoginAction">
		<property name="businessDelegate"><ref local="businessDelegate"/></property>
	</bean>

Web.xml

<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	xmlns="http://java.sun.com/xml/ns/javaee"
	xmlns:web="http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd"
	xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd"
	id="WebApp_ID" version="2.5">
	<display-name>StrutsHelloWorld</display-name>
	<welcome-file-list>
		<welcome-file>index.jsp</welcome-file>
	</welcome-file-list>

	<servlet>
		<servlet-name>action</servlet-name>
		<servlet-class>
			org.apache.struts.action.ActionServlet
		</servlet-class>
		<init-param>
			<param-name>config</param-name>
			<param-value>/WEB-INF/struts-config.xml</param-value>
		</init-param>
		<load-on-startup>1</load-on-startup>
	</servlet>

	<servlet-mapping>
		<servlet-name>action</servlet-name>
		<url-pattern>*.do</url-pattern>
	</servlet-mapping>



</web-app>

Struts-config.xml

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

<!DOCTYPE struts-config PUBLIC
          "-//Apache Software Foundation//DTD Struts Configuration 1.2//EN"
          "http://jakarta.apache.org/struts/dtds/struts-config_1_2.dtd">

<struts-config>
	<form-beans>
		<form-bean name="LoginForm"
			type="net.viralpatel.struts.helloworld.form.LoginForm" />
	</form-beans>

	<global-exceptions></global-exceptions>
	<global-forwards></global-forwards>

	<action-mappings>
		<action path="/login" name="LoginForm" validate="true"
			input="/index.jsp"
			type="org.springframework.web.struts.DelegatingActionProxy">
			<forward name="success" path="/welcome.jsp" />
			<forward name="failure" path="/index.jsp" />
		</action>
	</action-mappings>


	<message-resources parameter="MessageResource"></message-resources>

	<plug-in className="org.springframework.web.struts.ContextLoaderPlugIn">
             <set-property property="contextConfigLocation" 
             	value="/WEB-INF/ApplicationContext.xml"/>
    </plug-in>
	
</struts-config>

Please suggest me the syntax of code how my BusinessDelegate.java and ApplicationContext.xml conncet with database and checking the userid and password.

Thanks in advance.

Regards,
Sumanta Panda

[David Newton]

That's a difficult message to read.

Is the issue that you don't know how to write Spring database code?

[sumanta panda]

Dear David,

My doubt is what is the piece of code or syntax i will write in BusinessDelegate.java so that it will check database level.
.
For example::

private JdbcTemplate jdbcTemplate; 

public void setDataSource(DataSource dataSource) { 
this.jdbcTemplate = new JdbcTemplate(dataSource); 
} 
public String validateUser(String userName, String password) { 


jdbcTemplate.queryForList("select login_name,password from ABC_USER where login_name='"+userName+"',password='"+password+"'"); 


if(rs.next()) //How can i store the value in result set
{ 
return “success’; 
} 
Else 
return “failure”; 
} 

Please suggest.


Thanks for the understanding.
Regards,
Sumanta Panda