java应用开发之Mybatis通过Mapper代理自定义接口的实现

package repository;

import entity.Account;

import java.util.List;

public interface AccountRepository {

     public int save(Account account);

     public int update(Account account);

     public int deleteById( long id);

     public List<Account> findAll();

     public Account findById( long id);

}

<? xml version = "1.0" encoding = "UTF-8" ?>

<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"

         "http://mybatis.org/dtd/mybatis-3-mapper.dtd">

< mapper namespace = "repository.AccountRepository" >

     < insert id = "save" parameterType = "entity.Account" >

         insert into t_account(username,password,age) values (#{username},#{password},#{age});

     </ insert >

     < update id = "update" parameterType = "entity.Account" >

         update t_account set username=#{username},password=#{password},age=#{age} where id=#{id};

     </ update >

     < delete id = "deleteById" parameterType = "long" >

         delete from t_account where id=#{id};

     </ delete >

     < select id = "findAll" resultType = "entity.Account" >

         select * from t_account;

     </ select >

     < select id = "findById" parameterType = "long" resultType = "entity.Account" >

         select * from t_account where id =#{id};

     </ select >

</ mapper >

< mappers >

         < mapper resource = "mapper/AccountMapper.xml" ></ mapper >

         < mapper resource = "repository/AccountRepository.xml" ></ mapper >

     </ mappers >

package Test;

import entity.Account;

import org.apache.ibatis.io.ResolverUtil;

import org.apache.ibatis.session.SqlSession;

import org.apache.ibatis.session.SqlSessionFactory;

import org.apache.ibatis.session.SqlSessionFactoryBuilder;

import repository.AccountRepository;

import java.io.InputStream;

import java.util.List;

public class Test1 {

     public static void main(String[] args) {

         InputStream inputStream= ResolverUtil.Test. class .getClassLoader().getResourceAsStream( "config.xml" );

         SqlSessionFactoryBuilder sqlSessionFactoryBuilder = new SqlSessionFactoryBuilder();

         SqlSessionFactory sqlSessionFactory = sqlSessionFactoryBuilder.build(inputStream);

         SqlSession sqlSession = sqlSessionFactory.openSession();

         AccountRepository accountRepository=sqlSession.getMapper(AccountRepository. class );

//        List<Account> list=accountRepository.findAll();

//        for(Account account:list){

//            System.out.println(account);

//        }

//        sqlSession.close();

         //添加

//        Account account=new Account(3L,"wangwu","555555",122);

//        accountRepository.save(account);

//        sqlSession测试数据mit();

         //通过id查找对象

//        Account account=accountRepository.findById(3L);

//        System.out.println(account);

//        sqlSession.close();

         //通过id改对象

//        Account account=accountRepository.findById(2L);

//        account.setUsername("alibaba");

//        account.setPassword("12345678");

//        account.setAge(11);

//        int result=accountRepository.update(account);

//        sqlSession测试数据mit();

//        System.out.println(result);

//        sqlSession.close();

         //删除

         int result=accountRepository.deleteById(3L);

         sqlSession测试数据mit();

         System.out.println(result);

         sqlSession.close();

      }

}