- html - 出于某种原因,IE8 对我的 Sass 文件中继承的 html5 CSS 不友好?
- JMeter 在响应断言中使用 span 标签的问题
- html - 在 :hover and :active? 上具有不同效果的 CSS 动画
- html - 相对于居中的 html 内容固定的 CSS 重复背景?
这是我的用户模型
public class Users {
private long id;
private String userName;
private String normalizedUserName;
private String email;
private String normalizedEmail;
private boolean emailConfirmed;
private String passwordHash;
private String securityStamp;
private String concurrencyStamp;
private String phoneNumber;
private boolean phoneNumberConfirmed;
private boolean twoFactorEnabled;
private Date lockoutEnd;
private boolean lockoutEnabled;
private int accessFailedCount;
private long shopId;
private Date registerDate;
private Collection<UserTokens> userTokensById;
public long getId() {
return id;
}
public void setId(long id) {
this.id = id;
}
public String getUserName() {
return userName;
}
public void setUserName(String userName) {
this.userName = userName;
}
public String getNormalizedUserName() {
return normalizedUserName;
}
public void setNormalizedUserName(String normalizedUserName) {
this.normalizedUserName = normalizedUserName;
}
public String getEmail() {
return email;
}
public void setEmail(String email) {
this.email = email;
}
public String getNormalizedEmail() {
return normalizedEmail;
}
public void setNormalizedEmail(String normalizedEmail) {
this.normalizedEmail = normalizedEmail;
}
public boolean isEmailConfirmed() {
return emailConfirmed;
}
public void setEmailConfirmed(boolean emailConfirmed) {
this.emailConfirmed = emailConfirmed;
}
public String getPasswordHash() {
return passwordHash;
}
public void setPasswordHash(String passwordHash) {
this.passwordHash = passwordHash;
}
public String getSecurityStamp() {
return securityStamp;
}
public void setSecurityStamp(String securityStamp) {
this.securityStamp = securityStamp;
}
public String getConcurrencyStamp() {
return concurrencyStamp;
}
public void setConcurrencyStamp(String concurrencyStamp) {
this.concurrencyStamp = concurrencyStamp;
}
public String getPhoneNumber() {
return phoneNumber;
}
public void setPhoneNumber(String phoneNumber) {
this.phoneNumber = phoneNumber;
}
public boolean isPhoneNumberConfirmed() {
return phoneNumberConfirmed;
}
public void setPhoneNumberConfirmed(boolean phoneNumberConfirmed) {
this.phoneNumberConfirmed = phoneNumberConfirmed;
}
public boolean isTwoFactorEnabled() {
return twoFactorEnabled;
}
public void setTwoFactorEnabled(boolean twoFactorEnabled) {
this.twoFactorEnabled = twoFactorEnabled;
}
public Date getLockoutEnd() {
return lockoutEnd;
}
public void setLockoutEnd(Date lockoutEnd) {
this.lockoutEnd = lockoutEnd;
}
public boolean isLockoutEnabled() {
return lockoutEnabled;
}
public void setLockoutEnabled(boolean lockoutEnabled) {
this.lockoutEnabled = lockoutEnabled;
}
public int getAccessFailedCount() {
return accessFailedCount;
}
public void setAccessFailedCount(int accessFailedCount) {
this.accessFailedCount = accessFailedCount;
}
public long getShopId() {
return shopId;
}
public void setShopId(long shopId) {
this.shopId = shopId;
}
public Date getRegisterDate() {
return registerDate;
}
public void setRegisterDate(Date registerDate) {
this.registerDate = registerDate;
}
@Override
public boolean equals(Object o) {
if (this == o) return true;
if (o == null || getClass() != o.getClass()) return false;
Users users = (Users) o;
return id == users.id &&
emailConfirmed == users.emailConfirmed &&
phoneNumberConfirmed == users.phoneNumberConfirmed &&
twoFactorEnabled == users.twoFactorEnabled &&
lockoutEnabled == users.lockoutEnabled &&
accessFailedCount == users.accessFailedCount &&
shopId == users.shopId &&
Objects.equals(userName, users.userName) &&
Objects.equals(normalizedUserName, users.normalizedUserName) &&
Objects.equals(email, users.email) &&
Objects.equals(normalizedEmail, users.normalizedEmail) &&
Objects.equals(passwordHash, users.passwordHash) &&
Objects.equals(securityStamp, users.securityStamp) &&
Objects.equals(concurrencyStamp, users.concurrencyStamp) &&
Objects.equals(phoneNumber, users.phoneNumber) &&
Objects.equals(lockoutEnd, users.lockoutEnd) &&
Objects.equals(registerDate, users.registerDate);
}
@Override
public int hashCode() {
return Objects.hash(id, userName, normalizedUserName, email, normalizedEmail, emailConfirmed, passwordHash, securityStamp, concurrencyStamp, phoneNumber, phoneNumberConfirmed, twoFactorEnabled, lockoutEnd, lockoutEnabled, accessFailedCount, shopId, registerDate);
}
public Collection<UserTokens> getUserTokensById() {
return userTokensById;
}
public void setUserTokensById(Collection<UserTokens> userTokensById) {
this.userTokensById = userTokensById;
}
}
我的 userToken 模型有多个 pk,所以我有 2 个类
这是我的 UserTokens 模型
public class UserTokens implements Serializable {
private long userId;
private String loginProvider;
private String name;
private String value;
private Date registerDate;
private Users usersByUserId;
public long getUserId() {
return userId;
}
public void setUserId(long userId) {
this.userId = userId;
}
public String getLoginProvider() {
return loginProvider;
}
public void setLoginProvider(String loginProvider) {
this.loginProvider = loginProvider;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public String getValue() {
return value;
}
public void setValue(String value) {
this.value = value;
}
public Date getRegisterDate() {
return registerDate;
}
public void setRegisterDate(Date registerDate) {
this.registerDate = registerDate;
}
@Override
public boolean equals(Object o) {
if (this == o) return true;
if (o == null || getClass() != o.getClass()) return false;
UserTokens that = (UserTokens) o;
return userId == that.userId &&
Objects.equals(loginProvider, that.loginProvider) &&
Objects.equals(name, that.name) &&
Objects.equals(value, that.value) &&
Objects.equals(registerDate, that.registerDate);
}
@Override
public int hashCode() {
return Objects.hash(userId, loginProvider, name, value, registerDate);
}
public Users getUsersByUserId() {
return usersByUserId;
}
public void setUsersByUserId(Users usersByUserId) {
this.usersByUserId = usersByUserId;
}
}
和
public class UserTokensPK implements Serializable {
private long userId;
private String loginProvider;
private String name;
public long getUserId() {
return userId;
}
public void setUserId(long userId) {
this.userId = userId;
}
public String getLoginProvider() {
return loginProvider;
}
public void setLoginProvider(String loginProvider) {
this.loginProvider = loginProvider;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
@Override
public boolean equals(Object o) {
if (this == o) return true;
if (o == null || getClass() != o.getClass()) return false;
UserTokensPK that = (UserTokensPK) o;
return userId == that.userId &&
Objects.equals(loginProvider, that.loginProvider) &&
Objects.equals(name, that.name);
}
@Override
public int hashCode() {
return Objects.hash(userId, loginProvider, name);
}
}
这是我的 hbm 用户文件
<?xml version='1.0' encoding='utf-8'?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://www.hibernate.org/dtd/hibernate-mapping-3.0.dtd">
<hibernate-mapping>
<class name="oauth.identity.Model.Users" table="Users">
<id name="id">
<column name="Id" sql-type="bigint"/>
</id>
<property name="userName">
<column name="UserName" sql-type="nvarchar(256)" length="256" not-null="true"/>
</property>
<property name="normalizedUserName">
<column name="NormalizedUserName" sql-type="nvarchar(256)" length="256" not-null="true"/>
</property>
<property name="email">
<column name="Email" sql-type="nvarchar(256)" length="256" not-null="true"/>
</property>
<property name="normalizedEmail">
<column name="NormalizedEmail" sql-type="nvarchar(256)" length="256" not-null="true"/>
</property>
<property name="emailConfirmed">
<column name="EmailConfirmed" sql-type="bit"/>
</property>
<property name="passwordHash">
<column name="PasswordHash" sql-type="nvarchar(500)" length="500" not-null="true"/>
</property>
<property name="securityStamp">
<column name="SecurityStamp" sql-type="nvarchar(500)" length="500" not-null="true"/>
</property>
<property name="concurrencyStamp">
<column name="ConcurrencyStamp" sql-type="nvarchar(500)" length="500" not-null="true"/>
</property>
<property name="phoneNumber">
<column name="PhoneNumber" sql-type="nvarchar(50)" length="50" not-null="true"/>
</property>
<property name="phoneNumberConfirmed">
<column name="PhoneNumberConfirmed" sql-type="bit"/>
</property>
<property name="twoFactorEnabled">
<column name="TwoFactorEnabled" sql-type="bit"/>
</property>
<property name="lockoutEnd">
<column name="LockoutEnd" sql-type="datetime2" not-null="true"/>
</property>
<property name="lockoutEnabled">
<column name="LockoutEnabled" sql-type="bit"/>
</property>
<property name="accessFailedCount">
<column name="AccessFailedCount" sql-type="int"/>
</property>
<property name="shopId">
<column name="ShopId" sql-type="bigint"/>
</property>
<property name="registerDate">
<column name="RegisterDate" sql-type="datetime2"/>
</property>
<set name="userTokensById" inverse="true">
<key>
<column name="UserId"/>
</key>
<one-to-many not-found="ignore" class="oauth.identity.Model.UserTokens"/>
</set>
</class>
</hibernate-mapping>
和 hbm UserToken
<hibernate-mapping>
<class name="oauth.identity.Model.UserTokens" table="UserTokens">
<composite-id>
<key-property name="loginProvider">
<column name="LoginProvider" sql-type="nvarchar(256)" length="256"/>
</key-property>
<key-property name="name">
<column name="Name" sql-type="nvarchar(256)" length="256"/>
</key-property>
</composite-id>
<property name="value">
<column name="Value" sql-type="nvarchar(4000)" length="4000" not-null="true"/>
</property>
<property name="registerDate">
<column name="RegisterDate" sql-type="datetime2"/>
</property>
<many-to-one name="usersByUserId" class="oauth.identity.Model.Users">
<column name="UserId"/>
</many-to-one>
</class>
</hibernate-mapping>
和我的应用程序上下文
<bean id="myDataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
<property name="driverClassName" value="com.microsoft.sqlserver.jdbc.SQLServerDriver"/>
<property name="url" value="jdbc:sqlserver://DPK-122\MSSQLSERVER2014;databaseName=SHC1;instanceName=MSSQLSERVER2014;"/>
<property name="username" value="sa"/>
<property name="password" value="password"/>
</bean>
<bean id="mySessionFactory" class="org.springframework.orm.hibernate5.LocalSessionFactoryBean">
<property name="dataSource" ref="myDataSource"/>
<property name="mappingResources">
<list>
<value>Users.hbm.xml</value>
<value>UserTokens.hbm.xml</value>
</list>
</property>
<property name="hibernateProperties">
<props>
<prop key="hibernate.dialect">org.hibernate.dialect.SQLServerDialect</prop>
<prop key="hibernate.show_sql">true</prop>
<prop key="hibernate.hbm2ddl.auto">update</prop>
</props>
</property>
</bean>
我认为一切都很好,但它给了我一个错误并且不能正常工作
Column 'Users.Id' is not the same data type as referencing column 'UserTokens.UserId' in foreign key 'FKe2l2gfho1gf1q3srduiy8owig'.
两种 id 类型都很大,我不明白我的错在哪里?
最佳答案
在您的 UserToken 映射文件中,SQL 类型不存在
<column name="UserId"/>
当您在用户映射中拥有它时
<column name="Id" sql-type="bigint"/>
关于java - 列 'x.Id' 与引用列 'y.xId' 的数据类型不同,我们在Stack Overflow上找到一个类似的问题: https://stackoverflow.com/questions/56304615/
我刚刚编写了这些代码,但输出不同。第二个代码的输出符合我的预期,但第一个代码的输出不正确。但为什么呢? def fib(n): x = 0 y = 1 print x
#include #include #define CUBE(y)y*(y*y) main() { int j; j = CUBE(-2+4);
这个问题在这里已经有了答案: Multiple assignment and evaluation order in Python (11 个答案) 关闭 1 年前。 我看到下面的代码,但不知道它做
我正在阅读 book , 并讲了 typeclass Eq 的定义 有两个功能== , /=在等式中,它们被实现为: x == y = not (x /= y) x /= y = not (
我最近参加了一个代码力量竞赛。在比赛的编辑部分,我看到了按位运算符之间的一种美妙关系,即 x + y = x & y + x |是的我还不知道证据。我拿了几个数字来看看这个等式是否正确。我很高兴知道这
我使用 CGRectMake(x,x,x,x) 在我的 View 中放置了一个按钮,当然 x 是位置和大小。当我使用 -(BOOL)shouldAutoRotate... 旋转 View 时,我想将按
this.x = (Math.random()*canvasWidth); this.y = (Math.random()*canvasHeight); (1) this.shift = {x: th
我想将此代码运行为“if 'Britain' or 'UK' in string do stuff, but don't do stuff if "Ex UK" 在字符串中": #Case insen
早上好,我是新来的,我带来了一个小问题。我无法针对以下问题开发有效的算法:我需要找到三个正数 x、y 和 z 的组合,以便 x + y、x - y、y + z、y - z、x + z 和 x - z
我现在正在使用 C++ 编写方案的解释器。我有一个关于定义和 lambda 的问题。 (define (add x y) (+ x y)) 扩展为 (define add (lambda (x y)
我正在尝试使用一台主机通过 FTP 将内容上传到另一台主机。 “我不会打开到 172.xxx.xxx.xxx(仅到 54.xxx.xxx.xxx)的连接”甚至不相关,因为我没有连接到那个主持人。这是托
在 Python 中,使用 [] 解包函数调用有什么区别? , 与 ()还是一无所有? def f(): return 0, 1 a, b = f() # 1 [a, b] = f() # 2
给定方程 z = z(x,y) 2 个表面 I和 II : z_I(x, y) = a0 + a1*y + a2*x + a3*y**2 + a4*x**2 + a5*x*y z_II(x, y)
几年前我有这个面试问题,但我还没有找到答案。 x 和 y 应该是什么才能形成无限循环? while (x = y && x != y) { } 我们尝试了 Nan,infinity+/-,null f
我正在尝试使用 Camel FTP Producer 将文件发送到第三方 ftp 服务器(似乎由 Amazon 托管),但遇到了一个问题,写入文件失败,并显示:文件操作失败...主机尝试数据连接 x.
关闭。这个问题需要details or clarity .它目前不接受答案。 想改进这个问题吗? 通过 editing this post 添加细节并澄清问题. 关闭 8 年前。 Improve t
我正在使用 torch.tensor.repeat() x = torch.tensor([[1, 2, 3], [4, 5, 6]]) period = x.size(1) repeats = [1
#include int main() { int x = 9; int y = 2; int z = x - (x / y) * y; printf("%d", z
我很难理解先有定义然后有两个异或表达式的含义。这个定义的作用是什么? 我尝试发送 x=8, y=7,结果是 x=15 和 y=8为什么会这样? 这是程序: #define FUNC(a,b) a^=b
我正在尝试使用 SIMD 优化此功能,但我不知道从哪里开始。 long sum(int x,int y) { return x*x*x+y*y*y; } 反汇编函数如下所示: 4007a0
我是一名优秀的程序员,十分优秀!