ID 字段

@Id				@GeneratedValue(strategy = GenerationType.IDENTITY)				@Column(name = "id", unique = true, nullable = false, insertable = true, updatable = false)				private int id;

unique 属性表示该字段是否为唯一标识，默认为false。如果表中有一个字段需要唯一标识，则既可以使用该标记，也可以使用@Table标记中的@UniqueConstraint。				nullable 属性表示该字段是否可以为null值，默认为true。				insertable 属性表示在使用“INSERT”脚本插入数据时，是否需要插入该字段的值。				updatable 属性表示在使用“UPDATE”脚本插入数据时，是否需要更新该字段的值。insertable和updatable属性一般多用于只读的属性，例如主键和外键等。这些字段的值通常是自动生成的。				columnDefinition属性表示创建表时，该字段创建的SQL语句，一般用于通过Entity生成表定义时使用。				table 属性表示当映射多个表时，指定表的表中的字段。默认值为主表的表名。				length 属性表示字段的长度，当字段的类型为varchar时，该属性才有效，默认为255个字符。				precision 属性和scale属性表示精度，当字段类型为double时，precision表示数值的总长度，scale表示小数点所占的位数。

@Column(name="name", length=80, nullable=true)

@Column(precision=18, scale=5)      private BigDecimal principal; 	        @Column(name="Price", columnDefinition="Decimal(10,2) default '100.00'")

@Column(name = "ctime", nullable = false, insertable = false, updatable = false)

@NotNull				public String username;

public java.sql.Date createdate; 创建日期 YYYY-MM-DD				public java.util.Date finisheddate; 创建日期时间 YYYY-MM-DD HH:MM:SS

Json默认为 yyyy-MM-ddTHH:mm:ss 注意日期与时间中间的T，修改日期格式将T去掉

@DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")				@JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")

package common.domain;import java.util.Date;import java.util.Map;import javax.persistence.CascadeType;import javax.persistence.Column;import javax.persistence.Convert;import javax.persistence.Entity;import javax.persistence.GeneratedValue;import javax.persistence.GenerationType;import javax.persistence.Id;import javax.persistence.JoinColumn;import javax.persistence.ManyToOne;import org.springframework.format.annotation.DateTimeFormat;import com.fasterxml.jackson.annotation.JsonFormat;import common.type.OptionConverter;@Entitypublic class ItemPool {	@Id	@GeneratedValue(strategy = GenerationType.IDENTITY)	@Column(name = "id", unique = true, nullable = false, insertable = false, updatable = false)	public int id;	@ManyToOne(cascade = { CascadeType.PERSIST, CascadeType.REMOVE })	@JoinColumn(name = "site_id", referencedColumnName = "id")	private Site site;	public String question;	@Column(columnDefinition = "json DEFAULT NULL")	@Convert(converter = OptionConverter.class)	public Map
      
        options;	@Column(columnDefinition = "SET('A','B','C','D','E','F','G') DEFAULT NULL COMMENT '答案'")	public String answer;	@ManyToOne(cascade = { CascadeType.PERSIST, CascadeType.REMOVE })	@JoinColumn(name = "category_id", referencedColumnName = "id")	private Category category;	@DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")	@JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8")	@Column(columnDefinition = "TIMESTAMP DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间'")	public Date ctime;	@DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")	@JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8")	@Column(columnDefinition = "TIMESTAMP NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '更改时间'")	public Date mtime;}
      

定义 SET 如下，在JAVA中 SET被映射为逗号分隔的字符串（String），所以操作起来并无不同。使用字符串"A,B,C"存储即可，取出也同样是字符串。

@Column(columnDefinition = "SET('A','B','C','D','E','F','G') DEFAULT NULL COMMENT '答案'")

接入后查看

mysql> select answer from item_pool;+--------+| answer |+--------+| A,B,C  |+--------+1 row in set (0.00 sec)

完美实现

无符号整形

package com.example.api.domain.elasticsearch;import java.util.Date;import javax.persistence.Column;import javax.persistence.Entity;import javax.persistence.Id;import javax.persistence.Table;@Entity@Tablepublic class Member {	@Id	private int id;			@Column(columnDefinition = "INT(10) UNSIGNED NOT NULL")	private int age;		@Column(insertable = false, updatable = false, columnDefinition = "TIMESTAMP DEFAULT CURRENT_TIMESTAMP")	private Date ctime;	@Column(nullable = true, insertable = false, updatable = false, columnDefinition = "TIMESTAMP NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP")	private Date mtime;	@Column(columnDefinition = "enum('Y','N') DEFAULT 'N'")	private boolean status;}

