一年不洗澡-_- 2017-09-01 04:10 采纳率: 50%
浏览 3042
已采纳

mysql报错Unknown column

本人小白(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'

  • 写回答

4条回答 默认 最新

  • 崔伟 2017-09-01 05:08
    关注

    “Unknown column 'user0_.userId' in 'field list'”数据库字段可能sql字段可能不一致,查看创建表sql语句是 否有空格,或特殊字符引起错误
    分享个链接给你。http://blog.csdn.net/gnail_oug/article/details/53606608

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(3条)

报告相同问题?

悬赏问题

  • ¥15 matlab数字图像处理频率域滤波
  • ¥15 在abaqus做了二维正交切削模型,给刀具添加了超声振动条件后输出切削力为什么比普通切削增大这么多
  • ¥15 ELGamal和paillier计算效率谁快?
  • ¥15 file converter 转换格式失败 报错 Error marking filters as finished,如何解决?
  • ¥15 ubuntu系统下挂载磁盘上执行./提示权限不够
  • ¥15 Arcgis相交分析无法绘制一个或多个图形
  • ¥15 关于#r语言#的问题:差异分析前数据准备,报错Error in data[, sampleName1] : subscript out of bounds请问怎么解决呀以下是全部代码:
  • ¥15 seatunnel-web使用SQL组件时候后台报错,无法找到表格
  • ¥15 fpga自动售货机数码管(相关搜索:数字时钟)
  • ¥15 用前端向数据库插入数据,通过debug发现数据能走到后端,但是放行之后就会提示错误