KickJava   Java API By Example, From Geeks To Geeks.

Java > Open Source Codes > org > netbeans > modules > db > test > jdbcstub > JDBCStubUtilTest


1 /*
2  * The contents of this file are subject to the terms of the Common Development
3  * and Distribution License (the License). You may not use this file except in
4  * compliance with the License.
5  *
6  * You can obtain a copy of the License at http://www.netbeans.org/cddl.html
7  * or http://www.netbeans.org/cddl.txt.
8  *
9  * When distributing Covered Code, include this CDDL Header Notice in each file
10  * and include the License file at http://www.netbeans.org/cddl.txt.
11  * If applicable, add the following below the CDDL Header, with the fields
12  * enclosed by brackets [] replaced by your own identifying information:
13  * "Portions Copyrighted [year] [name of copyright owner]"
14  *
15  * The Original Software is NetBeans. The Initial Developer of the Original
16  * Software is Sun Microsystems, Inc. Portions Copyright 1997-2006 Sun
17  * Microsystems, Inc. All Rights Reserved.
18  */
19
20 package org.netbeans.modules.db.test.jdbcstub;
21
22 import java.sql.DatabaseMetaData JavaDoc;
23 import java.sql.ResultSet JavaDoc;
24 import java.sql.Types JavaDoc;
25 import junit.framework.TestCase;
26
27 /**
28  *
29  * @author Andrei Badea
30  */
31 public class JDBCStubUtilTest extends TestCase {
32     
33     public JDBCStubUtilTest(String JavaDoc name) {
34         super(name);
35     }
36     
37     public void testColumnsResultSet() throws Exception JavaDoc {
38         ResultSet JavaDoc rs = JDBCStubUtil.columnsResultSet(
39                 new String JavaDoc[] { "REAL_COL", "VARCHAR_COL" },
40                 new String JavaDoc[] { "REAL", "VARCHAR" },
41                 new int[] { Types.REAL, Types.VARCHAR },
42                 new int[] { 10, 20 },
43                 new int[] { 6, 0 },
44                 new int[] { DatabaseMetaData.columnNoNulls, DatabaseMetaData.columnNullable }
45         );
46         
47         rs.next();
48         assertEquals("REAL_COL", rs.getString("COLUMN_NAME"));
49         assertEquals("REAL", rs.getString("TYPE_NAME"));
50         assertEquals(Types.REAL, rs.getInt("DATA_TYPE"));
51         assertEquals(10, rs.getInt("COLUMN_SIZE"));
52         assertEquals(6, rs.getInt("DECIMAL_DIGITS"));
53         assertEquals(DatabaseMetaData.columnNoNulls, rs.getInt("NULLABLE"));
54         
55         rs.next();
56         assertEquals("VARCHAR_COL", rs.getString("COLUMN_NAME"));
57         assertEquals("VARCHAR", rs.getString("TYPE_NAME"));
58         assertEquals(Types.VARCHAR, rs.getInt("DATA_TYPE"));
59         assertEquals(20, rs.getInt("COLUMN_SIZE"));
60         assertEquals(0, rs.getInt("DECIMAL_DIGITS"));
61         assertEquals(DatabaseMetaData.columnNullable, rs.getInt("NULLABLE"));
62     }
63 }
64
Popular Tags