将DB2与Java连接

本文介绍了将DB2与Java连接的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

我需要将DB2与Java连接。 请帮助我将 DB2 与 ECLIPSE 中的Java连接。 如果您可以逐步指导我，那将对您有很大帮助。请让我知道如何在eclipse 代码段中添加类路径：

I need to connect DB2 with Java. Kindly help me to connect DB2 with java in ECLIPSE. It would be of great help if you could guide me step by step Please let me know how to add classpath in eclipse code snippet:

import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.DriverManager; import java.sql.Connection; import java.sql.SQLException; public class connection { public static void main(String[] argv) { try { Class.forName("COM.ibm.db2.jdbc.app.DB2Driver"); } catch (ClassNotFoundException e) { System.out.println("Please include Classpath Where your DB2 Driver is located"); e.printStackTrace(); return; } System.out.println("DB2 driver is loaded successfully"); Connection conn = null; PreparedStatement pstmt = null; ResultSet rset=null; boolean found=false; try { conn = DriverManager.getConnection("jdbc:db2:sabarish","db2admin","Murugasaranam"); if (conn != null) { System.out.println("DB2 Database Connected"); } else { System.out.println("Db2 connection Failed "); } pstmt=conn.prepareStatement("Select * from bo"); rset=pstmt.executeQuery(); if(rset!=null) { while(rset.next()) { found=true; System.out.println("Class Code: "+rset.getString("clcode")); System.out.println("Name: "+rset.getString("name")); } } if (found ==false) { System.out.println("No Information Found"); } } catch (SQLException e) { System.out.println("DB2 Database connection Failed"); e.printStackTrace(); return; } } }

正在运行代码中出现以下异常：

On running the code I got the following exceptions:

java.lang.ClassNotFoundException: COM.ibm.db2.jdbc.app.DB2Driver at java.URLClassLoader$1.run(Unknown Source) at java.security.AccessController.doPrivileged(Native Method) at java.URLClassLoader.findClass(Unknown Source) at java.lang.ClassLoader.loadClass(Unknown Source) at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source) at java.lang.ClassLoader.loadClass(Unknown Source) at java.lang.Class.forName0(Native Method) at java.lang.Class.forName(Unknown Source) at connection.main(connection.java:11)

推荐答案

您需要更正软件包名称。

You need to correct the package name.

Class.forName("com.ibm.db2.jdbc.app.DB2Driver");

要在项目中添加.jar => Project + Properties + Java Build Path +选择 Libraries标签+添加外部Jars ...

To add .jar in your project => Project + Properties + Java Build Path + Select "Libraries" tab + Add External Jars...