Mybatis的使用(1)
1、创建一个maven工程
pvcc8Q8D-1622169707500)(C:\Users\yhl\AppData\Roaming\Typora\typora-user-images\image-20210525183304511.png)]
2、在pom.xml中配置mybatis的环境依赖
还需要pom.xml中配置以下代码, 来解决Maven静态资源过滤问题
<build>
<resources>
<resource>
<directory>src/main/java</directory>
<includes>
<include>**/*.properties</include>
<include>**/*.xml</include>
</includes>
<filtering>false</filtering>
</resource>
<resource>
<directory>src/main/resources</directory>
<includes>
<include>**/*.properties</include>
<include>**/*.xml</include>
</includes>
<filtering>false</filtering>
</resource>
</resources>
</build>
3、在工程下创建一个module项目
①先删除工程下的src目录
②创建mybatis-01module
[外链图片转存失败,源站可能有防盗链机制,建议将图片保存下来直接上传(img-HM1c5jXn-1622169707505)(C:\Users\yhl\AppData\Roaming\Typora\typora-user-images\image-20210525184839093.png)]
4、在mybatis-01下的src/main/resources下创建mybatis核心配置文件
[外链图片转存失败,源站可能有防盗链机制,建议将图片保存下来直接上传(img-QXphJ59n-1622169707507)(C:\Users\yhl\AppData\Roaming\Typora\typora-user-images\image-20210525185200266.png)]
配置如下:将
<?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="development">
<environment id="development">
<transactionManager type="JDBC"/>
<dataSource type="POOLED">
<property name="driver" value="com.mysql.jdbc.Driver"/>
<property name="url" value="jdbc:mysql://localhost:3306/mybatis?useSSL=true&useUnicode=true&characterEncoding=UTF-8"/>
<property name="username" value="root"/>
<property name="password" value="root"/>
</dataSource>
</environment>
</environments>
<!--映射器配置-->
<mappers>
<mapper resource="com/yhl/mapper/userMapper.xml"/>
</mappers>
</configuration>
[外链图片转存失败,源站可能有防盗链机制,建议将图片保存下来直接上传(img-6ZgJpAxK-1622169707509)(C:\Users\yhl\AppData\Roaming\Typora\typora-user-images\image-20210528102505168.png)]
5 、UserMapper接口和UserMapper.xml配置文件
public interface UserMapper {
List<User> selectUser();
//查询一个用户
User getUserById(int id);
//insert插入一个用户
int addUser(User user);
int addUser2(Map map);
//delete删除指定用户
int deleteUserById(int id);
//update修改用户信息
int updateUser(User user);
//模糊查询
List<User> selectLike(String value);
}
<?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="com.yhl.mapper.UserMapper">
<select id="selectUser" resultType="com.yhl.pojo.User">
select * from user;
</select>
<select id="getUserById" parameterType="int" resultType="com.yhl.pojo.User">
select * from mybatis.user where id = #{id};
</select>
<insert id="addUser" parameterType="com.yhl.pojo.User">
insert into mybatis.user(id, name, pwd) values (#{id}, #{name} , #{pwd});
</insert>
<delete id="deleteUserById" parameterType="int">
delete from mybatis.user where id = #{id};
</delete>
<update id="updateUser" parameterType="com.yhl.pojo.User">
update mybatis.user set name = #{name}, pwd = #{pwd} where id = #{id};
</update>
</mapper>