创建普适性的Java连接器

创建普适性的Java连接器

这是一个简单的程序，可以连接到PSQL数据库：

import java.*;import java.sql.*;import pervasive.jdbc.*;import java.io.*;public class SQLStatement  {    public static void main(String args[]) {        String url = "jdbc:pervasive://localhost:1583/demodata?transport=tcp";        Connection con;        String query = "select* from class";        Statement stmt;        try { Class.forName("com.pervasive.jdbc.v2.Driver");        } catch(Exception e) { System.err.print("ClassNotFoundException: "); System.out.println(e.toString()); System.err.println(e.getMessage());        }        try { Connection conn=  DriverManager.getConnection(url); stmt = conn.createStatement(); ResultSet rs = stmt.executeQuery(query); ResultSetmetaData rsmd = rs.getmetaData(); int numberOfColumns = rsmd.getColumnCount(); int rowCount = 1; long j = 0; int i = 1; while (rs.next()) {     System.out.println("Row " + rowCount + ":  ");     for (i = 1; i <= numberOfColumns; i++) {         System.out.print("   Column " + i + ":  ");         System.out.println(rs.getString(i));     }     System.out.println("");     rowCount++; } System.out.println("Waiting."); String thisLine; try {     InputStreamReader converter = new InputStreamReader(System.in);     BufferedReader br = new BufferedReader(converter);     while ((thisLine = br.readLine()) != null) { // while loop begins here         System.out.println(thisLine);        } // end while      } // end try catch (IOException e) {     System.err.println("Error: " + e);     } stmt.close(); conn.close();        } catch(SQLException ex) { System.err.print("SQLException: "); System.err.println(ex.getMessage());        }       }}

要编译它，我使用：

javac -classpath "C:Program FilesPervasive SoftwarePSQLbinpvjdbc2.jar";"C:Program FilesPervasive SoftwarePSQLbinpvjdbc2x.jar";"C:Program FilesPervasive SoftwarePSQLbinjpscs.jar";. SQLStatement.java

为了运行它，我使用：

java -classpath "C:Program FilesPervasive SoftwarePSQLbinpvjdbc2.jar";"C:Program FilesPervasive SoftwarePSQLbinpvjdbc2x.jar";"C:Program FilesPervasive SoftwarePSQLbinjpscs.jar";. SQLStatement.java

如果使用的是64位 *** 作系统，则可能需要更改PSQL JAR文件的位置。