SR952100.java

package com.alipay.zdal.test.rw;

import java.sql.Connection;
import static com.alipay.ats.internal.domain.ATS.Step;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

import org.junit.After;
import org.junit.Before;
import org.junit.Test;
import org.junit.runner.RunWith;

import com.alipay.ats.annotation.Feature;
import com.alipay.ats.annotation.Priority;
import com.alipay.ats.annotation.Subject;
import com.alipay.ats.assertion.TestAssertion;
import com.alipay.ats.enums.PriorityLevel;
import com.alipay.ats.junit.ATSJUnitRunner;
import com.alipay.zdal.client.jdbc.ZdalDataSource;
import com.alipay.zdal.test.common.ConstantsTest;
import com.alipay.zdal.test.common.ZdalTestBase;
import com.alipay.zdal.test.common.ZdalTestCommon;

@RunWith(ATSJUnitRunner.class)
@Feature("zdal���oracle����Դ���������")
public class SR952100 extends ZdalTestBase {
	private Connection connection = null;
	private PreparedStatement ps = null;
	private ResultSet st = null;
	public TestAssertion Assert = new TestAssertion();

	@Before
	public void beforeTestCase() {
				
		zdalDataSource = (ZdalDataSource) ZdalRwSuite.context
		.getBean("zdalRwDSOracle2");
		
		try {
			connection = zdalDataSource.getConnection();

		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}

	@After
	public void afterTestCase() {
		try {
			connection.close();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			connection = null;
			e.printStackTrace();
		}
	}

	@Subject("�������ж���sql��䣬��ʧ�����")
	@Priority(PriorityLevel.HIGHEST)
	@Test
	public void TC952111() {
		Step("�������ж���sql��䣬��ʧ�����");
		String sqlStr = "insert into ACM_TARGET_RECORD (id,test_varchar,test_date,int_field_1,int_field_2,var_field_1,var_field_2) values (99,'DB_G',to_date('2012-06-15 20:46:34','YYYY-MM-DD-HH24:MI:SS'),1,1,'a','b')";
		try {
			connection.setAutoCommit(false);
			ps = connection.prepareStatement(sqlStr);
			ps.execute();
			Thread.sleep(50);
			Step(" �����ͻ������");
			ps.execute();
			connection.commit();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (InterruptedException ex) {
			ex.printStackTrace();
		} finally {
			try {
				connection.rollback();
				connection.setAutoCommit(true);
			} catch (Exception e) {
				e.printStackTrace();
			}
		}
		Step("���ݽ����˻ع����������");
		String sql = "select count(*) from ACM_TARGET_RECORD where id=99";
		String dburl = ConstantsTest.oralcePrefUrl;
		String dbpsd = ConstantsTest.oraclePrePsd;
		String dbuser = ConstantsTest.oraclePreUser1;
		st = ZdalTestCommon.dataCheckFromJDBCOracle(sql, dburl, dbpsd, dbuser);
		try {
			st.next();
			Assert.areEqual(0, st.getInt(1), "��֤������");
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}

}