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();
            }
        }
    }
}

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/329055/viewspace-600374/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/329055/viewspace-600374/