1 25 package org.jresearch.gossip.dao.drivers.keygen; 26 27 import java.sql.Connection ; 28 import java.sql.DatabaseMetaData ; 29 import java.sql.DriverManager ; 30 import java.sql.ResultSet ; 31 32 import junit.framework.TestCase; 33 34 40 public class KeyKeeperTest extends TestCase { 41 42 private Connection conn; 43 44 48 public KeyKeeperTest(String arg0) { 49 super(arg0); 50 } 51 52 public static void main(String [] args) { 53 junit.textui.TestRunner.run(KeyKeeperTest.class); 54 } 55 56 59 protected void setUp() throws Exception { 60 super.setUp(); 61 Class.forName("oracle.jdbc.driver.OracleDriver"); 62 conn = DriverManager.getConnection("jdbc:oracle:thin:@frodo:1521:ORACLEDB", "jgossip", "Welcome1");; 63 } 64 65 68 protected void tearDown() throws Exception { 69 super.tearDown(); 70 if (null != conn) conn.close(); 71 conn = null; 72 } 73 74 final public void testGetColumnTypeTC() 75 throws Exception 76 { 77 ResultSet rs = null; 78 String table = "JRF_KEY_KEEPER"; 79 String column = "next_key"; 80 DatabaseMetaData dmd = conn.getMetaData(); 81 System.out.println("database metadata obtained: "+dmd.toString()); 82 System.out.println("Columns info obtaining for table[" + table +"] column["+column+"]."); 83 rs = dmd.getColumns(null, null, table.toUpperCase(), column.toUpperCase()); 85 System.out.println("Columns info obtained: "+rs); 86 if(null != rs ) 87 { 88 for(int i = rs.getMetaData().getColumnCount(); i > 0; i--) { 89 System.out.println(rs.getMetaData().getColumnName(i)); 90 } 91 while(rs.next()) { 92 System.out.println("TABLE_CAT:"+rs.getObject("TABLE_CAT")); 93 System.out.println("TABLE_SCHEM:"+rs.getObject("TABLE_SCHEM")); 94 System.out.println("TABLE_NAME:"+rs.getObject("TABLE_NAME")); 95 System.out.println("COLUMN_NAME:"+rs.getObject("COLUMN_NAME")); 96 System.out.println("DATA_TYPE:"+rs.getObject("DATA_TYPE")); 97 System.out.println("TYPE_NAME:"+rs.getObject("TYPE_NAME")); 98 System.out.println("COLUMN_SIZE:"+rs.getObject("COLUMN_SIZE")); 99 System.out.println("DECIMAL_DIGITS:"+rs.getObject("DECIMAL_DIGITS")); 100 System.out.println("NULLABLE:"+rs.getObject("NULLABLE")); 101 System.out.println("IS_NULLABLE:"+rs.getObject("IS_NULLABLE")); 102 } 106 rs.close(); 107 } 108 } 109 110 final public void testGetColumnTypePK() 111 throws Exception 112 { 113 ResultSet rs = null; 114 String [] primaryKey = {"jrf_message", "id"}; 115 DatabaseMetaData dmd = conn.getMetaData(); 116 System.out.println("database metadata obtained: "+dmd.toString()); 117 System.out.println("Primary keys:"); 118 for (int i = 0; i < primaryKey.length; ++i) 119 System.out.println("primary key ["+i+"]="+primaryKey[i]); 120 System.out.println("Columns info obtaining for table[" + primaryKey[0] +"] column["+primaryKey[1]+"]."); 121 rs = dmd.getColumns(null, null, primaryKey[0].toUpperCase(), primaryKey[1].toUpperCase()); 123 System.out.println("Columns info obtained: "+rs); 124 if(null != rs ) 125 { 126 for(int i = rs.getMetaData().getColumnCount(); i > 0; i--) { 127 System.out.println(rs.getMetaData().getColumnName(i)); 128 } 129 while(rs.next()) { 130 System.out.println("TABLE_CAT:"+rs.getObject("TABLE_CAT")); 131 System.out.println("TABLE_SCHEM:"+rs.getObject("TABLE_SCHEM")); 132 System.out.println("TABLE_NAME:"+rs.getObject("TABLE_NAME")); 133 System.out.println("COLUMN_NAME:"+rs.getObject("COLUMN_NAME")); 134 System.out.println("DATA_TYPE:"+rs.getObject("DATA_TYPE")); 135 System.out.println("TYPE_NAME:"+rs.getObject("TYPE_NAME")); 136 System.out.println("COLUMN_SIZE:"+rs.getObject("COLUMN_SIZE")); 137 System.out.println("DECIMAL_DIGITS:"+rs.getObject("DECIMAL_DIGITS")); 138 System.out.println("NULLABLE:"+rs.getObject("NULLABLE")); 139 System.out.println("IS_NULLABLE:"+rs.getObject("IS_NULLABLE")); 140 } 144 rs.close(); 145 } 146 } 147 148 } 149 | Popular Tags |