PreparedStatementProxyImplTest.java

package com.alibaba.druid.bvt.pool;

import java.math.BigDecimal;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.Types;

import junit.framework.TestCase;

import org.junit.Assert;

import com.alibaba.druid.pool.DruidDataSource;
import com.alibaba.druid.proxy.jdbc.PreparedStatementProxy;

public class PreparedStatementProxyImplTest extends TestCase {

    private DruidDataSource dataSource;

    protected void setUp() throws Exception {
        dataSource = new DruidDataSource();
        dataSource.setUrl("jdbc:mock:xxx");
        dataSource.setInitialSize(1);
        dataSource.setFilters("log4j");
    }

    protected void tearDown() throws Exception {
        dataSource.close();
    }

    public void test_setObject() throws Exception {
        String sql = "insert t values(?, ?, ?, ?, ?,  ?, ?, ?, ?, ?)";
        Connection conn = dataSource.getConnection();

        PreparedStatement stmt = conn.prepareStatement(sql);
        stmt.setObject(1, (byte) 1);
        stmt.setObject(2, (short) 1);
        stmt.setObject(3, (int) 1);
        stmt.setObject(4, (long) 1);
        stmt.setObject(5, (float) 1);

        stmt.setObject(6, (double) 1);
        stmt.setObject(7, new BigDecimal(1));
        stmt.setObject(8, true);
        stmt.setObject(9, "xxx");
        stmt.setObject(10, new java.sql.Date(System.currentTimeMillis()));

        stmt.setObject(11, new java.util.Date(System.currentTimeMillis()));
        stmt.setObject(12, new java.sql.Timestamp(System.currentTimeMillis()));
        stmt.setObject(13, new java.sql.Time(System.currentTimeMillis()));

        stmt.execute();

        PreparedStatementProxy stmtProxy = stmt.unwrap(PreparedStatementProxy.class);
        Assert.assertNotNull(stmtProxy);

        Assert.assertEquals(Types.TINYINT, stmtProxy.getParameter(0).getSqlType());
        Assert.assertEquals(Types.SMALLINT, stmtProxy.getParameter(1).getSqlType());
        Assert.assertEquals(Types.INTEGER, stmtProxy.getParameter(2).getSqlType());
        Assert.assertEquals(Types.BIGINT, stmtProxy.getParameter(3).getSqlType());
        Assert.assertEquals(Types.FLOAT, stmtProxy.getParameter(4).getSqlType());

        Assert.assertEquals(Types.DOUBLE, stmtProxy.getParameter(5).getSqlType());
        Assert.assertEquals(Types.DECIMAL, stmtProxy.getParameter(6).getSqlType());
        Assert.assertEquals(Types.BOOLEAN, stmtProxy.getParameter(7).getSqlType());
        Assert.assertEquals(Types.VARCHAR, stmtProxy.getParameter(8).getSqlType());
        Assert.assertEquals(Types.DATE, stmtProxy.getParameter(9).getSqlType());

        Assert.assertEquals(Types.DATE, stmtProxy.getParameter(10).getSqlType());
        Assert.assertEquals(Types.TIMESTAMP, stmtProxy.getParameter(11).getSqlType());
        Assert.assertEquals(Types.TIME, stmtProxy.getParameter(12).getSqlType());

        stmt.close();

        conn.close();
    }
}