servlet链接不上mssql
prok 2006-01-05 05:19:59 我用tomcat5.0系统是2000sp4 3个jar也拷到D:\Program Files\Apache Software Foundation\Tomcat 5.0\webapps\ROOT\WEB-INF\lib下面了。
但是链接报错。。tomcat控制台输出:java.sql.SQLException: No suitable driver
以下是我得链接代码:
public void connectDB(){
try {
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
}catch(Exception e){
}
String url="jdbc:microsoft:sqlserver;DatabaseName=iblog";
String user="";
String password="";
try{
Connection conn= DriverManager.getConnection(url,user,password);
Statement stat = conn.createStatement();
ResultSet rs = stat.executeQuery("INSERT account (accountID,userName,passWord,eMail,firstName,lastName,age,career) VALUES ('id','name','psw','email','firstName','lastName','age','career')");
}catch(Exception e){
System.out.println(e);
}
}
解决立刻结贴