spring + hibernate+ C3P0+MYSQL如何配置

2012-12-24

spring + hibernate+ C3P0+MYSQL怎么配置我为这个问题专门写了一个测试用例：看下面的几个文件：可能贴的顺

spring + hibernate+ C3P0+MYSQL怎么配置
我为这个问题专门写了一个测试用例：

看下面的几个文件：
可能贴的顺序上有点问题，楼主可以自己整理一下：

(1) applicationContext.xml

---------------------

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN 2.0//EN" "http://www.springframework.org/dtd/spring-beans-2.0.dtd">

<beans>

<bean id="propertyConfigurer" />
</property>
<property name="hibernateProperties">
   <props>
    <prop key="hibernate.dialect">org.hibernate.dialect.MySQLDialect</prop>
    <prop key="hibernate.show_sql">true</prop>
    <prop key="hibernate.format_sql">true</prop>
    <prop key="hibernate.jdbc.fetch_size">80</prop>
    <prop key="hibernate.jdbc.batch_size">35</prop>
   </props>
</property>
<property name="mappingResources">
   <list>
    <value>com/spring/demo/bean/mapping/Book.hbm.xml</value>
   </list>
</property>
</bean>


<bean id="transactionManager" />
</property>
</bean>


<bean id="baseTransactionProxy" abstract="true" />
</property>
<property name="transactionAttributes">
   <props>
    <prop key="insert*">PROPAGATION_REQUIRED</prop>
    <prop key="update*">PROPAGATION_REQUIRED</prop>
    <prop key="delete*">PROPAGATION_REQUIRED</prop>
    <prop key="*">PROPAGATION_REQUIRED,readOnly</prop>
   </props>
</property>
</bean>

<bean id="hibernate_BookDao" >
<property name="sessionFactory">
   <ref bean="sessionFactory"/>
</property>
</bean>

<bean id="hibernate_BookManager" parent="baseTransactionProxy">
<property name="target">
   <bean encoding="utf-8"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">

<hibernate-mapping>
    <class name="com.spring.demo.bean.Book" table="BOOK" >
        <id name="id" type="integer" length="11">
            <column name="id" />
            <generator />
        </id>

        <property name="name" column="NAME" type="string" length="60" ></property>

    </class>
</hibernate-mapping>
---------------

#mysql的造表语句，指定了数据库springdemo#
---------------------
MYSQL 的BOOK 表创建语句

CREATE DATABASE IF NOT EXISTS springdemo;

USE springdemo;

DROP TABLE IF EXISTS book ;

CREATE TABLE book(
id int(11) NOT NULL auto_increment COMMENT 'primary key',
    name varchar(60) default NULL COMMENT 'book name',
    PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='my book table';

---------------------

下面是我的测试方法：
===========

package com.spring.demo;

import java.util.ArrayList;
import java.util.List;

import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;

import com.spring.demo.bean.Book;
import com.spring.demo.manager.Hibernate_BookManager;

public class HibernateDemo {

/**
* @param args
*/
public static void main(String[] args) {
ApplicationContext context = new ClassPathXmlApplicationContext("applicationContext.xml") ;

Hibernate_BookManager manager = (Hibernate_BookManager)context.getBean("hibernate_BookManager");

List books = new ArrayList();

books.add(new Book("book_01"));
books.add(new Book("book_02"));
books.add(new Book("book_03"));
books.add(new Book("book_04"));

manager.insertBooks(books);

System.out.println("OK");

}

}

确信是调通的，
==================

热点排行

Mysql

spring + hibernate+ C3P0+MYSQL如何配置