mybatis入门，对单表的增删改查

看spring mvc 需要整合一个mybatis玩玩，以前没弄过。所以冲入门的开始。下面就分享下我的入门经验吧。

注意config.mybatis和cn.lzg.mapper都是包在新建的时候是 package，不是folder。

因为我发现如果是folder文件夹，程序中就找不到对应的xml了。不知道有没有牛人能解释下这是为什么呢？

Configuration.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>
<typeAliases>
	<typeAlias alias="User" type="cn.lzg.pojo.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/springmvc" />
			<property name="username" value="root" />
			<property name="password" value="root" />
			
			<!-- <property name="driver" value="oracle.jdbc.driver.OracleDriver" />
			<property name="url" value="jdbc:oracle:thin:@192.168.15.102:1521:ora11g" />
			<property name="username" value="iris_ecnu_dev" />
			<property name="password" value="iris_ecnu_dev" /> -->
		</dataSource>
	</environment>
</environments>

<mappers>
	<mapper resource="cn/lzg/mapper/UserMapper.xml" />
</mappers>
</configuration>

 

User.java

package cn.lzg.pojo;

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.SequenceGenerator;
import javax.persistence.Table;

@Entity
@Table(name="user")
public class User {
	private Long id;
	private String username;
	private String password;
	
	@Id
	//@SequenceGenerator(name="aa_user_seq",sequenceName="aa_user_seq")
	//@GeneratedValue(strategy=GenerationType.SEQUENCE,generator="aa_user_seq")
	@GeneratedValue(strategy=GenerationType.IDENTITY)
	public Long getId() {
		return id;
	}
	public void setId(Long id) {
		this.id = id;
	}
	@Column(name="username")
	public String getUsername() {
		return username;
	}
	public void setUsername(String username) {
		this.username = username;
	}
	@Column(name="password")
	public String getPassword() {
		return password;
	}
	public void setPassword(String password) {
		this.password = password;
	}
	
	
}

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="cn.lzg.dao.MyBatisDao">

	<resultMap type="User" id="resultUserList">
		<result property="id" column="id"/>
		<result property="username" column="username"/>
		<result property="password" column="password"/>
	</resultMap>

     <select id="getUserByID" parameterType="Long" resultType="User">
         select * from user where id = #{id}
     </select>
     
     <select id="getUserByName" parameterType="String"  resultMap="resultUserList">
		select u.id as id,
			   u.username as username,
			   u.password as password
		from user u 
			where u.username like '%' || #{username} || '%'     
     </select>
     
     <insert id="addUser" parameterType="User" useGeneratedKeys="true"  keyProperty="id">
     	insert into user (username,password) values(#{username},#{password})
     </insert>
     
     <update id="updateUser" parameterType="User">
     	update user u set u.username=#{username},u.password=#{password}
     		where u.id = #{id}
     </update>
     
     <delete id="deleteUser" parameterType="Long">
     	delete from user u where u.id=#{id}
     </delete>
 </mapper>

MyBatisDao.java

package cn.lzg.dao;

import java.util.List;

import cn.lzg.pojo.User;

public interface MyBatisDao {
	public User getUserByID(Long id);
	
	public List<User> getUserByName(String username);
	
	public void addUser(User user);
	
	public void updateUser(User user);
	
	public void deleteUser(Long id);
}

Test.java

package cn.lzg.test;

import java.io.Reader;
import java.util.List;

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.lzg.dao.MyBatisDao;
import cn.lzg.pojo.User;

public class Test {
	private static SqlSessionFactory sqlSessionFactory;
	private static Reader reader;

	static {
		try {
			reader = Resources
					.getResourceAsReader("config/mybatis/Configuration.xml");
			sqlSessionFactory = new SqlSessionFactoryBuilder().build(reader);
		} catch (Exception e) {
			e.printStackTrace();
		}
	}

	public static SqlSessionFactory getSession() {
		return sqlSessionFactory;
	}

	public static void main(String[] args) {
		SqlSession session = sqlSessionFactory.openSession();
		try {
			MyBatisDao mapper = session.getMapper(MyBatisDao.class);
			
			//测试添加
			User user1 = new User();	
			user1.setUsername("admin1");
			user1.setPassword("123");
			mapper.addUser(user1);
			session.commit();
			
			//测试修改
//			User user2 = mapper.getUserByID(5);
//			user2.setPassword("123456");
//			user2.setUsername("测试修改");
//			mapper.updateUser(user2);
//			session.commit();
			
			//测试删除
//			mapper.deleteUser(5L);
//			session.commit();
			
//			//测试查找（返回List）
//			List<User> list = mapper.getUserByName("a");
//			for (User user : list) {
//				System.out.println(user.getId());
//				System.out.println(user.getUsername());
//			}
		} finally {
			session.close();
		}
	}
}

根据对应的注释去测试就OK了。

demo的下载地址

http://download.csdn.net/detail/hunanlzg/7647177