Mybatis
1.CRUD
1、namespace
namespace中的包名要和Dao/mapper接口的包名一样
2、select
选择,查询语句
-
id:就是对应的namespace中的方法名;
-
resultType:Sql语句执行的返回值
-
parameterType:参数类型
1.编写接口
//根据ID查询用户 User getUserById(int id);
2.编写对应的mapper中的sql语句
<select id="getUserById" parameterType="int" resultType="com.lwl.pojo.User"> select *from mybatis.user where id=#{id} </select>
3.测试
@Test public void getUserById() { SqlSession sqlSession = MybatisUtils.getSqlSession(); UserMapper mapper = sqlSession.getMapper(UserMapper.class); User userById = mapper.getUserById(1); System.out.println(userById); sqlSession.close(); } //增删改需要提交事务
3、Insert
<insert id="addUser" parameterType="com.lwl.pojo.User">
insert into mybatis.user(id,name,pwd) values(#{id},#{name},#{pwd})
</insert>
4、Update
<update