使用jdbc的template进行对数据库的操作

除了spring基本框架，需要导入的是spring-jdbc的jar包
在applicationContext.xml配置文件中添加如下代码：

<bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">
   	<property name="dataSource" ref="dataSource"/>
</bean>

Dao层代码：

@Repository
public class IStudentDaoImpl implements IStudentDao {

    @Autowired
    private JdbcTemplate jdbcTemplate;

    public void setJdbcTemplate(JdbcTemplate jdbcTemplate) {
        this.jdbcTemplate = jdbcTemplate;
    }

    /**
     * 增加学生方法
     * @param student
     * @return
     */
    @Override
    public Boolean addStu(Student student) {
        boolean flag = false;
        String sql = "insert into tb_student value(null,?,?,?)";

        int row = jdbcTemplate.update(sql,student.getName(),student.getSex(),student.getAge());
        if(row==0){
            flag = false;
        }else{
            flag = true;
        }
        return flag;

    }

    /**
     * 删除学生方法
     * @param stuId
     * @return
     */
    @Override
    public Boolean delStu(int stuId) {
        boolean flag = false;

        String sql = "delete FROM tb_student WHERE id=?";
        try {
            int row = jdbcTemplate.update(sql, stuId);
            if (row == 0) {
                flag = false;
            } else {
                flag = true;
            }
            return flag;
        }catch (Exception e){
            return false;
        }
    }

    /**
     * 更新学生方法
     * @param student
     * @return
     */
    @Override
    public Boolean updStu(Student student) {
        boolean flag = false;

        String sql = "update tb_student set name=?,sex=?,age=? where id=?";
        try{
            int row = jdbcTemplate.update(sql,student.getName(),student.getSex(),student.getAge(),student.getId());
            if(row==0){
                flag = false;
            }else{
                flag = true;
            }
            return flag;
        }catch (Exception e){
            return false;
        }

    }

    /**
     * 学生单查询
     * @param stuId
     * @return
     */
    @Override
    public Student findById(int stuId) {
        String sql = "select * from tb_student where id =?";
        BeanPropertyRowMapper<Student> rowMapper = new BeanPropertyRowMapper<>(Student.class);
        try{
            Student student = jdbcTemplate.queryForObject(sql, new Object[]{stuId}, rowMapper);
            return student;
        }catch (Exception e){
            return null;
        }
    }

    /**
     * 查询所有学生方法
     * @return
     */
    @Override
    public List<Student> findAll() {
        String sql = "select * from tb_student";
        BeanPropertyRowMapper<Student> rowMapper = new BeanPropertyRowMapper<>(Student.class);
        List<Student> query = jdbcTemplate.query(sql, rowMapper);
        return query;
    }
}