急问:servlet中访问数据库抛出异常

Question

java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]对象名 'message' 无效。at studytest2.www.com.AddMessageServlet.doGet(AddMessageServlet.java:45)at studytest2.www.com.AddMessageServlet.doPost(AddMessageServlet.java:63)---------------------源代码--------------------------------------------------
package studytest2.www.com;import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
import java.util.*;
import java.sql.*;public class AddMessageServlet extends HttpServlet {    private Connection conn;
    /**
     *接受GET请求,执行数据库操作,把视图派发到下一个页面
     */
    public void doGet(HttpServletRequest request, HttpServletResponse response) throws
            ServletException, IOException {        String add = "insert into message values(?,?,?,?,?)";
        //接受请求的参数
        String title = request.getParameter("title");
        String name = request.getParameter("name");
        String email = request.getParameter("email");
        String content = request.getParameter("content");
      
        if(title==null){
            title="";
        }
        if(name==null){
            name="";
        }
        if(email==null){
            email="";
        }
        if(content==null){
            content="";
        }
        try{
            conn = getConnect();
            PreparedStatement stmt = conn.prepareStatement(add);
            stmt.setString(1,title);
            stmt.setString(2,name);
            stmt.setString(3,email);
            stmt.setString(4,content);
            stmt.setDate(5,new java.sql.Date(new java.util.Date().getTime()));
            stmt.executeUpdate();
            stmt.close();
            conn.close();            //把视图派发到目标
            //RequestDispatcher requestDispatcher = request.getRequestDispatcher("view");
            //requestDispatcher.forward(request,response);        }catch(Exception e){
            e.printStackTrace();
        }
    }    /**
     * 和GET请求的处理一样
     */
    public void doPost(HttpServletRequest request, HttpServletResponse response) throws
            ServletException, IOException {
        doGet(request,response);
    }    /**
     * 创建到数据库的连接
     */
    public Connection getConnect() {
        String CLASSFORNAME =
                "com.microsoft.jdbc.sqlserver.SQLServerDriver";
        String SERVANDDB =
                "jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName = test";
        String USER = "sa";
        String PWD = "sa";
        Connection con = null;        try {
            Class.forName(CLASSFORNAME);
            con = DriverManager.getConnection
                  (SERVANDDB, USER, PWD);
        } catch (Exception e) {
            e.printStackTrace();
        }
        return con;
    }
}

Answer 1

java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]对象名 'message' 无效。错误是这个表有问题，确定名字正确！
再看有没有其他问题！

Answer 2

对象名 'message' 无效。
楼上正解