import com.example.demo2.com.example.dao.ShopDao;
import com.example.demo2.com.example.entity.Shops;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.ResponseBody;
import org.springframework.web.bind.annotation.RestController;
import javax.annotation.Resource;
import java.util.List;
@RestController
public class ShopController {
@Autowired
private ShopDao shopdao;
/*
* 查询
* */
@RequestMapping("sele")
@ResponseBody
public List test(){
List<Shops> finl = shopdao.finalAll();
for (Shops shop : finl){
System.out.println(shop.getNames());
System.out.println(shop.getPass());
}
return finl;
}
/*
* 添加
* */
@RequestMapping("add")
@ResponseBody
public String test1(String names,String pass,String sex){
Shops shop = new Shops();
shop.setNames(names);
shop.setPass(pass);
shop.setSex(sex);
Integer result = shopdao.add(shop);
String st = "添加失败";
if(result>0){
st = "添加成功";
}
return st;
}
/*
* 修改
* */
@RequestMapping("upda")
@ResponseBody
public String test2(Integer id,String names,String pass,String sex){
Shops shop = new Shops();
shop.setId(id);
shop.setNames(names);
shop.setPass(pass);
shop.setSex(sex);
Integer result = shopdao.updates(shop);
String st = "修改失败";
if(result>0){
st = "修改成功";
}
return st;
}
/*
* 删除
* */
@RequestMapping("dele")
@ResponseBody
public String test3(Integer id){
Integer result = shopdao.deletes(id);
String st = "删除失败";
if(result>0){
st = "删除成功";
}
return st;
}
}
dao层
import com.example.demo2.com.example.entity.Shops; import org.apache.ibatis.annotations.Mapper; import org.springframework.stereotype.Repository; import java.util.List; @Mapper//声明是一个Mapper,与springbootApplication中的@MapperScan二选一写上即可 public interface ShopDao { //查询 public List<Shops> finalAll(); //添加 public Integer add(Shops shop); //修改 public Integer updates(Shops shop); //删除 public Integer deletes(Integer id); }
mapper
<?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.example.demo2.com.example.dao.ShopDao"> <select id="finalAll" resultType="com.example.demo2.com.example.entity.Shops"> select * from first </select> <insert id="add" parameterType="com.example.demo2.com.example.entity.Shops" useGeneratedKeys="true"> INSERT INTO first(names,pass,sex) values(#{names},#{pass},#{sex}) </insert> <update id="updates" parameterType="com.example.demo2.com.example.entity.Shops"> update first set names =#{names},pass=#{pass},sex=#{sex} where id = #{id} </update> <delete id="deletes" parameterType="com.example.demo2.com.example.entity.Shops"> delete from first where id =#{id} </delete> </mapper>
application.yml
server: port: 8088 context-path: / spring: profiles: active: dev application: name: demo-2 jackson: date-format: yyyy-MM-dd HH:mm:ss time-zone: GMT+8 default-property-inclusion: non_null datasource: url: jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=UTF8 username: root password: root # 使用druid数据源 type: com.alibaba.druid.pool.DruidDataSource driver-class-name: com.mysql.jdbc.Driver filters: stat maxActive: 20 initialSize: 1 maxWait: 60000 minIdle: 1 timeBetweenEvictionRunsMillis: 60000 minEvictableIdleTimeMillis: 300000 validationQuery: select 'x' testWhileIdle: true testOnBorrow: false testOnReturn: false poolPreparedStatements: true maxOpenPreparedStatements: 20 mybatis: typeAliasesPackage: com.example.demo2.com.example.dao mapperLocations: classpath:mapper/*.xml
项目启动文件
import org.mybatis.spring.annotation.MapperScan; import org.springframework.boot.SpringApplication; import org.springframework.boot.autoconfigure.SpringBootApplication; import org.springframework.transaction.annotation.EnableTransactionManagement; @SpringBootApplication @EnableTransactionManagement//开启事务管理 @MapperScan("com.example.demo2.com.example.dao")//与dao层的@Mapper二选一写上即可(主要作用是扫包) public class Demo2Application { public static void main(String[] args) { SpringApplication.run(Demo2Application.class, args); } }
pom文件
<?xml version="1.0" encoding="UTF-8"?> <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd"> <modelVersion>4.0.0</modelVersion> <groupId>com.example</groupId> <artifactId>demo-2</artifactId> <version>0.0.1-SNAPSHOT</version> <packaging>jar</packaging> <name>demo-2</name> <description>Demo project for Spring Boot</description> <parent> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-parent</artifactId> <version>1.5.9.RELEASE</version> <relativePath/> <!-- lookup parent from repository --> </parent> <properties> <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding> <project.reporting.outputEncoding>UTF-8</project.reporting.outputEncoding> <java.version>1.8</java.version>
<!-- 这个可以使用和spring boot的mybatis两个选一 --> <!--<mybatis.version>3.3.1</mybatis.version>--> <!--<mybatis.spring.version>1.2.4</mybatis.spring.version>--> </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-aop</artifactId> </dependency> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-tomcat</artifactId> </dependency> <!-- druid --> <dependency> <groupId>com.alibaba</groupId> <artifactId>druid</artifactId> <version>1.0.11</version> </dependency> <dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> <scope>runtime</scope> </dependency> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-jdbc</artifactId> </dependency> <!--Mybatis 二选一 --> <!--<dependency> <groupId>org.mybatis</groupId> <artifactId>mybatis</artifactId> <version>${mybatis.version}</version> </dependency> <dependency> <groupId>org.mybatis</groupId> <artifactId>mybatis-spring</artifactId> <version>${mybatis.spring.version}</version> </dependency>-->
<dependency> <groupId>org.mybatis.spring.boot</groupId> <artifactId>mybatis-spring-boot-starter</artifactId> <version>1.1.1</version> </dependency> <!-- Mybatis Generator --> <dependency> <groupId>org.mybatis.generator</groupId> <artifactId>mybatis-generator-core</artifactId> <version>1.3.2</version> <scope>compile</scope> <optional>true</optional> </dependency> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-test</artifactId> <scope>test</scope> </dependency> </dependencies> <build> <plugins> <plugin> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-maven-plugin</artifactId> </plugin> </plugins> </build> </project>
以上是ssm的简单流程
以下是jpa的简单流程
import org.springframework.boot.SpringApplication; import org.springframework.boot.autoconfigure.EnableAutoConfiguration; import org.springframework.boot.autoconfigure.SpringBootApplication; import org.springframework.boot.autoconfigure.domain.EntityScan; import org.springframework.context.annotation.ComponentScan; import org.springframework.data.jpa.repository.config.EnableJpaRepositories; @ComponentScan(basePackages = {"com.example.demo3.action"}) @EnableJpaRepositories(basePackages = "com.example.demo3.dao") @EntityScan("com.example.demo3.entity") @EnableAutoConfiguration @SpringBootApplication public class Demo3Application { public static void main(String[] args) { SpringApplication.run(Demo3Application.class, args); } }
import com.example.demo3.dao.FirstDao; import com.example.demo3.entity.First; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.boot.autoconfigure.EnableAutoConfiguration; import org.springframework.boot.autoconfigure.jdbc.DataSourceAutoConfiguration; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.bind.annotation.ResponseBody; import org.springframework.web.bind.annotation.RestController; @RestController public class Action { @Autowired private FirstDao firstDao; @RequestMapping("hello") @ResponseBody public First test1(Integer id){ First first = firstDao.findOne(id); return first; } }
import javax.persistence.*; @Entity @Table(name="first") public class First { @Id @GeneratedValue(strategy = GenerationType.IDENTITY) @Column(name = "id") private Integer id; @Column(name="names") private String names; @Column(name="pass") private String pass; @Column(name="sex") private String sex; public Integer getId() { return id; } public void setId(Integer id) { this.id = id; } public String getNames() { return names; } public void setNames(String names) { this.names = names; } public String getPass() { return pass; } public void setPass(String pass) { this.pass = pass; } public String getSex() { return sex; } public void setSex(String sex) { this.sex = sex; } }
import com.example.demo3.entity.First; import org.springframework.data.jpa.repository.JpaRepository; import java.util.List; public interface FirstDao extends JpaRepository<First,Integer>{ }
spring: datasource: url: jdbc:mysql:/localhost:3306/test?useUnicode=true&characterEncoding=UTF-8 username: root password: root driver-class-name: com.mysql.jdbc.Driver type: com.alibaba.druid.pool.DruidDataSource filters: stat maxActive: 20 initialSize: 1 maxWait: 60000 minIdle: 1 timeBetweenEvictionRunsMillis: 60000 minEvictableIdleTimeMillis: 300000 validationQuery: select 'x' testWhileIdle: true testOnBorrow: false testOnReturn: false poolPreparedStatements: true maxOpenPreparedStatements: 20 jpa: show-sql: true hibernate: ddl-auto: create server: port : 8088 context-path : /
<?xml version="1.0" encoding="UTF-8"?> <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd"> <modelVersion>4.0.0</modelVersion> <groupId>com.example</groupId> <artifactId>demo-3</artifactId> <version>0.0.1-SNAPSHOT</version> <packaging>jar</packaging> <name>demo-3</name> <description>Demo project for Spring Boot</description> <parent> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-parent</artifactId> <version>1.5.9.RELEASE</version> <relativePath/> <!-- lookup parent from repository --> </parent> <properties> <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding> <project.reporting.outputEncoding>UTF-8</project.reporting.outputEncoding> <java.version>1.8</java.version> </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-data-jpa</artifactId> </dependency> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-aop</artifactId> <version>1.5.4.RELEASE</version> </dependency> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-tomcat</artifactId> </dependency> <dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> <scope>runtime</scope> </dependency> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-test</artifactId> <scope>test</scope> </dependency> <!-- druid --> <dependency> <groupId>com.alibaba</groupId> <artifactId>druid</artifactId> <version>1.0.11</version> </dependency> <dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> <scope>runtime</scope> </dependency> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-jdbc</artifactId> </dependency> </dependencies> <build> <plugins> <plugin> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-maven-plugin</artifactId> </plugin> </plugins> </build> </project>
以上就是全部的demo,中间出现了一些问题,也都慢慢的解决了,有了解的朋友可以加我微信
如可以解决的问题,私信发我.
微信