该楼层疑似违规已被系统折叠 隐藏此楼查看此楼
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.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();}
}
}
求解!!!