java连接不上mysql2008_快急死了！！！！关于jdbc连接sqlserver2008一直失败，求解啊！...

该楼层疑似违规已被系统折叠 隐藏此楼查看此楼

No suitable driver found for jdbc:sqlserver://localhost:1433;databasename=test;user=sa;password=123

一直出这个，加不加mircosoft都一样。

找了半天答案，在这上面加了class.forName，又出现了如下错误

jar包也导入了，实在不知道哪出了问题。下面是我现在的代码

public void doGet(HttpServletRequest request, HttpServletResponse response)

throws ServletException, IOException {

String username=request.getParameter("username");

username = new String(username.getBytes("iso-8859-1"),

"utf-8");

String mima=request.getParameter("mima");

mima = new String(mima.getBytes("iso-8859-1"),

"utf-8");

String querenmima=request.getParameter("querenmima");

querenmima = new String(querenmima.getBytes("iso-8859-1"),

"utf-8");

String name=request.getParameter("name");

name = new String(name.getBytes("iso-8859-1"),

"utf-8");

String mail=request.getParameter("mail");

mail = new String(mail.getBytes("iso-8859-1"),

"utf-8");

PreparedStatement st = null;

ResultSet rs= null;

Connection cn = null;

try {

Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");

cn = DriverManager.getConnection("jdbc:sqlserver://127.0.0.1:1433;databasename=test;user=sa;password=123");

String sql = "insert into Users values (?,?,?,?,?)";

st = cn.prepareStatement(sql);

st.setString(1, username);

st.setString(2, mima);

st.setString(3, querenmima);

st.setString(4, name);

st.setString(5, mail);

st.execute();

response.setContentType("text/html");

PrintWriter out = response.getWriter();

out

.println(""-//W3C//DTD HTML 4.01 Transitional//EN\">");

out.println("");

out.println("

A Servlet");

out.println("

");

out.print("成功 ");

out.println("请登录 ");

out.println(" ");

out.println("");

out.flush();

out.close();

} catch (SQLException e) {

System.out.println(e.getMessage());

} catch (ClassNotFoundException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

finally{

if (rs!=null) try {rs.close();} catch (SQLException e) {e.printStackTrace();}

if (st!=null) try {st.close();} catch (SQLException e) {e.printStackTrace();}

if (cn!=null) try {cn.close();} catch (SQLException e) {e.printStackTrace();}

}

}

求解！！！