mybatis3_spring3整合

package com.mybp.dao; import java.util.ArrayList; import java.util.List; import javax.annotation.Resource; import org.apache.ibatis.session.SqlSession; import org.apache.ibatis.session.SqlSessionFactory; import org.springframework.stereotype.Repository; import com.mybp.entity.Person; @Repository("personDao") public class PersonDao { private SqlSessionFactory sqlSessionFactory; public Person selectById(Integer id) { Person person = null; SqlSession session = null; try { session = sqlSessionFactory.openSession(); person = (Person) session.selectOne( "sql.selectPersonById", id); } finally { session.close(); } return person; } @SuppressWarnings("unchecked") public List<Person> selectAll() { List<Person> persons = new ArrayList<Person>(); SqlSession session = null; try { session = sqlSessionFactory.openSession(); persons = session .selectList("sql.selectAllPerson"); } finally { session.close(); } return persons; } public void delete(Person person) { SqlSession session = null; try { session = sqlSessionFactory.openSession(); session.delete("sql.deletePerson", person); session.commit(); } finally { session.close(); } } public void insert(Person person) { SqlSession session = null; try { session = sqlSessionFactory.openSession(); session.insert("sql.insertPerson", person); session.commit(); } finally { session.close(); } } public void update(Person person) { SqlSession session = null; try { session = sqlSessionFactory.openSession(); session.insert("sql.updatePerson", person); session.commit(); } finally { session.close(); } } @SuppressWarnings("unchecked") public List<Person> selectPersonsByName(String name) { List<Person> persons = new ArrayList<Person>(); SqlSession session = null; try { session = sqlSessionFactory.openSession(); System.out.println(name); persons = session.selectList( "sql.selectPersonsByName", "%" + name + "%"); session.commit(); } finally { session.close(); } return persons; } public SqlSessionFactory getSqlSessionFactory() { return sqlSessionFactory; } @Resource(name="sqlSessionFactory") public void setSqlSessionFactory(SqlSessionFactory sqlSessionFactory) { this.sqlSessionFactory = sqlSessionFactory; } }