Spring实战——属性占位符配置器

野性酷女 2021-07-24 20:29 353阅读 0赞

**一 配置文件**

<?xml version="1.0" encoding="GBK"?>
    <beans xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xmlns="http://www.springframework.org/schema/beans"
         xmlns:p="http://www.springframework.org/schema/p"
         xsi:schemaLocation="http://www.springframework.org/schema/beans
         http://www.springframework.org/schema/beans/spring-beans-4.0.xsd">
         
         <bean class=
               "org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
               <property name="locations">
                    <list>
                         <value>dbconn.properties</value>
                         
                         
                    </list>
               </property>
         </bean>
         
         <bean id="dataSource"  class="com.mchange.v2.c3p0.ComboPooledDataSource"
               destroy-method="close"
               p:driverClass="${jdbc.driverClassName}"
               p:jdbcUrl="${jdbc.url}"
               p:user="${jdbc.username}"
               p:password="${jdbc.password}"/>
    </beans>

**二 数据库配置属性**

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

**三 测试类**

package lee;
    
    import javax.sql.DataSource;
    import java.sql.*;
    
    import org.springframework.context.*;
    import org.springframework.context.support.*;
    
    public class BeanTest
    {
        public static void main(String[] args)throws Exception
        {
            ApplicationContext ctx = new
                ClassPathXmlApplicationContext("beans.xml");
            DataSource ds = (DataSource)ctx.getBean("dataSource");
            Connection conn = ds.getConnection();
            PreparedStatement pstmt = conn.prepareStatement(
                "insert into news_inf value(null , ? , ?)");
            pstmt.setString(1 , "疯狂Java讲义1");
            pstmt.setString(2 , "Struts 2权威指南2");
            pstmt.executeUpdate();
            pstmt.close();
            conn.close();
        }
    }

**四 测试结果**

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2NoZW5ncWl1bWluZw_size_16_color_FFFFFF_t_70][]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2NoZW5ncWl1bWluZw_size_16_color_FFFFFF_t_70]: /images/20210724/37cb95c8b4414f839c81e7898f91057f.png