rs cannot be resolved

来源:百度知道 编辑:UC知道 时间:2024/05/29 06:05:56
<!--jspdbc.jsp-->
<%@page contentType="text/html;charset=gb2312" import="java.sql.*"%>
<html>
<head>
<title>访问SQL Server数据库</title>
</head>
<body>
<h2 align="center">访问SQL Server数据库</h2>
<hr size="3">
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();
out.println("数据库驱动注册成功!<br>");
String url="jdbc:odbc:jspdb";
String user="sa";
String password="sa";
Connection conn=DriverManager.getConnection(url,user,password);
out.println("数据库连接成功!<br><hr>");
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql="select * from trade";
ResultSet rs=stmt.executeQuery(sql);
rs.first();
id:<%=rs.getObject("id")%><br>
商品名称:<

<%
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();
out.println("数据库驱动注册成功!<br>");
String url="jdbc:odbc:jspdb";
String user="sa";
String password="sa";
Connection conn=DriverManager.getConnection(url,user,password);
out.println("数据库连接成功!<br><hr>");
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql="select * from trade";
ResultSet rs=stmt.executeQuery(sql);
rs.first();
%>