myeclipse奇怪的问题 - JSP编程论坛

Toupiao里面有 5个文件,是用于投票自己喜欢的书：

1. booksend.jsp：

<%@ page language="java" import="java.util.*,java.sql.*;" pageEncoding="UTF-8"%>
<jsp:useBean id="connection" scope="request" class="lei.JDBConnection"/>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>

  </head>

  <body>
       <%
          Class.forName("com.microsoft.jdbc.sqlsever.SQL.ServerDriver");
          Connection con=DriverManager.getConnection("jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=db_bookGard","sa","210");
          Statement stmt=con.createStatement();
          String type[] =request.getParameterValues("type");
          String type2[]=request.getParameterValues("type2");
          String type3[]=request.getParameterValues("type3");


          if (type!=null)
           {
             for (int i=0;i<type.length;i++)
              {
                 String aa=type[i];
                   try
                      {
                        stmt.executeQuery("update db_book set "+aa+"="+aa+" + 1 where id=1");
                      }
                      catch (Exception e)
                            {e.printStackTrace();}
                }
              }

            if (type2!=null)
             {
               for (int i=0;i<type2.length;i++)
                 {
                   String aa=type2[i];
                     try
                       {
                         stmt.executeQuery("update db_language set "+aa+"="+aa+" + 1 where id=1");

                        }
                         catch (Exception e)
                             {e.printStackTrace();}
                     }
               }

            if (type3!=null)
              {
                for (int i=0;i<type3.length;i++)
                  {
                     String aa=type3[i];
                       try
                          {
                            stmt.executeQuery("update db_borrowbook set "+aa+"="+aa+" + 1 where id=1");
                            }
                             catch (Exception e)
                                { e.printStackTrace();}
                     }

                 }
          response.sendRedirect("watch.jsp");
         %>
   </body>
</html>

2. login.html:

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>


    <meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
    <meta http-equiv="description" content="this is my page">
    <meta http-equiv="content-type" content="text/html; charset=UTF-8">

</head>
<title> 投票实例</title>

3. login.jsp

<%@ page language="java" import="java.util.*,java.sql.*;" pageEncoding="UTF-8"%>
<jsp:useBean id="connection" scope="request" class="lei.JDBConnection"/>

<%String username=request.getParameter("username");
   String password=request.getParameter("password");
   Class.forName("com.microsoft.jdbc.sqlsever.SQLServerDriver");
   Connection con=DriverManager.getConnection("jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=db_bookGard","sa","210");
   Statement stmt=con.createStatement();
   String isCorrect="select * from tb_user where username='"+username+"' and password='"+password+"'";
   ResultSet rs=stmt.executeQuery(isCorrect);

        if (!rs.next())
          {
            response.sendRedirect("login.html");
            rs.close();
            stmt.close();
            con.close();
            }
         else if (rs.getString("isCheck").equals("0"))
                {  session.setAttribute("username",rs.getString("username"));
                   session.setAttribute("password",rs.getString("password"));
                   session.setAttribute("isCheck",rs.getString("isCheck"));


                try
                   {
                      stmt.executeQuery("update tb_user set isCheck='"+1+"'where username='"+username+"'");
                      stmt.close();
                      con.close();
                      rs.close();
                     }
                      catch(Exception e)
                        {  e.printStackTrace();
                          }
                      response.sendRedirect("index.html");

                   }
                else
                   {
                      response.sendRedirect("watch.jsp");
                       stmt.close();
                       con.close();
                       rs.close();}
    %>

4. index.html:
          <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
    <title>图书市场调研卡</title>

    <meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
    <meta http-equiv="description" content="this is my page">
    <meta http-equiv="content-type" content="text/html; charset=UTF-8">

  </head>

  <body  background="">
      <center><h2>明日科技图书市场调研</h2></center>
      <form method="post" action="booksend.jsp">
        <table width="567" height="176">
          <tr><td><h3> 调查信息</h3></td></tr>
            <tr>
                 <td><h4>1.你经常购买的编程累图书属于哪一类？</h4></td>
            </tr>

            <tr>
                 <td><input type="checkbox" name="type" value="kaifa">开发手册
                     <input type="checkbox" name="type" value="baili">百例
                     <input type="checkbox" name="type" value="jiqiao">技巧
                     <input type="checkbox" name="type" value="shili">实例锦集
                     <input type="checkbox" name="type" value="jiaocheng">教程
                 </td>
            </tr>

            <tr>
                 <td><h4>2.你使用的下面哪种编程语言或工具？</h4></td>
            </tr>

            <tr>
                 <td><input type="checkbox" name="type2" value="VB">VB
                     <input type="checkbox" name="type2" value="VC++">VC++
                     <input type="checkbox" name="type2" value="JAVA">JAVA
                     <input type="checkbox" name="type2" value="DELPHI">DELPHI
                     <input type="checkbox" name="type2" value="ASP">ASP
                     <input type="checkbox" name="type2" value="ASP.NET">ASP.NET
                     <input type="checkbox" name="type2" value="JSP">JSP
                     <input type="checkbox" name="type2" value="OTHER">其他
                 </td>
            </tr>

             <tr>
                 <td><h4>3.你最愿意购买或借阅哪类图书？</h4></td>
            </tr>

             <tr>
                 <td><input type="checkbox" name="type3" value="rumen">入门类
                     <input type="checkbox" name="type3" value="jiangjie">讲解+实例
                     <input type="checkbox" name="type3" value="wanquan">完全实例
                     <input type="checkbox" name="type3" value="baili">百例
                     <input type="checkbox" name="type3" value="jiqiao">技巧类
                 </td>
              </tr>
             <tr>
                 <td><input type="submit" name="handon" value="提交">
                     <input type="reset" name="reset"  value="重置"></td>
             </tr>
     </table>
  </body>
