1、添加业务
import com. kuang. pojo. User;
import org. apache. ibatis. annotations. Param;
import java. util. List;
public interface UserMapper {
public List< User> selectUser ( ) ;
public int addUser ( User user) ;
public int deleteUser ( int id) ;
}
2、编写sql
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
< mapper namespace = " com.kuang.mapper.UserMapper" >
< select id = " selectUser" resultType = " user" >
SELECT * FROM mybatis.user
</ select>
< insert id = " addUser" parameterType = " user" >
INSERT INTO mybatis.user(id, name, pwd) VALUES (#{id}, #{name}, #{pwd});
</ insert>
< delete id = " deleteUser" parameterType = " int" >
DELETE FROM mybatis.user WHERE id=#{id}
</ delete>
</ mapper>
3、实现类
import com. kuang. pojo. User;
import org. mybatis. spring. SqlSessionTemplate;
import org. mybatis. spring. support. SqlSessionDaoSupport;
import java. util. List;
c class UserMappingImpl extends SqlSessionDaoSupport implements UserMapper {
public List< User> selectUser ( ) {
User user = new User ( 5 , "小王" , "123213" ) ;
UserMapper mapper = getSqlSession ( ) . getMapper ( UserMapper. class ) ;
mapper. addUser ( user) ;
mapper. deleteUser ( 4 ) ;
return mapper. selectUser ( ) ;
}
public int addUser ( User user) {
return getSqlSession ( ) . getMapper ( UserMapper. class ) . addUser ( user) ;
}
public int deleteUser ( int id) {
return getSqlSession ( ) . getMapper ( UserMapper. class ) . deleteUser ( id) ;
}
}
测试
import com. kuang. pojo. User;
import org. junit. Test;
import org. springframework. context. ApplicationContext;
import org. springframework. context. support. ClassPathXmlApplicationContext;
import java. util. List;
public class MyTest {
@Test
public void test01 ( ) {
ApplicationContext context = new ClassPathXmlApplicationContext ( "applicationContext.xml" ) ;
UserMapper userMapper = context. getBean ( "userMapper" , UserMapper. class ) ;
for ( User user : userMapper. selectUser ( ) ) {
System. out. println ( user) ;
}
}
@Test
public void test02 ( ) {
ApplicationContext context = new ClassPathXmlApplicationContext ( "applicationContext.xml" ) ;
UserMapper userMapper = context. getBean ( "userMapper" , UserMapper. class ) ;
List< User> userList = userMapper. selectUser ( ) ;
for ( User user : userList) {
System. out. println ( user) ;
}
}
}