Mybatis的Dao层开发和动态代理开发

1.创建一个UserDao的接口

public interface UserDao {
public User getUserById(Integer i);
}

2.创建一个UserDaoImpl用来实现UserDao

public class UserDaoImpl implements UserDao{
	private SqlSessionFactory build;
	
	public UserDaoImpl(SqlSessionFactory build) {
		super();
		this.build = build;
	}
	
	@Override
	public User getUserById(Integer id) {
		
		//生产一个SqlSession
		SqlSession openSession = build.openSession();
		//操作数据库
		//参数1：需要操作的sql语句 参数2：sql语句的参数
		User user = openSession.selectOne("userMapper.selectById", id);
		
		return user;
	}

3.配置测试类UserDaoTest

public class UserDaoTest {
	private static SqlSessionFactory build;
	
	static {
		String resource="sqlMapConfig.xml";
		//读取配置文件
		InputStream inputStream;
		try {
			inputStream = Resources.getResourceAsStream(resource);
			//需要SqlSessionFactoryBuilder
		   SqlSessionFactoryBuilder builder=new SqlSessionFactoryBuilder();
		   //创建SqlSessionFactory
		   build = builder.build(inputStream);
		} catch (IOException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		
		
	}
	@Test
	public void test01() {
		UserDao daoTest=new UserDaoImpl(build);
		User userById = daoTest.getUserById(1);
		System.out.println(userById);
		
	}
}

4.其中的sqlMapconfig.xml和UserMapper.xml文件的配置

select * from user where u_id=#{id}



select * from user where u_username like "%"#{name}"%"


insert into user values(14,#{u_username},#{u_password},#{u_sex},#{u_createTime},#{u_cid})


update user set u_username=#{u_username} where u_id=#{u_id}


delete from user where u_id=#{id}

1.创建一个UserMapper接口

public interface UserMapper {
	
	public User selectById(Integer id);
	public List selectByName(String name);
	public void userInsert(User user);
}

2.修改UserMapper.xml文件

3.创建测试类

public class MapperTest {
	@Test
	public void test01() throws Exception {
		String resource="sqlMapConfig.xml";
		InputStream inputStream = Resources.getResourceAsStream(resource);
		SqlSessionFactoryBuilder builder=new SqlSessionFactoryBuilder();
		SqlSessionFactory build = builder.build(inputStream);
		SqlSession openSession = build.openSession();
		UserMapper mapper = openSession.getMapper(UserMapper.class);
		//通过ID查询
		User id = mapper.selectById(1);
		System.out.println(id);
		//模糊查询
		List name = mapper.selectByName("王");
	    for(User uname:name){
	    	System.out.println(uname);
	    }
//	    //插入
//	    User user=new User();
//		user.setU_username("小明");
//		user.setU_createTime(new Date());
//		user.setU_cid(1);
//		user.setU_password("12345");
//		user.setU_sex("男");
//		mapper.userInsert(user);
//		openSession.commit();
//		
	}
}