spring注入jdbctemplate空指针

aaaa8215 2012-09-17 01:20:35

import org.springframework.beans.factory.annotation.Autowired;

import org.springframework.jdbc.core.JdbcTemplate;

import org.springframework.jdbc.datasource.DataSourceUtils;

import org.springframework.stereotype.Service;



@Service("dbAccess")

public class DBAccess

{

    public int pidx = 1;

    public Connection conn = null;

    private boolean __count_records__ = false;

    private PreparedStatement __prod__ = null;

    

    @Autowired

    private JdbcTemplate jdbcTemplate;

    

	public synchronized void openConnection() throws Exception

    {

		System.out.println("jdbcTemplate :" + jdbcTemplate);

    	conn = jdbcTemplate.getDataSource().getConnection();

        pidx = 1;

    }



<?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:tx="http://www.springframework.org/schema/tx"

	xmlns:context="http://www.springframework.org/schema/context"  

	xmlns:mvc="http://www.springframework.org/schema/mvc"  

	xsi:schemaLocation="http://www.springframework.org/schema/beans 

	http://www.springframework.org/schema/beans/spring-beans-3.0.xsd 

	http://www.springframework.org/schema/tx 

	http://www.springframework.org/schema/tx/spring-tx-3.0.xsd

	http://www.springframework.org/schema/context

    http://www.springframework.org/schema/context/spring-context-3.0.xsd

	http://www.springframework.org/schema/mvc

    http://www.springframework.org/schema/mvc/spring-mvc-3.0.xsd">

    

	      <context:component-scan base-package="sms.framework" />  

	      

	       <bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">  

	          <property name="prefix" value="/WEB-INF/jsp/"/>

			  <property name="viewClass" value="org.springframework.web.servlet.view.JstlView"></property>

		   </bean>  

	        

	       <bean id="multipartResolver"  

	          class="org.springframework.web.multipart.commons.CommonsMultipartResolver"  

	       />  

	          	          

			<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://127.0.0.1:3306/webdb"/>

				<property name="username" value="root"/>

				<property name="password" value="900120"/>

				<property name="initialSize" value="10"/>

				<property name="maxActive" value="50"/>

				<property name="maxIdle" value="10"/>

				<property name="maxWait" value="1000"/>

				<property name="poolPreparedStatements" value="true"/>

			</bean>

			



			<bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate" >

				<property name="dataSource" ref="dataSource" />

			</bean>



			<bean id="transactionManager"

				class="org.springframework.jdbc.datasource.DataSourceTransactionManager">

				<property name="dataSource" ref="dataSource" />

			</bean>

			 

			<bean id="dbAccess" class="sms.framework.data.DBAccess">

				<property name="jdbcTemplate" ref="jdbcTemplate"></property>

			</bean>



			<tx:annotation-driven transaction-manager="transactionManager" proxy-target-class="true"/>  

	  </beans>

打印jdbctemplate一直是空的，是什么地方配置错了吗？