# UNI_MyBatis_Study_ChT

**Repository Path**: universe/UNI_MyBatis_Study_ChT

## Basic Information

- **Project Name**: UNI_MyBatis_Study_ChT
- **Description**: MyBatis传统方式增删改查练习
- **Primary Language**: Java
- **License**: Apache-2.0
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2017-01-06
- **Last Updated**: 2020-12-19

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

#UNI_MyBatis_Study_ChT
##MyBatis使用传统方式操作数据库

####1，创建SqlMapperConfig.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>
	<!-- 配置数据库配置文件 -->
	<properties resource="db.properties"></properties>
	<environments default="development">
		<environment id="development">
			<transactionManager type="JDBC"></transactionManager>
			<dataSource type="POOLED">
				<property name="driver" value="${jdbc.driver}" />
				<property name="url" value="${jdbc.url}" />
				<property name="username" value="${jdbc.username}" />
				<property name="password" value="${jdbc.password}" />
			</dataSource>
		</environment>
	</environments>
	<mappers>
		<mapper resource="mapper/mapper.xml" />
	</mappers>
</configuration>

```


####2，创建mapper.xml文件（在SqlMapperConfig.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="wu">
	<select id="getUserById" parameterType="int" resultType="com.universe.mybatis.po.User">
		SELECT * FROM `user` WHERE id=#{id}
	</select>
	
	<select id="getUserByName" parameterType="string" resultType="com.universe.mybatis.po.User">
		SELECT * FROM `user` WHERE username LIKE'%${value}%'
	</select>
	
	<insert id="insertUser" parameterType="com.universe.mybatis.po.User">
		
		<selectKey keyProperty="id" resultType="int" order="AFTER">
			SELECT LAST_INSERT_ID()
		</selectKey>
		
		INSERT INTO `user`(username,birthday,sex,address) VALUES(#{username},#{birthday},#{sex},#{address})
	
	</insert>
	
	<delete id="deleteUser" parameterType="int">
		DELETE FROM `user` WHERE id=#{id}
	</delete>
	
	<update id="updateUser" parameterType="com.universe.mybatis.po.User">
		UPDATE `user` set username=#{username},address=#{address} WHERE id=#{id}
	</update>
	
</mapper>
```


####3，创建对象，操作数据库；

```
public class MyBatisTest {
	@Test
	public void getUserById() throws Exception{
		
		SqlSessionFactoryBuilder builder=new SqlSessionFactoryBuilder();
		InputStream inputStream= Resources.getResourceAsStream("SqlMapperConfig.xml");
		SqlSessionFactory factory= builder.build(inputStream);
		
		SqlSession session=factory.openSession();
		User user= session.selectOne("getUserById", 10);
		System.out.println("user:" + user);
		session.close();
	}
	
	@Test
	public void getUserByName() throws Exception{
		SqlSessionFactoryBuilder builder=new SqlSessionFactoryBuilder();
		InputStream inputStream= Resources.getResourceAsStream("SqlMapperConfig.xml");
		SqlSessionFactory factory= builder.build(inputStream);
		
		SqlSession session= factory.openSession();
		List<User> users= session.selectList("getUserByName", "张");
		System.out.println("--users--" +users);
		session.close();
	}
	
	@Test
	public void insertUser() throws Exception{
		SqlSessionFactoryBuilder builder=new SqlSessionFactoryBuilder();
		InputStream inputStream= Resources.getResourceAsStream("SqlMapperConfig.xml");
		SqlSessionFactory factory= builder.build(inputStream);
		
		User user=new User();
		user.setAddress("西北王朝");
		user.setBirthday(new Date());
		user.setSex("2");
		user.setUsername("于建斌");
		
		SqlSession session= factory.openSession();
		int result= session.insert("insertUser", user);
		System.out.println("result -- " +result);
		session.commit();
		session.close();
	}
	
	@Test
	public void deleteUser()throws Exception{
		SqlSessionFactoryBuilder builder=new SqlSessionFactoryBuilder();
		InputStream inputStream= Resources.getResourceAsStream("SqlMapperConfig.xml");
		SqlSessionFactory factory= builder.build(inputStream);
		
		SqlSession session=factory.openSession();
		session.delete("deleteUser", 30);
		
		session.commit();
		session.close();
	}
	
	@Test
	public void updateUser()throws Exception{
		SqlSessionFactoryBuilder builder=new SqlSessionFactoryBuilder();
		InputStream inputStream= Resources.getResourceAsStream("SqlMapperConfig.xml");
		SqlSessionFactory factory= builder.build(inputStream);
		User user=new User();
		user.setAddress("天堂路");
		user.setUsername("宇宙人");
		user.setId(1);
		
		SqlSession session=factory.openSession();
		session.update("updateUser", user);
		
		session.commit();
		session.close();
	}
}

```