主题:关于数据库的问题
<%
Connection con;
Statement sql;
ResultSet rs;
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch ( ClassNotFoundException e)
{}
try{
con=DriverManager.getConnection("jdbc.odbc;sun","panwei","");
sql=con.createStatement();
rs=sql.executeQuery("select * from xuesheng");
out.print("<table border=0>");
out.print("<tr>");
out.print("<th width=100>"+"xingming");
out.print("<th width=100>"+"xuiehao");
out.print("<th width=100>"+"danwei");
out.priont("</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.getString(3)+"</td>");
out.print("</tr>");
}
out.print("</table>");
con.close();
}
catch(SQLException el){}
%>
这段代码已运行总是有错误
Generated servlet error:
[javac] Since fork is true, ignoring compiler setting.
[javac] Compiling 1 source file
[javac] Since fork is true, ignoring compiler setting.
[javac] D:\Program Files\Apache Group\Tomcat 4.1\work\Standalone\localhost\_\shujuku_jsp.java:66: cannot resolve symbol
[javac] symbol : variable sql
[javac] location: class org.apache.jsp.shujuku_jsp
[javac] rs=sql.executeQuery("select * from xuesheng");
[javac] ^
[javac] 1 error
Connection con;
Statement sql;
ResultSet rs;
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch ( ClassNotFoundException e)
{}
try{
con=DriverManager.getConnection("jdbc.odbc;sun","panwei","");
sql=con.createStatement();
rs=sql.executeQuery("select * from xuesheng");
out.print("<table border=0>");
out.print("<tr>");
out.print("<th width=100>"+"xingming");
out.print("<th width=100>"+"xuiehao");
out.print("<th width=100>"+"danwei");
out.priont("</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.getString(3)+"</td>");
out.print("</tr>");
}
out.print("</table>");
con.close();
}
catch(SQLException el){}
%>
这段代码已运行总是有错误
Generated servlet error:
[javac] Since fork is true, ignoring compiler setting.
[javac] Compiling 1 source file
[javac] Since fork is true, ignoring compiler setting.
[javac] D:\Program Files\Apache Group\Tomcat 4.1\work\Standalone\localhost\_\shujuku_jsp.java:66: cannot resolve symbol
[javac] symbol : variable sql
[javac] location: class org.apache.jsp.shujuku_jsp
[javac] rs=sql.executeQuery("select * from xuesheng");
[javac] ^
[javac] 1 error

您所在位置: