<?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="jdbc.properties"></properties>
<!--数据源环境-->
<environments default="development">
<environment id="development">
<transactionManager type="JDBC"></transactionManager>
<dataSource type="POOLED">
<property name="driver" value="${jdbc.driver}"></property>
<property name="url" value="${jdbc.url}"></property>
<property name="username" value="${jdbc.username}"></property>
<property name="password" value="${jdbc.password}"></property>
</dataSource>
</environment>
</environments>
<!--加载映射文件-->
<mappers>
<mapper resource="UserMapper.xml"></mapper>
</mappers>
</configuration>
插入:
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Config 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="userMapper">
<!--插入操作-->
<insert id="insert" parameterType="entity.User">/*传递过来的参数类型*/
insert into user values(#{username},#{password},#{id})/*参数对应的成员变量*/
</insert>
</mapper>
public MyBatisTest() throws IOException {}
/*获得核心配置文件*/
InputStream resourceAsStream = Resources.getResourceAsStream("sqlMapConfig.xml");
/*获得session工厂对象*/
SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(resourceAsStream);
/*获得session会话对象*/
SqlSession sqlSession = sqlSessionFactory.openSession();
@Test
public void insert() throws IOException
{
User user = new User();
user.setUsername("七");
user.setPassword("777");
sqlSession.insert("userMapper.insert",user);
//mybatis执行更新操作 需要最终提交事务
sqlSession.commit();
sqlSession.close();
}
修改:
<!--修改数据-->
<update id="update" parameterType="entity.User">
update user set username=#{username},password=#{password} where id=#{id}
</update>
@Test
public void update() throws IOException
{
User user = new User();
user.setId(5);
user.setUsername("晕");
user.setPassword("789");
sqlSession.update("userMapper.update",user);
//mybatis执行更新操作 需要最终提交事务
sqlSession.commit();
sqlSession.close();
}
删除:
<!--删除数据-->
<delete id="delete" parameterType="java.lang.Integer">
delete from user where id=#{id}
</delete>
@Test
public void delete()
{
sqlSession.delete("userMapper.delete",5);
sqlSession.commit();
sqlSession.close();
}