3

用spring 创建ComboPooledDataSource和JdbcTemplate对象

 2 years ago
source link: https://blog.51cto.com/u_15707781/5724417
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
neoserver,ios ssh client

用spring 创建ComboPooledDataSource和JdbcTemplate对象

精选 原创

呆萌老师博客号 2022-09-29 23:00:35 博主文章分类：JAVA基础学习 ©著作权

文章标签 spring xml 文章分类 Java 编程语言 yyds干货盘点 阅读数194

用spring 创建ComboPooledDataSource和JdbcTemplate对象
3.1添加ioc相关jar包

<dependency>
  <groupId>org.springframework</groupId>
  <artifactId>spring-core</artifactId>
  <version>4.3.18.RELEASE</version>
</dependency>
<dependency>
  <groupId>org.springframework</groupId>
  <artifactId>spring-beans</artifactId>
  <version>4.3.18.RELEASE</version>
</dependency>
<dependency>
  <groupId>org.springframework</groupId>
  <artifactId>spring-context</artifactId>
  <version>4.3.18.RELEASE</version>
</dependency>
<dependency>
  <groupId>org.springframework</groupId>
  <artifactId>spring-context-support</artifactId>
  <version>4.3.18.RELEASE</version>
</dependency>
<dependency>
  <groupId>org.springframework</groupId>
  <artifactId>spring-expression</artifactId>
  <version>4.3.18.RELEASE</version>
</dependency>
3.2创建db.properties文件
driverClass=com.mysql.jdbc.Driver
url=jdbc:mysql://localhost:3306/ssm
user=root
password=123
3.3在applicationContext.xml文件中创建对象
<context:property-placeholder location="db.properties"></context:property-placeholder>

<!-- 创建一个连接池对象 -->
<bean id="comboPooledDataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
   <property name="driverClass" value="${driverClass}" />
    <property name="jdbcUrl" value="${url}"/>
    <property name="user" value="${user}" />
    <property name="password" value="${password}" />
</bean>
<!-- 创建一个jdbcTemplate对象 并且通过构造函数 将连接池对象 注入到jdbcTemplate -->
<bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate" >
    <constructor-arg name="dataSource" ref="comboPooledDataSource" />
</bean>
3.4 修改dao 层
@Component
public class UsersDao implements IUsersDao {

//注入jdbcTemplate对象
    @Autowired
    private JdbcTemplate jdbcTemplate;

public JdbcTemplate getJdbcTemplate() {
        return jdbcTemplate;
    }

public void setJdbcTemplate(JdbcTemplate jdbcTemplate) {
        this.jdbcTemplate = jdbcTemplate;
    }

//update方法 (增 删 改)
    @Override
    public void add(Users user) {

String sql = "insert into users values(null,?,?)";

jdbcTemplate.update(sql, user.getUname(), user.getPassword());

}
3.5测试
@Test
public void test()
{
    ClassPathXmlApplicationContext applicationContext=new ClassPathXmlApplicationContext("applicationContext.xml");

IUsersDao usersDao=  applicationContext.getBean("usersDao",IUsersDao.class);

Users user=new Users("xiaowanglaoshi","123");

usersDao.add(user);
}

            

        
        
        
    

    

        
  • 
                
                    
                    赞
                
            
    • 
            
  • 
                
                    
                    收藏
                
            
    • 
            
  • 
                
                    
                    评论
                
            
    • 
            
  • 
                
                    
                    分享
                
            
    • 
                            
  • 
                    
                        
                        举报
                    
                
    • 
                    

    
    


        

        

            

                report
            

        

    







        
Recommend

        



                

    
About Joyk

    
 





Aggregate valuable and interesting links.

Joyk means Joy of geeK