Spring JDBC - STUDENT CURD

Follow this design pattern : 

• Main.java
• Student.java
• Address.java
• BeanConfig.java
• StudentDao.java

 Main.java

package com.spring.core.springjdbc;
import org.springframework.context.ApplicationContext;
import org.springframework.context.annotation.AnnotationConfigApplicationContext;

public class Main {
    public static void main(String[] args) { 

        ApplicationContext context = new AnnotationConfigApplicationContext(BeanConfig.class); 

        StudentDao studentDao = (StudentDao) context.getBean("studentDao"); 

        Address address = (Address) context.getBean("address"); 

        Address address1 = new Address();
            address1.setCity("pune");
            address1.setPinCode(123456); 

        Student student = new Student();
            student.setStudentId(3);
            student.setStudenttName("Sanu");
            student.setAddress(address1); 

//        int status=studentDao.saveStudent(student);
//        int status=studentDao.deleteStudents(student);
//        int status=studentDao.updateStudent(student); 

//        System.out.println(status);
    }
}{codeBox}

BeanConfig.java

package com.spring.core.springjdbc;

import org.springframework.context.annotation.Bean;

import org.springframework.context.annotation.ComponentScan;

import org.springframework.context.annotation.Configuration;

import org.springframework.jdbc.core.JdbcTemplate;

import org.springframework.jdbc.datasource.DriverManagerDataSource;

@Configuration

@ComponentScan(basePackages = "com.spring.core.springjdbc")

public class BeanConfig {

    @Bean

    public Student student(){

        return new Student();

    }

    @Bean

    public Address getAddress(){

        return new Address();

    }

    @Bean

    public JdbcTemplate getJdbcTemplate(){

         return  new JdbcTemplate(driverManagerDataSource());

    }

    @Bean

    public DriverManagerDataSource driverManagerDataSource(){

        return new DriverManagerDataSource("jdbc:mysql://localhost:3306/student","root","");

    }

}{codeBox}

StudentDao.java

package com.spring.core.springjdbc;

import org.springframework.beans.factory.annotation.Autowired;

import org.springframework.jdbc.core.JdbcTemplate;

import org.springframework.stereotype.Component;

@Component

public class StudentDao {

    @Autowired

    private JdbcTemplate jdbcTemplate;

    public int saveStudent(Student e){

        String query="insert into students values( '"+e.getStudentId()+"','"+e.getStudenttName()+"','"+e.getAddress().getCity()+"')";

        return jdbcTemplate.update(query);

    }

    public int updateStudent(Student e){

        String query="update students set name=?,address=? where id=?";

        return jdbcTemplate.update(query,e.getStudenttName(),e.getAddress().getCity(),e.getStudentId());

    }

    public int deleteStudents(Student e){

        String query="delete from students where id=?";

        return jdbcTemplate.update(query,e.getStudentId());

    }

}{codeBox}

Student.java POJO CLASS

package com.spring.core.springjdbc;

import org.springframework.beans.factory.annotation.Autowired;

import org.springframework.stereotype.Component;

@Component

public class Student {

    private int studentId;

    private String studenttName;

    public void setStudentId(int studentId) {

        this.studentId = studentId;

    }

    public void setStudenttName(String studenttName) {

        this.studenttName = studenttName;

    }

    public void setAddress(Address address) {

        this.address = address;

    }

    @Autowired

    private Address address;

    public Student() {

    }

    public int getStudentId() {

        return studentId;

    }

    public String getStudenttName() {

        return studenttName;

    }

    public Address getAddress() {

        return address;

    }

}

 

Address.java POJO CLASS

package com.spring.core.springjdbc;

import org.springframework.stereotype.Component;

@Component

public class Address {

    int pinCode;

    String city;

    public Address(int pinCode, String city) {

        this.pinCode = pinCode;

        this.city = city;

    }

    public Address() {}

    public int getPinCode() {

        return pinCode;

    }

    public void setPinCode(int pinCode) {

        this.pinCode = pinCode;

    }

    public String getCity() {

        return city;

    }

    public void setCity(String city) {

        this.city = city;

    }

}