今天完成的内容：

1、JdbcTemplate编写途中遇到了beans问题，检查了很久没发现怎么错的。

然后重新进行了idea软件的学习，发现是 jar包加载部分没有成功，只添加到lib了，但是没有成功导入。

需要add library

2、applicationContext.xml文件没有识别到，通过copy path命令解决。

3、jdbcTemplate已成功连接数据库，并进行了增删查改操作。

DAO.java

import java.util.*;
public  interface DAO {
    public void insert(String name, long create_at, long update_at);
    public void update(String name, long update_at,String name2);
    public void delete(String name);
    public List<User> select(String name);
}

User.java

public class User {
    private int id;
    private String name;
    public int getId() {
        return id;
    }
    public void setId(int id) {
        this.id = id;
    }
    public String getName() {
        return name;
    }
    public void setName(String name) {
        this.name = name;
    }
}

DAOImpl.java

import java.sql.*;
import org.springframework.jdbc.core.*;
import java.util.*;


public class DAOImpl implements DAO {
    private ResultSet rs;

    private JdbcTemplate jdbcTemplate;
    public JdbcTemplate getJdbcTemplate() {
        return jdbcTemplate;
    }
    public void setJdbcTemplate(JdbcTemplate jdbcTemplate) {
        this.jdbcTemplate = jdbcTemplate;
    }
    long time =new java.util.Date().getTime();
    public void insert(String name,long create_at,long update_at){
        String sql ="insert into xzy_test1.baomingtie(name,create_at,update_at) values (?,?,?)";

            jdbcTemplate.update(sql,name,create_at,update_at);
    }
    public void update(String name,long update_at,String name2) {
        String sql = "update xzy_test1.baomingtie set name=?,update_at=? where name=?";

            jdbcTemplate.update(sql,new PreparedStatementSetter(){
                @Override
                public void setValues(PreparedStatement ps) throws SQLException {
                    ps.setString(1, name);
                    ps.setLong(2, update_at);
                    ps.setString(3, name2);
                }
        });
    }
      public void delete(String name){
              String sql = "delete from xzy_test1.baomingtie where name=?";
          jdbcTemplate.update(sql,
                  new Object[]{name},
                  new int[]{Types.VARCHAR});
      }
    public List<User> select(String name) {
        List<User> users = null;
        users= jdbcTemplate.query("select id from xzy_test1.baomingtie where name = ?", new Object[]{Types.VARCHAR}, new org.springframework.jdbc.core.RowMapper<User>() {
            @Override
            public User mapRow(ResultSet resultSet, int i) throws SQLException {
                User user = new User();
                user.setId(rs.getInt("id"));
                user.setName(rs.getString("name"));
                while(rs.next()) {
                    System.out.println(rs.getString("name")+" "+rs.getInt("id"));
                }
                return user;
            }
        });
        return (users != null && users.size() > 0) ? users : null;
    }
}

DAOtest.java

import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;

public class DAOtest {
    public static void main(String[] args){
        ApplicationContext context = new ClassPathXmlApplicationContext("applicationContext.xml");
        DAO job = (DAO)context.getBean("DAOImpl");
        long time =new java.util.Date().getTime();
        job.insert("李四",time,time);
        job.insert("张三",time,time);
        job.update("王五",time,"李四");
        job.delete("王五");
        job.select("王五");
    }
}

今天遇到问题：

1、jar没有加载成功，看idea教程解决。

2、xml配置文件中，beans注入关系没搞清楚，比如DataSource注入jdbctemplate后，jdbctemplate该注入接口类DAO还是实现类DAOImpl，对比了以后也不是很明白。

明天的目标：

1、开始Mybatis、juint的学习。

2、抽空进一步深入了解spring。