qq_44772414的博客

构造所需要的jar包

EmployeMapper.xml<?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.atguigu.mybatis.dao.EmployeeMapper"> <cac

动态sql

DepartmentMapper.javapackage com.atguigu.mybatis.dao;import com.atguigu.mybatis.bean.Department;public interface DepartmentMapper { public Department getDeptById(Integer id); public Department getDeptByIdPlus(Integer id); public Department get

Employemapper.xml文件中，注意的是返回的类型resultType也是实体类对象的<!-- public List<Employe> getEmpsByLastNameLike(String lastName); --><select id="getEmpsByLastNameLike" resultType="com.atguigu.mybatis.hello.Employe"> select * from tbl_employe where la

<!--获取自增主键的值： mysql支持自增主键，自增主键的获取，mybatis也是利用statement.getGenreatedKeys() userGenerateKeys="true";使用自增主键获取主键值策略 keyProperty:指定对应的主键属性，也就是mybatis获取到主键值以后，将这个值封装给javaBean的哪个属性 --> <insert id="addEmp" useGeneratedKeys="true" keyP.

测试块 @Test public void test2() throws Exception{ SqlSession opSession=SqlSessionFactoryji(); try { EmployeMapper employeMapper=opSession.getMapper(EmployeMapper.class); //插入一条数据,openSession。commit()手动提交一条数据 /* * Employe employe=new Empl

driver=com.mysql.jdbc.Driverurl=jdbc:mysql://localhost:3306/mybatisusername=rootpassword=123456<?xml version="1.0" encoding="UTF-8" ?> <!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN" "http://mybatis.org/dtd/mybatis-3-co.

mybatis入门helloworld构建实体类对应着数据库中的tbl_employe表，Employe类。。。。。。。package com.atguigu.mybatis.hello;public class Employe { private Integer id; private String lastName; private String gender; private String email; public Integer getId() { return id;