ITPub博客

首页 > Linux操作系统 > Linux操作系统 > Java 连接 TimesTen数据库

Java 连接 TimesTen数据库

原创 Linux操作系统 作者:sky_heaven 时间:2009-05-19 08:42:58 0 删除 编辑

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/,如需转载,请注明出处,否则将追究法律责任。

上一篇: 没有了~
下一篇: WITH的用法
请登录后发表评论 登录
全部评论

注册时间:2008-08-06

  • 博文量
    9
  • 访问量
    21597