testjdbc.java

来自「自己做的关于spring框架的使用」· Java 代码 · 共 53 行

package myspring.v3.test;

import myspring.v3.jdbc.*;

import java.sql.ResultSet;
import java.sql.SQLException;

import java.util.ArrayList;

import org.springframework.context.ApplicationContext;
import org.springframework.context.support.FileSystemXmlApplicationContext;
import org.springframework.core.io.ClassPathResource;
import org.springframework.core.io.Resource;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.jdbc.core.RowCallbackHandler;
import org.springframework.jdbc.core.RowCountCallbackHandler;


public class TestJDBC {

	/**
	 * @param args
	 */
	public static void main(String[] args) {
		// TODO Auto-generated method stub
		
		ApplicationContext ctx = new FileSystemXmlApplicationContext("bean.xml");
		JdbcTemplate jt = (JdbcTemplate)ctx.getBean("dbtest");
		
		//创建数据库
		jt.execute(SqlStatement.createSql);
		//插入数据
		jt.execute(SqlStatement.insertSql);
		jt.execute(SqlStatement.insertSqlAgain);
		
		//获得表中的数据信息
		RowCountCallbackHandler rh = new RowCountCallbackHandler();
		jt.query(SqlStatement.selectSql, rh);
		System.out.println("列数：" + rh.getColumnCount());
		System.out.println("行数：" + rh.getRowCount());
		//获得列名
		String[] names = rh.getColumnNames();
		for(int i = 0; i < names.length; i++){
			System.out.println(names[i] + ",");
		}
		
		//取得表中的数据
		
		
	}

}