spring_demo14——使用JdbcTemplate操作数据库--IDEA准备工作

使用IDEA新建Java项目

1.引入相应的jar包
2.新建test.xml配置文件，引入context和aop名称空间

<?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.xsd
                            http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context.xsd
                            http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop.xsd">

</beans>

3.在test.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.xsd
                            http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context.xsd
                            http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop.xsd">

    
    
<!--    配置数据库的连接池-->
    <bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource" destroy-method="clone">
        <property name="driverClassName" value="com.mysql.jdbc.Driver"></property>
        <property name="url" value="jdbc:mysql:///user_db"></property>
        
        <property name="username" value="root"></property>
        <property name="password" value="1234"></property>
<!--        这里的用户名和密码要和我们安装MySQL是设置的保持一致-->
    </bean>
    
</beans>

4.配置JdbcTemplate对象，并将上面创建的数据库连接池注入到JdbcTemplate对象中

<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.xsd
                            http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context.xsd
                            http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop.xsd">



<!--    配置数据库的连接池-->
    <bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource" destroy-method="clone">
        <property name="driverClassName" value="com.mysql.jdbc.Driver"></property>
        <property name="url" value="jdbc:mysql:///user_db"></property>

        <property name="username" value="root"></property>
        <property name="password" value="1234"></property>
<!--        这里的用户名和密码要和我们安装MySQL是设置的保持一致-->
    </bean>

<!--    创建JdbcTemplate对象-->
    <bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">
<!--        并将上面创建的数据库连接池注入到JdbcTemplate对象中-->
        <property name="dataSource" ref="dataSource"></property>
    </bean>

</beans>

5.创建BookService类，创建接口DaoInterface，创建接口实现类BookDao
（1）创建BookService类

package com.shunde.spring;

public class BookService {
}

（2）创建接口DaoInterface

package com.shunde.spring;

public interface DaoInterface{
}

（3）创建接口实现类BookDao

package com.shunde.spring;

public class BookDao implements DaoInterface{
}

（4）在BookService类中注入BookDao类对象

package com.shunde.spring;

import org.springframework.beans.factory.annotation.Autowired;

public class BookService {
    
    //注入BookDao类对象
    @Autowired
    private BookDao bookDao;
}

（5）在BookDao类中注入JdbcTemplate对象

package com.shunde.spring;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.jdbc.core.JdbcTemplate;

import java.util.PrimitiveIterator;

public class BookDao implements DaoInterface{
    
    //注入JdbcTemplate类对象
    @Autowired
    private JdbcTemplate jdbcTemplate;
}

（6）使用注解方式创建BookService类对象和BookDao类对象

package com.shunde.spring;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Component;


@Component   //创建对象
public class BookService {

    //注入BookDao类对象
    @Autowired
    private BookDao bookDao;
}

package com.shunde.spring;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.stereotype.Component;

import java.util.PrimitiveIterator;


@Component  //创建对象
public class BookDao implements DaoInterface{

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

（7）在test.xml文件中开启注解扫描

<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.xsd
                            http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context.xsd
                            http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop.xsd">

<!--    开启注解扫描-->
    <context:component-scan base-package="com.shunde.spring"></context:component-scan>
    

<!--    配置数据库的连接池-->
    <bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource" destroy-method="clone">
        <property name="driverClassName" value="com.mysql.jdbc.Driver"></property>
        <property name="url" value="jdbc:mysql:///user_db"></property>

        <property name="username" value="root"></property>
        <property name="password" value="1234"></property>
<!--        这里的用户名和密码要和我们安装MySQL是设置的保持一致-->
    </bean>

<!--    创建JdbcTemplate对象-->
    <bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">
<!--        并将上面创建的数据库连接池注入到JdbcTemplate对象中-->
        <property name="dataSource" ref="dataSource"></property>
    </bean>

</beans>

准备工作完成