Spring JDBC访问数据库（properties）

最新推荐文章于 2024-11-24 11:15:00 发布

原创最新推荐文章于 2024-11-24 11:15:00 发布 · 112 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#JDBC #Spring #AOP #Bean #MySQL

spring 专栏收录该内容

17 篇文章

订阅专栏

本文详细介绍了Spring框架中bean.xml文件的配置方法，包括使用PropertyPlaceholderConfigurer读取外部属性文件，通过BasicDataSource设置数据源参数，以及AOP切面编程的应用实例。

bean.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" xmlns:context="http://www.springframework.org/schema/context"
	xmlns:aop="http://www.springframework.org/schema/aop"
	xsi:schemaLocation="http://www.springframework.org/schema/beans
           http://www.springframework.org/schema/beans/spring-beans-2.5.xsd
           http://www.springframework.org/schema/context
           http://www.springframework.org/schema/context/spring-context-2.5.xsd
           http://www.springframework.org/schema/aop
           http://www.springframework.org/schema/aop/spring-aop-2.5.xsd">
	<context:annotation-config />
	<context:component-scan base-package="com.lbx" />

	<bean class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
		<property name="locations" value="classpath:jdbc.properties" />
	</bean>



	<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource"
		destroy-method="close">
		<property name="driverClassName" value="${jdbc.driverClassName}" />
		<property name="url" value="${jdbc.url}" />
		<property name="username" value="${jdbc.username}" />
		<property name="password" value="${jdbc.password}" />
	</bean>


	<!--
		<bean id="myDataSource"
		class="org.apache.commons.dbcp.BasicDataSource"
		destroy-method="close"> <property name="driverClassName"
		value="com.mysql.jdbc.Driver" /> <property name="url"
		value="jdbc:mysql://localhost:3306/testhib" /> <property
		name="username" value="root" /> <property name="password" value="root"
		/> </bean>
	-->


	<bean id="logInterceptor" class="com.lbx.aop.LogInterceptor"></bean>
	<aop:config>
		<aop:pointcut expression="execution(public * com.lbx.dao..*.*(..))"
			id="servicePointCut" />
		<aop:aspect id="logAspect" ref="logInterceptor">
			<aop:before method="before" pointcut-ref="servicePointCut" />
			<aop:after method="afterReturning" pointcut-ref="servicePointCut" />
		</aop:aspect>
	</aop:config>

</beans>

jdbc.properties文件的配置

jdbc.driverClassName=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/testhib
jdbc.username=root
jdbc.password=root