做java小項目的時候提示：com.microsoft.sqlserver.jdbc.SQLServerException: 列名 sex 无效。

[咔嚓舰长]

com.microsoft.sqlserver.jdbc.SQLServerException: 列名 sex 无效。
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:190)
at com.microsoft.sqlserver.jdbc.SQLServerResultSet.findColumn(SQLServerResultSet.java:656)
at com.microsoft.sqlserver.jdbc.SQLServerResultSet.getString(SQLServerResultSet.java:2401)
at data.ReaderDao.selectReaderList(ReaderDao.java:42)
at window.BookQuery.btn_cxActionPerformed(BookQuery.java:126)
at window.BookQuery.access$0(BookQuery.java:116)
at window.BookQuery$1.actionPerformed(BookQuery.java:69)
at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995)
at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2318)
at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387)
at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:236)
at java.awt.Component.processMouseEvent(Component.java:6267)
at javax.swing.JComponent.processMouseEvent(JComponent.java:3267)
at java.awt.Component.processEvent(Component.java:6032)
at java.awt.Container.processEvent(Container.java:2041)
at java.awt.Component.dispatchEventImpl(Component.java:4630)
at java.awt.Container.dispatchEventImpl(Container.java:2099)
at java.awt.Component.dispatchEvent(Component.java:4460)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4577)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4238)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4168)
at java.awt.Container.dispatchEventImpl(Container.java:2085)
at java.awt.Window.dispatchEventImpl(Window.java:2478)
at java.awt.Component.dispatchEvent(Component.java:4460)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:599)
at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269)
at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:174)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:169)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:161)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:122)

各方面自己都檢查了一次，也修改過，但是運行都是顯示錯誤。各位幫我看看。。

[花谢尊前不敢香]

看看你表结构，看看你代码

[泰坦小毛驴]

把data.ReaderDao.selectReaderList(ReaderDao.java:42)这个方法发出来 ，再把数据库表结构发出来看看

[咔嚓舰长]

SQL 語句： CREATE TABLE book ( price decimal(11,0) NULL,--decimal 浮点型，第一位参数：有效长度，第二位参数小数占的位数 stock int NULL, publish_time datetime DEFAULT NULL, publisher varchar(1024) DEFAULT NULL, translator varchar(50) DEFAULT NULL, author varchar(50)DEFAULT NULL, type varchar(50) DEFAULT NULL, name varchar(100) DEFAULT NULL, id varchar(32) NOT NULL, PRIMARY KEY (id)) CREATE TABLE borrow ( is_back smallint DEFAULT NULL,--一种精确数值数据类型，其精度在算术运算后不变。它需要 2 个字节存储。默认为空。 back_date datetime DEFAULT NULL, borrow_date datetime DEFAULT NULL, reader_id varchar(50) DEFAULT NULL,--VARCHAR是一种比CHAR更加灵活的数据类型,同样用于表示字符数据,但是VARCHAR可以保存可变长度的字符串。 book_id varchar(50) NOT NULL, id int NOT NULL DEFAULT '0', PRIMARY KEY (id)) CREATE TABLE reader ( days_num int DEFAULT NULL, max_num int DEFAULT NULL, sex varchar(50) DEFAULT NULL, type varchar(20) DEFAULT NULL, name varchar(50) DEFAULT NULL, id int NOT NULL, PRIMARY KEY (id)) CREATE TABLE users ( is_admin smallint DEFAULT NULL, pass varchar(50) DEFAULT NULL, name varchar(50) DEFAULT NULL, id int NOT NULL, PRIMARY KEY (id)) INSERT INTO users VALUES(01,'123','king',1)

[咔嚓舰长]

該嘗試的都嘗試了，各位有高見？？

[咔嚓舰长]

包含sex字段的建表： CREATE TABLE reader ( days_num int DEFAULT NULL, max_num int DEFAULT NULL, sex char(2) DEFAULT NULL, type varchar(20) DEFAULT NULL, name varchar(50) DEFAULT NULL, id int NOT NULL, PRIMARY KEY (id)) 42行提示錯誤：reader.setSex(rs.getString("sex")); 調用到的函數： public void setSex(String sex) { this.sex = sex; }

[nai598455803]

看看数据库和pojo 字段是否对应

[nai598455803]

还有你的sql 语句

[咔嚓舰长]

細心發現原來是映射到的文件出了錯。。

[pp19911217]

映射到的文件出了错，具体是什么意思？