testdatatypes.java

java 数据库 功能强大 效率高 SmallSQL Database is a free DBMS library for the Java(tm) platform. It runs on

/* =============================================================
 * SmallSQL : a free Java DBMS library for the Java(tm) platform
 * =============================================================
 *
 * (C) Copyright 2004-2006, by Volker Berlin.
 *
 * Project Info:  http://www.smallsql.de/
 *
 * This library is free software; you can redistribute it and/or modify it 
 * under the terms of the GNU Lesser General Public License as published by 
 * the Free Software Foundation; either version 2.1 of the License, or 
 * (at your option) any later version.
 *
 * This library is distributed in the hope that it will be useful, but 
 * WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY 
 * or FITNESS FOR A PARTICULAR PURPOSE. See the GNU Lesser General Public 
 * License for more details.
 *
 * You should have received a copy of the GNU Lesser General Public
 * License along with this library; if not, write to the Free Software
 * Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301, 
 * USA.  
 *
 * [Java is a trademark or registered trademark of Sun Microsystems, Inc. 
 * in the United States and other countries.]
 *
 * ---------------
 * TestDataTypes.java
 * ---------------
 * Author: Volker Berlin
 * 
 */
package smallsql.junit;

import junit.framework.*;
import java.sql.*;
import java.math.*;

public class TestDataTypes extends BasicTestCase{

    static final String[] DATATYPES = { "varchar(100)",
                                                "varchar2(130)", "nvarchar(137)", "nvarchar2(137)", "sysname",
                                                "char(100)", "CHARACTER(99)",
                                                "nchar(80)",
                                                "int", "smallint", "tinyint", "bigint", "byte",
                                                "real", "float", "double",
                                                "bit", "Boolean",
                                                "binary( 125 )", "varbinary(57)", "raw(88)",
                                                "java_object", "sql_variant",
                                                "image", "LONGvarbinary", "long raw",
                                                "blob", "clob","nclob",
                                                "text", "ntext", "LongVarchar", "long",
                                                "time", "date", "datetime", "timestamp", "SMALLDATETIME",
                                                "UNIQUEIDENTIFIER",
                                                "numeric(28,4)", "decimal(29,4)","number(29,4)", "varnum(29,4)",
                                                "COUNTER",
                                                "money", "smallmoney"};

    private static final String table = "table_datatypes";

    private String datatype;

    TestDataTypes( String datatype ){
        super( datatype );
        this.datatype = datatype;
    }

    public void tearDown(){
        try{
            Connection con = AllTests.getConnection();
            Statement st = con.createStatement();
            st.execute("drop table " + table);
            st.close();
        }catch(Throwable e){
            //e.printStackTrace();
        }
    }

    public void setUp(){
        tearDown();
    }

    public void runTest() throws Throwable {
        Connection con = AllTests.getConnection();
        Statement st = con.createStatement();
        st.execute("Create Table " + table +"(abc " + datatype + ")");
        String name = "abc";

        Object[] values = null;
        String   quote = "";
        String escape1 = "";
        String escape2 = "";
        boolean needTrim = false;

        ResultSet rs = st.executeQuery("SELECT * From " + table);
		ResultSetMetaData md = rs.getMetaData();
        switch(md.getColumnType(1)){
            case Types.CHAR:
                needTrim = true;
            case Types.VARCHAR:
            case Types.LONGVARCHAR:
            case Types.CLOB:
                values = new Object[]{null,"qwert", "asdfg", "hjhjhj", "1234567890 qwertzuiop 1234567890 asdfghjkl