请教一个JSP连接数据库的问题先谢谢了!

<%@ page contentType="text/html;charset=GB2312" %>
<HTML>
<BODY>
<% //获取提交的姓名：
      Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
      Connection con=DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;database=student","sa","");
    Statement sql=con.createStatement();
    String name=request.getParameter("name");
    if(name==null){
       name="";
         }
    byte b[]=name.getBytes("ISO-8859-1");
    name=new String(b);
    String smt="SELECT * FROM student  WHERE 姓名 = ' "+name+"'";
    ResultSet rs=stm.executeQuery(smt);
%>
    <CENTER>
      输出姓名为<%=name%>的学生信息：<BR>
      <TABLE border="" bgcolor="#74bbc0">
<TR>
<TH width="100">学号</TH>
<TH width="100">姓名</TH>
<TH width="50">学分</TH>
</TR>
     <%  while(rs.next()){%>
<TR align="center">
<TD><%=rs.getString(1)%></TD>
<TD><%=rs.getString(2)%></TD>
<TD><%=rs.getInt(3)%></TD>
</TR>
   <%  }%>
</TABLE>
</CENTER>
<%
     con.close();
%>
</BODY>
</HTML>

报的错误是怎么回事啊?

type Exception report

message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

javax.servlet.ServletException: No suitable driver
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:825)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:758)
org.apache.jsp.xuefen_jsp._jspService(xuefen_jsp.java:129)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

root cause

java.sql.SQLException: No suitable driver
java.sql.DriverManager.getConnection(DriverManager.java:532)
java.sql.DriverManager.getConnection(DriverManager.java:171)
org.apache.jsp.xuefen_jsp._jspService(xuefen_jsp.java:72)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

note The full stack trace of the root cause is available in the Apache Tomcat/5.0.28 logs.

222.22.113.*

快试试吧，
可以对自己使用挽尊卡咯~

◆

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
驱动错了
应该是 Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");

谢谢,弄混�

扫二维码下载贴吧客户端

下载贴吧APP
看高清直播、视频！

2回复贴，共1页

<<返回jsp吧

分享到:

日	一	二	三	四	五	六

请教一个JSP连接数据库的问题 先谢谢了!

扫二维码下载贴吧客户端

请教一个JSP连接数据库的问题先谢谢了!