db2java_java 连接 db2

classpath中有db2java，文件在dos黑屏下编译，执行可以完成，在eclipse上导入了db2java.zip。一直执行失败，如下Unabletoconnectionjava.sql.SQLException:Nosuitabledriveratjava.sq...

classpath中有db2java，文件在dos黑屏下编译，执行可以完成，

在eclipse上导入了db2java.zip。一直执行失败，如下

Unable to connection

java.sql.SQLException: No suitable driver

at java.sql.DriverManager.getConnection(Unknown Source)

at java.sql.DriverManager.getConnection(Unknown Source)

at ConnDB2.main(ConnDB2.java:32)

public static void main(String argv[]) {

Connection con = null;

Statement sta = null;

ResultSet res = null;

// String url ="jdbc:db2://localhost:50000/sample";

String url = "jdbc:db2:sample";

// String url ="jdbc:db2://127.0.0.1:50000/sample";

try {

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

con = DriverManager.getConnection(url, "db2admin", "db2admin");

sta = con.createStatement();

String query = " select * from Administrater.staff";

res = sta.executeQuery(query);

boolean Have = res.next();

if (!Have) {

System.out.print("No record\n");

System.exit(-1);

}

ResultSetMetaData rsmd = res.getMetaData();

for (int i = 1; i <= rsmd.getColumnCount(); i++) {

System.out.print(rsmd.getColumnName(i) + " ");

}

System.out.print("\n");

do {

for (int i = 1; i <= rsmd.getColumnCount(); i++) {

System.out.print(res.getString(i) + " ");

}

System.out.print("\n");

} while (res.next());

res.close();

sta.close();

con.close

} catch (ClassNotFoundException e) {

System.out.println("Failed to load JDBC/ODBC");

e.printStackTrace();

System.exit(0);

} catch (SQLException e) {

System.out.println("Unable to connection");

e.printStackTrace();

}catch(Exception e)

{

System.out.println("s");

}

}

那么在eclipse里面如何设置db2profile？

展开