Spring jdbc

在不能使用Hibernate时，Spring JDBC还是非常好用的。
其基本框架：

在src下新建jdbc.xml

<?xml version="1.0" encoding="UTF-8"?>
<beans
	xmlns="http://www.springframework.org/schema/beans"
	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-2.5.xsd">

  <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">
    <property name="driverClassName">
      	<value>oracle.jdbc.driver.OracleDriver</value>
    </property>
    <property name="url">
      	<value>jdbc:oracle:thin:@192.168.1.2:1521:db</value>
    </property>
    <property name="username">
      	<value>user</value>
    </property>
    <property name="password"> 
      	<value>pwd</value>
    </property>
    <property name="maxActive">
    	<value>100</value>
    </property>
    <property name="maxIdle">
    	<value>20</value>
    </property>
  </bean>
  <bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">
    <property name="dataSource">
      <ref local="dataSource"/>
    </property>
  </bean>
  <bean id="dao" class="test.DBUtil">
    <property name="template">
      <ref local="jdbcTemplate"/>
    </property>
  </bean>
</beans>

然后是类：

public class DBUtil {

	private static JdbcTemplate template;

	public void setTemplate(JdbcTemplate template)
	{
		this.template = template;
	}

	static {
		new ClassPathXmlApplicationContext("jdbc.xml");
	}

	public static int count()
	{
		String sql = "select count(*) from T_table";
		int no = template.queryForInt(sql);
		return no;
	}
	
	public static void executeSql(String sql) {
		template.execute(sql);
	}
	
	public static void call() {
//		template.call(arg0, arg1);
	}
}