mybatis入门之简单操作

mybatis入门之简单操作

环境配置

1.准备jar包

2.编写配置文件

SqlMapConfig.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>
   <environments default="developement">
      <environment id="developement">
        <transactionManager type="JDBC"/>
        <dataSource type="POOLED">
          <property name="driver" value="com.mysql.jdbc.Driver"/>
          <property name="url" value="jdbc:mysql://localhost:3306/mybatis?characterEncoding=utf8"/>
          <property name="username" value="root"/>
          <property name="password" value="root"/>
        </dataSource>
      </environment>
   </environments>
   <mappers>

     <mapper resource="com/zrf/mybatis/config/sqlmap/UserMapper.xml"/>
   </mappers>
</configuration>

1.根据用户id查询用户

实体bean

public class User {
	private Integer id;
	private String username;
	private Date birthday;
	private String sex;
	private String address;

	public Integer getId() {
		return id;
	}

	public void setId(Integer id) {
		this.id = id;
	}

	public String getUsername() {
		return username;
	}

	public void setUsername(String username) {
		this.username = username;
	}


	public Date getBirthday() {
		return birthday;
	}

	public void setBirthday(Date birthday) {
		this.birthday = birthday;
	}

	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;
	}

	public User() {
	}


	public User(Integer id, String username, Date birthday, String sex,
			String address) {
		super();
		this.id = id;
		this.username = username;
		this.birthday = birthday;
		this.sex = sex;
		this.address = address;
	}

	@Override
	public String toString() {
		return "User [id=" + id + ", username=" + username + ", birthday="
				+ birthday + ", sex=" + sex + ", address=" + address + "]";
	}

mapper配置文件

<?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="user">
  <select id="findUserById" parameterType="int" resultType="com.zrf.mybatis.bean.User">
     select * from user where id=#{id}
  </select>

</mapper>

测试类

public class Test {
  public static void main(String[] args) {
	String resource="com/zrf/mybatis/config/SqlMapConfig.xml";
	try {
		InputStream  input=Resources.getResourceAsStream(resource);
		SqlSessionFactory sqlSessionFactory=new SqlSessionFactoryBuilder().build(input);
		SqlSession sqlSession=sqlSessionFactory.openSession();
		User user=sqlSession.selectOne("user.findUserById", 24);
		System.out.println(user);
	} catch (IOException e) {
		e.printStackTrace();
	}
}

运行结果

2.根据用户名称模糊查询用户

实体bean

public class User {
	private Integer id;
	private String username;
	private Date birthday;
	private String sex;
	private String address;

	public Integer getId() {
		return id;
	}

	public void setId(Integer id) {
		this.id = id;
	}

	public String getUsername() {
		return username;
	}

	public void setUsername(String username) {
		this.username = username;
	}


	public Date getBirthday() {
		return birthday;
	}

	public void setBirthday(Date birthday) {
		this.birthday = birthday;
	}

	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;
	}

	public User() {
	}


	public User(Integer id, String username, Date birthday, String sex,
			String address) {
		super();
		this.id = id;
		this.username = username;
		this.birthday = birthday;
		this.sex = sex;
		this.address = address;
	}

	@Override
	public String toString() {
		return "User [id=" + id + ", username=" + username + ", birthday="
				+ birthday + ", sex=" + sex + ", address=" + address + "]";
	}

mapper文件

<?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="user">
   <select id="findUserByName" parameterType="java.lang.String" resultType="com.zrf.mybatis.bean.User">
      select * from user where username like '%${value}%'
   </select>
</mapper>

测试类

public class Test {

	public static void main(String[] args) {
        String resource="com/zrf/mybatis/config/SqlMapConfig.xml";
        try {
        	InputStream inputStream=Resources.getResourceAsStream(resource);
        	SqlSessionFactory sqlSessionFactory=new SqlSessionFactoryBuilder().build(inputStream);
        	SqlSession  sqlSession =sqlSessionFactory.openSession();
        	List<User>userList=sqlSession.selectList("user.findUserByName", "小明");
        	System.out.println(userList);
        	sqlSession.close();
		} catch (IOException e) {
			e.printStackTrace();
		}
	}

}

运行结果

3.修改用户

实体bean

public class User {
	private Integer id;
	private String username;
	private Date birthday;
	private String sex;
	private String address;

	public Integer getId() {
		return id;
	}

	public void setId(Integer id) {
		this.id = id;
	}

	public String getUsername() {
		return username;
	}

	public void setUsername(String username) {
		this.username = username;
	}


	public Date getBirthday() {
		return birthday;
	}

	public void setBirthday(Date birthday) {
		this.birthday = birthday;
	}

	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;
	}

	public User() {
	}


	public User(Integer id, String username, Date birthday, String sex,
			String address) {
		super();
		this.id = id;
		this.username = username;
		this.birthday = birthday;
		this.sex = sex;
		this.address = address;
	}

