Mybatis实现增删改查

Mybatis实现增删改查

建包

AppleMapper.java是一个接口类，为了以后方便使用

AppleMapper.xml配置文件

mybatis-config.xml总配置文件

Test测试

package test;

import java.io.IOException;
import java.io.InputStream;
import java.util.List;
import java.util.Scanner;

import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;

import dao.AppleMapper;

import pojo.Apple;

public class Test {

/**
 * @param args
 */
static SqlSessionFactory factory;
static SqlSession session;
public static void main(String[] args) throws IOException{
	InputStream is = Resources.getResourceAsStream("mybatis-config.xml");
	factory = new SqlSessionFactoryBuilder().build(is);
	session= factory.openSession();
	fuzzy();
}
// TODO Auto-generated method stub
public static void select(){
	session = factory.openSession();
	AppleMapper am = session.getMapper(AppleMapper.class);
	List<Apple> list = am.getAll();
	System.out.println("序号\t型号\t价格\t颜色");
	for (Apple apple : list) {
		System.out.println(apple.getAid()+"\t\t"+apple.getAname()+"\t\t"+apple.getAprice()+"\t\t"+apple.getAcolor());
	}
}
public static void insert(){
	session = factory.openSession();
	AppleMapper am = session.getMapper(AppleMapper.class);
	Apple apple = new Apple();
	apple.setAid(4);
	apple.setAname("6s");
	apple.setAprice(666);
	apple.setAcolor("黄色");
	int num = am.insert(apple);
	if (num>0) {
		System.out.println("成功");
	}else {
		System.out.println("失败");
	}
	session.commit();
}
public static void delete(){
	session = factory.openSession();
	AppleMapper am = session.getMapper(AppleMapper.class);
	int num = am.delete(4);
	if (num>0) {
		System.out.println("成功");
	}else {
		System.out.println("失败");
	}
	session.commit();
}
public static void update(){
	session = factory.openSession();
	AppleMapper am = session.getMapper(AppleMapper.class);
	Apple apple = new Apple();
	apple.setAid(4);
	apple.setAname("6s");
	apple.setAprice(666);
	apple.setAcolor("绿色");
	int num = am.update(apple);
	if (num>0) {
		System.out.println("成功");
	}else {
		System.out.println("失败");
	}
	session.commit();
}
public static void page(){
	session = factory.openSession();
	AppleMapper am = session.getMapper(AppleMapper.class);
	int size=2;
	Scanner input = new Scanner(System.in);
	System.out.println("请问要查第几页（只有两页）：");
	int sdada = input.nextInt();
	List<Apple> list = am.sdada((sdada-1)*size,size);
	System.out.println("序号\t型号\t价格\t颜色");
	for (Apple apple : list) {
		System.out.println(apple.getAid()+"\t\t"+apple.getAname()+"\t\t"+apple.getAprice()+"\t\t"+apple.getAcolor());
	}
}
public static void fuzzy(){
	session = factory.openSession();
	AppleMapper am = session.getMapper(AppleMapper.class);
	List<Apple> list = am.fuzzy(0, "6s", 0, "");
	System.out.println("序号\t型号\t价格\t颜色");
	for (Apple apple : list) {
		System.out.println(apple.getAid()+"\t\t"+apple.getAname()+"\t\t"+apple.getAprice()+"\t\t"+apple.getAcolor());
	}
}

}