Springboot JPA 实现复合主键

package cn.netkiller.wallet.domain;

import javax.persistence.Embeddable;
import javax.persistence.EmbeddedId;
import javax.persistence.Entity;

@Entity
public class UserHasToken {
	@EmbeddedId
	private UserHasTokenPk id;

	private String name;
	private String symbol;
	private int decimals;

	public UserHasToken() {
		// TODO Auto-generated constructor stub
	}

	public UserHasTokenPk getId() {
		return id;
	}

	public void setId(UserHasTokenPk id) {
		this.id = id;
	}

	public String getName() {
		return name;
	}

	public void setName(String name) {
		this.name = name;
	}

	public String getSymbol() {
		return symbol;
	}

	public void setSymbol(String symbol) {
		this.symbol = symbol;
	}

	public int getDecimals() {
		return decimals;
	}

	public void setDecimals(int decimals) {
		this.decimals = decimals;
	}

	@Embeddable
	public class UserHasTokenPk implements java.io.Serializable {

		private static final long serialVersionUID = 1242827922377178368L;
		private String address;
		private String contractAddress;

		public UserHasTokenPk(String address, String contractAddress) {
			super();
			this.address = address;
			this.contractAddress = contractAddress;
		}

		public String getAddress() {
			return address;
		}

		public void setAddress(String address) {
			this.address = address;
		}

		public String getContractAddress() {
			return contractAddress;
		}

		public void setContractAddress(String contractAddress) {
			this.contractAddress = contractAddress;
		}

		@Override
		public String toString() {
			return "UserHasTokenPk [address=" + address + ", contractAddress=" + contractAddress + "]";
		}

	}

}

package cn.netkiller.wallet.repository;

import java.util.List;

import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.query.Param;

import cn.netkiller.wallet.domain.UserHasToken;
import cn.netkiller.wallet.domain.UserHasToken.UserHasTokenPk;;

public interface UserHasTokenRepository extends JpaRepository<UserHasToken, UserHasTokenPk> {

	@Query("select an from UserHasToken uht where uht.id.address=:address")
	List<UserHasToken> findByAddress(@Param("address") String address);

	@Query("select an from UserHasToken uht where uht.id.address=:address and uht.id.contractAddress=:contractAddress")
	List<UserHasToken> findByPk(@Param("address") String address, @Param("contractAddress") String contractAddress);
}
		

CREATE TABLE "user_has_token" (
  "address" varchar(255) NOT NULL,
  "contract_address" varchar(255) NOT NULL,
  "decimals" int(11) NOT NULL,
  "name" varchar(255) DEFAULT NULL,
  "symbol" varchar(255) DEFAULT NULL,
  PRIMARY KEY ("address","contract_address")
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4