java.sql.SQLException: Column 'admin' not found.的解决方案之一

最新推荐文章于 2023-03-30 16:04:02 发布

ChiefJY

最新推荐文章于 2023-03-30 16:04:02 发布

阅读量2.5k

点赞数 1

CC 4.0 BY-SA版权

分类专栏：常见使用方法文章标签：错误解决

本文链接：https://blog.youkuaiyun.com/weixin_43510014/article/details/89344174

常见使用方法专栏收录该内容

1 篇文章

订阅专栏

本文详细记录了在使用Java进行数据库操作时遇到的错误：尝试从数据库中获取用户名admin时出现的java.sql.SQLException异常。通过对比rs.getString(username)和rs.getString(“username”)的使用，最终解决了问题。

##我只是在做简单测试登录页面，从数据库里调取username列下的用户名admin。总是出错。出错代码如下：

java.sql.SQLException: Column 'admin' not found.
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:959)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:898)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:887)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:862)
at com.mysql.jdbc.ResultSetImpl.findColumn(ResultSetImpl.java:1076)
at com.mysql.jdbc.ResultSetImpl.getString(ResultSetImpl.java:5206)
at com.cjy.login.dao.UserDaoImpl.getUserByUsernameAndPassword(UserDaoImpl.java:36)
at com.cjy.login.servlet.LoginServlet.doPost(LoginServlet.java:49)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:650)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:494)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:1025)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:445)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1137)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:637)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:318)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Unknown Source)

后来发现只是 改正前致使出错的地方
和这个的区别 改正后