JSP连接SQL,使用语句时一定要“use+数据库名”不用的话就报对象名无效
try {
con=DriverManager.getConnection("jdbc:sqlserver://localhost;databeseName=salary","sa","123456");
DatabaseMetaData dma=con.getMetaData();
System.out.println(dma.getURL());
Statement stmt= con.createStatement();
ResultSet rs=stmt.executeQuery("select * from teacherinfo ");
while(rs.next()){%>
工号:<%=rs.getString("tno") %>
姓名:<%=rs.getString("teachername") %>
年龄: <%=rs.getInt("age") %>
性别:<%=rs.getString("sex") %>
职称:<%=rs.getString("title") %>
<% }
rs.close();
con.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
当写成ResultSet rs=stmt.executeQuery("use salary select * from teacherinfo ");就不报错
错误显示:
jdbc:sqlserver://localhost:1433;authenticationScheme=nativeAuthentication;xopenStates=false;sendTimeAsDatetime=true;trustServerCertificate=false;sendStringParametersAsUnicode=true;selectMethod=direct;responseBuffering=adaptive;packetSize=8000;multiSubnetFailover=false;loginTimeout=15;lockTimeout=-1;lastUpdateCount=true;encrypt=false;disableStatementPooling=true;applicationName=Microsoft JDBC Driver for SQL Server;applicationIntent=readwrite;
com.microsoft.sqlserver.jdbc.SQLServerException: 对象名 'teacherinfo' 无效。
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1515)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:792)
at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:689)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696)
at
(还有一堆就不写了)
小白求解
2处错误,
1、localhost换成localhost:1433
2、databeseName=salary换成DatabaseName=salary
在检查下自己的数据库名称,SQLServer是区分大小写的。
下一篇:笔记本电脑如何无线上网?
上一篇:vb判断一个数为质数代码大神求解