连接DB2数据库报错
VF 2008-07-17 10:48:29 小弟写了一个程序,连接DB2数据库的时候报错:
java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getConnection(DriverManager.java:545)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at dao.DBConnection.DBConnection(DBConnection.java:27)
at com.yourcompany.struts.action.LoginTestAction.execute(LoginTestAction.java:43)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
at java.lang.Thread.run(Thread.java:595)
数据库连接代码如下:
public class DBConnection{
public UserDAO DBConnection(){
try{
Class.forName("COM.ibm.db2.jdbc.app.DB2Driver").newInstance();
}catch(Exception e){
e.printStackTrace();
}
Connection coon=null;
Statement stmt=null;
ResultSet rs=null;
String url="jdbc:db2://localhost:50000/DB2_TEST";
String user="admin";
String psw="19861108";
String sql="select * from test";
PreparedStatement ptmt=null;
try{
coon=DriverManager.getConnection(url, user, psw);
stmt=coon.createStatement();
// stmt.executeUpdate(sql);
rs=stmt.executeQuery(sql);
UserDAO us=new UserDAO();
if(rs.next()){
us.setUserName(rs.getString(2));
us.setPassword(rs.getString(3));
}
return us;
}catch(Exception ex){
ex.printStackTrace();
}
finally{
try{
rs.close();
stmt.close();
coon.close();
}catch(Exception ex){
ex.printStackTrace();
}
}
return null;
}
}
DB2数据库安装文件夹中的db2jcc.jar,db2jcc_license_cu.jar已经复制到Tomcat中,工程下也有,也已经将db2java,jar复制到工程/WEB-INF/lib下,在Myeclipse中可以看到已经自动加载,请教各位前辈,我的问题该怎么解决啊?