在不能使用Hibernate时,Spring JDBC还是非常好用的。
其基本框架:
在src下新建jdbc.xml
然后是类:
其基本框架:
在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);
}
}