mybatis

								## mybatis

mybatis是一种强大的东西在以后的开发及工作上都用的到 而mybatis的增删改查运用范围广大 ，mybatis的操作思路及掌握的东西相对来说较简单，今天来展示增删改查
增：
public static void xin() throws IOException{
String path=“mybatis-config.xml”;
InputStream is=Resources.getResourceAsStream(path);
SqlSessionFactory factory=new SqlSessionFactoryBuilder().build(is);
SqlSession session=factory.openSession();
try {
session=factory.openSession();
//调用goods实体类
goods a=new goods();
a.setGname(“酷酷”);
a.setGprice(1233);
a.setGcolor(“卢瑟”);
a.setGscore(100);
//通过seesion.getMapper的方法调用goodsdao接口点新增方法来实现
int count=session.getMapper(goodsdao.class).xinz(a);
//if判断来实现是否新增成功或失败
if(count>0){
System.out.println(“新增成功”);
}else {
System.out.println(“新增失败”);
}
//运用回滚提交到数据库
session.commit();
} catch (Exception e) {
// TODO: handle exception
e.printStackTrace();
}
}

删：
public static void schu() throws IOException{
	String path="mybatis-config.xml";
	InputStream is=Resources.getResourceAsStream(path);
	SqlSessionFactory factory=new SqlSessionFactoryBuilder().build(is);
	SqlSession session=factory.openSession();
	try {
	**//通过seesion.getMapper的方法调用goodsdao接口点新增方法来实现****
		goodsdao sm=session.getMapper(goodsdao.class);
		 int coun= sm.schu(2);
			if(coun >0){
				System.out.println("删除成功");
				session.commit();
			}else {
				System.out.println("删除失败");
				session.rollback();
		
			}
	} catch (Exception e) {
		// TODO: handle exception
		e.printStackTrace();
	}
}

改：
public static void xiu() throws IOException{
String path=“mybatis-config.xml”;
InputStream is=Resources.getResourceAsStream(path);
SqlSessionFactory factory=new SqlSessionFactoryBuilder().build(is);
SqlSession session=factory.openSession();
try {
goods jGoods=new goods();
jGoods.setGid(1);
jGoods.setGname(“看看”);
jGoods.setGprice(11);
jGoods.setGcolor(“kk”);
jGoods.setGscore(111);
//通过seesion.getMapper的方法调用goodsdao接口点新增方法来实现**
int mmm=session.getMapper(goodsdao.class).xiu(jGoods);
if(mmm>0){
System.out.println(“修改成功”);
}else {
System.out.println(“修改失败”);
}
session.commit();
} catch (Exception e) {
// TODO: handle exception
e.printStackTrace();
}
}

查：
public static void mohu() throws IOException{

	String path="mybatis-config.xml";
	InputStream is=Resources.getResourceAsStream(path);
	SqlSessionFactory factory=new SqlSessionFactoryBuilder().build(is);
	SqlSession session=factory.openSession();
	try {
		****//通过seesion.getMapper的方法调用goodsdao接口点新增方法来实现******
		goodsdao m=session.getMapper(goodsdao.class);
		//通过LIst集合来查找 并输出
		List<goods>mm=m.mohu(1, "看看", 11, "kk", 111);
		System.out.println("编号\t姓名\t价格\t颜色\t得分");
		**//通过for循环来实现循环输出**
		for (goods goods : mm) {		System.out.println(goods.getGid()+"\t"+goods.getGname()+"\t"+goods.getGprice()+"\t"+goods.getGcolor()+"\t"+goods.getGscore());
		}
	} catch (Exception e) {
		// TODO: handle exception
		e.printStackTrace();
	}
}