UC知道跪求sql2000高手！！！！
来源：百度知道 编辑：UC知道 时间：2024/05/03 10:42:18
No suitable driver问题，三个jar包都放在C:\Program Files\Java\jre6\lib\ext下面了，也放在项目的lib下面了，classpath也配置了，指向三个jar包的位置，sql2000也打sp4补丁了，网上说的办法基本上都试过了，还是这个错误。。。我快疯了，马上要交毕设了，请高手指点！
public class LoginServlet extends HttpServlet {
public void doGet(HttpServletRequest req, HttpServletResponse res) throws IOException {
res.setContentType("text/html;charset=gb2312");
String uname=req.getParameter("username");
String pwd=req.getParameter("pass");
String role=null;
HttpSession hs =req.getSession();
hs.setAttribute("u", req.getParameter("username"));
Connection con = null;
PreparedStatement ps = null;
PreparedStatement ps1=null;
ResultSet rs1=null;
ResultSet rs = null;
int rowcount;
try {
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
con = DriverManager.getConnection("jdbc:microsoft:@
public class LoginServlet extends HttpServlet {
public void doGet(HttpServletRequest req, HttpServletResponse res) throws IOException {
res.setContentType("text/html;charset=gb2312");
String uname=req.getParameter("username");
String pwd=req.getParameter("pass");
String role=null;
HttpSession hs =req.getSession();
hs.setAttribute("u", req.getParameter("username"));
Connection con = null;
PreparedStatement ps = null;
PreparedStatement ps1=null;
ResultSet rs1=null;
ResultSet rs = null;
int rowcount;
try {
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
con = DriverManager.getConnection("jdbc:microsoft:@
应该是 jdbc:microsoft:sqlserver://localhost:1433:DatabaseName=aaaa
吧，没有@
好久不这样写了，都忘了 汗！
推荐使用 jtds-1.2.jar驱动，替换几句关键的：
Class.forName("net.sourceforge.jtds.jdbc.Driver");
con = DriverManager.getConnection("jdbc:jtds:sqlserver://localhost:1433:DatabaseName=aaaa",
"sa", "sa");
你试试