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); } }