使用Mapper接口动态代理的方式编程-作业

javaee框架-mybatis作业

使用Mapper接口动态代理的方式编程

//成功
查询user中id=2的用户
添加一条用户信息到user中（id=6）
删除user中id=6的用户信息

//未成功
修改user中id=4的用户的信息
模糊查询user中username带“小”的的用户信息（模糊查询）

目录结构

User.java

package cn.mybatis.bean;

public class User {
	private int id;
	private String username;
	private String sex;
	private String address;
	public int getId() {
		return id;
	}
	public void setId(int id) {
		this.id = id;
	}
	public String getUsername() {
		return username;
	}
	public void setUsername(String username) {
		this.username = username;
	}
	public String getSex() {
		return sex;
	}
	public void setSex(String sex) {
		this.sex = sex;
	}
	public String getAddress() {
		return address;
	}
	public void setAddress(String address) {
		this.address = address;
	}
	@Override
	public String toString() {
		return "User [id=" + id + ", username=" + username + ", sex=" + sex
				+ ", address=" + address + "]";
	}
}

UserMapper.java

package com.mybatis.dao;

import cn.mybatis.bean.User;

//DAO接口
public interface UserMapper {

	public User findUserById(int id) throws Exception;
	public User findUserByName(String username) throws Exception;
	public User updateUserById(User user) throws Exception;
	public User insertUserInfo(User user)throws Exception;
	public User deleteUserById(int id)throws Exception;
}

UserMapper.xml

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper
PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">

<mapper namespace="com.mybatis.dao.UserMapper">

	<!-- 根据id查询用户信息 -->
	<select id="findUserById" parameterType="int" resultType="cn.mybatis.bean.User">
		select * from user where id=#{id};
	</select>

	<insert id="insertUserInfo" parameterType="cn.mybatis.bean.User">
		insert into user(id,username,sex,address)
		values(#{id},#{username},#{sex},#{address});
	</insert>

	<!-- 根据姓名模糊查询 -->
	<select id="findUserByName" parameterType="string" resultType="cn.mybatis.bean.User">
	select * from user where username like '%${value}%'
	</select>
	
	<update id="updateUserById" parameterType="cn.mybatis.bean.User" >
	update user set username=#{username},sex=#{sex},address=#{address} where id=#{id};
	</update>
	
	<delete id="deleteUserById" parameterType="int">
	delete from user where id =#{id}
	</delete>
</mapper>

SqlMapConfig.xml

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper
PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">

<mapper namespace="com.mybatis.dao.UserMapper">

	<!-- 根据id查询用户信息 -->
	<select id="findUserById" parameterType="int" resultType="cn.mybatis.bean.User">
		select * from user where id=#{id};
	</select>

	<insert id="insertUserInfo" parameterType="cn.mybatis.bean.User">
		insert into user(id,username,sex,address)
		values(#{id},#{username},#{sex},#{address});
	</insert>

	<!-- 根据姓名模糊查询 -->
	<select id="findUserByName" parameterType="string" resultType="cn.mybatis.bean.User">
	select * from user where username like '%${value}%'
	</select>
	
	<update id="updateUserById" parameterType="cn.mybatis.bean.User" >
	update user set username=#{username},sex=#{sex},address=#{address} where id=#{id};
	</update>
	
	<delete id="deleteUserById" parameterType="int">
	delete from user where id =#{id}
	</delete>
</mapper>

Test.java

package com.mybatis.test;

import java.io.IOException;
import java.io.InputStream;

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 cn.mybatis.bean.User;
import com.mybatis.dao.UserMapper;

public class Test {
	// SqlSessionFactory是线程安全的，这里可以使用单例模式
	private static SqlSessionFactory sqlSessionFactory;

	static {
		try {
			// 1、读取配置文件SqlMapConfig.xml
			InputStream inputStream = Resources
					.getResourceAsStream("SqlMapConfig.xml");
			// 2、根据配置文件构建SqlSessionFactory
			sqlSessionFactory = new SqlSessionFactoryBuilder()
					.build(inputStream);
		} catch (IOException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}

	public static void main(String[] args) {

		SqlSession sqlSession = sqlSessionFactory.openSession();
		try {
			// Mapper接口动态生成代理类
			UserMapper userMapper = sqlSession.getMapper(UserMapper.class);
			// findbyid
			User user2 = userMapper.findUserById(2);
			System.out.println(user2.toString());
			// insert		
			User user3 = new User();
			user3.setId(6);
			user3.setUsername("郑铮铮");
			user3.setSex("女");
			user3.setAddress("3309");
			userMapper.insertUserInfo(user3);
			System.out.println("success");
			//delete
			userMapper.deleteUserById(6);
		
			//未实现
			
			//update
			User user4 = new User();
			user4.setId(4);
			user4.setAddress("6666");
			user4.setSex("男");
			user4.setUsername("爸爸去哪儿");
			userMapper.updateUserById(user4);
			// findbyname
			User user1 = userMapper.findUserByName("小");
			System.out.println(user1.toString());
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}

		sqlSession.commit();
		sqlSession.close();

	}

}