麻豆小视频在线观看_中文黄色一级片_久久久成人精品_成片免费观看视频大全_午夜精品久久久久久久99热浪潮_成人一区二区三区四区

首頁 > 開發 > Java > 正文

詳解springboot中mybatis注解形式

2024-07-14 08:42:32
字體:
來源:轉載
供稿:網友

springboot整合mybatis對數據庫進行訪問,本實例采用注解的方式,如下:

pom.xml文件

 <parent>    <groupId>org.springframework.boot</groupId>    <artifactId>spring-boot-starter-parent</artifactId>    <version>2.0.5.RELEASE</version>  </parent>  <properties>    <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>    <maven.compiler.source>1.8</maven.compiler.source>    <maven.compiler.target>1.8</maven.compiler.target>  </properties>   <dependencies>    <dependency>      <groupId>org.springframework.boot</groupId>      <artifactId>spring-boot-starter-web</artifactId>    </dependency>    <dependency>      <groupId>org.springframework.boot</groupId>      <artifactId>spring-boot-starter-test</artifactId>      <scope>test</scope>    </dependency>     <dependency>      <groupId>org.springframework.boot</groupId>      <artifactId>spring-boot-starter-web</artifactId>    </dependency>    <dependency>      <groupId>mysql</groupId>      <artifactId>mysql-connector-java</artifactId>      <version>5.1.45</version>    </dependency>    <dependency>      <groupId>org.springframework.boot</groupId>      <artifactId>spring-boot-starter-jdbc</artifactId>    </dependency>    <dependency>      <groupId>org.springframework.boot</groupId>      <artifactId>spring-boot-configuration-processor</artifactId>      <optional>true</optional>    </dependency>    <dependency>      <groupId>org.mybatis.spring.boot</groupId>      <artifactId>mybatis-spring-boot-starter</artifactId>      <version>1.3.1</version>    </dependency>  </dependencies>   <build>    <plugins>      <plugin>        <groupId>org.springframework.boot</groupId>        <artifactId>spring-boot-maven-plugin</artifactId>      </plugin>    </plugins>  </build></project>

domain類

package com.rookie.bigdata.domain; /** * @author * @date 2018/10/9 */public class Student {  private Long stuNo;  private String name;  private Integer age;  public Student() {  }  public Student(String name, Integer age) {    this.name = name;    this.age = age;  }  public Student(Long stuNo, String name, Integer age) {    this.stuNo = stuNo;    this.name = name;    this.age = age;  }  public Long getStuNo() {    return stuNo;  }  public void setStuNo(Long stuNo) {    this.stuNo = stuNo;  }  public String getName() {    return name;  }  public void setName(String name) {    this.name = name;  }  public Integer getAge() {    return age;  }  public void setAge(Integer age) {    this.age = age;  }  @Override  public boolean equals(Object o) {    if (this == o) return true;    if (o == null || getClass() != o.getClass()) return false;    Student student = (Student) o;    if (stuNo != null ? !stuNo.equals(student.stuNo) : student.stuNo != null) return false;    if (name != null ? !name.equals(student.name) : student.name != null) return false;    return age != null ? age.equals(student.age) : student.age == null;  }  @Override  public int hashCode() {    int result = stuNo != null ? stuNo.hashCode() : 0;    result = 31 * result + (name != null ? name.hashCode() : 0);    result = 31 * result + (age != null ? age.hashCode() : 0);    return result;  }  @Override  public String toString() {    return "Student{" +        "stuNo=" + stuNo +        ", name='" + name + '/'' +        ", age=" + age +        '}';  }}

StudentMapper類

package com.rookie.bigdata.mapper;import com.rookie.bigdata.domain.Student;import org.apache.ibatis.annotations.*;import java.util.List;import java.util.Map;/** * @author * @date 2018/10/9 */@Mapperpublic interface StudentMapper {   @Select("SELECT * FROM student WHERE name = #{name}")  Student findByName(@Param("name") String name);   @Results({      @Result(property = "name", column = "name"),      @Result(property = "age", column = "age")  })  @Select("SELECT name, age FROM student")  List<Student> findAll();   @Insert("INSERT INTO student(name, age) VALUES(#{name}, #{age})")  int insert(@Param("name") String name, @Param("age") Integer age);   @Update("UPDATE student SET age=#{age} WHERE name=#{name}")  void update(Student student);   @Delete("DELETE FROM student WHERE id =#{id}")  void delete(Long id);   @Insert("INSERT INTO student(name, age) VALUES(#{name}, #{age})")  int insertByUser(Student student);   @Insert("INSERT INTO student(name, age) VALUES(#{name,jdbcType=VARCHAR}, #{age,jdbcType=INTEGER})")  int insertByMap(Map<String, Object> map); }

測試類如下:

package com.rookie.bigdata.mapper;import org.junit.Test;import org.junit.runner.RunWith;import org.springframework.beans.factory.annotation.Autowired;import org.springframework.boot.test.context.SpringBootTest;import org.springframework.test.context.junit4.SpringRunner;import org.springframework.transaction.annotation.Transactional;import static org.junit.Assert.*;/** * @author * @date 2018/10/10 */@RunWith(SpringRunner.class)@SpringBootTestpublic class StudentMapperTest {   @Autowired  private StudentMapper studentMapper;   @Test  public void findByName() throws Exception {    System.out.println(studentMapper.findByName("zhangsan"));  }   @Test  public void findAll() throws Exception {    System.out.println(studentMapper.findByName("zhangsan"));  }   @Test  public void insert() throws Exception {    System.out.println(  studentMapper.insert("zhangsan", 20));  }   @Test  public void update() throws Exception {  }   @Test  public void delete() throws Exception {  }   @Test  public void insertByUser() throws Exception {  }   @Test  public void insertByMap() throws Exception {  }}

大家可以自己編寫測試類進行測試一下,后續會更新xml的配置方式和mybatis采用多數據源進行配置的方式


注:相關教程知識閱讀請移步到JAVA教程頻道。
發表評論 共有條評論
用戶名: 密碼:
驗證碼: 匿名發表
主站蜘蛛池模板: 免费看a级片 | 国产精品美女一区二区 | 日本人乱人乱亲乱色视频观看 | av影院在线播放 | 97视频 | 精品国产一区在线 | 欧美一级黄色录相 | 毛片免费视频观看 | 亚洲精品动漫在线观看 | 一区二区三区视频在线 | 欧美一级无毛 | 色蜜桃av| 毛片一区二区三区 | 免费一级欧美大片视频 | 毛片视频播放 | 欧美自拍 | 狠狠干导航 | 久久精品视频16 | 91福利免费观看 | 少妇的肉体的满足毛片 | 久草视频福利在线观看 | 国产成年人视频 | 黄色片视频在线观看 | 在线日韩亚洲 | 免费观看黄色影片 | 视频毛片 | 国产一区二区观看 | 国产毛片网站 | 黄色免费在线网站 | 国产九九| 毛片免费在线视频 | 国产91九色在线播放 | 在线中文字幕观看 | 精品国产一区二区三区蜜殿 | 黄色片网站免费观看 | 男男啪羞羞视频网站 | 国产精品视频自拍 | 羞羞网站 | 精品一区二区免费视频视频 | 国产精品久久久久久久久久 | 91一区二区三区久久久久国产乱 |