JDBC和Servlet 表单提交问题

用HTML写了 个表单提交的时候在 Servlet端口上的 String driver="com.microsoft.jdbc.sqlserver.SQLServerDriver";这句话中断点了
知道的告诉下 哦 谢谢

解决方案 »

  1.   

    楼主是说用DEBUG测试时在那个位置断开了吗？说明的你JDBC和数据库没有连接上啊，配置错了吧
      

  2.   

    我给你看 哈程序吧package com.v512.guestbook;import java.io.IOException;
    import java.io.PrintWriter;
    import java.sql.*;import javax.servlet.ServletException;
    import javax.servlet.http.HttpServlet;
    import javax.servlet.http.HttpServletRequest;
    import javax.servlet.http.HttpServletResponse;public class AddMessageServlet extends HttpServlet {
    /**
     * 
     */
    private static final long serialVersionUID = -4602174847536625099L;
    public void doGet(HttpServletRequest request, HttpServletResponse response)
    throws ServletException, IOException {
    doPost(request,response);
    }
    public void doPost(HttpServletRequest request, HttpServletResponse response)
    throws ServletException, IOException {
              String driver="com.microsoft.jdbc.sqlserver.SQLServerDriver";
              String url="jdbc:microsoft:sqlserver://127.0.0.1:1433";
              String username="com";
              String password="cat";
              String sql="insert into guestbook(id,name,phone,email,title,content)values(gb_seq.nexttval,?,?,?,?,?,)";
              int result = 0;

    request.setCharacterEncoding("gb2312");
    String name=request.getParameter("username");
    String title=request.getParameter("title");
    response.setContentType("text/html;charset=gb2312" );
    PrintWriter out = response.getWriter();
    out.println("<html>");
    out.println("<body>");
    out.println("<head><title>addMessage</title></head>");
    if(StringUtil.validateNull(name)){
    out.println("对不起，用户名不能为空，请重新输入！");
    out.println("<a href='/guestbook/addMessage.html'>添加留言 </a><br>");
    }else if(StringUtil.validateNull(title)){
    out.println("对不起，主题不能为空，请重新输入！");
    out.println("<a href='/guestbook/addMessage.html'>添加留言 </a><br>");
    }else{
    try {
    Class.forName(driver);

    Connection conn=DriverManager.getConnection(url,username,password);
    PreparedStatement pstmt=conn.prepareStatement(sql);
        pstmt.setString(1, StringUtil.filterHtml(request.getParameter(name)));
    pstmt.setString(2, StringUtil.filterHtml(request.getParameter("phone")));
    pstmt.setString(3, StringUtil.filterHtml(request.getParameter("email")));
    pstmt.setString(4, StringUtil.filterHtml(request.getParameter(title)));
    pstmt.setString(5, request.getParameter("content"));
    result = pstmt.executeUpdate();
    pstmt.close();
    conn.close();
    }catch (ClassNotFoundException e) {
    // TODO Auto-generated catch block
    e.printStackTrace();
    }catch (SQLException e) {
    // TODO Auto-generated catch block
    e.printStackTrace();
    }
    if(result==0){
    out.println("对不起，用户名不能为空，请重新输入！");
    out.println("<a href='/guestbook/addMessage.html'>添加留言 </a><br>");

    }else{
    out.println("恭喜添加成功！");


    }out.println("</body>");
     out.println("</html>");

    }
               
    }}
      

  3.   

    还有 个 验证程序package com.v512.guestbook;
    public class StringUtil{

    public  static boolean validateNull(String args){
    if(args==null||args.length()==0)
          return true;
    else{
    return false;}

    }
    public static String chanageNull(String source,String target)
    { if(source==null||source.length()==0)
    return target;
      else
    return source; 
      
     }

    public static String filterHtml(String input){
    if(input==null)
    return null;
    if(input.length()==0){
    return input;
    }
        input=input.replaceAll("&","&amp");
    input=input.replaceAll("<","&lt");
    input=input.replaceAll(">","&gt");
    input=input.replaceAll(" ","&nbsp");
    input=input.replaceAll("'","&#39");
    input=input.replaceAll("\"","&quot");
    input=input.replaceAll("\n","<br>");
    return input;


    }




    }
      

  4.   

    看看你是不是没有把SQLSERVER DRIVER的3个JAR包导入到项目的lib目录中