SQL的JAVA连接器_创建普适性的Java连接器

小编典典

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

/*

* SQLStatement.java

* Simple JDBC Sample using Pervasive JDBC driver.

*/

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 Files\Pervasive Software\PSQL\bin\pvjdbc2.jar";"C:\Program Files\Pervasive Software\PSQL\bin\pvjdbc2x.jar";"C:\Program Files\Pervasive Software\PSQL\bin\jpscs.jar";. SQLStatement.java

为了运行它，我使用：

java -classpath "C:\Program Files\Pervasive Software\PSQL\bin\pvjdbc2.jar";"C:\Program Files\Pervasive Software\PSQL\bin\pvjdbc2x.jar";"C:\Program Files\Pervasive Software\PSQL\bin\jpscs.jar";.\ SQLStatement.java

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

2020-09-28