com.corp.repository.StudentRepository.java Source code

Introduction

Here is the source code for com.corp.repository.StudentRepository.java

Source

/*
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */
package com.corp.repository;

import com.corp.model.StudentModel;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.List;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.jdbc.core.BeanPropertyRowMapper;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.jdbc.core.RowMapper;
import org.springframework.stereotype.Repository;
import org.springframework.util.ObjectUtils;
import org.springframework.util.StringUtils;

/**
 *
 * @author sgoswami
 */

@Repository
public class StudentRepository {

    @Autowired
    protected JdbcTemplate jdbc;

    public List<StudentModel> getUser() {
        return jdbc.query("SELECT * FROM student", new StudentRowMapper());

    }

    /**
     *
     * @param ids
     * @return
     */
    public List<StudentModel> getUsers(String ids) {
        // System.out.println(ids);
        return jdbc.query("SELECT * FROM student WHERE id in (?)", new String[] { ids },
                new BeanPropertyRowMapper(StudentModel.class));
    }

}

class StudentRowMapper implements RowMapper<StudentModel> {
    @Override
    public StudentModel mapRow(ResultSet rs, int rowNum) throws SQLException {
        System.out.println(rowNum);
        StudentModel student = new StudentModel();
        student.setName(rs.getString("name"));
        student.setRoll(Integer.parseInt(rs.getString("roll")));
        student.setId(Integer.parseInt(rs.getString("id")));
        return student;
    }
}