## 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();
}
}