spring框架程序开发模式详解

spring程序开发模式

今天来的挺早，继续更新！相信学完spring框架后，我们能对spring的开发模式与之前传统模式有一个比较，下面就对spring开发模式作一个较为全面的诠释吧。

1. 功能需求：从数据库中查询所有的数据，采用jdbc开发，并将查询结果输入到控制台上
2. IDEA创建一个普通的maven工程，并导入相应的依赖。（此处涉及数据库操作）

 <dependencies>
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-context</artifactId>
            <version>5.0.2.RELEASE</version>
        </dependency>
        <dependency>
            <groupId>commons-logging</groupId>
            <artifactId>commons-logging</artifactId>
            <version>1.1.3</version>
        </dependency>
        <dependency>
            <groupId>log4j</groupId>
            <artifactId>log4j</artifactId>
            <version>1.2.12</version>
        </dependency>
        <dependency>
            <groupId>junit</groupId>
            <artifactId>junit</artifactId>
            <version>4.12</version>
            <scope>test</scope>
        </dependency>

        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>druid</artifactId>
            <version>1.1.10</version>
        </dependency>

        <!-- https://mvnrepository.com/artifact/mysql/mysql-connector-java -->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>5.1.6</version>
        </dependency>

    </dependencies>

3.创建包pojo并编写对应的实体类User

public class User implements Serializable {

    private Integer id;
    private String uesrname;
    private Date birthday;
    private String sex;
    private String address;
get.set方法以及toString()方法省略

4.创建包dao并编写对应的持久层接口UserDao以及实现类UesrDaoImpl

public interface UserDao {

    List<User> selectAll();
}

public class UserDaoImpl implements UserDao {
  //注入数据源
    private DataSource dataSource;

    public void setDataSource(DataSource dataSource) {
        this.dataSource = dataSource;
    }

    public List<User> selectAll() {
        List<User> list = new ArrayList<User>();
        Connection connection = null;
        PreparedStatement stmt = null;
        ResultSet rs = null;
        try {
            // 获取连接
            connection = dataSource.getConnection();
            // 编写sql语句
            String sql = "select * from user";
            // 预编译
            stmt = connection.prepareStatement(sql);
            // 查询
            rs = stmt.executeQuery();
            // 遍历，封装数据
            while (rs.next()){
                User user = new User();
                user.setId(rs.getInt("id"));
                user.setUesrname(rs.getString("username"));
                list.add(user);
            }
        } catch (SQLException e) {
            e.printStackTrace();
        }finally {
            try {
                connection.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
            try {
                stmt.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
            try {
                rs.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
        return list;

    }
}

5.创建包service并编写对应的业务层接口UserService以及实现类UesrServiceImpl

public interface UserService {

    List<User> queryAll();
}

public class UserServiceImpl implements UserService {
   //注入userDao对象
    private UserDao userDao;

    public void setUserDao(UserDao userDao) {
        this.userDao = userDao;
    }

    public List<User> queryAll() {
        return userDao.selectAll();
    }
}

6.在resources文件下创建applicationContext.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"
       xsi:schemaLocation="
        http://www.springframework.org/schema/beans
        http://www.springframework.org/schema/beans/spring-beans.xsd">

      <bean id="userService" class="UserServiceImpl全限定类名">
            <property name="userDao" ref="userDao"></property>
      </bean>


      <bean id="userDao" class="UserDaoImpl全限定类名">
         <property name="dataSource" ref="dataSource"></property>
      </bean>

      <bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource">
            <property name="driverClassName" value="com.mysql.jdbc.Driver"></property>
            <property name="url" value="jdbc:mysql://localhost:3306/mybatis"></property>
            <property name="username" value="root"></property>
            <property name="password" value="123456"></property>

      </bean>

</beans>

7.以上操作均已完成，现在只需在测试类中进行测试即可

public class test01 {
    @Test
    public void test(){
        ApplicationContext ac = new ClassPathXmlApplicationContext("applicationContext.xml");
        UserService userService = (UserService) ac.getBean("userService");
        List<User> list = userService.queryAll();
        for(User users : list){
            System.out.println(users);
        }
    }
}

8.在控制台中就可以看到如下查询结果，因为我只设置了id，username的值，所以其他属性值为空。

User{id=1, uesrname='老王', birthday=null, sex='null', address='null'}
User{id=2, uesrname='熊大', birthday=null, sex='null', address='null'}
User{id=3, uesrname='熊二', birthday=null, sex='null', address='null'}
User{id=4, uesrname='光头强', birthday=null, sex='null', address='null'}
User{id=5, uesrname='小明', birthday=null, sex='null', address='null'}
User{id=6, uesrname='小明', birthday=null, sex='null', address='null'}

9.完结，以上内容思路还是很清晰的，代码量很少，就没有过多解释。撒花！