本人小白(c币有限,求帮忙!!),在搭建ssh框架时遇到如题的问题,在网上也没有找到解决方案,求大神帮帮忙,在线等:
建表语句:
CREATE TABLE `user` (
`userId` varchar(100) NOT NULL,
`userName` varchar(255) DEFAULT NULL,
`userPassword` varchar(255) DEFAULT NULL,
`userCreateTime` varchar(255) DEFAULT NULL,
`userUpdateTime` varchar(255) DEFAULT NULL,
`userStatus` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES ('001', 'admin', '123456', null, null, null);
实体类:
@Entity
@Table(name="USER")
public class User {
private String userid;//
private String user_name;//
private String user_password;//
private String user_status;//
private String user_create_time;//
private String user_update_time;//
@Id
@Column(name="userId")
public String getUserid() {
return userid;
}
public void setUserid(String userid) {
this.userid = userid;
}
@Column(name="userName")
public String getUser_name() {
return user_name;
}
public void setUser_name(String user_name) {
this.user_name = user_name;
}
@Column(name="userPassword")
public String getUser_password() {
return user_password;
}
public void setUser_password(String user_password) {
this.user_password = user_password;
}
@Column(name="userStatus")
public String getUser_status() {
return user_status;
}
public void setUser_status(String user_status) {
this.user_status = user_status;
}
@Column(name="userCreateTime")
public String getUser_create_time() {
return user_create_time;
}
public void setUser_create_time(String user_create_time) {
this.user_create_time = user_create_time;
}
@Column(name="userUpdateTime")
public String getUser_update_time() {
return user_update_time;
}
public void setUser_update_time(String user_update_time) {
this.user_update_time = user_update_time;
}
用的ssh框架,查询时打印的sql语句正常,但报错,
错误代码如下:
Hibernate: select user0_.userId as userId1_7_, user0_.userCreateTime as userCrea2_7_, user0_.userName as userName3_7_, user0_.userPassword as userPass4_7_, user0_.userStatus as userStat5_7_, user0_.userUpdateTime as userUpda6_7_ from user user0_ where user0_.userName='admin'
2017-09-01 12:03:34,397 [http-nio-8080-exec-28] WARN [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] - SQL Error: 1054, SQLState: 42S22
2017-09-01 12:03:34,397 [http-nio-8080-exec-28] ERROR [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] - Unknown column 'user0_.userId' in 'field list'
2017-09-01 12:03:34,578 [http-nio-8080-exec-28] WARN [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] - SQL Warning Code: 1054, SQLState: 42S22
2017-09-01 12:03:34,578 [http-nio-8080-exec-28] WARN [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] - Unknown column 'user0_.userId' in 'field list'