帮忙看看有两个错误.

[huqing1980]

输出数据库的两个字段
<%@ page import="java.sql.*" %>
<% Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:test","test","test");
Statement st=con.createStatement();
ResultSet rs;
rs=st.executeQuery("SELECT * FORM test");
while(rs.next())
{out.print (rs.getString("name"));
out.print (rs.getString("id"));
}
rs.close();
%>
又出现了两个错误:
1>ambiguous class:java.beans.statement and java.sql.statement
statement st =con.createStement();
2>variable rs may not have been initialized
谢谢大家

[hjb1029]

rs=st.executeQuery("SELECT * FORM test");
=>rs=st.executeQuery("SELECT * from test");

[bubblebird]

<%@ page import="java.sql.*" %>
<% Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:test","test","test");
//java.beans.statement and java.sql.statement都有statement，引起誤解
java.sql.Statement st=con.createStatement();
ResultSet rs = null; //初值
rs=st.executeQuery("SELECT * FORM test");
while(rs.next())
{out.print (rs.getString("name"));
out.print (rs.getString("id"));
}
rs.close();
%>
另外加上try...catch...

[WOnion]

使用之前使rs=null;

[xwake]

1>ambiguous class:java.beans.statement and java.sql.statement
statement st =con.createStement();

因为在你import的JAVA类库包中有两个statement（java.beans.statement and java.sql.statement），请指定使用哪一个Statement，或者不要导入程序中没有使用的类包

2>variable rs may not have been initialized
变量rs可能没有初始化!
ResultSet rs = st.executeQuery(sqlstr);
或者
ResultSet rs = null;
rs = st.....