Spring实战——Spring的Bean和JavaBean

偏执的太偏执、 2021-07-25 01:44 427阅读 0赞

**一 配置**

<?xml version="1.0" encoding="GBK"?>
    <beans xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xmlns="http://www.springframework.org/schema/beans"
         xsi:schemaLocation="http://www.springframework.org/schema/beans
         http://www.springframework.org/schema/beans/spring-beans-4.0.xsd">
         
         <bean id="dataSource"  class="com.mchange.v2.c3p0.ComboPooledDataSource"
               destroy-method="close">
               
               <property name="driverClass"  value="com.mysql.jdbc.Driver"/>
               
               <property name="jdbcUrl"  value="jdbc:mysql://localhost/spring"/>
               
               <property name="user" value="root"/>
               
               <property name="password" value="32147"/>
               
               <property name="maxPoolSize" value="200"/>
               
               <property name="minPoolSize" value="2"/>
               
               <property name="initialPoolSize" value="2"/>
               
               <property name="maxIdleTime" value="200"/>
         </bean>
    </beans>

**二 测试类**

package lee;
    
    
    import javax.sql.DataSource;
    import java.sql.*;
    
    
    import org.springframework.context.ApplicationContext;
    import org.springframework.context.support.ClassPathXmlApplicationContext;
    
    public class BeanTest
    {
        public static void main(String[] args)
            throws Exception
        {
            // 实例化Spring容器。Spring容器负责实例化Bean
            ApplicationContext ctx =
                new ClassPathXmlApplicationContext("beans.xml");
            // 获取容器中id为dataSource的Bean
            DataSource ds = ctx.getBean("dataSource", DataSource.class);
            // 通过DataSource来获取数据库连接
            Connection conn = ds.getConnection();
            // 通过数据库连接获取PreparedStatement
            PreparedStatement pstmt = conn.prepareStatement(
                "insert into news_inf values(null , ? , ?)");
            pstmt.setString(1 , "疯狂Java联盟成立了");
            pstmt.setString(2 , "疯狂Java地址：www.crazyit.org");
            // 执行SQL语句
            pstmt.executeUpdate();
            // 清理资源，回收数据库连接资源。
            if (pstmt != null)pstmt.close();
            if (conn != null)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/cb3f140835ac49b09aa6282726c3f165.png