1、添加用户
(1)映射文件中添加SQL语句
<?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="test">
<insert id="insertUser" parameterType="edu.tjut.pojo.User">
INSERT INTO user(username,birthday,sex,address) VALUE(#{username},#{birthday},#{sex},#{address})
</insert>
</mapper>
其中:parameterType:指定输入参数类型是pojo类 #{}中指定pojo的属性名,接收到pojo对象的属性值,mybatis通过OGNL获取对象的属性值
(2)java程序
@Test
public void insertUser() throws IOException
{
String resource
= "SqlMapConfig.xml";
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(1996-1900,8-1,24+1));
user
.setSex("女");
user
.setAddress("北京");
sqlSession
.insert("test.insertUser",user
);
sqlSession
.commit();
sqlSession
.close();
}
2、自增主键的返回
mysql自增主键,执行insert提交之前自动生成一个自增主键(这里是指用户的id),通过mysql函数获取刚插入记录的自增主键LAST_INSERT_ID(),在insert之后调用
<insert id="insertUser" parameterType="edu.tjut.pojo.User">
<selectKey keyProperty="id" order="AFTER" resultType="java.lang.Integer" >
SELECT LAST_INSERT_ID()
</selectKey>
insert into user(username,birthday,sex,address) value(#{username},#{birthday},#{sex},#{address})
</insert>
3、非自增主键的返回:
使用mysql的uuid()函数生成主键,需要修改表中id字段类型为string,长度设置成35位。 执行思路: 先通过uuid()查询到主键,将主键输入到sql语句中 执行uuid()语句顺序相对于insert语句之前执行
(1)映射文件中添加SQL语句:
<insert id="insertUser" parameterType="edu.tjut.pojo.User">
<selectKey keyProperty="id" order="BEFORE" resultType="java.lang.String" >
SELECT uuid()
</selectKey>
insert into user(id,username,birthday,sex,address) value(#{id},#{username},#{birthday},#{sex},#{address}
</insert>
4、java程序