/*
 * SQLStatement.java       
 * Simple JDBC Sample using Pervasive JDBC driver. 
 */
import java.*;
import java.sql.*;
import pervasive.jdbc.*;

     
public class SQLStatement  {

	public static void main(String args[]) {
		  
		String url = "jdbc:pervasive://192.168.0.1:1583/Demodata";
		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;
			
			while (rs.next()) {
				System.out.println("Row " + rowCount + ":  ");
				for (int i = 1; i <= numberOfColumns; i++) {
					System.out.print("   Column " + i + ":  ");
					System.out.println(rs.getString(i));
				}
				System.out.println("");
				rowCount++;
			}
			stmt.close();
			conn.close();

		} catch(SQLException ex) {
			System.err.print("SQLException: ");
			System.err.println(ex.getMessage());
		}	
	}
}