</html>

5. watch.jsp:
<%@ page language="java" import="java.util.*,java.sql.*" pageEncoding="UTF-8"%>
<jsp:useBean id="Connect" class="lei.JDBConnection" scope="request"/>

<html>

    <title>投票结果</title>


  <body>
      <center><h2>明日科技图书市场调研卡</h2>
       <table  width="567" height="176">
         <tr><td><h3>调查结果：</h3></td></tr>

         <% Class.forName("com.microsoft.jdbc.sqlserver.SQL.ServerDriver");
            Connection con=DriverManager.getConnection("jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=db_bookGard","sa","210");
            Statement stmt=con.createStatement();
            ResultSet rs1=stmt.executeQuery("select * from tb_book where id=1");
            ResultSet rs2=stmt.executeQuery("select * from tb_language where id=1");
            ResultSet rs3=stmt.executeQuery("select * from tb_borrowbook where id=1");

            if (rs1.next())
             {
                %>
                <tr>
                    <td><h4>1.你经常购买的编程类图书属于哪一类？</h4></td>
                </tr>
                <tr>
                    <td>
                         开发手册类型得票：<%=rs1.getString("kaifa")%>票<br>
                         百例类得票：     <%=rs1.getString("baili")%>票<br>
                         技巧类：         <%=rs1.getString("jiqiao")%>票<br>
                         实例类锦类得票：  <%=rs1.getString("shili")%>票<br>
                         教程类得票：      <%=rs1.getString("教程")%>票<br>
                    </td>
                 </tr>

                 <% }%>

              <% if (rs2.next())
                  {
                  %>
                  <tr>
                     <td><h4>2.你使用的下面哪种编程语言或工具？</h4></td>
                  </tr>
                  <tr>
                     <td>
                        VB得票：       <%=rs2.getString("VB") %>票<br>
                        VC得票：       <%=rs2.getString("VC") %>票<br>
                        JAVA得票：     <%=rs2.getString("JAVA") %>票<br>
                        DELPHI得票：       <%=rs2.getString("DELPHI") %>票<br>
                        ASP得票：       <%=rs2.getString("ASP") %>票<br>
                        JSP得票：       <%=rs2.getString("JSP") %>票<br>
                        ASPNET得票：       <%=rs2.getString("ASPNET") %>票<br>
                        OTHER得票：       <%=rs2.getString("OTHER") %>票<br>
                       </td>
                    </tr>
                  <% } %>


                 <% if (rs3.next())

                    {
                    %>
                     <tr>
                         <td><h4>3.你最愿意购买或借阅哪类图书？</h4></td>
                     </tr>

                     <tr>
                         <td>
                               入门类得票：<%=rs3.getString("rumen") %>票<br>
                               讲解类得票：<%=rs3.getString("jiangjie") %>票<br>
                               完全实例类得票：<%=rs3.getString("wanquan") %>票<br>
                               百例类得票：<%=rs3.getString("baili") %>票<br>
                               技巧类得票：<%=rs3.getString("jiqiao") %>票<br>
                         </td>
                     </tr>



                    <%} %>




       </table>
  </body>
</html>

今天重新修改了一下，又出现新问题：

exception

javax.servlet.ServletException: com.microsoft.jdbc.sqlsever.SQLServerDriver
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:848)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:781)
org.apache.jsp.login_jsp._jspService(org.apache.jsp.login_jsp:108)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:322)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

root cause

java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlsever.SQLServerDriver
org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1338)
org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1187)
org.apache.jasper.servlet.JasperLoader.loadClass(JasperLoader.java:127)
org.apache.jasper.servlet.JasperLoader.loadClass(JasperLoader.java:65)
java.lang.ClassLoader.loadClassInternal(Unknown Source)
java.lang.Class.forName0(Native Method)
java.lang.Class.forName(Unknown Source)
org.apache.jsp.login_jsp._jspService(org.apache.jsp.login_jsp:61)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:322)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

请求帮忙～～

*快速回复：myeclipse奇怪的问题 [ 回帖是一种美德 :) ]
会员账号	用户名：还没注册? 密码：忘记密码?
内容 HTML标签：不可用 UBB标签：可用贴图标签：可用多媒体标签：可用表情字符转换：可用上传图片：不可用最多15KB
点击表情图即可在帖子中加入相应的表情
邮件回复显示签名	[Ctrl+Enter直接提交贴子]