lianjie.jsp
<%@ page contentType="text/html;charset=utf-8" %>
<%@ page import="java.sql.*" %>
<html>
<body >
<font size="3">
<%
Connection con;
Statement sql;
ResultSet rs;
try{
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
}
catch(Exception e){
}
try{
String uri="jdbc:sqlserver://127.0.0.1:1433;DatebaseName=jsp";
String user="sa";
String password="";
con=DriverManager.getConnection(uri,user,password);
sql=con.createStatement();
rs=sql.executeQuery("select * from sc");
out.print("<table border=2>");
out.print("<tr>");
out.print("<th width=100>"+"sno");
out.print("<th width=100>"+"cno");
out.print("<th width=100>"+"score");
out.print("</tr>");
while(rs.next()){
out.print("<tr>");
out.print("<td>"+rs.getString(1)+"</td>");
out.print("<td>"+rs.getString(2)+"</td>");
out.print("<td>"+rs.getFloat("score")+"</td>");
out.print("</tr>");
}
out.print("</table>");
con.close();
}
catch(SQLException e){
System.out.println(e);
}
%>
</font>
</body>
</html>
网页运行结果是空白
Tomact显示:
com.microsoft.sqlserver.jdbc.SQLServerException: 对象名 'sc' 无效。