小女子紧急求救

sql2000.java编译后的sql2000.class文件放在 \webapps\ROOT\WEB-INF\classes目录下

解决方案 »

  1.   

    我已经把sql2000.class复制到\webapps\ROOT\WEB-INF\classes，还是有同样错误啊　？？？
      

  2.   

    因为javaBean 在实例化对象的时候会去调用默认(无参的,没有异常的)构造函数,你的sql2000()构造函数抛出了异常.
    改成如下试一下.public sql2000() {  
    try{this.con = null;  
    this.stat = null;  
    this.rs = null;  
    this.number = 0;  
    this.driver = "com.microsoft.jdbc.sqlserver.SQLServerDriver";  
    this.url = "jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=liao";  
    this.user = "kecheng";  
    this.pwd = "123456";  
    this.SQL = "select * from book";  
    this.newID = "";  
    this.newName = "";  
    this.newAuthor = "";  
    this.newPublisher = "";  
    this.newPrice = "";  this.id = "";  
    this.name = "";  
    this.author = "";  
    this.publisher = "";  
    this.price = "";  Class.forName(this.driver).newInstance();//加载数据库驱动并注册  
    this.con = DriverManager.getConnection(url,user,pwd);//连接数据库  
    this.stat = con.createStatement();//创建语句对象  
    this.rs = stat.executeQuery(this.SQL);//返回结果集合对象  }catch(Exception ex){
       ex.printStackTrace();
    }
    } 
      

  3.   

    我已经把sql2000.class复制到\webapps\ROOT\WEB-INF\classes，还是有同样错误啊　？？？=>把sql2000.class复制到\webapps\ROOT\WEB-INF\classes\MyBean 下面
      

  4.   

    1 直接驱动包没有加进来;
    2 把sql2000.class复制到\webapps\ROOT\WEB-INF\classes\MyBean 下面;
    3 没有看到MyBean(就是含JAVABEAN)的文件,应该是必须有的;
      

  5.   

    通过把sql2000.class复制到\webapps\ROOT\WEB-INF\classes\MyBean 下面 
    测试成功,请大师补下我的程序,再加个删除和查询功能,需做哪下修改?谢谢哈,由于我这是面试,所以急于求成些
      

  6.   

    建议整本jsp的书
    系统学学
    不然浪费你的时间
      

  7.   

    1 直接驱动包没有加进来; 
    2 把sql2000.class复制到\webapps\ROOT\WEB-INF\classes\MyBean 下面; 
    3 没有看到MyBean(就是含JAVABEAN)的文件,应该是必须有的;
      

  8.   

    眼下这个貌似是一种习惯鸟～hoho~
      

  9.   

    我有个新问题想问大家,这个是我配置了10多天的一个宿舍管理系统还是不行,我思索了好久了,请各位大哥帮帮忙吧?谢谢了!先说明一下:我的jdk,tomcat,sql2000都配置成功,OK按作者的安装说明如下,我安装了1、解压缩，把文件夹MyDesign复制到你Tomcat的ROOT文件夹下面.
    2、把MyDesign\WEB-INF下的mydesign文件夹复制到ROOT文件夹下的WEB-INF\classes下面.
    3、把ROOT\MyDesign\WEB-INF\下的web.xml中的<web-app>和</web-app>内容复制到ROOT\WEB-INF\下web.xml的<web-app>和</web-app>中，即   可完整了配置！
    4、配置数据源：使用SQL Server 2000的企业管理器，附加数据库MyDesign\data\MyDesign_Data.mdf。都OK,只是第3步,奇怪哦,如果不复制<web-app>和</web-app>中的内容到ROOT\WEB-INF\下web.xml里面,反而可以打开/MyDesign 下的页面,但他的每个页面都设置了必须先登陆再打开的,可是我看了数据库中的内容的admin表,把管理员和密码都输入了,每次都返回 http 404 错误(之前 还以为版本不对,我用的是tomcat6.0,而作者是5.X的,我换了再试,问题依然)
      

  10.   

    由于内容过长,接上条回复
    如果按他的第三步配置后,及配置后的ROOT\WEB-INF\下web.xml 为如下所示:<?xml version="1.0" encoding="ISO-8859-1"?><web-app xmlns="http://java.sun.com/xml/ns/j2ee"
        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
        xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd"
        version="2.4">  <display-name>学生宿舍管理系统</display-name>
      <description>
         学生宿舍管理系统
      </description><!-- JSPC servlet mappings start -->    <servlet>
            <servlet-name>PageBean</servlet-name>
            <servlet-class>mydesign.PageBean</servlet-class>
        </servlet>    <servlet-mapping>
            <servlet-name>PageBean</servlet-name>
            <url-pattern>/MyDesign/PageBean</url-pattern>
        </servlet-mapping>    <servlet>
            <servlet-name>DBConnect</servlet-name>
            <servlet-class>mydesign.DBConnect</servlet-class>
        </servlet>    <servlet-mapping>
            <servlet-name>DBConnect</servlet-name>
            <url-pattern>/MyDesign/DBConnect</url-pattern>
        </servlet-mapping>    <servlet>
            <servlet-name>Admin</servlet-name>
            <servlet-class>mydesign.Admin</servlet-class>
        </servlet>    <servlet-mapping>
            <servlet-name>Admin</servlet-name>
            <url-pattern>/MyDesign/Admin</url-pattern>
        </servlet-mapping>    <servlet>
            <servlet-name>AdminControl</servlet-name>
            <servlet-class>mydesign.AdminControl</servlet-class>
        </servlet>    <servlet-mapping>
            <servlet-name>AdminControl</servlet-name>
            <url-pattern>/MyDesign/AdminControl</url-pattern>
        </servlet-mapping>    <servlet>
            <servlet-name>AddAdmin</servlet-name>
            <servlet-class>mydesign.AddAdmin</servlet-class>
        </servlet>    <servlet-mapping>
            <servlet-name>AddAdmin</servlet-name>
            <url-pattern>/MyDesign/AddAdmin</url-pattern>
        </servlet-mapping>    <servlet>
            <servlet-name>SearchAdmin</servlet-name>
            <servlet-class>mydesign.SearchAdmin</servlet-class>
        </servlet>    <servlet-mapping>
            <servlet-name>SearchAdmin</servlet-name>
            <url-pattern>/MyDesign/SearchAdmin</url-pattern>
        </servlet-mapping>    <servlet>
            <servlet-name>UpdateAdmin</servlet-name>
            <servlet-class>mydesign.UpdateAdmin</servlet-class>
        </servlet>    <servlet-mapping>
            <servlet-name>UpdateAdmin</servlet-name>
            <url-pattern>/MyDesign/UpdateAdmin</url-pattern>
        </servlet-mapping>    <servlet>
            <servlet-name>UpdatePWD</servlet-name>
            <servlet-class>mydesign.UpdatePWD</servlet-class>
        </servlet>    <servlet-mapping>
            <servlet-name>UpdatePWD</servlet-name>
            <url-pattern>/MyDesign/UpdatePWD</url-pattern>
        </servlet-mapping><servlet>
            <servlet-name>login</servlet-name>
            <servlet-class>mydesign.login</servlet-class>
        </servlet>    <servlet-mapping>
            <servlet-name>login</servlet-name>
            <url-pattern>/MyDesign/login</url-pattern>
        </servlet-mapping>    <servlet>
            <servlet-name>House</servlet-name>
            <servlet-class>mydesign.House</servlet-class>
        </servlet>    <servlet-mapping>
            <servlet-name>House</servlet-name>
            <url-pattern>/MyDesign/House</url-pattern>
        </servlet-mapping>    <servlet>
            <servlet-name>HouseControl</servlet-name>
            <servlet-class>mydesign.HouseControl</servlet-class>
        </servlet>    <servlet-mapping>
            <servlet-name>HouseControl</servlet-name>
            <url-pattern>/MyDesign/HouseControl</url-pattern>
        </servlet-mapping>    <servlet>
            <servlet-name>AddHouse</servlet-name>
            <servlet-class>mydesign.AddHouse</servlet-class>
        </servlet>    <servlet-mapping>
            <servlet-name>AddHouse</servlet-name>
            <url-pattern>/MyDesign/AddHouse</url-pattern>
        </servlet-mapping>    <servlet>
            <servlet-name>SearchHouse</servlet-name>
            <servlet-class>mydesign.SearchHouse</servlet-class>
        </servlet>    <servlet-mapping>
            <servlet-name>SearchHouse</servlet-name>
            <url-pattern>/MyDesign/SearchHouse</url-pattern>
        </servlet-mapping>    <servlet>
            <servlet-name>UpdateHouse</servlet-name>
            <servlet-class>mydesign.UpdateHouse</servlet-class>
        </servlet>    <servlet-mapping>
            <servlet-name>UpdateHouse</servlet-name>
            <url-pattern>/MyDesign/UpdateHouse</url-pattern>
        </servlet-mapping>    <servlet>
            <servlet-name>Student</servlet-name>
            <servlet-class>mydesign.Student</servlet-class>
        </servlet>    <servlet-mapping>
            <servlet-name>Student</servlet-name>
            <url-pattern>/MyDesign/Student</url-pattern>
        </servlet-mapping>    <servlet>
            <servlet-name>StudentControl</servlet-name>
            <servlet-class>mydesign.StudentControl</servlet-class>
        </servlet>    <servlet-mapping>
            <servlet-name>StudentControl</servlet-name>
            <url-pattern>/MyDesign/StudentControl</url-pattern>
        </servlet-mapping>    <servlet>
            <servlet-name>AddStudent</servlet-name>
            <servlet-class>mydesign.AddStudent</servlet-class>
        </servlet>    <servlet-mapping>
            <servlet-name>AddStudent</servlet-name>
            <url-pattern>/MyDesign/AddStudent</url-pattern>
        </servlet-mapping>    <servlet>
            <servlet-name>AddStudentHouse</servlet-name>
            <servlet-class>mydesign.AddStudentHouse</servlet-class>
        </servlet>    <servlet-mapping>
            <servlet-name>AddStudentHouse</servlet-name>
            <url-pattern>/MyDesign/AddStudentHouse</url-pattern>
        </servlet-mapping>    <servlet>
            <servlet-name>SearchStudent</servlet-name>
            <servlet-class>mydesign.SearchStudent</servlet-class>
        </servlet>    <servlet-mapping>
            <servlet-name>SearchStudent</servlet-name>
            <url-pattern>/MyDesign/SearchStudent</url-pattern>
        </servlet-mapping>    <servlet>
            <servlet-name>UpDateStudent</servlet-name>
            <servlet-class>mydesign.UpDateStudent</servlet-class>
        </servlet>    <servlet-mapping>
            <servlet-name>UpDateStudent</servlet-name>
            <url-pattern>/MyDesign/UpDateStudent</url-pattern>
        </servlet-mapping>    <servlet>
            <servlet-name>UpDateSH</servlet-name>
            <servlet-class>mydesign.UpDateSH</servlet-class>
        </servlet>    <servlet-mapping>
            <servlet-name>UpDateSH</servlet-name>
            <url-pattern>/MyDesign/UpDateSH</url-pattern>
        </servlet-mapping>    <servlet>
            <servlet-name>DelStudentHouse</servlet-name>
            <servlet-class>mydesign.DelStudentHouse</servlet-class>
        </servlet>    <servlet-mapping>
            <servlet-name>DelStudentHouse</servlet-name>
            <url-pattern>/MyDesign/DelStudentHouse</url-pattern>
        </servlet-mapping><servlet>
            <servlet-name>Exchange</servlet-name>
            <servlet-class>mydesign.Exchange</servlet-class>
        </servlet>    <servlet-mapping>
            <servlet-name>Exchange</servlet-name>
            <url-pattern>/MyDesign/Exchange</url-pattern>
        </servlet-mapping>    <servlet>
            <servlet-name>Visitor</servlet-name>
            <servlet-class>mydesign.Visitor</servlet-class>
        </servlet>    <servlet-mapping>
            <servlet-name>Visitor</servlet-name>
            <url-pattern>/MyDesign/Visitor</url-pattern>
        </servlet-mapping>由于内容过长接下条
      

  11.   

    内容过长,接上条
    <servlet>
            <servlet-name>VisitorControl</servlet-name>
            <servlet-class>mydesign.VisitorControl</servlet-class>
        </servlet>    <servlet-mapping>
            <servlet-name>VisitorControl</servlet-name>
            <url-pattern>/MyDesign/VisitorControl</url-pattern>
        </servlet-mapping>    <servlet>
            <servlet-name>AddVisitor</servlet-name>
            <servlet-class>mydesign.AddVisitor</servlet-class>
        </servlet>    <servlet-mapping>
            <servlet-name>AddVisitor</servlet-name>
            <url-pattern>/MyDesign/AddVisitor</url-pattern>
        </servlet-mapping>    <servlet>
            <servlet-name>SearchVisitor</servlet-name>
            <servlet-class>mydesign.SearchVisitor</servlet-class>
        </servlet>    <servlet-mapping>
            <servlet-name>SearchVisitor</servlet-name>
            <url-pattern>/MyDesign/SearchVisitor</url-pattern>
        </servlet-mapping>    <servlet>
            <servlet-name>UpdateVisitor</servlet-name>
            <servlet-class>mydesign.UpdateVisitor</servlet-class>
        </servlet>    <servlet-mapping>
            <servlet-name>UpdateVisitor</servlet-name>
            <url-pattern>/MyDesign/UpdateVisitor</url-pattern>
        </servlet-mapping>    <servlet>
            <servlet-name>Outthings</servlet-name>
            <servlet-class>mydesign.Outthings</servlet-class>
        </servlet>    <servlet-mapping>
            <servlet-name>Outthings</servlet-name>
            <url-pattern>/MyDesign/Outthings</url-pattern>
        </servlet-mapping>    <servlet>
            <servlet-name>OutthingsControl</servlet-name>
            <servlet-class>mydesign.OutthingsControl</servlet-class>
        </servlet>    <servlet-mapping>
            <servlet-name>OutthingsControl</servlet-name>
            <url-pattern>/MyDesign/OutthingsControl</url-pattern>
        </servlet-mapping>    <servlet>
            <servlet-name>AddOutthings</servlet-name>
            <servlet-class>mydesign.AddOutthings</servlet-class>
        </servlet>    <servlet-mapping>
            <servlet-name>AddOutthings</servlet-name>
            <url-pattern>/MyDesign/AddOutthings</url-pattern>
        </servlet-mapping>    <servlet>
            <servlet-name>SearchOutthings</servlet-name>
            <servlet-class>mydesign.SearchOutthings</servlet-class>
        </servlet>    <servlet-mapping>
            <servlet-name>SearchOutthings</servlet-name>
            <url-pattern>/MyDesign/SearchOutthings</url-pattern>
        </servlet-mapping>    <servlet>
            <servlet-name>UpdateOutthings</servlet-name>
            <servlet-class>mydesign.UpdateOutthings</servlet-class>
        </servlet>    <servlet-mapping>
            <servlet-name>UpdateOutthings</servlet-name>
            <url-pattern>/MyDesign/UpdateOutthings</url-pattern>
        </servlet-mapping>    <servlet>
            <servlet-name>Repair</servlet-name>
            <servlet-class>mydesign.Repair</servlet-class>
        </servlet>    <servlet-mapping>
            <servlet-name>Repair</servlet-name>
            <url-pattern>/MyDesign/Repair</url-pattern>
        </servlet-mapping>    <servlet>
            <servlet-name>RepairControl</servlet-name>
            <servlet-class>mydesign.RepairControl</servlet-class>
        </servlet>    <servlet-mapping>
            <servlet-name>RepairControl</servlet-name>
            <url-pattern>/MyDesign/RepairControl</url-pattern>
        </servlet-mapping>    <servlet>
            <servlet-name>AddRepair</servlet-name>
            <servlet-class>mydesign.AddRepair</servlet-class>
        </servlet>    <servlet-mapping>
            <servlet-name>AddRepair</servlet-name>
            <url-pattern>/MyDesign/AddRepair</url-pattern>
        </servlet-mapping>    <servlet>
            <servlet-name>IsRepair</servlet-name>
            <servlet-class>mydesign.IsRepair</servlet-class>
        </servlet>    <servlet-mapping>
            <servlet-name>IsRepair</servlet-name>
            <url-pattern>/MyDesign/IsRepair</url-pattern>
        </servlet-mapping>    <servlet>
            <servlet-name>SearchRepair</servlet-name>
            <servlet-class>mydesign.SearchRepair</servlet-class>
        </servlet>    <servlet-mapping>
            <servlet-name>SearchRepair</servlet-name>
            <url-pattern>/MyDesign/SearchRepair</url-pattern>
        </servlet-mapping>    <servlet>
            <servlet-name>UpdateRepair</servlet-name>
            <servlet-class>mydesign.UpdateRepair</servlet-class>
        </servlet>    <servlet-mapping>
            <servlet-name>UpdateRepair</servlet-name>
            <url-pattern>/MyDesign/UpdateRepair</url-pattern>
        </servlet-mapping>    <servlet>
            <servlet-name>Standard</servlet-name>
            <servlet-class>mydesign.Standard</servlet-class>
        </servlet>    <servlet-mapping>
            <servlet-name>Standard</servlet-name>
            <url-pattern>/MyDesign/Standard</url-pattern>
        </servlet-mapping>    <servlet-mapping>
            <servlet-name>StandardControl</servlet-name>
            <url-pattern>/MyDesign/StandardControl</url-pattern>
        </servlet-mapping>    <servlet>
            <servlet-name>StandardControl</servlet-name>
            <servlet-class>mydesign.StandardControl</servlet-class>
        </servlet>    <servlet>
            <servlet-name>SetStandard</servlet-name>
            <servlet-class>mydesign.SetStandard</servlet-class>
        </servlet>    <servlet-mapping>
            <servlet-name>SetStandard</servlet-name>
            <url-pattern>/MyDesign/SetStandard</url-pattern>
        </servlet-mapping>    <servlet>
            <servlet-name>SearchStandard</servlet-name>
            <servlet-class>mydesign.SearchStandard</servlet-class>
        </servlet>    <servlet-mapping>
            <servlet-name>SearchStandard</servlet-name>
            <url-pattern>/MyDesign/SearchStandard</url-pattern>
        </servlet-mapping>    <servlet>
            <servlet-name>Expense</servlet-name>
            <servlet-class>mydesign.Expense</servlet-class>
        </servlet>    <servlet-mapping>
            <servlet-name>Expense</servlet-name>
            <url-pattern>/MyDesign/Expense</url-pattern>
        </servlet-mapping>    <servlet>
            <servlet-name>ExpenseControl</servlet-name>
            <servlet-class>mydesign.ExpenseControl</servlet-class>
        </servlet>    <servlet-mapping>
            <servlet-name>ExpenseControl</servlet-name>
            <url-pattern>/MyDesign/ExpenseControl</url-pattern>
        </servlet-mapping>    <servlet>
            <servlet-name>WriteExpense</servlet-name>
            <servlet-class>mydesign.WriteExpense</servlet-class>
        </servlet>    <servlet-mapping>
            <servlet-name>WriteExpense</servlet-name>
            <url-pattern>/MyDesign/WriteExpense</url-pattern>
        </servlet-mapping>    <servlet>
            <servlet-name>SearchExpense</servlet-name>
            <servlet-class>mydesign.SearchExpense</servlet-class>
        </servlet>    <servlet-mapping>
            <servlet-name>SearchExpense</servlet-name>
            <url-pattern>/MyDesign/SearchExpense</url-pattern>
        </servlet-mapping>    <servlet>
            <servlet-name>UpdateExpense</servlet-name>
            <servlet-class>mydesign.UpdateExpense</servlet-class>
        </servlet>    <servlet-mapping>
            <servlet-name>UpdateExpense</servlet-name>
            <url-pattern>/MyDesign/UpdateExpense</url-pattern>
        </servlet-mapping>    <servlet>
            <servlet-name>Handin</servlet-name>
            <servlet-class>mydesign.Handin</servlet-class>
        </servlet>    <servlet-mapping>
            <servlet-name>Handin</servlet-name>
            <url-pattern>/MyDesign/Handin</url-pattern>
        </servlet-mapping>
         <servlet>
            <servlet-name>Exit</servlet-name>
            <servlet-class>mydesign.Exit</servlet-class>
        </servlet>    <servlet-mapping>
            <servlet-name>Exit</servlet-name>
            <url-pattern>/MyDesign/Exit</url-pattern>
        </servlet-mapping><!-- JSPC servlet mappings end -->
    </web-app>
    之后会连主页都打不开了http://localhost:8000/(注先前都可以打开,我把端口自己改成8000了,之后所有的页面都显示 为404错误,)
    请问 这是怎么回事啊?
      

  12.   

    内容过长 ,接上条我的登陆 URL  http://localhost:8000/MyDesign/login.htm  (输入管理员和密码后,转至此页http://localhost:8000/MyDesign/login)显示 HTTP Status 404 - /MyDesign/login--------------------------------------------------------------------------------type Status reportmessage /MyDesign/logindescription The requested resource (/MyDesign/login) is not available. 我的login.java 如下:package mydesign;import java.io.*;
    import javax.servlet.*;
    import javax.servlet.http.*;
    import mydesign.*;public class login extends HttpServlet
    {

    //Initialize global variables
        public void init() throws ServletException
        {
        }
        
        //Process the HTTP Post request
    public void service(HttpServletRequest req,HttpServletResponse res)
    throws ServletException,IOException
    {
    req.setCharacterEncoding("gb2312");
    res.setContentType("text/html;charset=gb2312");
    PrintWriter pw=res.getWriter();
    Admin admin=new Admin();
    AdminControl admincontrol=new AdminControl();
    String username=req.getParameter("username");
    String password=req.getParameter("password");
    if(username.equals("")||password.equals(""))
                    pw.print("<script>alert('请输入帐号和密码!');history.back()</script>");
    try
    {
    admin.setUserName(username);
                admin.setPassword(password);
                if(!admincontrol.isAdmin(admin).equals(null))
                {
                 HttpSession session=req.getSession(true);
                 session.setAttribute("manage",admincontrol.isAdmin(admin));
                 session.putValue("admin",username);
                 res.sendRedirect("/MyDesign/index.jsp");
                }else
                {
                 pw.print("<script>alert('密码错误！');history.back()</script>");
                }
            }catch(Exception e)
            {
                System.out.println("login has error"+e.getMessage());
            }
        }
        //Clean up resources
        public void destroy() 
        {
        }
    }请问各位 大哥我 这个该做哪些修改?
      

  13.   

    第一步就错了
    1、解压缩，把文件夹MyDesign复制到你Tomcat的ROOT文件夹下面. 既然有 MyDesign 文件夹，也就是所有的程序都在这个目录下面，包括WEB-INF，那么你不应该复制到ROOT下面，而应该在
    webapps 下面最终结果为
    webapps
      ROOT
      MyDesign
         WEB-INF
            classes然后用
    http://localhost:8080/MyDesign 访问就行了！
      

  14.   

    IT中coding的女生不多，像lz这么好学的女生就更少，支持一下吧
      

  15.   

    404么找不到咯，把你的程序（Project1），放在tomcat，webapp下面后，启动~
    browser里面打 http://localhost:8080/Project1/..pagename
    要是直接想http://localhost:8080/Project1看到结果，web.xml里设一下welcomepage就来赛了
    网上多的是这种料
      

  16.   

    servlet学的够牛比的,N个servlet搭起来的，看着都晕~~