Insert Update Delete using Spring (Spring + MySQL)

Insert Update Delete using Spring (Spring + MySQL)

Here is the code to insert, delete and update records using MySQL and Spring.
Code tested in NetBeans 8.0

Create Table in Database:

create table student
(
sname varchar(20),
sid int,
sdept varchar(20)
)

student.java

public class student {
    String sname,sid,sdept;

    public student()
    {
        
    }
    public student(String sname, String sid, String sdept)
    {
        this.sname=sname;
        this.sid=sid;
        this.sdept=sdept;
    }
// Getters and Setters

Studentdao.java

public class Studentdao {
    public JdbcTemplate jdbctemplate;
    
    public void setJdbcTemplate(JdbcTemplate jdbcTemplate) 
    {  
    this.jdbctemplate = jdbcTemplate;  
    }  
    public int savestudent(student s)
    {
        String insertq="insert into student values('"+s.getSname()+"','"+s.getSid()+"','"+s.getSdept()+"')";
        return jdbctemplate.update(insertq);
    }
    
    public int updatestudent(student s)
    {
        String updateq="update student set sname='"+s.getSname()+"', sdept='"+s.getSdept()+"' where sid='"+s.getSid()+"'";
        return jdbctemplate.update(updateq);
    }
    
    public int deletestudent(student s)
    {
        String deleteq="delete from student where sid='"+s.getSid()+"'";
        return jdbctemplate.update(deleteq);
    }
}

Spring-Config.xml
Include this code in Spring-Config.xml

<bean id="datasource1" class="org.springframework.jdbc.datasource.DriverManagerDataSource">  
<property name="driverClassName" value="com.mysql.jdbc.Driver" />  
<property name="url" value="//url here" />  
<property name="username" value="" />  
<property name="password" value="" />  
</bean>  

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

<bean id="student" class="Studentdao">
    <property name="jdbcTemplate" ref="jdbcTemplate"></property>
</bean>

Operations.java

public class Operations {
    public static void main(String[] args) 
    {  
    Scanner input=new Scanner(System.in);    
    String sname,sid,sdept; 
    String sname1,sdept1,sid1;
    String sid2;
    ApplicationContext ac=new ClassPathXmlApplicationContext("springconfig.xml");
    Studentdao sdao=(Studentdao)ac.getBean("student");
    
    System.out.println("Enter the Student Name: ");
    sname=input.next();
    System.out.println("Enter Student id: ");
    sid=input.next();
    System.out.println("Enter Student Department: ");
    sdept=input.next();
    
    int insertq=sdao.savestudent(new student(sname,sid,sdept));
    System.out.println("-----------------------------------------------------------");
    Scanner input1=new Scanner(System.in);
    System.out.println("Enter the id: ");
    sid1=input1.next();
    System.out.println("Enter the Student Name: ");
    sname1=input1.next();
    System.out.println("Enter Student Department: ");
    sdept1=input1.next();
    
    int updateq=sdao.updatestudent(new student(sname1,sid1,sdept1));
    System.out.println("-----------------------------------------------------------"); 
    System.out.println("Enter the id: ");
    Scanner input2=new Scanner(System.in);    
    sid2=input2.next();
    student s=new student();
    s.setSid(sid2);
    int delete=sdao.deletestudent(s);
    }
}