jsp连接数据库出错了，求高手指点，在线等

Question

连接数据库出现问题了，这是为嘛呢？
package myservlet.control;
import java.sql.*;
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class HandleLogin extends HttpServlet
{  
   public void init(ServletConfig config) throws ServletException
    { 
      super.init(config);
      try { 
             Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
          }
       catch(Exception e){} 
    }
   public String handleString(String s)
   {  
       try{ 
            byte bb[]=s.getBytes("UTF-8");
            s=new String(bb);
          }
       catch(Exception ee){} 
       return s;  
   }
   public  void  doPost(HttpServletRequest request,HttpServletResponse response) 
                        throws ServletException,IOException
    {   
        Connection con; 
        Statement sql; 
 Login loginBean=null;
String backNews="";
        HttpSession session=request.getSession(true);
        try{  loginBean=(Login)session.getAttribute("Login");
              if(loginBean==null)
 { loginBean=new Login();  
                session.setAttribute("login",loginBean);
              }
           }
        catch(Exception ee)
          {  loginBean=new Login();  

Answer 1

搞错地方来，JSP和JS是两码事

Answer 2

catch(Exception ee){} 里面把异常打出来看看啊。。不行把异常信息贴出来

Answer 3

package myservlet.control;
import java.sql.*;
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class HandleLogin extends HttpServlet
{  
   public void init(ServletConfig config) throws ServletException
    { 
      super.init(config);
      try { 
             Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
          }
       catch(Exception e){} 
    }
   public String handleString(String s)
   {  
       try{ 
            byte bb[]=s.getBytes("UTF-8");
            s=new String(bb);
          }
       catch(Exception ee){} 
       return s;  
   }
   public  void  doPost(HttpServletRequest request,HttpServletResponse response) 
                        throws ServletException,IOException
    {   
        Connection con; 
        Statement sql; 
        Login loginBean=null;
        String backNews="";
        HttpSession session=request.getSession(true);
        try{  loginBean=(Login)session.getAttribute("login");
              if(loginBean==null)
              { loginBean=new Login();  
                session.setAttribute("login",loginBean);
              }
           }
        catch(Exception ee)
          {  loginBean=new Login();  
             session.setAttribute("login",loginBean);
          }
        String logname=request.getParameter("logname").trim(),
        password=request.getParameter("password").trim();
        boolean ok=loginBean.getSuccess();
        logname=handleString(logname); 
        password=handleString(password);
        if(ok==true&&logname.equals(loginBean.getLogname()))
        {  
           backNews=logname+"已经登录了";
           loginBean.setBackNews(backNews);
        }
        else
        { 
           String uri="jdbc:sqlserver://127.0.0.1:1433;DatabaseName=MakeFriend";
           boolean boo=(logname.length()>0)&&(password.length()>0);  
           try{ 
                con=DriverManager.getConnection(uri,"sa","sa");
                String condition=
                "select * from member where logname = '"+
logname+"' and password ='"+password+"'";
                sql=con.createStatement();  
                if(boo)
                {
                  ResultSet rs=sql.executeQuery(condition);
                  boolean m=rs.next();
                  if(m==true)
                  {  
                     backNews="登录成功";
                     loginBean.setBackNews(backNews);
                     loginBean.setSuccess(true);
                     loginBean.setLogname(logname);
                  }
                 else
                  {  
                     backNews="您输入的用户名不存在，或密码不般配";
                     loginBean.setBackNews(backNews); 
                     loginBean.setSuccess(false); 
                     loginBean.setLogname(logname);
                     loginBean.setPassword(password);
                  }
                }
                else
                { 
                  backNews="您输入的用户名不存在，或密码不般配";
                  loginBean.setBackNews(backNews); 
                  loginBean.setSuccess(false); 
                  loginBean.setLogname(logname);
                  loginBean.setPassword(password);
                }
                con.close();
              }
           catch(SQLException exp)
             { 
                backNews=""+exp;
                loginBean.setBackNews(backNews); 
                loginBean.setSuccess(false); 
             }
        }
       RequestDispatcher RequestDispatcherdispatcher = request.getRequestDispatcher("showLoginMess.jsp"); 
       RequestDispatcher dispatcher;
dispatcher.forward(request,response);
    }
   public  void  doGet(HttpServletRequest request,HttpServletResponse response) 
                        throws ServletException,IOException
    {   
       doPost(request,response);
    }
}

Answer 4

Multiple ers at this line
- Login cannot be resolved to a type
- Line breakpoint:HandleLogin [line: 30] - doPost(HttpServletRequest, 
 HttpServletResponse)

Answer 5

java.lang.ClassNotFoundException: com.microsoft.sqlserver.odbc.SQLServerDriver
java.sql.SQLException: No suitable driver found for jdbc:sqlserver://192.168.1.233:1433;DatabaseName=fztxb这个错误又怎么解决？