CREATE TABLE `member` (  `id` int(11) NOT NULL,  `age` int(10) unsigned NOT NULL,  `ctime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,  `mtime` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,  `status` enum('Y','N') DEFAULT 'N',  PRIMARY KEY (`id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8

MySQL 5.7 中增加了 json 数据类型，下面是一个例子：

CREATE TABLE `test` (  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,  `your` json DEFAULT NULL,  PRIMARY KEY (`id`)) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8

我们需要在 Java 实体中定义 json 数据库结构，我搜索遍了整个互联网（Google,Bing,Baidu......），没有找到解决方案，功夫不负有心人，反复尝试后终于成功。记住我是第一个这样用的 ：） 。

package common.domain;import java.util.Date;import java.util.Map;import javax.persistence.CascadeType;import javax.persistence.Column;import javax.persistence.Convert;import javax.persistence.Entity;import javax.persistence.GeneratedValue;import javax.persistence.GenerationType;import javax.persistence.Id;import javax.persistence.JoinColumn;import javax.persistence.ManyToOne;import org.springframework.format.annotation.DateTimeFormat;import com.fasterxml.jackson.annotation.JsonFormat;import common.type.OptionConverter;@Entitypublic class ItemPool {	@Id	@GeneratedValue(strategy = GenerationType.IDENTITY)	@Column(name = "id", unique = true, nullable = false, insertable = false, updatable = false)	public int id;	@ManyToOne(cascade = { CascadeType.PERSIST, CascadeType.REMOVE })	@JoinColumn(name = "site_id", referencedColumnName = "id")	private Site site;	public String name;	@Column(columnDefinition = "json DEFAULT NULL")	@Convert(converter = OptionConverter.class)	public Map
      
        options;	@ManyToOne(cascade = { CascadeType.PERSIST, CascadeType.REMOVE })	@JoinColumn(name = "category_id", referencedColumnName = "id")	private Category category;	@DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")	@JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8")	@Column(columnDefinition = "TIMESTAMP DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间'")	public Date ctime;	@DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")	@JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8")	@Column(columnDefinition = "TIMESTAMP NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '更改时间'")	public Date mtime;}
      

类型转换 Class

package common.type;import java.util.Map;import javax.persistence.AttributeConverter;import com.google.gson.Gson;import com.google.gson.reflect.TypeToken;public class OptionConverter implements AttributeConverter

通过 @Column(columnDefinition = "json DEFAULT NULL") 定义数据库为 JSON 数据类型

数据存储与取出通过 @Convert(converter = OptionConverter.class) 做转换

这里我需要使用 Map 数据结构 public Map<String, String> options;， 你可以根据你的实际需要定义数据类型 Class

启动 Spring 项目后创建 Schema 如下：

