<?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"><!--namespace是命名空间,调用时要这样 userMapper.具体的id--><mappernamespace="userMapper"><!--删除操作--><deleteid="delete"parameterType="int">
delete from user where id=#{abc}
</delete><!--修改操作--><updateid="update"parameterType="com.itheima.domain.User">
update user set username=#{username},password=#{password} where id=#{id}
</update><!--插入操作--><insertid="save"parameterType="com.itheima.domain.User">
insert into user values(#{id},#{username},#{password})
</insert><!--查询操作--><selectid="findAll"resultType="user">
select * from user
</select><!--根据id进行查询--><selectid="findById"resultType="user"parameterType="int">
select * from user where id=#{id}
</select></mapper>
编写核心文件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><!--通过properties标签加载外部properties文件--><propertiesresource="jdbc.properties"></properties><!--自定义别名--><typeAliases><typeAliastype="com.itheima.domain.User"alias="user"></typeAlias></typeAliases><!--数据源环境--><!--environments中的default是表示默认使用哪个环境,填写enviroment标签中的id--><environmentsdefault="developement"><environmentid="developement"><!--事务管理器--><transactionManagertype="JDBC"></transactionManager><!--池化类型--><dataSourcetype="POOLED"><propertyname="
Mybatis简介1.1 原始jdbc操作1.2 什么是MybatisMybatis快速入门1. 开发步骤添加MyBatis的坐标创建user数据表编写User实体类package com.itheima.domain;public class User { private int id; private String username; private String password; public int getId() {