	@Override
	public String toString() {
		return "User [id=" + id + ", username=" + username + ", birthday="
				+ birthday + ", sex=" + sex + ", address=" + address + "]";
	}

mapper配置文件

<?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="user">
	<update id="updateUser">
		update user set
		username=#{username},birthday=#{birthday},sex=#{sex},address=#{address}
		where id=#{id}
	</update>
</mapper>

测试类

public class Test {

	public static void main(String[] args) {
		 String resource="com/zrf/mybatis/config/SqlMapConfig.xml";
         try {
        	 InputStream inputStream=Resources.getResourceAsStream(resource);
        	 SqlSessionFactory sqlSessionFactory=new SqlSessionFactoryBuilder().build(inputStream);
        	 SqlSession sqlSession=sqlSessionFactory.openSession();
        	 User user=new User();
        	 user.setId(29);
        	 user.setUsername("王大军");
        	 user.setBirthday(new Date());
        	 user.setSex("2");
        	 user.setAddress("甘肃平凉");
        	 sqlSession.update("user.updateUser", user);
        	 sqlSession.commit();
        	 sqlSession.close();
		} catch (IOException e) {
			e.printStackTrace();
		}
	}

}

4.删除用户

实体bean

public class User {
	private Integer id;
	private String username;
	private Date birthday;
	private String sex;
	private String address;

	public Integer getId() {
		return id;
	}

	public void setId(Integer id) {
		this.id = id;
	}

	public String getUsername() {
		return username;
	}

	public void setUsername(String username) {
		this.username = username;
	}


	public Date getBirthday() {
		return birthday;
	}

	public void setBirthday(Date birthday) {
		this.birthday = birthday;
	}

	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;
	}

	public User() {
	}


	public User(Integer id, String username, Date birthday, String sex,
			String address) {
		super();
		this.id = id;
		this.username = username;
		this.birthday = birthday;
		this.sex = sex;
		this.address = address;
	}

	@Override
	public String toString() {
		return "User [id=" + id + ", username=" + username + ", birthday="
				+ birthday + ", sex=" + sex + ", address=" + address + "]";
	}

mapper配置文件

<?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="user">
   <delete id="deleteUser" parameterType="java.lang.Integer">
      delete from user where id=#{id}
   </delete>
</mapper>

测试类

public class Test {

	public static void main(String[] args) {
       String resource="com/zrf/mybatis/config/SqlMapConfig.xml";
       try {
    	   InputStream  inputStream =Resources.getResourceAsStream(resource);
    	   SqlSessionFactory sqlSessionFactory=new SqlSessionFactoryBuilder().build(inputStream);
    	   SqlSession sqlSession =sqlSessionFactory.openSession();
    	   sqlSession.delete("user.deleteUser", 28);
    	   sqlSession.commit();
    	   sqlSession.close();
	} catch (IOException e) {
		e.printStackTrace();
	}
	}

}

5.添加用户

实体bean

public class User {
	private Integer id;
	private String username;
	private Date birthday;
	private String sex;
	private String address;

	public Integer getId() {
		return id;
	}

	public void setId(Integer id) {
		this.id = id;
	}

	public String getUsername() {
		return username;
	}

	public void setUsername(String username) {
		this.username = username;
	}


	public Date getBirthday() {
		return birthday;
	}

	public void setBirthday(Date birthday) {
		this.birthday = birthday;
	}

	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;
	}

	public User() {
	}


	public User(Integer id, String username, Date birthday, String sex,
			String address) {
		super();
		this.id = id;
		this.username = username;
		this.birthday = birthday;
		this.sex = sex;
		this.address = address;
	}

	@Override
	public String toString() {
		return "User [id=" + id + ", username=" + username + ", birthday="
				+ birthday + ", sex=" + sex + ", address=" + address + "]";
	}

配置文件

<?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="user">
   <insert id="insertUser" parameterType="com.zrf.mybatis.bean.User">
      insert into user(username,birthday,sex,address)value(#{username},#{birthday},#{sex},#{address})
   </insert>
</mapper>

测试类

public class Test {

	public static void main(String[] args) {
        String resource="com/zrf/mybatis/config/SqlMapConfig.xml";
        try {
        	InputStream  inputStream=Resources.getResourceAsStream(resource);
        	SqlSessionFactory sqlSessionFactory=new SqlSessionFactoryBuilder().build(inputStream);
        	SqlSession sqlSession=sqlSessionFactory.openSession();
        	User user=new User();
        	user.setUsername("王小军");
        	user.setBirthday(new Date());
        	user.setSex("1");
        	user.setAddress("河南郑州");
        	sqlSession.insert("user.insertUser", user);
        	sqlSession.commit();
        	sqlSession.close();
		} catch (IOException e) {
			e.printStackTrace();
		}
	}

}