MyBatis 入门之增删改查

参考优快云-------http://blog.youkuaiyun.com/kutejava/article/details/9164353#t3

public class User {
	
	private int id;
	private String name;
	private int age;
	
	public User() {
		
	}
	
	public User(int id, String name, int age) {
		super();
		this.id = id;
		this.name = name;
		this.age = age;
	}
	public int getId() {
		return id;
	}
	public void setId(int id) {
		this.id = id;
	}
	public String getName() {
		return name;
	}
	public void setName(String name) {
		this.name = name;
	}
	public int getAge() {
		return age;
	}
	public void setAge(int age) {
		this.age = age;
	}
	
	@Override
	public String toString() {
		return "User -->" + id + " -->name -->" + name + "--> age -->" +
				"-->" +age;
	}
}

config.xml

<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN" "http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
	<!-- 自动扫描,这里使用了别名，在其他的xml中直接使用别名即可-->
	<typeAliases>
		<typeAlias alias="User" type="com.imut.po.User" />
	</typeAliases>

	<environments default="development">
		<environment id="development">
			<transactionManager type="JDBC"/>
			<!--配置数据库连接信息 -->
			<dataSource type="POOLED">
				<property name="driver" value="com.mysql.jdbc.Driver" />
				<property name="url" value="jdbc:mysql://localhost:3306/mybatis" />
				<property name="username" value="root" />
				<property name="password" value="123,456a" />
			</dataSource>
		</environment>			
	</environments>

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,namespace的值习惯上设置成Mapper的全名。
例如namespace="com.imut.mapping.userMapper"就是操作com.imut.po.User的文件-->
<mapper namespace="com.imut.inf.IUser" >
	<select id="getUserById" parameterType="int" resultType="com.imut.po.User">
		select * from users where id = #{id}
	</select>
	
	<!-- 定义resultMap 返回list类型 -->
	<resultMap id="resultListUser" type="User">
		<id column="id" property="id" jdbcType="INTEGER"/>
		<result column="name" property="name" jdbcType="VARCHAR" />
		<result column="age" property="age" jdbcType="INTEGER" />
	</resultMap>
	
	<select id="getAllUser" resultMap="resultListUser">
		select * from users
	</select>
	
	<insert id="addUser" parameterType="User" useGeneratedKeys="true" keyProperty="id">
		insert into users(id,name,age) values(#{id},#{name},#{age})
	</insert>
	
	<update id="updateUserById" parameterType="user">
		update users set name = #{name}, age=#{age} where id = #{id}
	</update>
	
	<delete id="delUser" parameterType="User">
		delete from users where id = #{id}
	</delete>
</mapper>

IUser.java

public interface IUser {
	//方法名与userMapper.xml中的保持一致
	public User getUserById(int userid);
	
	public List<User> getAllUser();
	
	
	public void addUser(User user);
	
	public void updateUserById(User user);
	
	public void delUser(User user);
	
}

测试类Test

public class SelectUserByIdTest {
	private static SqlSessionFactory sqlSessionFactory;
	private static Reader reader;
	
	public static SqlSessionFactory getSqlSession(){
		return sqlSessionFactory;
	}

	static{
		try {
			reader = Resources.getResourceAsReader("conf.xml");
			sqlSessionFactory = new SqlSessionFactoryBuilder().build(reader);
		} catch (IOException e) {
			e.printStackTrace();
		}
		
	}
	
	public static void main(String[] args) {
		/*
		 * 根据userid获取该User信息
		 SqlSession sqlSession = sqlSessionFactory.openSession();//创建SqlSession
		IUser iuser = sqlSession.getMapper(IUser.class);
		User user = iuser.getUserById(1);
		System.out.println("result <---->"+user);
		sqlSession.close();*/
		
		/*
		 * 查询所有
		 * SqlSession sqlSession = sqlSessionFactory.openSession();
		IUser iuser = sqlSession.getMapper(IUser.class);
		List<User> userList = iuser.getAllUser();
		System.out.println("result <---->"+userList.size());
		sqlSession.close();*/
		
		
		/*
		 * 新增
		 * SqlSession sqlSession = sqlSessionFactory.openSession();
		IUser iuser = sqlSession.getMapper(IUser.class);
		User user = new User();
		user.setAge(22);
		user.setName("lili");
		iuser.addUser(user);
		sqlSession.commit();
		System.out.println("Success");
		sqlSession.close();*/
		
	/*	
	 * 更新
	 * SqlSession sqlSession = sqlSessionFactory.openSession();
		IUser iuser = sqlSession.getMapper(IUser.class);
		User user = iuser.getUserById(1);
		user.setAge(25);
		user.setName("mingming");
		iuser.updateUserById(user);
		sqlSession.commit();
		System.out.println("Success");
		sqlSession.close();*/
		
		//删除
		SqlSession sqlSession = sqlSessionFactory.openSession();
		IUser iuser = sqlSession.getMapper(IUser.class);
		User user = iuser.getUserById(1);
		iuser.delUser(user);
		sqlSession.commit();
		System.out.println("Success");
		sqlSession.close();
	}

}