java-自定义sql

最新推荐文章于 2024-07-23 22:52:18 发布

feng_fly_28

最新推荐文章于 2024-07-23 22:52:18 发布

阅读量425

点赞数

分类专栏： java学习要点文章标签： sql java hibernate

本文链接：https://blog.csdn.net/minihuabei/article/details/125779985

版权

java学习要点专栏收录该内容

31 篇文章 0 订阅

订阅专栏

api

在这里插入图片描述

    @GetMapping("单个用户查询map")
    String findUserByIdMap(@PathVariable("id") String id);

控制器

在这里插入图片描述

    @Override
    @GetMapping("/User/findUserByIdMap/{id}")
    public String findUserByIdMap(@PathVariable("id") String id) {
        return userService.findUserByIdMap(id);
    }

在这里插入图片描述

    @Autowired
    UserMapper userMapper;

    public String findUserByIdMap(String id) {
        User user = userMapper.findUserById("34993");
//        System.out.println(user);
//        System.out.println(user.getOpenid());
        return user.getOpenid();
    }

UserMapper

在这里插入图片描述

@Mapper
public interface UserMapper {
   User findUserById(String id);
}

map

在这里插入图片描述

<?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.xuecheng.manage_user.dao.UserMapper">
    <select id="findUserById" parameterType="java.lang.String"
            resultType="com.xuecheng.framework.domain.nuoyun.User">
        select * from ny_user where id = #{id}
    </select>
</mapper>

user模型

package com.xuecheng.framework.domain.nuoyun;

import lombok.Data;
import lombok.ToString;

import javax.persistence.*;
import java.io.Serializable;

/**
 * Created by admin on 2018/2/10.
 */
@Data
@ToString
@Entity
@Table(name="ny_user")
//@GenericGenerator(name = "jpa-uuid", strategy = "uuid")
public class User implements Serializable {
    private static final long serialVersionUID = -916357110051689499L;

    @Id //声明此属性为主键。该属性值可以通过应该自身创建，但是Hibernate推荐通过Hibernate生成
//    @GeneratedValue(generator = "jpa-uuid")
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    @Column(length = 32)
    private String id;
    private String openid;
    private String unionid;
    @Column(name="first_name")//数据库里的字段名称
    private String firstName;//项目中中的字段名称
    @Column(name="invite_code")//数据库里的字段名称
    private String inviteCode;//项目中中的字段名称
    @Column(name="wechat_name")
    private String wechatName;
    private String name;
    private String type;
    @Column(name="reg_ip")
    private String regIp;
    @Column(name="reg_time")
    private String regTime;
    private String photo;
    @Column(name="auth_status")
    private String authStatus;
    @Column(name="auth_time")
    private String authTime;
    @Column(name="waiter_id")
    private String waiterId;
    @Column(name="master_type")
    private String masterType;
    @Column(name="client_type")
    private String clientType;
    @Column(name="room_limit")
    private String roomLimit;
    @Column(name="create_area")
    private String createArea;
    @Column(name="salesman")
    private String salesman;
    @Column(name="is_webrtc")
    private String isWebrtc;
    @Column(name="cdn_switch")
    private String cdnSwitch;
    @Column(name="push_extime")
    private String pushExtime;
    @Column(name="concurrency_limit")
    private String concurrencyLimit;
}