KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
How can I connect DB2 with Java in Eclipse ? What are some step-by-step instructions? How can I add the 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 Informa
Tags (comma-separated)
Save Edits
Cancel