spring_jdbc(轉)

1.

 引入spring能力:

  需要三個Libraries:

   Spring

3.0 Persistence JDBC Libraries -

<MyEclipse-Library>

   Spring 3.0 AOP Libraries -

   Spring 3.0 Core Libraries -

   Spring 3.0 Persistence Core

Libraries -

2.

 資料源(dataSource):

  <!--

1.org.springframework.jdbc.datasource.DriverManagerDataSource

經典jdbc連結的資料源,相當于每次使用DriverManager取得一個連結

  -->

  <!--bean

id="dataSource"

class="org.springframework.jdbc.datasource.DriverManagerDataSource">

   <property

name="driverClassName"

value="oracle.jdbc.driver.OracleDriver"/>

name="url"

value="jdbc:oracle:thin:@localhost:1521:moluo"/>

name="username" value="fengpeng"/>

name="password"

value="fengpeng"/>

  </bean-->

2.org.springframework.jdbc.datasource.SimpleDriverDataSource

和DriverManagerDataSource一樣

class="org.springframework.jdbc.datasource.SimpleDriverDataSource">

name="driverClass"

3.org.springframework.jdbc.datasource.SingleConnectionDataSource

無論怎麼取,都傳回同一個連接配接對象

class="org.springframework.jdbc.datasource.SingleConnectionDataSource">

4.用于實戰的資料源:org.apache.tomcat.dbcp.dbcp.BasicDataSource

需要引入Spring 3.0 Persistence JDBC Libraries(jar包)

或者使用第三方jar包:tomcat-dbcp.jar <bean id="dataSource"

class="org.apache.commons.dbcp.BasicDataSource">

class="org.apache.tomcat.dbcp.dbcp.BasicDataSource">

name="password" value="fengpeng"/>

name="maxActive" value="10"/>

name="maxIdle"

value="5"/>

  <bean

id="TestDao" class="dao.TestDaoImple">

name="dataSource"

ref="dataSource"/>

  </bean>

 3.JdbcTemplate對象的介紹

  在application.xml檔案中的配置:

   <bean

    <property

   </bean>

   <!--bean

id="connection" factory-bean="dataSource" factory-method="getConnection"

scope="prototype"></bean-->

id="jdbcTemplate"

class="org.springframework.jdbc.core.JdbcTemplate">

ref="dataSource"></property>

id="TestDao"

class="dao.TestDaoImple">

name="jdbcTemplate"

ref="jdbcTemplate"/>

  在dao.TestDaoImple類中定義JdbcTemplate

   private

JdbcTemplate jdbcTemplate;

   public void

setJdbcTemplate(JdbcTemplate jdbcTemplate)

{

    this.jdbcTemplate =

jdbcTemplate;

   }