No suitable driver
急求jsp连接数据库出错(sql server 2000)!!已经把jar包导入到lib目录下!还是提示:
No suitable driver.求老鸟解答
<%@ page language="java" import="java.util.*" pageEncoding="gb2312"%>
<%@ page import="java.sql.*" %>
<html>
<head>
<title>My JSP 'conn.jsp' starting page</title>
</head>
<body>
<%
Connection con;
Statement sql;
ResultSet rs;
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException e)
{}
try
{
con=DriverManager.getConnection("jbbc:odbc:mymoon","","");
sql=con.createStatement();
rs=sql.executeQuery("select * from employee");
out.print("<table border=2>");
out.print("<tr>");
out.print("<th width=100>"+"雇佣号");
out.print("<th width=100>"+"姓名");
out.print("<th width=50>"+"出生日期");
out.print("<th width=50>"+"薪水");
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.getDate("birthday")+"</td>");
out.print("<td>"+rs.getFloat("salary")+"</td>");
out.print("</tr>");
}
out.print("</table>");
con.close();
}catch(SQLException e)
{
out.print(e);
}
%>
</body>
</html>