jdbc连接timesten_Java 连接 TimesTen数据库

package com.linkage.billing;

import java.sql.Connection;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

import com.timesten.jdbc.TimesTenDataSource;

public class Test

{

/**

* @param args

* @throws SQLException

*/

public static void main(String[] args)

throws SQLException

{

// connection URL for the data store

String URL = "jdbc:timesten:direct:dsn=paradise;uid=tt;pwd=tt;";

Connection conn = null;

Statement stmt = null;

ResultSet rs = null;

try

{

Class.forName("com.timesten.jdbc.TimesTenDriver");

}

catch (ClassNotFoundException e)

{

e.printStackTrace();

}

try

{

TimesTenDataSource ds = new TimesTenDataSource();

ds.setUrl(URL);

conn = ds.getConnection();

stmt = conn.createStatement();

rs = stmt

.executeQuery(

"SELECT T.SYS26, T.TBLNAME, T.TBLOWNER FROM TABLES T;");

while (rs.next())

{

System.out.println("    ID: " + rs.getInt(1));

System.out.println("  NAME: " + rs.getString(2));

System.out.println(" OWNER: " + rs.getString(2) + "\n");

}

}

catch (Exception e)

{

e.printStackTrace();

}

finally

{

if (rs != null)

{

rs.close();

}

if (stmt != null)

{

stmt.close();

}

if (conn != null)

{

conn.close();

}

}

}

}