Java SE
连接DB2数据库报错
墨衍会员 · AI 创作全网分发 墨衍智能分发 通过墨衍一键同步至各平台 可同步平台 CSDN微信公众号微博知乎掘金百家号博客园抖音小红书 你的文章也可以这样分发 墨衍会员 ¥399起/年，写一次发全网
我也要 关注 + 加入社区小弟写了一个程序，连接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中可以看到已经自动加载，请教各位前辈，我的问题该怎么解决啊？
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中可以看到已经自动加载，请教各位前辈，我的问题该怎么解决啊？
...全文
