使用Maven构建spring JdbcTemplate项目

桃扇骨 2022-04-13 05:21 255阅读 0赞

1.新建Maven项目，配置pom.xml，引入需要的jar包

<?xml version="1.0" encoding="UTF-8"?>
    <project xmlns="http://maven.apache.org/POM/4.0.0"
             xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
             xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
        <modelVersion>4.0.0</modelVersion>
    
        <groupId>edu.njxz.demo</groupId>
        <artifactId>springTest</artifactId>
        <version>1.0-SNAPSHOT</version>
    
        <dependencies>
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-context</artifactId>
                <version>5.0.6.RELEASE</version>
            </dependency>
            <dependency>
                <groupId>junit</groupId>
                <artifactId>junit</artifactId>
                <version>4.12</version>
            </dependency>
            <dependency>
                <groupId>mysql</groupId>
                <artifactId>mysql-connector-java</artifactId>
                <version>5.1.47</version>
            </dependency>
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-jdbc</artifactId>
                <version>5.1.2.RELEASE</version>
            </dependency>
            <dependency>
                <groupId>commons-logging</groupId>
                <artifactId>commons-logging</artifactId>
                <version>1.2</version>
            </dependency>
        </dependencies>
    
    
    </project>

2.创建并编辑配置文件

<?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"
           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">
    
         
        <context:component-scan base-package="edu.njxz.demo"/>
    
        
        <bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
            
            <property name="driverClassName" value="com.mysql.jdbc.Driver"></property>
            
            <property name="url" value="jdbc:mysql://localhost:3306/pblog?characterEncoding=utf8"></property>
            
            <property name="username" value="root"></property>
            
            <property name="password" value="Root"></property>
        </bean>
    
        
        <bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">
            <property name="dataSource" ref="dataSource"></property>
        </bean>
    
    </beans>

3.创建实体类

public class User {
        private int userId;
        private String userName;
        private String userPwd;
        private String userEmail;
    
        public int getUserId() {
            return userId;
        }
    
        public String getUserName() {
            return userName;
        }
    
        public String getUserPwd() {
            return userPwd;
        }
    
        public String getUserEmail() {
            return userEmail;
        }
    
        public void setUserId(int userId) {
            this.userId = userId;
        }
    
        public void setUserName(String userName) {
            this.userName = userName;
        }
    
        public void setUserPwd(String userPwd) {
            this.userPwd = userPwd;
        }
    
        public void setUserEmail(String userEmail) {
            this.userEmail = userEmail;
        }
    }

4.创建数据访问层Dao

public interface UserDao {
        int update(String sql,Object[] param);
        List<User> query(String sql,Object[] param);
    }

5.实现UserDao的接口类

@Repository("userDao")
    public class UserDaoImpl implements UserDao {
    
        //使用配置文件中的jdbc模板
        @Autowired
        private JdbcTemplate jdbcTemplate;
    
        /**
         * 更新方法
         * @param sql
         * @param param
         * @return
         */
        public int update(String sql, Object[] param) {
            return jdbcTemplate.update(sql,param);
        }
    
        /**
         * 查询方法
         * @param sql
         * @param param
         * @return
         */
        public List<User> query(String sql, Object[] param) {
            RowMapper<User> rowMapper=new BeanPropertyRowMapper<User>(User.class);
    
            return jdbcTemplate.query(sql,rowMapper,param);
        }
    }

6.创建测试类

public class Test {
        public static void main(String[] args) {
            //把beans.xml的类加载到容器
            ApplicationContext applicationContext=new ClassPathXmlApplicationContext("beans.xml");
    
            //从容器获取目标对象
            UserDao userDao= (UserDao) applicationContext.getBean("userDao");
    
            String insertSql="insert into p_user(user_name,user_pwd,user_email) values(?,?,?) ";
            Object param1[]={"神龟","123456","for@163.com"};
    
            userDao.update(insertSql,param1);
    
            String selectSql="select * from p_user ";
            List<User> userList=userDao.query(selectSql,null);
            for(User user:userList){
                System.out.println(user.getUserId()+" "+user.getUserName());
            }
        }
    }

7.运行结果  
[![springJdbcTemplate][]][springJdbcTemplate 1]

[springJdbcTemplate]: https://github.com/yangxuechen/learnSSM/raw/master/resource/sping-learn-images/springJdbcTemplate.jpg
[springJdbcTemplate 1]: https://github.com/yangxuechen/learnSSM/blob/master/resource/sping-learn-images/springJdbcTemplate.jpg