package com.fgkj;
|
|
import com.fgkj.mapper.UserMapper;
|
import com.fgkj.pojo.User;
|
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 java.io.IOException;
|
import java.io.InputStream;
|
import java.util.HashMap;
|
import java.util.List;
|
import java.util.Map;
|
|
public class MyBatisDemo {
|
|
|
public static void main(String[] args) throws IOException {
|
//1.加载mybatis 的核心配置文件，获取SqlSessionFactory
|
String resource = "mybatis-config.xml";
|
InputStream inputStream = Resources.getResourceAsStream(resource);
|
SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
|
|
//2.获取 SqlSession 对象，用它执行sql
|
SqlSession sqlSession = sqlSessionFactory.openSession();
|
|
System.out.println(sqlSession);
|
//3.执行sql
|
// List<User> users = sqlSession.selectList("test.selectAll");
|
//
|
//3.1 获取UserMapper 对象
|
UserMapper userMapper = sqlSession.getMapper(UserMapper.class);
|
List<User> users = userMapper.selectAll();
|
System.out.println(users);
|
|
System.out.println("---------------------------------------------------------------------------------");
|
|
User user = userMapper.selectById(2);
|
System.out.println(user);
|
|
System.out.println("---------------------------------------------------------------------------------");
|
|
String uName = "admin";
|
String uDepartment = "省";
|
String uJobGroup = "管理员";
|
|
uName = "%" + uName + "%";
|
uDepartment = "%" + uDepartment + "%";
|
uJobGroup = "%" + uJobGroup + "%";
|
|
User u = new User();
|
u.setuName(uName);
|
u.setuDepartment(uDepartment);
|
u.setuJobGroup(uJobGroup);
|
|
Map map = new HashMap();
|
// map.put("uName",uName);
|
// map.put("uDepartment",uDepartment);
|
// map.put("uJobGroup",uJobGroup);
|
|
// List<User> users1 = userMapper.selectCondition(uName, uDepartment, uJobGroup);
|
// List<User> users1 = userMapper.selectCondition(u);
|
//List<User> users1 = userMapper.selectCondition(map);
|
List<User> users1 = userMapper.selectConditionSigle(map);
|
|
|
System.out.println(users1);
|
|
//4.释放资源
|
sqlSession.close();
|
}
|
}
|
