supplier_edit.jsp:<%@ page contentType="text/html; charset=gb2312" %>
<%@ page import="java.sql.*" %>
<%request.setCharacterEncoding("GB2312");%><%
String supplier_id = request.getParameter("supplier_id")==null?"1":request.getParameter("supplier_id");
long fID = Long.parseLong(supplier_id);
String supplier_name = request.getParameter("supplier_name")==null?"1":request.getParameter("supplier_name");
String supplier_address = request.getParameter("supplier_address")==null?"1":request.getParameter("supplier_address");
String supplier_chargeName = request.getParameter("supplier_chargeName")==null?"1":request.getParameter("supplier_chargeName");
String supplier_phone = request.getParameter("supplier_phone")==null?"1":request.getParameter("supplier_phone");
String supplier_email = request.getParameter("supplier_email")==null?"1":request.getParameter("supplier_email");
String supplier_QQ = request.getParameter("supplier_QQ")==null?"1":request.getParameter("supplier_QQ");
String supplier_re = request.getParameter("supplier_re")==null?"1":request.getParameter("supplier_re");
String sql="update supplier_tb set supplierName= \'"+supplier_name+"\' ,supplierAddress=\'"+supplier_address+"\',supplierChargeName= \'"+supplier_chargeName+"\' ,supplierPhone= \'"+supplier_phone+"\' ,supplierEmail= \'"+supplier_email+"\' ,supplierQQ= \'"+supplier_QQ+"\',supplierRe= \'"+supplier_re+"\' where supplierID = "+ fID;
try{  
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
Connection con = DriverManager.getConnection("jdbc:sqlserver://localhost:1433;DatabaseName=db_ilike","zbf","123");
Statement dbc = con.createStatement();     
int count= dbc.executeUpdate(sql);
  if(count>0) 
     out.print("<script>alert('修改成功!');document.location='supplier_edit.jsp';</script>");
   else  
      out.print("<script>alert('修改失败!');document.location='supplier_edit.jsp';</script>");     
dbc.close();
}catch(Exception e1) {out.println(e1.toString());}
%>
 
m_supplier_edit.jsp:
<%@ page contentType="text/html; charset=gb2312" %>
<%@ page import="java.sql.*" %>
<%request.setCharacterEncoding("GB2312");%><%
String supplier_id = request.getParameter("supplier_id")==null?"1":request.getParameter("supplier_id");
long fID = Long.parseLong(supplier_id);
String supplier_name = request.getParameter("supplier_name")==null?"1":request.getParameter("supplier_name");
String supplier_address = request.getParameter("supplier_address")==null?"1":request.getParameter("supplier_address");
String supplier_chargeName = request.getParameter("supplier_chargeName")==null?"1":request.getParameter("supplier_chargeName");
String supplier_phone = request.getParameter("supplier_phone")==null?"1":request.getParameter("supplier_phone");
String supplier_email = request.getParameter("supplier_email")==null?"1":request.getParameter("supplier_email");
String supplier_QQ = request.getParameter("supplier_QQ")==null?"1":request.getParameter("supplier_QQ");
String supplier_re = request.getParameter("supplier_re")==null?"1":request.getParameter("supplier_re");
String sql="update supplier_tb set supplierName= \'"+supplier_name+"\' ,supplierAddress=\'"+supplier_address+"\',supplierChargeName= \'"+supplier_chargeName+"\' ,supplierPhone= \'"+supplier_phone+"\' ,supplierEmail= \'"+supplier_email+"\' ,supplierQQ= \'"+supplier_QQ+"\',supplierRe= \'"+supplier_re+"\' where supplierID = "+ fID;
try{  
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
Connection con = DriverManager.getConnection("jdbc:sqlserver://localhost:1433;DatabaseName=db_ilike","zbf","123");
Statement dbc = con.createStatement();     
int count= dbc.executeUpdate(sql);
  if(count>0) 
     out.print("<script>alert('修改成功!');document.location='supplier_edit.jsp';</script>");
   else  
      out.print("<script>alert('修改失败!');document.location='supplier_edit.jsp';</script>");     
dbc.close();
}catch(Exception e1) {out.println(e1.toString());}
%>显示:java.sql.SQLException: No suitable driver found for jdbc:sqlserver:127.0.0.1:1433;DatabaseName=db_ilike 补充:db_ilike已经放到SQL 2005中了,也导进sqljdbc了,Tomcat也启动了...请问是什么问题?