java连接数据库配置及properties文件的读取

一, 连oracle

1, spring-mybatis.xml

其中读取properties文件的三种方式略有不同:

1.1 util:properties方式

       对应value值的读取:  value="#{jdbc['jdbc.driver']}

1.2 context:property-placeholder方式

        对应value值的读取: value="${jdbc.driver}

1.3 org.springframework.context.support.PropertySourcesPlaceholderConfigurer

       对应value值的读取: value="${jdbc.driver}

<?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:jdbc="http://www.springframework.org/schema/jdbc"  
	xmlns:jee="http://www.springframework.org/schema/jee" 
	xmlns:tx="http://www.springframework.org/schema/tx"
	xmlns:aop="http://www.springframework.org/schema/aop" 
	xmlns:mvc="http://www.springframework.org/schema/mvc"
	xmlns:util="http://www.springframework.org/schema/util"
	xmlns:jpa="http://www.springframework.org/schema/data/jpa"
	xsi:schemaLocation="
		http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.2.xsd
		http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-3.2.xsd
		http://www.springframework.org/schema/jdbc http://www.springframework.org/schema/jdbc/spring-jdbc-3.2.xsd
		http://www.springframework.org/schema/jee http://www.springframework.org/schema/jee/spring-jee-3.2.xsd
		http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-3.2.xsd
		http://www.springframework.org/schema/data/jpa http://www.springframework.org/schema/data/jpa/spring-jpa-1.3.xsd
		http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-3.2.xsd
		http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc-3.2.xsd
		http://www.springframework.org/schema/util http://www.springframework.org/schema/util/spring-util-3.2.xsd">
	
	
	<!-- 加载配置文件-1 -->
	<!-- <util:properties id="jdbc" location="classpath:conf/db.properties"/> -->
	<!-- 加载配置文件-2 -->
	<context:property-placeholder location="classpath:conf/db.properties" />
    
    <!-- 加载配置文件-3 读取多个properties文件 -->
    <!--<bean id="propertyConfigurer"         
        class="org.springframework.context.support.PropertySourcesPlaceholderConfigurer">
		<property name="locations">
			<list>
				<value>file:/app/pcbank/conf/cmbank.properties</value>
				<value>file:/app/pcbank/conf/redis.properties</value>
			</list>
		</property>
		<property name="ignoreUnresolvablePlaceholders" value="true" />
	</bean>-->
	
	<!-- 1.配置数据库连接池 -->
	<!-- 1.1 直接设置参数 -->
	<!-- <bean id="dbcp" 
	      class="org.apache.commons.dbcp.BasicDataSource">
	  <property name="driverClassName" value="oracle.jdbc.OracleDriver"></property>
	  <property name="url" value="jdbc:oracle:thin:@localhost:1521:XE"></property>
	  <property name="username" value="system"></property>
	  <property name="password" value="root"></property>
	</bean> -->
	<!-- 1.2 util:properties方式读取properties文件设置参数 -->
	<!-- <bean id="dbcp" 
	      class="org.apache.commons.dbcp.BasicDataSource">
	  <property name="driverClassName" value="#{jdbc['jdbc.driver']}"></property>
	  <property name="url" value="#{jdbc['jdbc.url']}"></property>
	  <property name="username" value="#{jdbc['jdbc.username']}"></property>
	  <property name="password" value="#{jdbc['jdbc.password']}"></property>
	</bean> -->
	<!-- 1.3 context:property-placeholder方式读取properties文件设置参数 -->
	<bean id="dbcp" 
	      class="org.apache.commons.dbcp.BasicDataSource">
	  <property name="driverClassName" value="${jdbc.driver}"></property>
	  <property name="url" value="${jdbc.url}"></property>
	  <property name="username" value="${jdbc.username}"></property>
	  <property name="password" value="${jdbc.password}"></property>
	</bean>
	
	<!-- 2.配置SqlSessionFactory处理类 -->
	<bean id="ssf" 
	      class="org.mybatis.spring.SqlSessionFactoryBean">
	  <!-- 指定连接池 -->
	  <property name="dataSource" ref="dbcp"></property>
	  <!-- 指定映射位置 -->
	  <property name="mapperLocations" 
	            value="classpath:mapper/*.xml"/>
	</bean>
	
	<!-- 3.配置mapper扫描 -->	
	<bean id="mapperScanner" 
	      class="org.mybatis.spring.mapper.MapperScannerConfigurer">
	  <property name="basePackage" value="cn.tedu.test.dao"></property>
	</bean>
	 
</beans>

2, db.properties

jdbc.driver=oracle.jdbc.OracleDriver
jdbc.url=jdbc:oracle:thin:@localhost:1521:XE
jdbc.username=system
jdbc.password=root

3, jar包

ojdbc-14.jar等相关jar包

 

二, 连MySQL

和连接oracle类似, db.properties

jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/test?characterEncoding=utf-8
jdbc.username=root
jdbc.password=123456aa