java 连接SQL数据库出错小白恳请大神帮忙一下~

浮生成诗 2017-11-14 09:05:55



//SQL语句代码

public UserDto login(String name,String password) throws SQLException{

		QueryRunner runner = new QueryRunner(C3P0Utils.getDataSource());

		String sql = "select *from loginuser where Name=? and Password = ?";

		UserDto user = (UserDto)runner.query(sql, new BeanHandler(UserDto.class),new Object[]{name,password});

		return user;

	}



//错误

java.sql.SQLException: com.microsoft.sqlserver.jdbc.SQLServerException: 无法识别元数据的表 select *from loginuser where Name=? and Password = ?。 Query: select *from loginuser where Name=? and Password = ? Parameters: [root, root]

	at org.apache.commons.dbutils.AbstractQueryRunner.rethrow(AbstractQueryRunner.java:527)

	at org.apache.commons.dbutils.QueryRunner.query(QueryRunner.java:391)

	at org.apache.commons.dbutils.QueryRunner.query(QueryRunner.java:329)

	at cn.edu.lingnan.dao.UserDao.login(UserDao.java:63)

	at cn.edu.lingnan.servlet.loginservlet.doPost(loginservlet.java:54)

	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:220)

	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)

	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:505)

	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)

	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)

	at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:956)

	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)

	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:423)

	at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1079)



	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:625)

	at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.doRun(AprEndpoint.java:2522)

	at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.run(AprEndpoint.java:2511)

	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)

	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)

	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)

	at java.lang.Thread.run(Thread.java:744)