今日完成的事情：

1）  完成jdbctemplate的增删改查操作

 项目结构：

              Domain封装了User对象，UserMapper用于查询时候的映射关系

              DBUtils用于获取jdbctemplate

               Pom.xml文件：

<?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>com.itschool</groupId>
    <artifactId>Test</artifactId>
    <version>1.0-SNAPSHOT</version>
    <properties>
        <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
    </properties>

    <dependencies>
        <dependency>
            <groupId>junit</groupId>
            <artifactId>junit</artifactId>
            <version>3.8.1</version>
            <scope>test</scope>
        </dependency>
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-beans</artifactId>
            <version>4.2.5.RELEASE</version>
        </dependency>
        <dependency>
            <groupId>com.mchange</groupId>
            <artifactId>c3p0</artifactId>
            <version>0.9.5.2</version>
        </dependency>
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-jdbc</artifactId>
            <version>4.2.5.RELEASE</version>
        </dependency>
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>5.1.38</version>
        </dependency>
        <dependency>
            <groupId>com.mchange</groupId>
            <artifactId>mchange-commons-java</artifactId>
            <version>0.2.11</version>
        </dependency>
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-context</artifactId>
            <version>4.2.5.RELEASE</version>
        </dependency>
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-aop</artifactId>
            <version>4.2.5.RELEASE</version>
        </dependency>
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-jdbc</artifactId>
            <version>4.2.5.RELEASE</version>
        </dependency>
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-jdbc</artifactId>
            <version>4.2.5.RELEASE</version>
        </dependency>
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-jdbc</artifactId>
            <version>4.2.5.RELEASE</version>
        </dependency>
    </dependencies>


</project>

                增加操作：

public void add(User user) {
    jdbcTemplate= DBUtils.getJdbcTemplate();
    String sql="insert into t_sign values(?,?,?,?,?,?,?,?,?,?,?,?)";
    jdbcTemplate.update(sql,user.getID(),user.getName(),
            user.getQq(),user.getLearn_type(),
            user.getCreate_time(),user.getSchool(),user.getDaily_url(),user.getFlag(),
            user.getSenior(),user.getSource(),user.getUpdate_at(),user.getCreate_at());

}

查询单个用户：

public User findById(Long id) {
    jdbcTemplate=DBUtils.getJdbcTemplate();
    String sql="select * from t_sign where ID=?";
    List<User> users=jdbcTemplate.query(sql,new UserMapper(),id);
    if (users!=null&&users.size()>0){
        return users.get(0);
    }

    return null;

}

    根据id删除用户：

 public void deleteById(Long id) {
     jdbcTemplate=DBUtils.getJdbcTemplate();
     String sql="DELETE  from t_sign where ID=?";
     jdbcTemplate.update(sql,id);
 
 }

 根据id更新用户

public void update(User user) {
    jdbcTemplate=DBUtils.getJdbcTemplate();

    String sql="update t_sign set name=?,qq=?,learn_type=?," +
            "create_time=?,school=?,daily_url=?,flag=?,senior=?,source=?," +
            "create_at=?,update_at=? where ID=?";

    jdbcTemplate.update(sql,user.getName(),user.getQq(),
                        user.getLearn_type(),user.getCreate_time(),
                        user.getSchool(),user.getDaily_url(),user.getFlag(),
                        user.getFlag(),user.getSource(),user.getCreate_at(),
                        user.getUpdate_at(),user.getID());
}

             2）学习了junit与spring框架的整合，junit的测试。具体代码还没写完，明天一并叫上。

           ps：今天放假第一天开学，课程比较多，时间不太充足，进度没赶上，明天补上。

明日任务：

     完成spring与junit整合并进行测试，继续完成接下来的任务。