jdbctemplatetest.java

《精通Spring》源代码

/*
 * Created on 2004-11-13
 *
 * http://www.open-v.com 提供代码的维护工作
 */
package com.openv.spring;

import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;

import org.springframework.beans.factory.BeanFactory;
import org.springframework.beans.factory.xml.XmlBeanFactory;

import org.springframework.core.io.ClassPathResource;
import org.springframework.core.io.Resource;

import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.jdbc.core.RowCountCallbackHandler;


/**
 * JdbcTemplateTest客户应用
 *
 * @author luoshifei
 */
public class JdbcTemplateTest {
    protected static final Log log = LogFactory.getLog(JdbcTemplateTest.class);

    public static void main(String[] args) {
        Resource resource = new ClassPathResource("appcontext.xml");
        BeanFactory factory = new XmlBeanFactory(resource);
        JdbcTemplate jt = (JdbcTemplate) factory.getBean("jdbcTemplate");
        RowCountCallbackHandler rcch = new RowCountCallbackHandler();
        jt.query("select * from jdbctemplate", rcch);
        log.info("结果集中的列数量：" + rcch.getColumnCount());
        log.info("结果集中的行数量：" + rcch.getRowCount());
        log.info("结果集中的列名：");

        String[] str = rcch.getColumnNames();

        for (int i = 0, k = str.length; i < k; ++i) {
            log.info(str[i]);
        }
    }
}