CREATE TABLE `item_pool` (  `id` int(11) NOT NULL AUTO_INCREMENT,  `ctime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '????',  `mtime` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '????',  `name` varchar(255) DEFAULT NULL,  `category_id` int(11) DEFAULT NULL,  `site_id` int(11) DEFAULT NULL,  PRIMARY KEY (`id`),  KEY `FKgwuxedi20fxclobkk2po053hj` (`category_id`),  KEY `FKiujumwssofow95st51ukklpgv` (`site_id`),  CONSTRAINT `FKgwuxedi20fxclobkk2po053hj` FOREIGN KEY (`category_id`) REFERENCES `category` (`id`),  CONSTRAINT `FKiujumwssofow95st51ukklpgv` FOREIGN KEY (`site_id`) REFERENCES `site` (`id`)) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8

我们做个简单的测试, 创建仓库。

package common.repository;import org.springframework.data.repository.CrudRepository;import org.springframework.stereotype.Repository;import common.domain.ItemPool;@Repositorypublic interface ItemPoolRepository extends CrudRepository
      
        {}
      

package cn.netkiller.api.restful;import java.util.LinkedHashMap;import java.util.List;import java.util.Map;import org.slf4j.Logger;import org.slf4j.LoggerFactory;import org.springframework.beans.factory.annotation.Autowired;import org.springframework.web.bind.annotation.GetMapping;import org.springframework.web.bind.annotation.PathVariable;import org.springframework.web.bind.annotation.PostMapping;import org.springframework.web.bind.annotation.RequestBody;import org.springframework.web.bind.annotation.RequestMapping;import org.springframework.web.bind.annotation.RequestMethod;import org.springframework.web.bind.annotation.RestController;import common.domain.ItemPool;import common.repository.ItemPoolRepository;@RestControllerpublic class TestRestController {	private static final Logger logger = LoggerFactory.getLogger(TestRestController.class);	@Autowired	private ItemPoolRepository itemPoolRepository;	@GetMapping("/test/json/data/type")	public void jsonType() {		ItemPool itemPool = new ItemPool();		itemPool.name = "Which is Operstion System?";		Map
      
        opt = new LinkedHashMap
       
        ();		opt.put("A", "Linux");		opt.put("B", "Java");		itemPool.options = opt;		itemPoolRepository.save(itemPool);		itemPool = null;		itemPool = itemPoolRepository.findOne(1);		System.out.println(itemPool.toString());	}}
       
      

只能用完美来形容

mysql> select options from item_pool;+-----------------------------+| options                     |+-----------------------------+| {"A": "Linux", "B": "Java"} |+-----------------------------+1 row in set (0.00 sec)

@JoinColumn与@Column注释类似，它的定义如下代码所示。

@Target({METHOD, FIELD}) @Retention(RUNTIME) public @interface JoinColumn { String name() default ""; String referencedColumnName() default ""; boolean unique() default false; boolean nullable() default true; boolean insertable() default true; boolean updatable() default true; String columnDefinition() default ""; String table() default ""; }

一对一表结构，如下面ER图所示，users表是用户表里面有登陆信息，profile 保存的时死人信息，这样的目的是我们尽量减少users表的字段，在频繁操作该表的时候性能比较好，另外一个目的是为了横向水平扩展。

+----------+             +------------+    | users    |             | profile    |    +----------+             +------------+    | id       | <---1:1---o | id         |    | name     |             | sex        |        | password |             | email      |        +----------+             +------------+

package cn.netkiller.api.domain.test;import java.io.Serializable;import javax.persistence.Entity;import javax.persistence.GeneratedValue;import javax.persistence.GenerationType;import javax.persistence.Id;import javax.persistence.Table;@Entity@Table(name = "users")public class Users implements Serializable {	@Id	@GeneratedValue(strategy = GenerationType.AUTO)	private int id;	private String name;	private String password;	public int getId() {		return id;	}	public void setId(int id) {		this.id = id;	}	public String getName() {		return name;	}	public void setName(String name) {		this.name = name;	}	public String getPassword() {		return password;	}	public void setPassword(String password) {		this.password = password;	}	@Override	public String toString() {		return "Users [id=" + id + ", name=" + name + ", password=" + password + "]";	}}

package cn.netkiller.api.domain.test;import java.io.Serializable;import javax.persistence.Entity;import javax.persistence.Id;import javax.persistence.JoinColumn;import javax.persistence.OneToOne;import javax.persistence.Table;@Entity@Table(name = "profile")public class Profile implements Serializable {	/**	 * 	 */	private static final long serialVersionUID = -2500499458196257167L;	@Id	@OneToOne	@JoinColumn(name = "id")	private Users users;	private int age;	private String sex;	private String email;	public Users getUsers() {		return users;	}	public void setUsers(Users users) {		this.users = users;	}	public int getAge() {		return age;	}	public void setAge(int age) {		this.age = age;	}	public String getSex() {		return sex;	}	public void setSex(String sex) {		this.sex = sex;	}	public String getEmail() {		return email;	}	public void setEmail(String email) {		this.email = email;	}	@Override	public String toString() {		return "Profile [users=" + users + ", age=" + age + ", sex=" + sex + ", email=" + email + "]";	}}

CREATE TABLE `users` (	`id` INT(11) NOT NULL AUTO_INCREMENT,	`name` VARCHAR(255) NULL DEFAULT NULL,	`password` VARCHAR(255) NULL DEFAULT NULL,	PRIMARY KEY (`id`))COLLATE='utf8_general_ci'ENGINE=InnoDB;			CREATE TABLE `profile` (	`age` INT(11) NOT NULL,	`email` VARCHAR(255) NULL DEFAULT NULL,	`sex` VARCHAR(255) NULL DEFAULT NULL,	`id` INT(11) NOT NULL,	PRIMARY KEY (`id`),	CONSTRAINT `FK6x079ilawxjrfsljwyyi5ujjq` FOREIGN KEY (`id`) REFERENCES `users` (`id`))COLLATE='utf8_general_ci'ENGINE=InnoDB;

如果第二张表关联的并非主表的PK（主键）需要使用 referencedColumnName 指定。

@JoinColumn(name = "member_id",referencedColumnName="member_id")

我们要实现一个一对多实体关系，ER 图如下

+----------+          +------------+    | Classes  |          | Student    |    +----------+          +------------+    | id       | <---+    | id         |    | name     |     |    | name       |        +----------+     +--o | classes_id |                              +------------+

classes 表需要 OneToMany 注解，Student 表需要 ManyToOne 注解，这样就建立起了表与表之间的关系

package cn.netkiller.api.domain.test;import java.io.Serializable;import java.util.Set;import javax.persistence.CascadeType;import javax.persistence.Entity;import javax.persistence.GeneratedValue;import javax.persistence.GenerationType;import javax.persistence.Id;import javax.persistence.OneToMany;import javax.persistence.Table;@Entity @Table(name="classes") public class Classes implements Serializable{	/**	 * 	 */	private static final long serialVersionUID = -5422905745519948312L;	@Id 	@GeneratedValue(strategy=GenerationType.AUTO) 	private int id; 	private String name; 	    	@OneToMany(cascade=CascadeType.ALL,mappedBy="classes")    	private Set
      
        students;	public int getId() {		return id;	}	public void setId(int id) {		this.id = id;	}	public String getName() {		return name;	}	public void setName(String name) {		this.name = name;	}	public Set
       
         getStudents() {		return students;	}	public void setStudents(Set
        
          students) {		this.students = students;	}	@Override	public String toString() {		return "classes [id=" + id + ", name=" + name + ", students=" + students + "]";	} }
        
       
      

package cn.netkiller.api.domain.test;import java.io.Serializable;import javax.persistence.CascadeType;import javax.persistence.Entity;import javax.persistence.GeneratedValue;import javax.persistence.GenerationType;import javax.persistence.Id;import javax.persistence.JoinColumn;import javax.persistence.ManyToOne;import javax.persistence.Table;@Entity@Table(name = "student")public class Student implements Serializable{	/**	 * 	 */	private static final long serialVersionUID = 6737037465677800326L;	@Id	@GeneratedValue(strategy = GenerationType.AUTO)	private int id;	private String name;	// 若有多个cascade，可以是：{CascadeType.PERSIST,CascadeType.MERGE}	@ManyToOne(cascade = { CascadeType.ALL })	@JoinColumn(name = "classes_id") 	private Classes classes;	public int getId() {		return id;	}	public void setId(int id) {		this.id = id;	}	public String getName() {		return name;	}	public void setName(String name) {		this.name = name;	}	public Classes getClasses() {		return classes;	}	public void setClasses(Classes classes) {		this.classes = classes;	}	@Override	public String toString() {		return "Student [id=" + id + ", name=" + name + ", classes=" + classes + "]";	}}

最终 SQL 表如下

CREATE TABLE `classes` (	`id` INT(11) NOT NULL AUTO_INCREMENT,	`name` VARCHAR(255) NULL DEFAULT NULL,	PRIMARY KEY (`id`))COLLATE='utf8_general_ci'ENGINE=InnoDB;				CREATE TABLE `student` (	`id` INT(11) NOT NULL AUTO_INCREMENT,	`name` VARCHAR(255) NULL DEFAULT NULL,	`class_id` INT(11) NULL DEFAULT NULL,	PRIMARY KEY (`id`),	INDEX `FKnsl7w2nw6o6eq53hqlxfcijpm` (`class_id`),	CONSTRAINT `FKnsl7w2nw6o6eq53hqlxfcijpm` FOREIGN KEY (`class_id`) REFERENCES `classes` (`id`))COLLATE='utf8_general_ci'ENGINE=InnoDB;

Classes classes=new Classes();       classes.setName("One");               Student st1=new Student();       st1.setSname("jason");       st1.setClasses(classes);       studentRepostitory.save(st1);               Student st2=new Student();       st2.setSname("neo");       st2.setClasses(classes);       studentRepostitory.save(st2);

用户与角色就是一个多对多的关系，多对多是需要中间表做关联的。所以我方需要一个 user_has_role 表。

+----------+          +---------------+            +--------+    | users    |          | user_has_role |            | role   |    +----------+          +---------------+            +--------+    | id       | <------o | user_id       |      /---> | id     |    | name     |          | role_id       | o---+      | name   |    | password |          |               |            |        |    +----------+          +---------------+            +--------+

创建 User 表

package cn.netkiller.api.domain.test;import java.io.Serializable;import java.util.Set;import javax.persistence.Entity;import javax.persistence.FetchType;import javax.persistence.GeneratedValue;import javax.persistence.GenerationType;import javax.persistence.Id;import javax.persistence.JoinTable;import javax.persistence.ManyToMany;import javax.persistence.Table;import javax.persistence.JoinColumn;@Entity@Table(name = "users")public class Users implements Serializable {	/**	 * 	 */	private static final long serialVersionUID = -2480194112597046349L;	@Id	@GeneratedValue(strategy = GenerationType.AUTO)	private int id;	private String name;	private String password;	@ManyToMany(fetch = FetchType.EAGER)	@JoinTable(name = "user_has_role", joinColumns = { @JoinColumn(name = "user_id", referencedColumnName = "id") }, inverseJoinColumns = { @JoinColumn(name = "role_id", referencedColumnName = "id") })	private Set
      
        roles;	public int getId() {		return id;	}	public void setId(int id) {		this.id = id;	}	public String getName() {		return name;	}	public void setName(String name) {		this.name = name;	}	public String getPassword() {		return password;	}	public void setPassword(String password) {		this.password = password;	}	public Set
       
         getRoles() {		return roles;	}	public void setRoles(Set
        
          roles) {		this.roles = roles;	}	@Override	public String toString() {		return "Users [id=" + id + ", name=" + name + ", password=" + password + ", roles=" + roles + "]";	}}
        
       
      

创建 Role 表

package cn.netkiller.api.domain.test;import java.io.Serializable;import java.util.Set;import javax.persistence.Entity;import javax.persistence.GeneratedValue;import javax.persistence.GenerationType;import javax.persistence.Id;import javax.persistence.ManyToMany;import javax.persistence.Table;@Entity@Table(name = "roles")public class Roles implements Serializable {	private static final long serialVersionUID = 6737037465677800326L;	@Id	@GeneratedValue(strategy = GenerationType.AUTO)	private int id;	private String name;	@ManyToMany(mappedBy = "roles")	private Set
      
        users;	public int getId() {		return id;	}	public void setId(int id) {		this.id = id;	}	public String getName() {		return name;	}	public void setName(String name) {		this.name = name;	}	public Set
       
         getUsers() {		return users;	}	public void setUsers(Set
        
          users) {		this.users = users;	}	@Override	public String toString() {		return "Roles [id=" + id + ", name=" + name + ", users=" + users + "]";	}}
        
       
      

最终产生数据库表如下

CREATE TABLE `users` (	`id` INT(11) NOT NULL AUTO_INCREMENT,	`name` VARCHAR(255) NULL DEFAULT NULL,	`password` VARCHAR(255) NULL DEFAULT NULL,	PRIMARY KEY (`id`))COLLATE='utf8_general_ci'ENGINE=InnoDB;	CREATE TABLE `roles` (	`id` INT(11) NOT NULL AUTO_INCREMENT,	`name` VARCHAR(255) NULL DEFAULT NULL,	PRIMARY KEY (`id`))COLLATE='utf8_general_ci'ENGINE=InnoDB;			CREATE TABLE `user_has_role` (	`user_id` INT(11) NOT NULL,	`role_id` INT(11) NOT NULL,	PRIMARY KEY (`user_id`, `role_id`),	INDEX `FKsvvq61v3koh04fycopbjx72hj` (`role_id`),	CONSTRAINT `FK2dl1ftxlkldulcp934i3125qo` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`),	CONSTRAINT `FKsvvq61v3koh04fycopbjx72hj` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`))COLLATE='utf8_general_ci'ENGINE=InnoDB;

orphanRemoval = true 可以实现数据级联删除

package cn.netkiller.api.domain;import java.io.Serializable;import java.util.Set;import javax.persistence.CascadeType;import javax.persistence.Column;import javax.persistence.Entity;import javax.persistence.Id;import javax.persistence.OneToMany;import javax.persistence.GeneratedValue;import javax.persistence.GenerationType;import javax.persistence.Table;import com.fasterxml.jackson.annotation.JsonIgnore;@Entity@Table(name = "member")public class Member implements Serializable {	/**	 * 	 */	private static final long serialVersionUID = 1L;	@Id	@GeneratedValue(strategy = GenerationType.IDENTITY)	@Column(name = "id", unique = true, nullable = false, insertable = true, updatable = false)	private int id;	private String name;	private String sex;	private int age;	private String wechat;	@Column(unique = true)	private String mobile;	private String picture;	private String ipAddress;	@JsonIgnore	@OneToMany(cascade = CascadeType.ALL, orphanRemoval = true, mappedBy = "member")	private Set
      
        comment;	@JsonIgnore	@OneToMany(cascade = CascadeType.ALL, orphanRemoval = true, mappedBy = "member")	private Set
       
         statisticsHistory;	public Member() {	}	public Member(int id) {		this.id = id;	}	public int getId() {		return id;	}	public void setId(int id) {		this.id = id;	}	public String getName() {		return name;	}	public void setName(String name) {		this.name = name;	}	public String getSex() {		return sex;	}	public void setSex(String sex) {		this.sex = sex;	}	public int getAge() {		return age;	}	public void setAge(int age) {		this.age = age;	}	public String getWechat() {		return wechat;	}	public void setWechat(String wechat) {		this.wechat = wechat;	}	public String getMobile() {		return mobile;	}	public void setMobile(String mobile) {		this.mobile = mobile;	}	public String getPicture() {		return picture;	}	public void setPicture(String picture) {		this.picture = picture;	}	public String getIpAddress() {		return ipAddress;	}	public void setIpAddress(String ipAddress) {		this.ipAddress = ipAddress;	}	@Override	public String toString() {		return "Member [id=" + id + ", name=" + name + ", sex=" + sex + ", age=" + age + ", wechat=" + wechat + ", mobile=" + mobile + ", picture=" + picture + ", ipAddress=" + ipAddress + "]";	}}
       
      

package cn.netkiller.api.repository;import org.springframework.data.repository.CrudRepository;import cn.netkiller.api.domain.StatisticsHistory;public interface StatisticsHistoryRepostitory extends CrudRepository
      
        {	public StatisticsHistory findByMemberIdAndStatisticsIdAndType(long member_id, long statistics_id,			StatisticsHistory.StatisticsType type);}
      

@Autowired	private StatisticsHistoryRepostitory statisticsHistoryRepostitory;							statisticsHistoryRepostitory.findByMemberIdAndStatisticsIdAndType(uid, id, type);

package cn.netkiller.api.repository;import java.util.List;import org.springframework.data.domain.Pageable;import org.springframework.data.repository.CrudRepository;import cn.netkiller.api.domain.RecentRead;public interface RecentReadRepostitory extends CrudRepository
      
        {	List
       
         findByMemberId(long id, Pageable pageable);}
       
      

Top 10 实例

@RequestMapping("/recent/read/list/{id}")	public List
      
        recentList(@PathVariable long id) {		int page = 0;		int limit = 10;		List
       
         recentRead = recentReadRepostitory.findByMemberId(id, new PageRequest(page, limit));		return recentRead;	}
       
      

List
      
        findByName(String name, Sort sort);
      

Sort sort = new Sort(Direction.DESC, "id"); repostitory.findByName("Neo", sort);

public List
      
        findAllByOrderByIdAsc();public List
       
         findAllByOrderByIdDesc();List
        
          findByMemberIdOrderByIdDesc(int memberId, Pageable pageable);
        
       
      

package schedule.repository;import java.util.Date;import org.springframework.data.repository.CrudRepository;import common.domain.CmsTrash;public interface CmsTrashRepository extends CrudRepository
      
        {	Iterable
       
         findBySiteIdAndTypeOrderByCtimeASC(int siteId, String string);	Iterable
        
          findBySiteIdAndTypeAndCtimeGreaterThanOrderByCtimeASC(int siteId, String string, Date date);}