Spring中使用mysql数据库的方法

需要基本的Maven依赖

<!-- jbpc驱动 -->
<dependency>
    <groupId>commons-dbcp</groupId>
    <artifactId>commons-dbcp</artifactId>
    <version>1.4</version>
</dependency>
<!-- mysql -->
<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
    <version>5.1.37</version>
</dependency>

Spring配置

<!-- 连接数据库 -->
<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
    <property name="configLocation" value="classpath:mybatis-config.xml" />
    <property name="dataSource" ref="dataSource" />
</bean>

<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">
    <property name="driverClassName" value="com.mysql.jdbc.Driver">
    </property>
    <property name="url" value="jdbc:mysql://localhost:3306/teworks" >
    </property>
    <property name="username" value="root"></property>
    <property name="password" value="123"></property>
</bean>

<!-- ***事务** -->
<bean name="transactionManager"
    class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
    <property name="dataSource" ref="dataSource"></property>
</bean>
<tx:advice id="userTxAdvice" transaction-manager="transactionManager">
    <tx:attributes>
        <tx:method name="delete*" propagation="REQUIRED" read-only="false"
            rollback-for="java.lang.Exception" no-rollback-for="java.lang.RuntimeException" />
        <tx:method name="insert*" propagation="REQUIRED" read-only="false"
            rollback-for="java.lang.RuntimeException" />
        <tx:method name="update*" propagation="REQUIRED" read-only="false"
            rollback-for="java.lang.Exception" />

        <tx:method name="add*" propagation="REQUIRED" read-only="false"
            rollback-for="java.lang.Exception" />                
        <tx:method name="modify*" propagation="REQUIRED" read-only="false"
            rollback-for="java.lang.Exception" />    

        <tx:method name="find*" propagation="SUPPORTS" />
        <tx:method name="get*" propagation="SUPPORTS" />
        <tx:method name="select*" propagation="SUPPORTS" />

        <tx:method name="*" propagation="REQUIRED" read-only="false"
            rollback-for="java.lang.Exception" />
    </tx:attributes>
</tx:advice>

注意

这是基本的数据库连接方式 ,需要结合其他ORM框架进行访问,比如Hibernate 和 Mybatis等等,关于Hibernate和Mybatis究竟需要哪些包以及如何配置,请查阅其他资料。

本站总访问量