HWDBTestCase3

来源:互联网 发布:https绑定域名iis 编辑:程序博客网 时间:2024/06/05 13:21

 private void disableForeignKey() throws Exception
    {
        IDatabaseConnection iConn = getConnection();
        Connection conn = iConn.getConnection();
        PreparedStatement pstmt = conn.prepareStatement(disableSql);
        ResultSet result = pstmt.executeQuery();
        while (result.next())
        {
            pstmt = conn.prepareStatement(result.getString(1));
            pstmt.execute();
        }
        pstmt.close();
    }
   
    private void enableForeignKey() throws Exception
    {
        IDatabaseConnection iConn = getConnection();
        Connection conn = iConn.getConnection();
        PreparedStatement pstmt = conn.prepareStatement(enableSql);
        ResultSet result = pstmt.executeQuery();
        while (result.next())
        {
            pstmt = conn.prepareStatement(result.getString(1));
            pstmt.execute();
        }
        pstmt.close();
    }

原创粉丝点击