Spring注入JdbcTemplate空指针异常

最新推荐文章于 2021-02-28 16:00:01 发布

QQ669300324

最新推荐文章于 2021-02-28 16:00:01 发布

阅读量1.3k

点赞数 1

文章标签： Spring

本文链接：https://blog.csdn.net/QQ669300324/article/details/84353643

版权

applicationContext.xml配置文件如下：

<bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">
        <constructor-arg>
            <ref bean="dataSource" />
        </constructor-arg>
    </bean>
    <bean id="dataSource"
        class="org.springframework.jdbc.datasource.DriverManagerDataSource">
        <property name="driverClassName" value="oracle.jdbc.OracleDriver" />
        <property name="url">
            <value><![CDATA[jdbc:oracle:thin:@(description=(address_list=(address=(protocol=TCP)(port=1521)(host=192.168.1.201)))(connect_data=(SERVER = orcl)(SERVICE_NAME = orcl)))]]></value>
        </property>
        <property name="username" value="oms" />
        <property name="password" value="oms" />
    </bean>
     
    <bean id="test" class="com.yi.test.Test">
        <property name="template" ref="jdbcTemplate"></property>
    </bean>

java代码：

private JdbcTemplate template;
    public void work() {
        //在这里包空指针异常
        List<Map> list = template.queryForList("select * from OMS_ROLE_INFO");
        for (Map map : list) {
            System.out.println(map.get("jsmc"));
        }
    }
    public JdbcTemplate getTemplate() {
        return template;
    }
    public void setTemplate(JdbcTemplate template) {
        this.template = template;
    }
 
public static void main(String[] args) throws SQLException {
        ApplicationContext context = new ClassPathXmlApplicationContext("classpath:applicationContext.xml");
new Test().work();
    }

求解？