MyBatis单表增删改多表查询

package comkanq.dao; import java.io.IOException; import java.io.Reader; import java.util.List; import java.util.Map; import javax.annotation.Resources; import org.apache.ibatis.session.SqlSession; import org.apache.ibatis.session.SqlSessionFactory; import org.apache.ibatis.session.SqlSessionFactoryBuilder; import com.kanq.bean.User; public class UserDAOImp implements UserDAO{ //sesionfactory 获得 private static SqlSessionFactory factory=null; private static SqlSession session = null; static { String resource = "Configuration.xml"; try { Reader reader; reader = org.apache.ibatis.io.Resources.getResourceAsReader(resource); SqlSessionFactoryBuilder builder = new SqlSessionFactoryBuilder(); SqlSessionFactory factory = builder.build(reader); session = factory.openSession(); reader.close(); } catch (IOException e) { // TODO Auto-generated catch block e.printStackTrace(); } } @Override public int insert(User user) { // TODO Auto-generated method stub int userId = session.insert("insert",user); session.commit(); return userId; } @Override public int update(User user) { // TODO Auto-generated method stub return session.update("update",user); } @Override public int delete(String userName) { // TODO Auto-generated method stub return session.delete("deleteByName",userName); } @Override public List<User> selectAll() { // TODO Auto-generated method stub return session.selectList("selectAll"); } @Override public int countAll() { // TODO Auto-generated method stub return session.selectOne("countAll"); } @Override public User findByUserName(String userName) { // TODO Auto-generated method stub return session.selectOne("", User.class); } @Override public User findByUserId(int userId) { // TODO Auto-generated method stub return session.selectOne("findById",userId); } // public Map zonghe(){ // // //return session.selectMap("zonghe", arg1) // // } }