/*
Navicat Premium Data Transfer
Source Server : MySql
Source Server Type : MySQL
Source Server Version : 80017
Source Host : localhost:3306
Source Schema : mybatis
Target Server Type : MySQL
Target Server Version : 80017
File Encoding : 65001
Date: 31/05/2021 16:43:14
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
`id` int(255) UNSIGNED NOT NULL AUTO_INCREMENT,
`name` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`password` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES (2, '小何', '男');
INSERT INTO `user` VALUES (5, 'hello', '123987');
SET FOREIGN_KEY_CHECKS = 1;
<?xml version="1.0" encoding="UTF-8"?><!DOCTYPEmapperPUBLIC"-//mybatis.org//DTD Mapper 3.0//EN""http://mybatis.org/dtd/mybatis-3-mapper.dtd"><!-- 该mapper文件唯一对应的接口 --><mappernamespace="dao.UserDao"><!-- id对应接口下的方法名,parameterType表示参数类型,其中#{id}为取出参数列表中名为id的值, 返回被删除的记录条数 --><deleteid="deleteUserById"parameterType="int">
delete from user where id = #{id}
</delete><!-- id对应接口下的方法名,resultType表示返回类型,mybatis会通过反射帮我们自动封装好 --><selectid="selectAllUsers"resultType="pojo.User">
select * from user
</select></mapper>