项目管理必备及MyBatis入门--MyBatis入门

MyBatis入门

​

 

​

 

​

 

数据库

create table users(
	id int auto_increment primary key comment '用户编号',
	username varchar(50) comment '登录账号',
	userpass varchar(50) comment '登录密码',
	nickname varchar(20) comment '用户昵称'
);

insert into users values (1,'admin','admin','管理员');
insert into users values (2,'manager','manager','管理员');
insert into users values (3,'administrator','administrator','管理员');

select * from users;

mybatis.xml

user.java

usersMapper

<?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="org.mybatis.example.BlogMapper">
<select id="selectBlog" resultType="Blog">
select * from Blog where id = #{id}
</select>
</mapper>

Test

运行