|
#2
日落下一只狼2006-10-21 16:11
|
<%@ page contentType="text/html;charset=GB2312" %>
<%@ page import="java.sql.*" %>
<html>
<body>
<% Connection con;
Statement sql;
ResultSet rs;
try
{
Class.forName("sun.jdbc.odbc.jdbcodbcdriver");
}
catch(ClassNotFoundException e)
{
out.print("no found!");
}
try
{
con=DriverManager.getConnection("jdbc:odbc:test");
sql=con.createStatement();
rs=sql.executeQuery("SELECT * FROM test");
out.print("<Table Border>");
out.print("<Tr><td colspan=8 align=center>yonghusj</td></tr>");
out.print("<Tr>");
out.print("<Td withd=100 > "+"admin");
out.print("</Tr>");
while(rs.next())
{out.print("<Td>");
out.print("<Td>"+rs.getLong(1)+"</Td>");
out.print("</Tr>");
}
out.print("</Table>");
con.close();
}
catch(SQLException e1)
{
out.print("SQL not yes!");
}
%>
</body>
</html>
类找不到.sql not yes 这是为什么 呢?
