ibatis3应用实例(oracle数据库)

package com.ibatis.dao; import java.util.ArrayList; import java.util.List; import org.apache.ibatis.session.SqlSession; import org.apache.ibatis.session.SqlSessionFactory; import com.ibatis.model.User; import com.ibatis.test.DbConfig.SessionFactory; public class PersonManagerImpl implements PersonManager { private SqlSessionFactory sessionFactory = SessionFactory.getInstance() .getSqlSessionFactory(); public void delete(int id) { SqlSession session = null; int result = 0; try { session = sessionFactory.openSession(); result = session.insert("delete", id); session.commit(); if (result > 0) { System.out.println("删除成功"); } else { System.out.println("删除失败"); } } catch (Exception e) { session.rollback(); e.printStackTrace(); } finally { session.close(); } } public void insert(User user) { SqlSession session = null; int result = 0; try { session = sessionFactory.openSession(); result = session.insert("insert", user); session.commit(); if (result > 0) { System.out.println("添加成功"); } else { System.out.println("添加失败"); } } catch (Exception e) { session.rollback(); e.printStackTrace(); } finally { session.close(); } } @SuppressWarnings("unchecked") public List<User> selectAll() { List<User> persons = new ArrayList<User>(); SqlSession session = null; try { session = sessionFactory.openSession(); persons = session .selectList("selectAll"); } finally { session.close(); } return persons; } public User selectById(String name) { User person = new User(); SqlSession session = null; try { session = sessionFactory.openSession(); person = (User) session.selectOne( "selectById", name); } finally { // session.close(); } return person; } public List<User> selectPersonsByName(String name) { // TODO 自动生成方法存根 return null; } public void update(User user) { SqlSession session = null; int result = 0; try { session = sessionFactory.openSession(); result = session.update("update", user); session.commit(); if (result > 0) { System.out.println("更新成功"); } else { System.out.println("更新失败"); } } catch (Exception e) { session.rollback(); e.printStackTrace(); } finally { session.close(); } } public static void main(String args[]) { // 显示所有用户 List<User> persons = new PersonManagerImpl().selectAll(); for(User user:persons){ System.out.println(user.getId()); System.out.println(user.getName()); System.out.println(user.getJin()); } // 添加用户 // User u=new User(); // u.setName("ddddd"); // u.setJin("ssdfsdfds"); // new PersonManagerImpl().insert(u); // 更新用户 // User u = new User(); // u.setName("77777"); // u.setJin("88888"); // u.setId(380); // new PersonManagerImpl().update(u); // new PersonManagerImpl().delete(380); } }