Spring 和 Mybatis的整合后的——增删改查

Test.java
package com.zhongruan.test;

import com.zhongruan.bean.User;
import com.zhongruan.service.IUserService;
import org.springframework.context.support.ClassPathXmlApplicationContext;

import java.util.List;

public class Test {
public static void main(String[] args){
ClassPathXmlApplicationContext applicationContext= new ClassPathXmlApplicationContext(“applicationContext.xml”);
IUserService userService= (IUserService) applicationContext.getBean(“userService”);

// List all=userService.findAll();//查询
// System.out.println(all);

// List all=userService.findAll();
// userService.delete(21);//删除
// System.out.println(all);

// List all=userService.findAll();
// User user=new User(); //修改
// user.setId(25);
// user.setUsername(“sdf”);
// user.setPassword(“sdfs”);
// userService.update(user);
// System.out.println(all);

    List<User> all=userService.findAll();
    User user=new User(); //增添
    user.setUsername("xxx");
    user.setPassword("xxs");
    userService.add(user);
    System.out.println(all);
}

}

UserMapper1.xml

<?xml version="1.0" encoding="UTF-8"?> select * from tb_user

<delete id="delete" parameterType="int">
    delete from tb_user where id=#{id}
</delete>

<update id="update" parameterType="com.zhongruan.bean.User">
    update tb_user set username=#{username},password=#{password} where id=#{id}
</update>

<insert id="add" parameterType="com.zhongruan.bean.User">
    insert into tb_user(username,password) values (#{username},#{password})
</insert>