提示javax.servlet.ServletException: com.microsoft.sqlserver.jdbc.SQLServerException: 对象名 'authors' 无效,可是已经确定在SQLServer中建立了表authors,所以想知道有什么解决方法
部分代码如下:
<%@page contentType="text/html;charset=gbk" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<jsp:directive.page import="java.sql.DriverManager"/>
<jsp:directive.page import="java.sql.Connection"/>
<jsp:directive.page import="java.sql.Statement"/>
<jsp:directive.page import="java.sql.ResultSet"/>
<%
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
String url = "jdbc:sqlserver://localhost:1433;DatebaseName=books";
String userName="sa";
String password="199093";
Connection conn = DriverManager.getConnection(url, userName, password);
Statement stmt=conn.createStatement();
ResultSet rs=stmt.executeQuery("select * from authors");
%>
部分代码如下:
<%@page contentType="text/html;charset=gbk" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<jsp:directive.page import="java.sql.DriverManager"/>
<jsp:directive.page import="java.sql.Connection"/>
<jsp:directive.page import="java.sql.Statement"/>
<jsp:directive.page import="java.sql.ResultSet"/>
<%
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
String url = "jdbc:sqlserver://localhost:1433;DatebaseName=books";
String userName="sa";
String password="199093";
Connection conn = DriverManager.getConnection(url, userName, password);
Statement stmt=conn.createStatement();
ResultSet rs=stmt.executeQuery("select * from authors");
%>
”改为“ResultSet rs=stmt.executeQuery("use books select * from authors");”