新手上路,出了好多错,记录一下
1.创建数据库:springBootSsmTest
2.打开IDEA创建 Spring boot项目:File——New——Project——Spring Assistant,下一步,填好包名等信息,下一步
Develop Tool选Lombok
Web选Spring Web
SQL选Jpa,Mysql,Mybatis
3.把java文件夹标识 为Source Root(右键,Mark as Directory As —— Source Root)
4.在com.my.demo下创建package命名为model,然后在这里创建 Java 类
import lombok.AllArgsConstructor;import lombok.Data;import lombok.NoArgsConstructor;import javax.persistence.Entity;import javax.persistence.Id;import javax.persistence.Table;@NoArgsConstructor@AllArgsConstructor@Data@Entity@Table(name = "tb_user")public class User { @Id @GeneratedValue(strategy = GenerationType.IDENTITY) private Integer id; private String userName; private String password; private String email;}5.在resources下创建文件application.yml,删除原先的application.properties,粘帖如下代码:
spring: datasource: driver-class-name: com.mysql.jdbc.Driver url: jdbc:mysql://127.0.0.1:3306/springbootssmtest?serverTimezone=UTC username: root password: 123456 jpa: hibernate: ddl-auto: update show-sql: true6.运行程序,会自动生成数据表。7.创建package命名为mapper,添加一个java类,命名为UserMapper import java.util.List;public interface UserMapper { User getUser(Integer id);//根据id获取信息 boolean addUser(User user);//新增 boolean modifyUser(User user);//修改 boolean deleteUser(Integer id);//根据id删除 List<User> getAll();//获取所有}8.创建package命名为service,添加一个java类,命名为UserService @Servicepublic class UserService { @Autowired private UserMapper userMapper; public User getUser(Integer id){ return userMapper.getUser(id); } public boolean addUser(User user){ return userMapper.addUser(user); } public boolean modifyUser(User user){ return userMapper.modifyUser(user); } public boolean deleteUser(Integer id){ return userMapper.deleteUser(id); } public List<User> getAll(){ return userMapper.getAll(); }}9.创建package命名为controller,创建Java类命名为UserController @RestControllerpublic class UserController { @Autowired private UserService userService; /** * 获取默认的数据源信息 * @return * @throws SQLException */ /** * 根据id获取信息 * @param id * @return * @throws SQLException */ @ResponseBody @GetMapping("/user/get/{id}") public User getUser(@PathVariable("id") Integer id){ return userService.getUser(id); } /** * 获取所有信息 * @return */ @ResponseBody @GetMapping("/user/list") public List<User> getAll(){ return userService.getAll(); } /** * 新增信息 * @param user * @return */ @ResponseBody @PostMapping("/user/add") public boolean addUser(@RequestBody User user){ return userService.addUser(user); } /** * 修改信息 * @param user * @return */ @ResponseBody @PutMapping("/user/put") public boolean modifyUser(@RequestBody User user){ return userService.modifyUser(user); } /** * 删除信息 * @param id * @return */ @ResponseBody @DeleteMapping("/user/delete/{id}") public boolean deleteUser(@PathVariable("id") Integer id){ return userService.deleteUser(id); }}10.添加依赖,Import Change <!-- 整合Swagger依赖方便 REST测试 --><dependency> <groupId>io.springfox</groupId> <artifactId>springfox-swagger2</artifactId> <version>2.9.2</version></dependency><dependency> <groupId>io.springfox</groupId> <artifactId>springfox-swagger-ui</artifactId> <version>2.7.0</version></dependency> 11.打开主类,添加注解,记得改包名@MapperScan("com.my.demo.mapper")//自动扫描的Mapper包,如果这里不指定,则需要在每个Mapper接口中添加@Mapper主键(这两种方法二选一)@EnableSwagger2 //开启Swagger2功能,方便测试RestApi12.在resources下创建目录mapper,添加一个文件UserMapper,记得修改文件中两处包名。
<?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.my.demo.mapper.UserMapper"> <resultMap id="BaseResultMap" type="com.my.demo.model.User"> <id column="id" jdbcType="INTEGER" property="id"/> <result column="user_name" jdbcType="VARCHAR" property="userName"/> <result column="password" jdbcType="VARCHAR" property="password"/> <result column="email" jdbcType="VARCHAR" property="email"/> </resultMap> <!-- 根据id获取信息 --> <select id="getUser" parameterType="java.lang.Integer" resultMap="BaseResultMap"> select * from tb_user t where t.id = #{id} </select> <!-- 获取所有信息 --> <select id="getAll" resultMap="BaseResultMap"> select * from tb_user t </select> <!-- 新增 --> <insert id="addUser" parameterType="user"> insert into tb_user values(default,#{userName},#{password},#{email}) </insert> <!-- 修改 --> <update id="modifyUser" parameterType="user"> update tb_user set user_name=#{userName},password=#{password},email=#{email} where id = #{id} </update> <!-- 删除 --> <delete id="deleteUser" parameterType="java.lang.Integer"> delete from tb_user where id = #{id} </delete></mapper> 13.在application.yml中添加,记得改包名,顶格,和spring同一层次。
# Mybatis相关配置mybatis: # 对象别名包 type-aliases-package: com.my.demo.model # Mybatis mapper.xml映射文件配置 mapper-locations: - classpath:mappers/*.xml14.运行程序吧。
转载于:https://www.cnblogs.com/MarsMercury/p/11580635.html