Steps to configure and use Mysql database with Spring MVC 3.0 without using hibernate.

[Prashant Chindhade]

Hi everyone
I am new to spring MVC and I am using spring MVC 3.0.4.

I need to use jdbc with mysql server.

can anyone provide me link for step by step tutorial for configuration. it will be helpful for me.

thanks
Prashant

[Bill Gorder]

assuming you are using XML config

<?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:context="http://www.springframework.org/schema/context"
    xsi:schemaLocation="
        http://www.springframework.org/schema/beans
        http://www.springframework.org/schema/beans/spring-beans-3.0.xsd
        http://www.springframework.org/schema/context
        http://www.springframework.org/schema/context/spring-context-3.0.xsd">
    

    
    <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
        <property name="driverClassName" value="${jdbc.driverClassName}"/>
        <property name="url" value="${jdbc.url}"/>
        <property name="username" value="${jdbc.username}"/>
        <property name="password" value="${jdbc.password}"/>
    </bean>


    <bean name="jdbcTemplate" class="org.springframework.data.jdbc.core.JdbcTemplate">
        <constructor-arg name="dataSource" ref="dataSource"/>
    </bean>

    <context:property-placeholder location="jdbc.properties"/>

</beans>

You could shorten that up a bit by using the p and c namespaces but it gives you the idea. Put your properties in a file named jdbc.properties on the classpath.

Once you have that you can @Autowire in you jdbcTemplate and use that to execute queries.