OracleDataSource java spring jdbctemplate demo

package com.liuliu.test.db;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

import org.springframework.jdbc.core.BeanPropertyRowMapper;
import org.springframework.jdbc.core.RowMapper;
import org.springframework.jdbc.core.simple.SimpleJdbcTemplate;

import oracle.jdbc.pool.OracleDataSource;

public class OracleTest {
	/**
	 * @param args
	 * @throws SQLException
	 */
	public static void main(String[] args) throws SQLException {
		// TODO Auto-generated method stub
		OracleDataSource ds = new OracleDataSource();
		ds.setDriverType("thin");
		ds.setServerName("11111111");
		ds.setPortNumber(1521);
		ds.setDatabaseName("1111111111");
		ds.setUser("1111111111");
		ds.setPassword("11111111111");
		SimpleJdbcTemplate simpleJdbcTemplate = new SimpleJdbcTemplate(ds);
		String sql = "select tb from tbool";
		RowMapper<Tbool> rm = new RowMapper<Tbool>() {
			public Tbool mapRow(ResultSet rs, int i) throws SQLException {
				Tbool tb = new Tbool();
				tb.setTb(rs.getBoolean("tb"));
				return tb;
			}
		};
		List<Tbool> result = simpleJdbcTemplate.query(sql, rm);
		for (Tbool tb : result) {
			System.out.println(tb.isTb());
		}
		List<Tbool> result2 = simpleJdbcTemplate.query(sql,
				new BeanPropertyRowMapper<Tbool>(Tbool.class));
		for (Tbool tb : result2) {
			System.out.println(tb.isTb());
		}
		sql = "update TBOOL set tb = :tb";
		simpleJdbcTemplate.update(sql, true);
	}
}