mybatis 实现数据的增删改查小demo

package com.wz.dao; import java.util.List; import org.apache.ibatis.session.SqlSession; import com.wz.bean.Grade; import com.wz.bean.StuBean; import com.wz.mybatis.IstuOperation; import com.wz.util.SessionFactory; /** * 持久层 * */ public class StuDao { public StuBean query(String id){ //1 不需要接口 已经实现 // SqlSession session = SessionFactory.getSqlSessionFactory().openSession(); // System.out.println(session); // // StuBean stu = null; // stu = (StuBean)session.selectOne("com.dtdx.mybatis.selectAll",id); // session.close(); //2 通过接口 SqlSession session = SessionFactory.getSqlSessionFactory().openSession(); IstuOperation stuOperation=session.getMapper(IstuOperation.class); StuBean stu=stuOperation.selectAll(id); session.close(); return stu; } /** * 通过mybatis实现查询所有的功能 * @return */ public List<StuBean> selectStuByName(String name){ List<StuBean> students = null; SqlSession session = SessionFactory.getSqlSessionFactory().openSession(); try{ IstuOperation stuOperation=session.getMapper(IstuOperation.class); students = stuOperation.selectStu(name); for(StuBean stu:students){ System.out.println(stu.getId()+"---"+stu.getName()+"---"+stu.getSex()+"---"+stu.getRemark()); } } catch(Exception e){ System.out.println("出错了"); } finally{ session.close(); } return students; } /** * 添加 * @param st */ public void addStu(StuBean st){ SqlSession session = SessionFactory.getSqlSessionFactory().openSession(); IstuOperation stuOperation=session.getMapper(IstuOperation.class); stuOperation.addStu(st); session.commit(); System.out.println("用户+1"+st.getId()); session.close(); } /** * 修改 * @param st */ public void updateStu(StuBean st){ SqlSession session = SessionFactory.getSqlSessionFactory().openSession(); IstuOperation stuOperation=session.getMapper(IstuOperation.class);//得到接口的映射 int i = stuOperation.updateStu(st); System.out.println("i = "+i);//i在此表示修改的列数 session.commit(); session.close(); } /** * 删除 * @param id */ public void delStu(String id){ SqlSession session = SessionFactory.getSqlSessionFactory().openSession(); IstuOperation stuOperation=session.getMapper(IstuOperation.class);//得到接口的映射 stuOperation.delStu(id); System.out.println("删除成功"); session.commit(); session.close(); } /** * 查询一个寝室中都住着谁 */ public void getGradeBystuId(String id){ SqlSession session = SessionFactory.getSqlSessionFactory().openSession(); IstuOperation stuOperation=session.getMapper(IstuOperation.class);//得到接口的映射 List<Grade> gra = stuOperation.getStuGrade(id); System.out.println(id); for(Grade gras:gra){ System.out.println("课程成绩为"+gras.getCourse()+"------------"+"课程成绩为"+gras.getGrade()); } session.close(); } }