mybatis 的crud操作

1. 在userdao层完成增删改查

package cn.sxt.dao;

import java.io.IOError;
import java.io.IOException;
import java.nio.channels.SeekableByteChannel;
import java.util.List;

import org.apache.ibatis.session.SqlSession;

import cn.sxt.entity.User;
import cn.sxt.util.MyBatisUtil;

public class UserDao {
    public User getById(int id) throws IOException {
        SqlSession session  = MyBatisUtil.getSession();
        User user = session.selectOne("cn.sxt.entity.UserMapper.selectUser",id);
        //System.out.println("id="+user.getId()+",name="+user.getName()+",psw="+user.getPwd());
        session.close();
        return user;
    } 
    public int add(User user) throws IOException {
        SqlSession session = MyBatisUtil.getSession();
        int result = session.insert("cn.sxt.entity.UserMapper.addUser", user);
        session.commit();
        session.close();
        return result;
    }
    public int updata(User user) throws IOException {
        SqlSession session = MyBatisUtil.getSession();
        int result = session.update("cn.sxt.entity.UserMapper.updateUser", user);
        session.commit();
        session.close();
        return result;
    }
//    public int delete(int id) throws IOException {
//
//    }
    public int delete(int id) throws IOException {
        SqlSession session = MyBatisUtil.getSession();
        int result = session.delete("cn.sxt.entity.UserMapper.deleteUser", id);
        session.commit();
        session.close();
        return result;
    }
    public List<User> getAll() throws IOException {
        SqlSession session  = MyBatisUtil.getSession();
        List<User> list = session.selectList("cn.sxt.entity.UserMapper.selectAll");
        //System.out.println("id="+user.getId()+",name="+user.getName()+",psw="+user.getPwd());
        session.close();
        return list;
    }
}

2. 测试类

package cn.sxt.test;

import java.io.IOException;
import java.util.List;

import javax.sound.midi.SysexMessage;

import org.apache.ibatis.session.SqlSession;
import org.omg.PortableInterceptor.USER_EXCEPTION;

import cn.sxt.dao.UserDao;
import cn.sxt.entity.User;
import cn.sxt.util.MyBatisUtil;

public class Test {

    /**
     * @param args
     * @throws IOException 
     */
    public static void main(String[] args) throws IOException {
        UserDao userDao = new UserDao();
        //System.out.println(userDao.getById(2));
        
//        User user = new User();
//        user.setId(6);
//        user.setName("laoliu");
//        user.setPwd("666");
//        System.out.println(userDao.add(user));
//        System.out.println(userDao.getById(6));
        
//        User user  = new User();
//        user.setId(3);
//        user.setName("puluomixiusi");
//        user.setPwd("puluomixiusi");
//        System.out.println(userDao.updata(user));
//        System.out.println(userDao.getById(3));

//        int id = 2;
//        System.out.println(userDao.delete(id));
        
        
        List<User> list = userDao.getAll();
        for(User i:list) {
            System.out.println(i);
        }
    }

}

3. javabean类的配置xml文件

package cn.sxt.test;

import java.io.IOException;
import java.util.List;

import javax.sound.midi.SysexMessage;

import org.apache.ibatis.session.SqlSession;
import org.omg.PortableInterceptor.USER_EXCEPTION;

import cn.sxt.dao.UserDao;
import cn.sxt.entity.User;
import cn.sxt.util.MyBatisUtil;

public class Test {

    /**
     * @param args
     * @throws IOException 
     */
    public static void main(String[] args) throws IOException {
        UserDao userDao = new UserDao();
        //System.out.println(userDao.getById(2));
        
//        User user = new User();
//        user.setId(6);
//        user.setName("laoliu");
//        user.setPwd("666");
//        System.out.println(userDao.add(user));
//        System.out.println(userDao.getById(6));
        
//        User user  = new User();
//        user.setId(3);
//        user.setName("puluomixiusi");
//        user.setPwd("puluomixiusi");
//        System.out.println(userDao.updata(user));
//        System.out.println(userDao.getById(3));

//        int id = 2;
//        System.out.println(userDao.delete(id));
        
        
        List<User> list = userDao.getAll();
        for(User i:list) {
            System.out.println(i);
        }
    }

}